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

Announcements

Check out the Community Spotlight Video Series
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 gives wrong figures for the items financial amount and unit cost price

(0) ShareShare
ReportReport
Posted on by Community Member

There is a counting carried out then a recalculation for the inventory had been run over Item groups without selecting specific group. The figures of the item was not correct and adjustment had been done for most of the items to correct the cost price to be correct over site and to be the same over the breakdown on locations. After adjustment; a recalculation took place and the result that the figures got far from the correct ones set by the adjustment. The inventory value after adjustment and before recalculation equals 2,505,296,326.61 which is the right value while after recalculation gets to 2,628,991,613.11.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,308 Super User 2026 Season 1 on at

    Hi Marwa,

    The behavior of the recalculation depends on many settings. E.g. Do you include physical values (setting on Item model group)? What dimensions are included as financial cost price? Also the transaction details are important. So probably you won't get a definite answer on this forum as it depends on many things.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre

    Actually I need some guide lines not a very specific answer. The physical value is included in the model group and also financial inventory is active over site on the dimension group for non serialized items while it is active on site and serial over the serialized group.

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

    You could try closing the inventory  (out of hours)

    Then zero the stock and re-load it with the new values.

  • Community Member Profile Picture
    Community Member on at

    It will solve it for the time being but if there is any setup missing or something wrong; the problem will be repeated again.

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

     ...and that raises the questions whether the original numbers were actually wrong e.g. due to wrong posting set up, or wrong data entry, and/or whether, they were not understood , or that users just did not like the numbers they saw perhaps due to the timings or sequence of bookings..

  • Community Member Profile Picture
    Community Member on at

    It is due to wrong data entry for the prices.

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

    In which case its not a set up issue and my last suggestion is an option.

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans