NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Inventory Bin Move Demand Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Product Code |
40 |
Character |
Yes |
Enter a valid product code. This product must exist in the location entered for the Location Prefix field. |
B |
2 |
Location Prefix |
3 |
Character |
Yes |
Enter a valid location prefix for the location in which the inventory is being moved. |
C |
3 |
From Bin Name |
20 |
Character |
Yes |
Enter a valid bin from which the product is being moved. |
D |
4 |
To Bin Name |
20 |
Character |
Yes |
Enter a valid bin to which the product is being moved. |
E |
5 |
Unit of Measure |
8 |
Character |
Yes |
Enter a valid unit of measure for the product being moved. |
F |
6 |
Quantity |
15 |
Decimal or Integer based on the unit of measure entered for the Unit of Measure field |
Yes |
Enter the quantity of the product being moved. |
G |
7 |
Wireless Warehouse Task Type |
25 |
Character |
No |
Enter the Wireless Warehouse task type for the bin move. |
H |
8 |
Lot |
20 |
Character |
Yes, only for lot-tracked products |
Enter the lot of the product being moved if the product is tracked by lot. |
I |
9 |
Serial Number |
40 |
Character |
Yes, only for serial-tracked products |
Enter the serial number of the product being moved if the product is tracked by serial number. |
J |
10 |
To Unit of Measure |
8 |
Character |
No |
Enter a valid unit of measure in which the product will be stored after the bin move. If this field is blank, it defaults to the unit of measure entered for the Unit of Measure field (position 5). |
K |
11 |
License Plate ID |
30 |
Character |
No |
Enter a license plate ID for which to transfer inventory. |
Before using this import, the following must be set up:
products
locations
bins
units of measure