web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Item Recalculation Rev...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Item Recalculation Reversal - How to validate

(0) ShareShare
ReportReport
Posted on by Lwebbie 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! 

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Lwebbie,

    If I understand you correctly then the reversal of the recalculation does not generate a respective correction voucher in GL.

    Have you checked the GL form 'subledger journal vouchers not yet transferred' to ensure that there is nothing pending there?

    If nothing is visible there can you let us know your AX2012 version that you operate? (build no.)

    In addition, do you see a change in inventory value before and after you recorded the recalculation? I would like to ask and double check that the recalculation does not only create physical transactions. Would be great if you could re-run the recalculation for this item in a demo/test system and share the voucher settlements and the respective settlement report.

    Many thanks and best regards,

    Ludwig

  • Lwebbie Profile Picture
    Lwebbie 15 on at

    Ludwig,

    That is correct, I don't see a respective correction voucher in the GL. 

    I checked the 'subledger journal vouchers not yet transferred' and it is empty.

    I am on 2012 R3. 

    I will rerun the recalculation, how do I pull a settlement report? I know how to see the settlement transactions associated with the recalculation. 


    Thanks!

    Liz

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

    Hi Liz,

    On the Inventory Closing and Adjustment form, you can change the view from 'Active' to 'All'. In that case, the reversed adjustments should be visible. When it initially got disappeared, it means that it has been reversed. The reversal adjustment itself is also visible. You can then go to the details and view the settlements and voucher transactions.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Good Morning Liz, 

    Can you check the highlighted elements in your closing and adjustment form?

    They should give you additional insights what happened from a valuation and financial perspective. 

    Best regards, 

    Ludwig

    invcl.png

  • Lwebbie Profile Picture
    Lwebbie 15 on at

    Ludwig,

    I printed the recalculation and the financial cost column (in yellow) is blank. Also I ran the GL > Posted Transactions by journal report and put in the journal number from the recalculation and it is came back as blank. However, if I pull the GL > Ledger transaction list the vouchers shows in the respective accounts, this was leading us to believe it was posting an actual financial transaction. 

    The last image is the recalculations we did, the one is blue is the one referenced below. If I were to cancel it would completely disappear from the list, but the voucher would still show in the GL > Ledger transaction list for the respective accounts. 

    pastedimage1588347587288v4.png

    pastedimage1588347483833v2.png

    pastedimage1588347498100v3.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Lwebbie,

    To me the first screenshot looks as if the items were posted with a $0 financial cost amount.

    As a result, the adjustment amounts shown in the last column are recorded and posted in GL.

    Is this possible?

    Can you check the cost prices of the items listed?

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

    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.

  • Lwebbie Profile Picture
    Lwebbie 15 on at

    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!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Lwebbie Profile Picture
    Lwebbie 15 on at

    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?

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 608

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 591 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 430

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans