
Hallo,
We uploaded an inventory adjustment file which updated the costs and quantities of multiple products.
Before the issue was identified we did a stock close. This is a necessary step when using the weighted average costing method.
Due to the uploaded file, the cost price of multiple sales orders has been updated incorrectly.
We then adjusted the transactions on the stock close, and did recalculation, which corrected the average cost but not the sales orders.
How do we correct the cost price on the sales orders as our margins are incorrect at the moment.
Regards,
Hi Keyla.C,
Where are you looking for the transactions ? Because whenever we do a weighted average inventory close, the adjustments are done on the issue transactions.
So there would definitely be some adjustment transactions for sale orders if there's a difference b/w the running average price & weighted average of the period. Please see the transactions under Cost management> Inventory accounting inquiries> Transactions.
One more thing, can you see that if those Sales order are physically updated or financially updated?
Warm Regards,
Zain