Import Stock On Hand Field Definitions
Follow
George Sutton
Updated : Created :
This import is only for new products. DO NOT use this import for existing products with available stock on hand.
* denotes mandatory fields. Ensure that you enter correct values in the template before importing into Unleashed.
| Field Name | Description |
|---|---|
| *Product Code | Product code for an existing product (max character length 100). Ensure that the product has been created in Unleashed before you import stock on hand. |
| *Warehouse Code | Warehouse code where the stock is located. You can find the codes under Settings | Warehouse. |
| *SOH | Stock on hand quantity (numeric value) of the product. |
| *AverageLandCost | The calculation per unit including purchase price + any other costs associated in purchasing the stock including delivery costs. |
| Serial Number | Specified serial number of the serialized product. These products must be tagged as 'Serialized'. Products can have multiple serial numbers. |
| Batch Number | Specified batch number of the product. These products must be tagged as 'Batch Tracked'. Products can have multiple batch numbers. |
| Expiry date | This is the expiry date ( DD/MM/YYYY) of the specified batch number of the product. The Expiry date is required only for batch numbers. |
Example: How to enter Serial Numbers or Batch Numbers
