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
Quantity – Required
OwnerName – Optional
The WarehouseName is a reference to the name of the warehouse where the inventory will be created.
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.
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.
A reference to the item number of the item that you are adding inventory for.
The unit of measure for the inventory you are adding.
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.
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:
lot – lot tracking
date – expiration date tracking
serial – serial tracking
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.
The amount of inventory in the bin for the item listed.
Inventory can be added for a specific customer to be used to fulfill orders for only that customer.