Inventory Quantity Adjust 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 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.

Prerequisites

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

Import Format Notes