Inventory Balance Lot Import

Last updated
Save as PDF

Overview

The Inventory Balance Lot import process reads files from ./Incoming/InventoryBalanceLot/ SFTP folder. These files will be moved to the archive folder located at ./Incoming/Archive/InventoryBalanceLot/ before being processed in alpha-numeric order.

Keys and Validations

Item number is the unique identifier.

Inventory balance columns

Column	Description	Hidden	Req'd	Unique	Type	Allowable Values
Balance	Indicates the type of row	false	true	false	-	Balance
Item Number	Item Number.	false	true	false	string(255)	Any
Item Name	Item Name. To be deprecated. Use Item Number.	false	false	false	string(255)	Any
Warehouse	Warehouse Name	false	true	false	string(255)	Must be an active warehouse
Aisle	Warehouse Location Aisle	false	true	false	string(255)	Must be a valid warehouse location
Bin	Warehouse Location Bin	false	true	false	string(255)	Must be a valid warehouse location
Level	Warehouse Location Level	false	true	false	string(255)	Must be a valid warehouse location
Quantity	Quantity	false	true	false	decimal(32,4)	Any
UOM	The unit of measure name	false	true	false	string(6)	Must exist in Coupa. Must match item UoM.
Price	Price	false	true	false	decimal(30,6)	Any
Currency	The currency code	false	true	false	string(6)	Must exist in Coupa.

The bulk loader doesn't support modifying the on-hand balance with items that have a quantity of 0 and a price of $0.

Inventory lot columns

Column	Description	Hidden	Req'd	Unique	Type	Allowable Values
Lot	Indicates the row type. Required if the item has lot tracking enabled.	false	true	false	-	Lot
Lot Number	Lot Number. Required if the item has lot tracking enabled.	false	true	false	string(255)	Any
Quantity	Lot quantity. Required if the item has lot tracking enabled.	false	true	false	decimal(32,4)	Any
Expiration Date	Lot Expiration Date	false	false	false	date	Any