WMS One-Step Inventory Transfer Import Format

1

LOCTRANS

Yes

This is LOCTRANS to indicate the record is a one-step inventory transfer record.

2

From Location

Yes

This is the location from which inventory is being transferred.

3

To Location

Yes

This is the location to which inventory is being transferred. This should match the WMS location.

4

Product Code

Yes

This is the product code for the inventory transfer.

5

Quantity Transferred

Yes

This is the quantity transferred. It must be greater than zero.

6

From Unit of Measure

Yes

This is the unit of measure for the product in the bin from which it is being transferred.

7

To Unit of Measure

Yes

This is the unit of measure for the product in the bin to which it is being transferred.

8

From Bin

Yes

This is the bin from which the product is being transferred.

9

To Bin

Yes

This is the bin to which the product is being transferred.

10

Lot

Yes, only if the product is tracked by lot

This is the lot of the product being transferred if it is tracked by lot.

11

Serial Number

Yes, only if the product is tracked by serial number

This is the serial number of the product being transferred if it is tracked by serial number.

12

Transfer Date

Yes

The posting period is the period in which the WMS performs the transaction. If that period was already closed, then the software uses the default period for the Warehouse Management module.

13

WMS Transaction Date

No

This is the date the transaction occurred in the WMS. This defaults to the current date.

14

WMS Transaction Time

No

This is the time the transaction occurred in the WMS. This defaults to the current time.

15

WMS Import Key

No

This is a key value used to differentiate between WMS transactions. If this is imported, it must be a unique value that was not previously associated with a WMS transaction.