web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics AX (Archived) / Inventory recalculatio...
Microsoft Dynamics AX (Archived)

Inventory recalculation with empty voucher

(0) ShareShare
ReportReport
Posted on by alzelus 4

Hi

I have some inventory recalculation with settlement that didn't post to the GL. How Can I fix it ?

The recalculation is done, there is a lot of transaction in the settlement, but the voucher is blank.

Any Idea why this can happend?

Can I recreate the GL entry directly in the database

Thanks for your kelp

*This post is locked for comments

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

    Hi,

    One possibility might be that the voucher is still pending in the subledger journal postings not yet transferred form in GL. If this is not the case then print the adjustment report (print-adjustments) to get some additional insights. You might have settlements that are related to the 'marking' principle and consequently do not result in posted voucher transactions.

    Best regards,

    Ludwig

  • alzelus Profile Picture
    alzelus 4 on at

    It look like there was a problem at the moment of the posting to the ledger.

    The settlement is full of transactions but none of them have been written to the GL. Even if I try to cancel it it is acting like it have been posted.

    Can I play with the status in the DB to make it cancelable again ?

     

     

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

    Hello alzelus,

    In a test/demo environment you can certainly 'play' with the status.

    However, I would not do that in a live environment if you are not absolutely sure what to do.

    By the way, does your inventory recalculation has a log or an error sign? I regularly see recalculations that do not result in ledger postings. All depends on the transactions recorded. That is, if you do not see a ledger posting created there must not be something wrong.

    Best regards,

    Ludwig

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at

    I have seen this when there are a lot of transactions to process and the client machine may not be able to finish the task. This happens when companies rely on recalculation and only run inventory close e.g once a year or in some cases much longer periods. Its bad practise, but it happens. Even when you use helpers those only help the calculation part of the close, not the GL posting that results.

    I don't know whether this is the cause of your problem- as Ludwig suggests then check the error messages.

    If you think this may be the reasons, then you will find this old blog post of use to try and resolve things. http://natepaine.blogspot.com/2010/10/large-inventory-close-workaround.html

  • Verified answer
    alzelus Profile Picture
    alzelus 4 on at

    I have been able to regenerate the voucher.

    I cancel all the recalculation to the point where there was no voucher. The recalculation with no voucher was a cancellation.

    I unlinked the canellationRefId on the inventclosing table and I uncheck the cancelled for each line of the recalculation on the invent settlement table I also put back the RECALC to Active. This way I have been able to redo the cancellation of the recalculation and it rebalanced the GL.

    Been able to do a recalculation to the end of the month and an invent closing.

    Everything look ok.

  • guk1964 Profile Picture
    guk1964 10,888 on at

    Good to hear- thanks for the update.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans