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
Put aways

We strongly recommend using a text editor to create the import PRN files, as characters beyond 240 are wrapped to the next line in Excel which causes problems when importing the file using the Inventory Transaction Import program.

Menu and Toolbar

Field	Description
Import	Validates the contents of the import file and import records if there are no errors.

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).
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.
Options
Transaction date
Posting period
Posting year
Change posting period	Click the Edit hyperlink to change the posting period.
Import re-run
Import run date	Displays the import's run date.
Delete operator's autorun file	Deletes the operator's autorun file.
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
Print	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 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

* product-authoring@syspro.com