WMS Inventory Quantity Adjustment Import Format

The following table lists the format for importing inventory quantity adjustment data from a WMS. Each record is a caret-delimited row in the import file.

Position	Field Name	Required	Description
1	INVADJ	Yes	This is INVADJ to indicate the record is an inventory quantity adjustment record.
2	Location	Yes	This is the location for the quantity adjustment.
3	Product Code	Yes	This is the product code for the quantity adjustment.
4	Quantity Adjusted	Yes	This is the quantity adjusted. It should not be zero.
5	Unit of Measure	Yes	This is the unit of measure of the quantity adjustment.
6	Bin	Yes	This is the bin for the quantity adjustment.
7	Lot	Yes, only if the product is tracked by lot	This is the lot of the product for the quantity adjustment if the product is tracked by lot.
8	Serial Number	Yes, only if the product is tracked by serial number	This is the serial number of the product for the quantity adjustment if the product is tracked by serial number.
9	Lot Expiration Date	No	This is the lot expiration date if the product is tracked by lot. It is required for new lots.
10	Transaction Date	No	This defaults to the current date.
11	Adjustment Code	Yes	This is the inventory adjustment code for the inventory quantity adjustment.
12	Remarks	Yes	This is the remarks describing the inventory quantity adjustment.
13	WMS Transaction Date	No	This is the date the transaction occurred in the WMS. This defaults to the current date.
14	WMS Transaction Time	No	This is the time the transaction occurred in the WMS. This defaults to the current time.
15	WMS Transaction Key	No	This is a key value used to differentiate between WMS transactions. If this is imported, it must be a unique value that was not previously associated with a WMS transaction.