NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Inventory Quantity 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 importing inventory data. The product must exist in the warehouse location for which inventory is to be imported. |
B |
2 |
Location Prefix |
3 |
Character |
Yes |
Enter a valid location prefix into which the inventory is to be imported. |
C |
3 |
Bin Name |
20
|
Character |
Yes |
Enter the bin in which the product is stored. You must enter a bin that already exists if the Create Bins check box is cleared in Inventory Quantity Import. |
D |
4 |
Lot |
40 |
Character |
Yes, only if the product is tracked by lot |
Enter the lot if the product is tracked by lot. |
E |
5 |
Serial Number |
40 |
Character |
Yes, only if the product is tracked by serial number |
Enter a unique serial number if the product is tracked by serial number. Note The quantity entered for a product tracked by serial number must be one. |
F |
6 |
On Hand Quantity |
15 |
>>,>>>,>>9.9999 |
Yes |
Enter the quantity on hand for the bin/lot/serial number for the unit of measure entered for the Unit of Measure field. |
G |
7 |
Cost |
15 |
>>,>>>,>>9.9999 |
Yes |
Enter the cost per unit of the quantity imported for the bin/lot/serial number for the unit of measure entered for the Unit of Measure field. |
H |
8 |
Unit of Measure |
8 |
Character |
Yes |
Enter a valid unit of measure for the quantity imported. |
I |
9 |
Zone |
20 |
Character |
No |
Enter the zone to use if creating a bin. |
J |
10 |
Can Break Inventory |
3 |
Yes/No |
No |
Enter Yes if creating a bin, and you want to allow products in the bin to be broken down to smaller units of measure or built up to larger units of measure. This field defaults to No. Note You must enter Yes for this field if you enter Yes for the Speed Bin Override field. |
K |
11 |
Bin Sequence Number |
7 |
Integer |
No |
If creating a bin, enter the pick sequence number of the bin. |
L |
12 |
Not Available Bin |
3 |
Yes/No |
No |
Enter Yes if creating a bin, and you want to make the quantity in the bin unavailable for picking or replenishment. This field defaults to No. Note You cannot enter Yes for this field if you enter Yes for the Speed Bin Override field. |
M |
13 |
Speed Bin Override |
3 |
Yes/No |
No |
Enter Yes if creating a bin, to have pick demand creation first pick from this bin, regardless of the unit of measure required. Typically, this is used for a high velocity product that is temporarily staged in a speed bin to facilitate an efficient pick. This field defaults to No. |
N |
14 |
Lot Expiration Date |
10 |
99/99/9999 |
No |
Enter the date that the lot of inventory expires. |
O |
15 |
Receipt Date |
10 |
99/99/9999 |
No |
Enter the receipt date, which is used for LIFO/FIFO cost calculations. If this field is left blank, the receipt date defaults to the current date. |
P |
16 |
Posting Year |
4 |
Integer |
Yes |
Enter a valid general ledger year in which the inventory quantity is updated. This should be the year in which a manual journal entry is posted (separate from the import process) for the general ledger inventory account. |
Q |
17 |
Posting Period |
2 |
Integer |
Yes |
Enter a valid general ledger period in which the inventory quantity is updated. This should be the period in which a manual journal entry is posted (separate from the import process) for the general ledger inventory account. |
R |
18 |
Cost Currency |
8 |
Character |
No |
Enter a valid currency for which you are importing inventory data. |
S |
19 |
Weight Remaining |
15 |
>>>,>>>,>>9.99 |
Yes, only for catch weight products |
Enter the weight remaining for the bin, lot, or serial number for the unit of measure entered for the Unit of Measure field (position 8) |
Before using this import, the following must be set up:
products
locations
units of measure
Selecting the Create Bins check box in Inventory Quantity Import indicates you want to create any bins in the import file that do not already exist. If the check box is cleared, and the imported bin does not exist, an error message appears in the import error log.
There must be a record of blank space(s) at the end of an import file.