You’re offline. This is a read only version of the page.
Announcements
30
I am working in Microsoft AX 2009 and our system is using the weighted average by date method which includes the physical value. There will be instances where an account will show a balance with a Voucher ADJV indicating that it is from the inventory recalculation that I run weekly (see pic 1). However, when I go to the Origins tab to drill down to what SKUs are affected it - it'll show me all the skus and accounts that were affected by the recalculation in that journal (see pic 2). My questions are - is there a way to see exactly what SKU affected which account? As you can see in pic 2, finished goods, wip, and cogs were hit showing all the different SKUs but it doesn't say which skus hit which account. My second question is why are there different G/L accounts hit from the recalculation...why would some hit cogs while others hit finished goods? I would understand inventory accounts being hit but I don't get what constitutes a sku recalc to hit certain cogs accounts?
Hi Cost accountant pdx,
To my knowledge there is no drill down functionality available that would be comparable to - let's say - the drill down that you have available in the trial balance form or in the management reporter.
A kind of drill down is available in the settlement form that you can find in the closing and adjustment form.
Once you have opened the settlement form you can open the related voucher, inventory transactions and settlement transactions, which is a kind of drill down.
Another option is to open the voucher that was created during recalculation and then checking the transaction origin, which gives you a linkage between your inventory posting and your GL voucher.
If you need more than that, you will probably have to design an own report/analysis form.
Best regards,
Ludwig
Thank you all. The print adjustments was a new one for me and helpful! - but it doesn't drill it down to GL. It shows a Number column but this number isn't associated to anything in DAX for the GL variance i'm looking for.
And the settlements are helpful for doing one by one transactions. However I have 1000+ lines ...so other than those two there isn't a way that you all know of to narrow it down to which skus hit which GL?
Thanks again!
Agree with André's suggestion. the adjustment vouchers created during recalculation is mapping with settlements.
Hi Cost accountant,
In addition: Starting from the inventory closing or the inventory transaction, you can open the settlement details which will give you insight what exact transactions were settled and which correction amount was posted. This could help analysis, but it will be quite hard to understand it if you look transaction by transaction.
Hello Cost accountant pdx,
Is it quite difficult to identify the underlying items and the reasons why an adjustment amount has been posted. This is partly because of the complexity of the calculation method. What usually helps is the adjustment report that you can run in the closing and adjustment form by selecting 'print-adjustments'. Hope that answers your first question.
The second question is almost impossible to answer without doing a deeper analysis of your transactions. In general, the inventory posting matrix that you can find under inventory-setup-posting-posting defines for each item group the ledger accounts used. Can you check this setup and compare it with the accounts used in your vouchers?
Note:
What might help in addition is the following blog post that describes the inventory closing/recalculation procedure extensively.
It's quite long and detailed but I believe it is worth working through
Best regards,
Ludwig
#1
André Arnaud de Cal...
294,137
Super User 2025 Season 1
#2
Martin Dráb
232,877
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
