Skip to main content

 

 

Coupa Success Portal

Inventory Balance Lot

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 depreated. 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 code 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.

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
  • Was this article helpful?