Open topic with navigation

 Show/Hide All

The following table illustrates the ASCII import file format for Inventory Management transactions.

Note Records should be terminated with LF or LF/CR combination. The Lot/Serial Number field is optional for non-lot/serial number items.

 For Inventory Sales

Field Description	Start	Length
Transaction Type (hardcode - "1")	1	1
Transaction Date (YYMMDD format)	2	6
From Warehouse Number	8	3
Item Code	11	30
Job Number (blank if no job)	41	7
Cost Code (G/L Number if the Job Number field is blank)	48	32
Quantity (########.0000)	80	13
Price Method (S=Standard, R=Retail, "I"= Imported)	93	1
Price when Price Method ="" (########.0000)	94	13
Lot/Serial Number (if applicable)	107	15

 

 For Inventory Issues

Field Description	Start	Length
Transaction Type (hardcode - "2")	1	1
Transaction Date (YYMMDD format)	2	6
From Warehouse Number	8	3
Item Code	11	30
Job Number (blank if no job)	41	7
Cost Code (G/L Number if the Job Number field is blank)	48	32
Quantity (########.0000)	80	13
Lot/Serial Number (if applicable)	93	15

 

 For Inventory Transfers

Field Description	Start	Length
Transaction Type (hardcode - "4")	1	1
Transaction Date (YYMMDD format)	2	6
From Warehouse Number	8	3
To Warehouse Number	11	3
Item Code	14	30
Quantity (########.0000)	44	13
Lot/Serial Number (if applicable)	57	15

 

 For Inventory Receipts

Field Description	Start	Length
Transaction Type (hardcode - "6")	1	1
Transaction Date (YYMMDD format)	2	6
Warehouse Number	8	3
Item Code	11	30
Cost Method (S=Standard, L=Last, A=Average, ""=Importing)	41	1
Cost when Cost Method="" (########.0000)	42	13
Quantity (########.0000)	55	13
Lot/Serial Number (if applicable)	68	15

 

 For Physical Count

Field Description	Start	Length
Transaction Type (hardcode - "8")	1	1
Warehouse Number	2	3
Item Code	5	30
Quantity (########.0000)	35	13
Lot/Serial Number (if applicable)	48	15

 

For more information, see Handheld Computer File Layouts.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks