Helpful Links:

Data Import Checklist

Troubleshooting Import Errors

How to manage Average Landed Costs

Import Stock Revaluation Field Definitions

Use the Import Stock Revaluation to update the current Average Landed Costs (ALC) of your products and manage the total value of your existing Stock on Hand (SOH). 

Points to Note

• The Import Stock Revaluation only applies to products that have a current Stock on Hand (SOH) quantity.
• Changes to a product's Average Landed Cost (ALC) will only apply to transaction's completed after it's been updated. 
• The Import Stock Revaluation cannot be back-dated.
• Changes made to a product's ALC by the Import Stock Revaluation will be logged as a value-only Stock Adjustment. 
• The Import Stock Revaluation can only be completed using a CSV format. 
• The Import Stock Revaluation updates the ALC of the product across all warehouses and is not warehouse specific. 

Import Stock Revaluation

The Import Stock Revaluation page allows you to export the current Average Landed Costs (ALC) for all products that currently have stock on hand into a CSV template, which can then be used to bulk update their ALC, if required. Upon import, any changes made to a product's ALC will create and complete a value only Stock Adjustment that will update the product's Stock Value, based on it's current on hand quantity.

If integrated with an accounting provider, the stock revaluation will export as a Stock Journal to your default Stock on Hand and COGS accounts, exporting the adjustment's total value.

Using the Import Stock Revaluation

Follow the below steps to process a Stock Revaluation: 

1. From the main menu, head to the Inventory module, Transactions and select Import Stock Revaluation. 
   
   
   
2. Click the Download Stock Revaluation Template File button and this will download a pre-populated template with all products that currently have SOH across all Warehouses in your account.
   
   
   • Product Code: Product code for an existing product.
   • Product Description: Product description for an existing product.
   • AverageLandCost: The current ALC for the product.
   • NewAverageLandCost: Where the new ALC will be entered.
     
     
3. Initially, the NewAverageLandCost column will be blank, but this is where you will want to advise an updated cost:
   
   
   • Remove any product rows that don't require an updated ALC, this will ensure no changes are inaccurately made for the product.
   • If the NewAverageLandCost field is left blank in the template and imported, it will not update the product's ALC in Unleashed.
   • If the NewAverageLandCost field is given a 0 value, the product's new ALC will be 0.00.
     
     
4. Once the NewAverageLandCost column has been filled in, upload the CSV file via the Import Stock Revaluation.
   
   
5. Once uploaded, a Stock Adjustment per updated ALC will be created and completed to register the change. Each Stock Adjustment will display Reason: Stock Revaluation.

To review an individual product's current ALC and how it's changed over time, open the product's record and go to the Costs tab. At the top of the page, the current ALC will be displayed in an un-editable field, next to the product's Last Cost. Below, in the Costs grid, any transaction that has triggered a recalculation for the product's ALC will be displayed.