Physical Inventory Entry Import Format

A

1

Physical Inventory ID

20

Character

Yes

Enter a valid physical inventory ID. For information on setting up physical inventory ID's, see Physical Inventory Select.

B

2

Quantity

12

>>>,>>>,>>9.99

Yes

Enter the quantity physically counted.

C

3

Bin

20

Character

Yes

Enter a valid bin. For information on setting up bins, see Bin Maintenance.

D

4

Product Code

40

Character

Yes

Enter a valid product code. For information on setting up products, see Product Maintenance.

E

5

Unit of Measure

8

Character

Yes

Enter a valid unit of measure. For information on setting up units of measure, see Unit of Measure Maintenance.

F

6

Zone

20

Character

No

Enter a valid zone. For information on setting up zones, see Zone Maintenance. If a zone is defined for the bin entered for the Bin field and this field is blank, the zone is automatically imported based on the bin.

G

7

Lot

20

Character

Yes, only if the product is tracked by lot

Enter the lot number for a lot-tracked product.

H

8

Serial Number

40

Character

Yes, only if the product is tracked by serial number

Enter the serial number for a serial-tracked product.

I

9

Expiration Date

10

99/99/9999

No

Enter the expiration date for a lot-tracked product. If this field is blank, the expiration date is calculated based on the number of lot days entered in Product Maintenance.

J

10

Notes

80

Character

No

Enter notes for the product count.