You’re offline. This is a read only version of the page.
15
I am new to AX (using version 2012 R3) and working to help reconcile some inventory issues we are having. We ran an item recalculation for a specific item but now we need to reverse it. When I reverse it on the the voucher disappears from the "Closing and Adjustments" screen but when I go into the GL and lookup the voucher it is still there. I also ran a ledger transaction list for the date expecting to see offsets for the original settlements but there is nothing there.
I assumed I would see either a new voucher created in "Closing and Adjustments" to reverse the original recalculation voucher and offset the settlements, and the inventory value to go back to what it was. The inventory value did return to what it was prior to the recalculation but the it appears the settlements from the recalculation are still hitting the GL accounts.
Shouldn't we see an offset to voucher? I need to prove this is truly a reversal to my leadership and that is hard to do when the original vouchers is still showing in the ledger transactions and there is no offset voucher.
We are doing all this in our testing environment just to be safe.
Any insight would be great!
Hello Lwebbie,
You should be able to see something like this:
Best regards,
Ludwig
Good morning Lwebbie,
Great to hear that you got this one fixed/answered.
If there is nothing else left open for this thread then it would be great if you could verify the answers by hitting the yes button further above.
Many thanks and best regards,
Ludwig
I tried on a new item that was setup correctly. I pulled the GL > Trial Balance before I ran the recalculation and then again after I ran the recalculation. The difference match the voucher and the item cost has been updated to reflect FIFO (the inventory model we use). Then I ran the reversal of the recalculation and pulled the trial balance again and there is an offset bringing it back to the starting trail balance. The only odd thing is that I can still pull the old voucher and it shows the original adjustment and there is no voucher reflecting the reversal. May just be an AX thing, I would have just expected to see a new voucher created showing the reversal. Or for the original recalculation voucher to be removed from the GL all together.
At least we can see the changes in the GL Trail Balance are being reversed.
Thanks!
Hello Lwebbie,
For an ordinary item that is properly setup and regularly used in purchase / sales orders, I would expect seeing some adjustments for the valuation method selected (fifo, lifo, etc.)
This here is an excellent post that gives you more insights:
A bit old but largely still valid.
Best regards,
Ludwig
Not sure if that is possible, we are talking years of bad data and practices that we are now trying to correct. Fortunately, of the hundreds of items we need to fix one a handful (maybe 5) don't have a cost associated with them.
That being said, for an item that was setup correctly and does have a cost associated with it. What should I expect to see when I do an item recalculation reversal?
Good Morning Lwebbie,
If an item had no costs associated until 4/24 then item issue transactions might have been wrong.
What you can do here is - for example - adjust the incorrectly entered transactions by making use of the adjustment-transactions or adjustment-onhand functionalities in the closing and adjustment form.
Please test those options carefully in a demo/test environment especially if you have not used these features before.
They should allow you getting your inventory values corrected.
Best regards,
Ludwig
This was an item that didn't have a cost associated with it until 4/24, we found that when we were doing the adjustment so we added it.
I have some items that we did recalculations for that had costs associated with them so I can try a reversal on one of them. If a reversal on a recalculation works as designed we should see what happen? (i.e. a new voucher for the offset amounts, a deletion of the voucher all together, etc.).
Thanks!
Hi Lwebbie.
All the recalculations are still active in your screenshot. If one of these should have been cancelled, then it probably didn't run. I can't see any 'Cancellation' records here.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (