Inventory Transaction Import
This program lets you import multiple inventory transaction types from a fixed length text file. You would typically use this program to capture historical transaction information that was entered using a third party application.
Transactions that can be imported include:
- WIP Material Issues
- Receipts
- Bin Transfers
- Warehouse Transfers Out
- Warehouse Transfers In
- Expense Issues
- Backflushing
Menu and Toolbar
| Field | Description |
|---|---|
| Import | Validates the contents of the import file and import records if there are no errors. |
| Save Form Values |
This option is only enabled in Design mode (Automation Design). Your selections are saved and applied when the program is run in automated mode. Form values and defaults are applied at operator level. They are not saved at role or group level. |
Options
| Field | Description |
|---|---|
| File location |
Indicate whether the import file resides on the server or the client. |
| File name | Indicate the name of the import file (including the full path). |
| Options | |
| Transaction date | |
| Posting period | |
| Posting year | |
| Change posting period | Click the Edit hyperlink to change the posting period. |
| Import re-run | |
| After processing completed | |
| Print the Details |
Generate a report of the contents of the Details entry grid. |
| Email the Details | Generate an email of the contents of the Details entry grid. |
| Print the Import Results |
Generate a report of the contents of the Import Results pane. |
| Email the Import Results |
Generate an email of the contents of the Import Results pane. |
| Email recipients | Indicate the email addresses of recipients to whom you want to email the information displayed in the output panes. |
| Delete import file |
Indicate whether you want to delete the import file after all records are successfully imported. The file is also deleted if you enable this option and select the Review file function. In a client/server environment, both the import file on the server and the temporary import file created on the client are deleted. |
| Close the application | Exits the program once processing is complete. Do not select this if you want to be able to view the information on screen when processing is complete or you want to print or email the contents of the Details and Import Results panes. |
Details
| Field | Description |
|---|---|
| Validate | This verifies whether there are any errors in the grid,
without actually importing records. Exclamation marks in the Validation status column indicates that one or more fields in the line are invalid. An explanatory error message is displayed when you hover your mouse pointer over the exclamation marks. |
| Prints the contents of the import file, or changes made in the grid. | |
| Export to Excel | Outputs data from the Details pane to an Excel spreadsheet. |
| Search text | |
| Clear | Clears the contents in the search text field. |
| Edit | |
| Copy |
Copies the lines in the Details pane. |
| Paste (all columns) | Ensure that you have data for all the columns that can
appear in the data grid before selecting this option. When you select to Paste (all columns) the date you are pasting must be in the format CCYYMMDD. Although no validation errors are displayed, the date is not converted into your SYSPRO date format. |
| Paste (visible columns only) | Pastes data into the columns that currently appear in the
data grid, in the sequence that they appear. When you select to Paste (visible columns only) and the date you are pasting is not in CCYYMMDD format, you are prompted for the date format. The program correctly inserts it into the grid in the SYSPRO date format. |
| Duplicate | Copies the current row to the end of the data grid. |
| Find and Replace |
Import Results
Displays a summary of the results of the validation/import.
This information can be printed or emailed providing you did not select to Close the application in the After processing completed section.
WIP Material Issues
The following lists the format of the import file that you must define.
| Field | Description | Start Position | Field Size | Default (* = mandatory) |
|---|---|---|---|---|
|
RECORD TYPE |
The first character of the file layout must be an I to indicate a material issue. |
1 |
1 |
* (must be I) |
|
STOCK CODE |
This indicates the stock code being issued to the job. |
2 |
30 |
* |
|
WAREHOUSE |
This indicates the warehouse code to be used in the material issue (** indicates a non-stocked warehouse code). |
32 |
10 |
* |
|
QUANTITY TO ISSUE |
This indicates the quantity to be issued to the job (a maximum of 12 whole numbers and 6 decimal places) The quantity field may be less than zero if you are processing a negative receipt (e.g. 254.543-) |
42 |
20 |
* |
|
NON STOCKED ITEM DESCRIPTION |
This indicates the description of the non-stocked code (if the inventory warehouse code is ** ) being issued to the job. |
62 |
50 |
Blank |
|
NON-STOCKED ITEM PRODUCT CLASS |
This indicates the product class of the non-stocked item (if the inventory warehouse code is ** ). |
112 |
20 |
Blank |
|
NON- STOCKED ITEM COST |
This indicates the cost of the non-stocked item. This must be a positive value (a maximum of 6 whole numbers and 3 decimals). |
132 |
16 |
Blank |
|
ALLOCATION COMPLETE |
This indicates whether the allocation issued to the job is complete (i.e. Y/N). If the field is left blank then the default allocation is Y. |
148 |
1 |
* |
|
REF NUMBER |
This indicates the reference of the job issue. |
149 |
30 |
Blank |
|
JOB NUMBER |
This indicates the job number for the material issue. If the field is left blank then an inventory issue is performed by default.. |
179 |
20 |
* |
|
JOB COMPLETE |
Reserved |
199 |
1 |
Blank |
|
EMPLOYEE NUMBER |
Reserved This indicates the employee number against the job. This should contain a numeric value. |
200 |
20 |
Blank |
|
BIN LOCATION |
This indicates the bin location from which the issue is to be taken. If FIFO or LIFO costing is in use, then the appropriate bin will be used, starting from 000000. This field can be left blank. |
220 |
20 |
Blank |
|
SERIAL NUMBER |
This indicates the serial number that is to be used for the material issue. If numeric, then the maximum number of digits is 15. |
240 |
50 |
Blank |
|
SERIAL LOCATION |
Reserved This indicates the location of the serialized item. |
290 |
20 |
Blank |
|
LOT NUMBER |
This indicates the lot number that is to be used for the material issue. |
310 |
50 |
* (if lot traceable) |
|
CERTIFICATE NUMBER |
This indicates the certificate number entered for the stock item . |
360 |
10 |
Blank |
|
CONCESSIONS NUMBER |
This indicates the concession number entered for the stock item. |
370 |
10 |
Blank |
|
EXPIRY DATE |
Reserved This indicates the expiry date entered for the stock item (in the format YYYYMMDD). |
380 |
8 |
Blank |
|
NOTATION |
Specify any notation text. |
388 |
50 |
Blank |
|
LINE VERSION |
This indicates the line number for material issues to job ( If blank, the material will be issued always to the first allocation found). |
438 |
2 |
Blank |
|
ECC VERSION |
Reserved |
440 |
5 |
Blank |
|
ECC RELEASE |
Reserved |
445 |
5 |
Blank |
Receipts
The following lists the format of the import file that you must define.
| Field | Description | Start Position | Field Size | Default (* = mandatory) |
|---|---|---|---|---|
|
RECORD-TYPE |
The first character of the file layout must be an R to indicate an inventory receipt. |
1 |
1 |
* (must be R) |
|
STOCK CODE |
This indicates the stock code being received into the warehouse. |
2 |
30 |
* |
|
WAREHOUSE |
This indicates the warehouse code to be used in the inventory receipt. |
32 |
10 |
* |
|
QUANTITY RECEIVED |
This indicates the quantity to be received (a maximum of 7 whole numbers and 3 decimal places). The quantity field may be less than zero if you are processing a negative receipt (e.g. 254.543-). |
42 |
20 |
* |
|
REFERENCE NUMBER |
This indicates the reference number of the inventory receipt. |
62 |
30 |
Blank |
|
JOB NUMBER |
This indicates the job number for the inventory receipt. This field may be left blank. |
92 |
20 |
n/a |
|
JOB COMPLETE |
Job complete (i.e. Y/N). |
112 |
1 |
n/a |
|
EMPLOYEE NUMBER |
This indicates the employee number. |
113 |
20 |
n/a |
|
BIN NUMBER |
This indicates the bin location of the stock item in the warehouse. If FIFO or LIFO costing is in use, then the bin number is automatically incremented from 000000. This field may be left blank. |
133 |
20 |
Blank |
|
SERIAL NUMBER |
This indicates the serial number of the stock item being received. |
153 |
50 |
* ( if serialized) |
|
SERIAL LOCATION |
This indicates the serial location ( e.g. on loan, in for service, etc.). |
203 |
20 |
Blank |
|
LOT NUMBER |
This indicates the lot number of the stock item being received. (Not required if automatic lot numbering is in use). |
223 |
50 |
* (if lot traceable) |
|
CERTIFICATE NUMBER |
This indicates the certificate number entered for the stock item. |
273 |
10 |
Blank |
|
CONCESSION NUMBER |
This indicates the concession number entered for the stock item. |
283 |
10 |
Blank |
|
EXPIRY DATE |
This indicates the expiry date entered for the stock item. |
293 |
8 |
Blank |
|
NEW UNIT COST |
This indicates the receipt cost. |
301 |
16 |
* |
|
COST BASIS |
This indicates the new cost (Manual) |
317 |
1 |
* |
Bin Transfers
The following lists the format of the import file that you must define.
| Field | Description | Start Position | Field Size | Default (* = mandatory) |
|---|---|---|---|---|
|
RECORD TYPE |
The first character of the file layout must be a B to indicate a bin transfer |
1 |
1 |
* (must be B) |
|
STOCK CODE |
This indicates the stock code that is being transferred to the new bin. |
2 |
30 |
* |
|
WAREHOUSE |
This indicates the warehouse code of the stock item. |
32 |
10 |
* |
|
TRANSFER FROM BIN |
This indicates the source bin number from which the transfer will be made. |
42 |
20 |
* |
|
TRANSFER TO BIN |
This indicates the destination bin number. |
62 |
20 |
* |
|
QUANTITY TRANSFERRED |
This indicates the quantity to transfer. The number can be entered anywhere within the 20 characters . |
82 |
20 |
* |
|
LOT NUMBER |
This indicates the lot number, which must exist if the item is lot traceable. The number can be entered anywhere within the 50 characters. If numeric, then only 15 digits can be used. |
102 |
50 |
* ( if lot traceable) |
|
ECC VERSION |
This indicates the Engineering Change Control version. |
152 |
5 |
Required |
|
ECC RELEASE |
This indicates the Engineering Change Control release. |
157 |
5 |
Required |
| SERIAL | This indicates the serial number to be used for the material issue. If numeric, then the maximum number of digits is 15. | 162 | 50 | * ( if serial tracking) |
|
NOTATION |
Specify any notation text. |
212 |
50 |
|
Warehouse Transfers Out
The following lists the format of the import file that you must define.
| Field | Description | Start Position | Field Size | Default (* = mandatory) |
|---|---|---|---|---|
|
RECORD TYPE |
The first character of the file layout must be an O to indicate a warehouse transfer out. |
1 |
1 |
* (must be T) |
|
STOCK CODE |
Specify up to 30 characters for the stock code that is being transferred. |
2 |
30 |
* |
|
TRANSFER FROM WAREHOUSE |
Specify the source warehouse from which the stock code is being transferred. |
32 |
10 |
* |
|
TRANSFER TO WAREHOUSE |
Specify the destination warehouse to which the stock code is being transferred. |
42 |
10 |
* |
|
TRANSFER FROM BIN |
Specify the bin number from which the stock code is being transferred. This field is only valid if multiple bins is in use. |
52 |
20 |
* |
|
TRANSFER TO BIN |
Specify the bin number to which the stock code is being transferred. |
72 |
20 |
* |
|
REFERENCE NUMBER |
Specify the reference number of the transfer. This is printed on the journal report. |
92 |
30 |
Blank |
|
NO DESTINATION TRANSFER |
Specify Y to create a no destination transfer. This defaults to N. |
122 |
1 |
* |
|
IMMEDIATE TRANSFER |
Specify Y for an immediate transfer or N to leave the stock code in transit |
123 |
1 |
|
|
QUANTITY TRANSFERRED |
Specify the quantity to transfer (a maximum of 12 whole numbers and 6 decimal places) This cannot be negative. If the stock code to be transferred is a manual serialized stock code, then the quantity must be 1. |
124 |
20 |
* |
|
SERIAL NUMBER |
Specify the serial number of the stock code if the stock item is serialized. If the serial numbering method is numeric, a maximum of 15 digits is allowed. |
144 |
50 |
Mandatory if serialized |
|
SERIAL LOCATION |
Specify the location of the serial number (e.g. on loan). |
194 |
20 |
Blank |
|
LOT NUMBER |
Specify the lot number of the stock code. |
214 |
50 |
Mandatory if lot traceable |
|
FIFO BUCKET |
Specify the the certificate number of the stock code. |
264 |
10 |
Blank |
|
NOTATION |
Specify any notation text. |
274 |
50 |
Blank |
|
ECC VERSION |
This indicates the Engineering Change Control version. |
324 |
5 |
Required |
|
ECC RELEASE |
This indicates the Engineering Change Control release. |
329 |
5 |
Required |
Warehouse Transfers In
The following lists the format of the import file that you must define.
| Field | Description | Start Position | Field Size | Default (* = mandatory) |
|---|---|---|---|---|
|
RECORD TYPE |
The first character of the file layout must be an T to indicate a warehouse transfer in. |
1 |
1 |
* (must be T) |
|
STOCK CODE |
Specify up to 30 characters for the stock code that is being transferred. |
2 |
30 |
* |
|
TRANSFER FROM WAREHOUSE |
Specify the source warehouse from which the stock code is being transferred. |
32 |
10 |
* |
|
TRANSFER TO WAREHOUSE |
Specify the destination warehouse to which the stock code is being transferred. |
42 |
10 |
* |
|
REFERENCE NUMBER |
Specify the reference number of the transfer. This is printed on the journal report. |
52 |
30 |
Blank |
|
LINE |
This indicates the line number corresponding to the transaction being processed. |
82 |
10 |
|
|
TRANSFER FROM BIN |
Specify the bin number to transfer the stock code from. This field is only valid if multiple bins is in use. |
92 |
20 |
* |
|
TRANSFER TO BIN |
Specify the bin number to which the stock code is being transferred. |
112 |
20 |
* |
|
QUANTITY TRANSFERRED |
Specify the quantity to transfer (a maximum of 12 whole numbers and 6 decimal places) This cannot be negative. If the stock code to be transferred is a manual serialized stock code, then the quantity must be 1. |
132 |
20 |
* |
|
SERIAL NUMBER |
Specify the serial number of the stock code if the stock item is serialized. If the serial numbering method is numeric, a maximum of 15 digits is allowed. |
152 |
50 |
* (if serialized) |
|
SERIAL LOCATION |
Specify the location of the serial number (e.g. on loan). |
202 |
20 |
Blank |
|
LOT NUMBER |
Specify the lot number of the stock code. |
222 |
50 |
* (if lot traceable) |
|
FIFO BUCKET |
Specify the the certificate number of the stock code. |
272 |
10 |
Blank |
|
NOTATION |
Specify any notation text. |
282 |
50 |
Blank |
|
ECC VERSION |
This indicates the Engineering Change Control version. |
332 |
5 |
Required |
|
ECC RELEASE |
Specify the location of the serial number (e.g. on loan). |
337 |
5 |
Required |
Expense issues
The following lists the format of the import file that you must define.
| Field | Description | Start Position | Field Size | Default (* = mandatory) |
|---|---|---|---|---|
|
RECORD TYPE |
The first character of the file layout must be an E to indicate a material issue. |
1 |
1 |
* (must be E) |
|
STOCK CODE |
This indicates the stock code that is to be issued to the job. |
2 |
30 |
* |
|
WAREHOUSE |
This indicates the warehouse code to be used in the material issue (** indicates a non-stocked warehouse code). |
32 |
10 |
* |
|
QUANTITY TO ISSUE |
This indicates the quantity to be issued to the job (a maximum of 12 whole numbers and 6 decimal places). The quantity field may be less than zero if you are processing a negative receipt (e.g. 254.543-). |
42 |
20 |
* |
|
NON STOCKED ITEM DESCRIPTION |
This indicates the description of the non-stocked code (if the inventory warehouse code is ** ) being issued to the job. |
62 |
50 |
Blank |
|
NON-STOCKED ITEM PRODUCT CLASS |
This indicates the product class of the non-stocked item (if the inventory warehouse code is ** ). |
112 |
20 |
Blank |
|
NON- STOCKED ITEM COST |
This indicates the cost of the non-stocked item. This must be a positive value (a maximum of 6 whole numbers and 3 decimals). |
132 |
16 |
Blank |
|
ALLOCATION COMPLETE |
This indicates whether the allocation issued to the job is complete (i.e. Y/N). If the field is left blank then the default allocation is Y. |
148 |
1 |
* |
|
REF NUMBER |
This indicates the reference of the job issue. |
149 |
30 |
Blank |
|
JOB NUMBER |
This indicates the job number for the material issue. If the field is left blank then an inventory issue is performed by default. |
179 |
20 |
* |
|
JOB COMPLETE |
Reserved. This indicates whether the job is complete (i.e. Y/N). |
199 |
1 |
Blank |
|
EMPLOYEE NUMBER |
Reserved. This field indicates the employee number against the job and should contain a numeric value. |
200 |
20 |
Blank |
|
BIN LOCATION |
This indicates the bin location from which the issue is to be taken. If FIFO or LIFO costing is in use, then the appropriate bin will be used, starting from 000000. This field can be left blank. |
220 |
20 |
Blank |
|
SERIAL NUMBER |
This indicates the serial number that is to be used for the material issue. If the serial numbering method is numeric, then the serial numbers used cannot exceed 15 digits. |
240 |
50 |
Blank |
|
SERIAL LOCATION |
Reserved This indicates the location of the serialized item. |
290 |
20 |
Blank |
|
LOT NUMBER |
This indicates the lot number that is to be used for the material issue. |
310 |
50 |
* (if lot traceable) |
|
CERTIFICATE NUMBER |
This indicates the certificate number entered for the stock item. |
360 |
10 |
Blank |
|
CONCESSIONS NUMBER |
This indicates the concession number entered for the stock item. |
370 |
10 |
Blank |
|
EXPIRY DATE |
Reserved This indicates the expiry date entered for the stock item (i.e. YYYYMMDD). |
380 |
8 |
Blank |
|
NOTATION |
Specify any notation text. |
388 |
50 |
Blank |
|
LINE VERSION |
Line number for material issues to job ( If blank the material will be issued always to the first allocation found. |
488 |
2 |
Blank |
|
ECC VERSION |
Reserved. |
490 |
5 |
Blank |
|
ECC RELEASE |
Reserved. |
495 |
5 |
Blank |
Backflushing
The following lists the format of the import file that you must define to import.
| Field | Description | Start Position | Field Size | Default (* = mandatory) |
|---|---|---|---|---|
|
IMPORT-TYPE |
The first character of the file layout must be an U to indicate a backflushing transactions. |
1 |
1 |
* (must be U) |
|
IMPORT-STOCK-U |
This indicates the parent stock code. |
2 |
30 |
* |
|
IMPORT-WHS-U |
This indicates the warehouse for the parent. |
32 |
10 |
* |
|
IMPORT-QTY-BFL-U |
This indicates the quantity for the parent (a maximum 7 whole numbers and 3 decimal places). The decimal point must be present. The quantity can be negative (e.g. 567.89-). The number can be anywhere within the 20 characters. |
42 |
20 |
* |
|
IMPORT-BFL-LEVEL-U |
This indicates the backflush components level. M indicates multiple (all) levels; S indicates single level. |
62 |
1 |
M |
|
IMPORT-BFL-ROUTE-U |
This indicates the route to use (0 to 5). If blank, this defaults to 0. |
63 |
2 |
0 |
|
IMPORT-SETUP-U |
This indicates whether you want to include setup time (i.e. Y/N). |
65 |
1 |
N |
|
IMPORT-STARTUP-U |
This indicates whether you want to include startup time (i.e. Y/N). |
66 |
1 |
N |
|
IMPORT-TEARDOWN-U |
This indicates whether you want to include teardown time (i.e. Y/N). |
67 |
1 |
N |
|
IMPORT-SER-U |
This indicates the serial number for the parent (if numeric, only 15 digits can be used; the last 5 must be blank). |
68 |
50 |
* (if serialized) |
|
IMPORT-SER-LOC-U |
This indicates the serial location. |
118 |
20 |
Blank |
|
IMPORT-LOT-U |
This indicates the lot number for parent. |
138 |
50 |
* (if lot traceable) |
|
IMPORT-CONC-U |
This indicates the concession number. |
188 |
10 |
Blank |
|
IMPORT-REF-U |
This indicates the reference number. |
198 |
30 |
Blank |
|
IMPORT-NOTATION-U |
Specify any notation text. |
228 |
100 |
Blank |
|
IMPORT- WH-COMP-U |
This indicates the component warehouse to use. |
328 |
10 |
Blank |
|
IMPORT-ECC-VER-U |
This indicates the ECC version. |
|||
|
IMPORT-ECC-REL-U |
This indicates the ECC release. |
|||
|
IMPORT-FIFO-U |
This indicates the FIFO/LIFO bucket. |
|||
|
IMPORT-BIN-U |
This indicates the bin location. |
|||
|
IMPORT-EXP-DATE-U |
This indicates the expiry date. |
|||
|
IMPORT-JOB-U |
This indicates the job number. |
|||
|
IMPORT-ROUTE-PASS-U |
This indicates the route password. |
|||
|
IMPORT-COMP-STOCK-U |
This indicates the component stock code. |
|||
|
IMPORT-COMP-UNDERISSUE |
This indicates that the serialized and lot traceable components should be issued. |
|||
|
IMPORT-COMP-LOT-U |
This indicates the lot number for component. |
|||
|
IMPORT-COMP-QTY-U |
This indicates the quantity for the component. |
|||
|
IMPORT-COMP-FIFO-U |
This indicates the component FIFO bucket number. |
|||
|
IMPORT-COMP-SER-U |
This indicates the serial number for component. |
Putaways
The following lists the format of the import file that you must define.
| Field | Description | Start Position | Field Size | Default (* = mandatory) |
|---|---|---|---|---|
| RECORD TYPE |
The first character of the file layout must be an A to indicate a putaway. |
1 | 1 | * (must be A) |
|
FROM WH |
Specify the source warehouse from which the stock code is being taken. |
2 |
10 |
* |
|
FROM BIN |
Specify the bin number from which the stock code is taken. This field is only valid if multiple bins is in use. |
12 |
20 |
* (if multiple bins) |
|
STOCK CODE |
This indicates the stock code that is included in the putaway. |
32 |
30 |
* |
|
REV |
The indicates the revision number for the stock item. |
62 |
5 |
* ( if stock is ECC-controlled at version level) |
|
REL |
The indicates the release number for the stock item. |
67 |
5 |
* ( if stock is ECC-controlled at version level) |
|
GTR REFERENCE |
This indicates the goods in transit reference number. |
72 |
30 |
* (if GIT Reference is set to be Manual) |
|
QUANTITY |
This indicates the quantity that is putaway. |
102 |
20 |
* |
|
TO WH |
Specify the destination warehouse where the stock code is being placed. |
122 |
10 |
Blank |
|
TO BIN |
Specify the bin number where the stock code is placed. This field is only valid if multiple bins is in use. |
132 |
20 |
Blank |
|
TO WH NOTATION |
Specify any notation text regarding the warehouse in which the stock code is placed. |
152 |
50 |
Blank |
|
LOT |
This indicates the lot number of the stock item that is included in the putaway. |
202 |
50 |
* (if lot traceable) |
|
REFERENCE |
This indicates the reference number of the putaway. |
252 |
30 |
Blank |
|
NOTATION |
Specify any notation text for the putaway. |
282 |
50 |
Blank |
|
SERIAL |
This indicates the serial number that is to be used for the material issue. If numeric, then the maximum number of digits is 15. |
332 |
50 |
* (if serialized) |
|
SERIAL LOC |
This indicates the serial location. |
382 |
20 |
Blank |
Copyright © 2024 SYSPRO PTY Ltd.