Users may encounter having incorrect average costs for their items. Causes of this scenario may vary from business to business.
Here are some tips on what we can do:
I. To check the cause of the behavior, we can do it through the help of different inventory-related reports such us, but not limited to,Inventory Valuationand Inventory Activity Detail.
II. Identify the type of Inventory to know the possible approach in resolving. Is it serialized or non-serialized?
III. To resolve,
a.) we can use the Adjust Inventory (Transactions > Inventory > Adjust Inventory) for serialized items. We just have to zero out the quantity first and then bring them back with the correct unit cost.
b.) we can use the Inventory Worksheet(Transactions > Inventory > Adjust Inventory Worksheet) if our item is non-serialized.
IV. For multiple items/lines, we can create and update records using the CSV Import Assistant. It is recommend to perform this in batch instead of updating all items at once. Refer to the following for more information:
a.) SuiteAnswer Id 51417 – Inventory Adjustment Import
b.) SuiteAnswer Id 20037- Single Inventory Worksheet Import
Just to share, in the event that you wish to revalue the Location Average Cost for items that use Standard Costing Method, you can use the following options:
1.) Create a manual Inventory Cost Revaluation and set the desired cost or
2.) For Bulk Process, edit the cost of existing Planned Standard Cost then proceed to Revalue Standard Cost Inventory.
To ensure that necessary setup or steps have been performed to get standard costing work perfectly, you can check this Standard Costing Workflow.