Inventory Balance Lot Import
The Inventory Balance Lot loader has a single set of header columns.
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.
| 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. |
Warning
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 |