Hi everyone,
My client is using Microsoft Dynamics 365 Finance and operations latest version.
I am facing an issue which is mentioned:
We have run the inventory recalculation and closing till 25 June 2022 and after that when the retail statement was posted on 27 June 2022, it give an abnormal negative cost, below are the details:
Before posting of retail statement, inventory of item was around 59500 qty having financial cost amount of around 365000.
After posting of retail statement, inventory of item was around 59000 qty having financial cost amount of aroiund -3,195,406,604.10.
The reason of running inventory closing at 25 June 2022 was because client wants to change the costing method from FIFO to Weighted Average and for that purpose, we performed the recalculations and inventory closing till 25 June 2022 and the changed the costing method.
P.S. I replicate the Live environment to test and performed the same activity of costing method change and processed manual sales order but there is no issue in that but when retail statement is posted then system posts an abnormal negative financial cost amount.
Has anyone faced this?
Urgent help regarding the root cause and solution for this would be highly appreciated.