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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Closing and Adjustment...
Microsoft Dynamics AX (Archived)

Closing and Adjustment not balance

(0) ShareShare
ReportReport
Posted on by Osman Adanur 95

Hi,

As you know, we are closing stock at the end of each month in closing and adjustment form.

8688.err2.PNG

And normally, in the recalculation process, Adjustment amounts were collected and posted as a voucher on the last day of the month. It is described in the picture below.

But this month did not happen correctly. Did not post collection of adjustment amount.

If I cancel the recalculation and try it again, I get the same result again. 

What should I do to accomplish this?

I would appreciate your help.

4478.Err.png

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,704 Super User 2025 Season 2 on at
    RE: Closing and Adjustment not balance

    Hi Osnan,

    Can you check if the option 'Post financial inventory' is still enabled on the Item model group(s)? As of date 27.2.2017 it seems like there is a difference between inventory and the ledger. Are you sure the selected date for closing the inventory was 28.2.2017? Not by accident e.g. 28.4.2017 or 28.2.2018?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Closing and Adjustment not balance

    Hi,

    Can you explain a bit more on the recalculation that you showed in the screenshot above? Where do you get the data from? How can you say that the values are not right and that you expect the difference highlighted?

    The sum of amounts columns show different totals. How does this come?

    Instead of making the reconciliation in the way shown above, have you tried using the inventory value report?

    Best regards,

    Ludwig

  • Osman Adanur Profile Picture
    Osman Adanur 95 on at
    RE: Closing and Adjustment not balance

    Hi Andre,

    It produced accurate results when we try to April. But in February and March we get an error. It is still wrong when I cancel and recalculation to February. Normally, it is necessary to post the sum of adjustment amounts into the last day of the selected month. This is happening for the 4th month.

    Could not it have been canceled when we canceled the 2nd month? Where else should I look?

    Thank you for all.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,704 Super User 2025 Season 2 on at
    RE: Closing and Adjustment not balance

    Hi Osnan,

    The base for the calculations and posting is the setup and transactions done. The inventory closing and recalculations is not an easy area. You can download the Inventory costing whitepaper which explains how it works.

    To be able to find the culprit you need to verify all settings and transactions. Did you select to summarize the posting or create a posting per Item? If you select per item, you have more details to check where the issue may come from. I have done a lot of troubleshooting in this area in the past and can try to guide you with some tips, but I'm not aware of your settings and transactions done.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
AlissonGodoy Profile Picture

AlissonGodoy 2

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans