Skip to main content

Notifications

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, ... / Reversed Inventory rec...
Finance | Project Operations, Human Resources, ...
Suggested answer

Reversed Inventory recalculation Still showing in Items adjustment

(0) ShareShare
ReportReport
Posted on by Lira.B 15

Hi,

I am facing an issue regarding the Inventory recalculation.

I did run an Inventory recalculation for the month of October and it get stuck so I decided to cancel the batch job. After canceling the batch job we did delete the voucher from the InventClosing table and re - run the Inventory for the period of October.

After the recalculation did finish we noticed that the canceled one was still showing as an adjustment value in the Items, but wasn't posted in the GL, meanwhile the new recalculation has posted entries in the GL, causing inconsistency between the GL and COGS.

Can anyone let help how to cancel the deleted values? 

  • Lira.B Profile Picture
    Lira.B 15 on at
    RE: Reversed Inventory recalculation Still showing in Items adjustment

    Hi Ludwig,

    We managed to solve the issue by creating the header of the Inventory calculation in inventClosing table, with the same characteristics and same voucher number of the deleted one, which it's linked with the transactions in the InventSettlement table. Now the GL and Sales are posted just fine.

    But in December we have faced another issue regarding the recalculation with another client.

    The client has recalculated one item for the month of December and than decided to cancel it.

    The recalculation itself has created settlements, but has not posted in Ledger, while the canceling has created settlement and has also posted in Ledger.

    This causing discrepancy between GL and Sales.

    How is that even possible to happen and how can we manage to fix the issue??

    Thank you in advance,

    Lira

  • Lira.B Profile Picture
    Lira.B 15 on at
    RE: Reversed Inventory recalculation Still showing in Items adjustment

    Hi Ludwig,

    Yes, we did analyze the reasons of the inconsistency. We will take care of the deleted voucher with a developer as well.

    Regards,

    Lira

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reversed Inventory recalculation Still showing in Items adjustment

    Hi Lira,

    I would recommend that a developer has a look at this.

    Deleting vouchers is something very critical and can cause a lot of inconsistencies/problems in your system.

    If the inconsistency existed already before then it might be wise analyzing why those inconsistencies were created and what process caused them.

    This is probably not a short-term analysis and necessitates technical knowledge of the code (and code adjustments) that is responsible for those inconsistencies.

    For that, you will need some technical help.

    Best regards,

    Ludwig

  • Lira.B Profile Picture
    Lira.B 15 on at
    RE: Reversed Inventory recalculation Still showing in Items adjustment

    Hi Ludwing,

    We did delete the voucher of the canceled recalculation from the inventclosing table. The inconsistency between GL and COGS did happen before we deleted the voucher. Because the recalculation it is recalculation twice the same sales order of October even in November, and we don't know why this is happening.

    Meanwhile the transactions of the deleted voucher do still exist in the InventSettle table.

    Best Regards,

    Lira

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Reversed Inventory recalculation Still showing in Items adjustment

    Hi Lira

    Can you describe in more detail what you deleted?

    Did you really delete the voucher?

    Did you only delete the voucher or also the related pending calculations?

    Based on what you write I would expect an inconsistency between GL can COGS that you won't be able to fix yourself from the AX client.

    For that reason, please talk to a developer / system admin how to get this fixed.

    Do you have a database backup from the time before the deletion of the voucher occurred?

    Best regards,

    Ludwig

  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Reversed Inventory recalculation Still showing in Items adjustment

    Can you try to cancel it again if it exists their it means that it's still activated for adjustments. 

    For that you also may have to cancel the later adjustments. Because changes in inventory may cause a ripple effect.

    Warm Regards,

    Zain

  • Lira.B Profile Picture
    Lira.B 15 on at
    RE: Reversed Inventory recalculation Still showing in Items adjustment

    We did cancel it from the table but after it got canceled it didn't allow us to start a new recalculation, that's why we did delete it from InventClosing.

    I did check the voucher from the inventory adjustment and the cancel button its not checked.

  • Suggested answer
    Zain Mehmood Profile Picture
    Zain Mehmood 2,715 on at
    RE: Reversed Inventory recalculation Still showing in Items adjustment

    Hi Lira.B,

    Why did you deleted the transactions from the table, that is not good practice. You should have canceled the recalculation voucher from the inventory closing window. That would have been the right way to do so. Can you see if the first recalculation voucher has the cancel button checked for that?

    Warm Regards,

    Zain

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans