Inventory Quantity Import Format

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)

Prerequisites

Before using this import, the following must be set up:

Import Format Notes