Inventory Upload

Inventory Upload Template

The Inventory Upload document contains the following columns:

WarehouseName – Required

ParentBinNumber – Required

LicensePlate – Optional

ItemNumber – Required

UOM – Required

ConversionFactor – Optional

ItemType – Required

ItemValue – Required if ItemType is DATE/LOT/SERIAL

Quantity – Required

AllocationSetName – Optional

WarehouseName

The WarehouseName is a reference to the name of the warehouse where the inventory will be created.

ParentBinNumber

The parent bin is where the inventory will be created. If a license plate is specified in column C, the inventory will reside on the license plate inside the parent bin. If no License Plate is specified, the inventory will reside directly inside the parent bin.

LicensePlate

Inventory in WithoutWire can be placed on a license plate inside of a bin. Specify a license plate to place inventory on or leave this field blank to create the inventory directly in the parent bin.

ItemNumber

A reference to the item number of the item that you are adding inventory for.

UOM

The unit of measure for the inventory you are adding.

ConversionFactor

The Base Conversion Factor for the Unit of Measure referenced in column E. If this is the smallest Unit of Measure you will track for this item, enter 1. A default value of 1 will be used for any new UOM’s missing a conversion factor.

ItemType

A reference to the item type of the item being added inventory for.  If this item exists in the system, then this field is not required.  If the item is new, then the item type should be set to one of the following:

Basic

lot – lot tracking

date – expiration date tracking

serial – serial tracking

ItemValue

The value of the tracking unit.  For example, if you are lot tracking, this field would be the lot number.  If serial tracked, then the serial number.  If the item type is date, then the value must be MM/DD/YY.  If the item type is basic, then this value can be left blank.

Quantity

The amount of inventory in the bin for the item listed.

Allocation Set Name

Inventory can be added for a specific customer to be used to fulfill orders for only that customer.