NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Inventory Quantity Adjust Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Product Code |
40 |
Character |
Yes |
Enter a valid product code of the product for which you are adjusting the inventory quantity. The product must exist in the warehouse location for which the inventory adjustment is to be imported. |
B |
2 |
Location Prefix |
3 |
Character |
Yes |
Enter a valid location prefix into which the inventory adjustment is to be imported. |
C |
3 |
Bin |
20 |
Character |
Yes |
Enter a valid bin for the inventory adjustment. The bin must exist in the specified location. |
D |
4 |
Lot |
20 |
Character |
Yes, only if the product is lot tracked |
Enter the lot number of the product if it is tracked by lot. |
E |
5 |
Serial Number |
40 |
Character |
Yes, only if the product is tracked by serial number |
Enter the serial number of the product if it is tracked by serial number. The quantity entered for a serial-tracked product must be zero. |
F |
6 |
Unit of Measure |
8 |
Character |
Yes |
Enter a valid unit of measure for the quantity adjustment. The unit of measure must be a valid unit of measure for the product in the location. |
G |
7 |
Quantity Adjustment |
9 or >>>,>>>,>>9.9999 |
Decimal or Integer (depending on the unit of measure) |
Yes |
Enter the quantity adjustment for the bin/lot/serial number for the unit of measure entered for the Unit of Measure field. |
H |
8 |
Adjustment Code |
10 |
Character |
Yes |
Enter a valid inventory adjustment code. |
I |
9 |
Remark |
40 |
Character |
Yes |
Enter a comment for the adjustment. |
J |
10 |
Weight Remaining Adjustment |
>>>,>>>,>>9.9999 |
Decimal |
Yes, only for catch weight products |
Enter a weight remaining adjustment. This can be a negative value. |
Before using this import, the following must be set up:
products
locations
bins
units of measure
inventory adjustment codes
There must be a record of blank space(s) at the end of an import file.