Using the Import Stock on Hand template, you can establish initial Stock on Hand (SOH) quantities and Average Land Costs (ALC) to products that have never had SOH before.
If Serialized Products or Batch Tracking is enabled in your account's configuration settings, the Stock on Hand import will also allow you to assign serial or batch numbers to the new SOH being imported.
Import Stock on Hand template field* denotes mandatory fields | Description |
*Product Code | The unique Product Code for the product. |
*Warehouse Code | The Warehouse Code, the SOH quantity is being added to. |
*SOH | The product's total Stock On Hand quantity, per warehouse. |
*AverageLandCost | The product's current Average Landed Cost (ALC). |
Serial Number | If Serialized Products is enabled, the serial number of each SOH unit, per product. |
Batch Number | If Batch Tracking is enabled, the batch number for each batch of the product's SOH. |
Expiry date | If Batch Tracking is enabled, the expiry date for each batch of the product. |
How to enter Serial or Batch Numbers into the SOH template
To assign multiple Serial or Batch Numbers to each product on the Import SOH template, list each serial or batch number in per row in the respective template column. Once the serial or batch numbers have been added for a product, enter the next product's details in the subsequent row and list the next product's serial or batch numbers in the same way.