Has anyone met case that Inventory Recalculation Value ( ex: adjustment for raw material) is different from it's GL voucher value ?
We are using AX 2012 R3 CU0.
*This post is locked for comments
Hello Peter,
Can you share some additional details on the difference that you identified, such as how did you identify it?, what accounts did you investigate?, how did you calculate your GL balance, etc.
It would be great if you could also share some screenprints that illustrate the issue.
Many thanks and best regards,
Ludwig
One possible reason is that 'Non-financial transfers' are ignored by Inventory close - Basically the stock is still in the company so a transfer does not change its value. The inventory cost is adjusted, however the posted transfer journal lines are not changed and the cost amount still shows the same values as before recalculation
Hi Ludwig Reinhard,
When I checked Inventory Value Report and GL account for Raw Material for 1 month, I found that the difference is from Inventory Recalculation Voucher.
So I investigated that I filtered Inventory Recalculation transactions by Raw Material Item Group compared with Raw Material GL Account in it's voucher.
I exported Inventory Settlement and filtered by Raw Material Group
I exported Voucher of this recalculation and filtered by Raw Material Account
The difference is same as one when I compared Inventory Value Report and GL account.
I did the same steps for other Inventory Recalculation months, it was matched between Inventory settlement and GL
- The Costing Method is Weight Avg
- Post Physical Inventory is checked
- Post Financial Inventory is checked
Hi Crispin John Augustine,
We performed Inventory Closing after recalculation.
We don't need to reverse the recalculation because many closing periods were performed.
We would like to the reason for the difference only that we can explain to Audit later.
From your screenprints I cannot identify a difference between GL and inventory.
I only see a total calculated in Excel.
Can you share a screenprint of the inventory value report that shows the inventory and GL balances similar to what is shown in the next screenprint?
Hi Ludwig Reinhard
Please see the screenprint of Raw Material
Hi,
What you have to do is to define a total account in the general ledger that holds all the inventory accounts.
This total account needs then to be setup in the inventory value report and shows you the difference between GL and inventory.
Currently you do not have such an account setup and therefore see a difference of 100%.
You can find details of the required setup in this whitepaper for AX2009 that is still valid for AX2012 and later versions
www.microsoft.com/.../details.aspx
Best regards,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Tocauer 4
Community Member 2
Nayyar Siddiqi 2
