Refer to the example below:

• The inventory was closed till 31-12-2022, normally. And the weighted average cost was calculated in a correct way.
•  For the below item after closing, the latest weighted average calculation was on date 09-11-2022 and the unit cost was “762.21”.
•  At the end of 2022 the total QTY of item was “13”.
• Then a new purchase was received in 2023 by the date 25-01-2023.
• The unit cost of the new purchase was 608.86.
• At the end of the period when run the inventory closing for 31-01-2023.
• The system did not consider the cost of units coming from the previous period and the weighted average calculation only considered the new purchase cost and it was calculated as 608.86.
• As per the manual calculation outside the system the correct weighted average unit cost should be “624.19”.