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 / Microsoft Dynamics AX (Archived) / The Inventory value re...
Microsoft Dynamics AX (Archived)

The Inventory value report does not show fixed values after inventory closing

(0) ShareShare
ReportReport
Posted on by Facundo Costabile 345

Hi all, I'm having a problem with the Inventory Value Report on AX2012 R3.

I am using Weight average cost method and I always close the inventory monthly. I generated today morning the report between the dates 8/1/2018 to 8/31/2018. One hour later, I generated the same report on same dates and the Financial Quantity keeps the same value but the Financial Amount changes. Making several tests I realized that any later transaction to the inventory closing change this value, even when the 'To date' is a closing inventory date.

Is this the normal behavior of the report? Can anybody help me?

Thanks a lot!!

*This post is locked for comments

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

    Hi,

    Can you explain what you mean by saying

    "... any later transaction to the inventory closing change..."

    What is this later transaction, how and why do you record it?

    Best regards,

    Ludwig

  • Facundo Costabile Profile Picture
    Facundo Costabile 345 on at

    Hi Ludwig, thanks for your reply!

    I mean any transaction after the inventory closing, for example a sales invoice or a purchase receipt that I make on september the value changes.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Do you use the weighted average or weighted average date valuation principle?

    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/about-weighted-average-with-physical-value-and-marking

    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/about-weighted-average-date

    Can you identify what retrospective changes are recorded? Do they come from settlements or other inventory transactions (purchases, sales)?

    Best regards,

    Ludwig

  • Facundo Costabile Profile Picture
    Facundo Costabile 345 on at

    I am using both methods. Some items have weighted average and others weighted average date. And the changes come from the inventory transactions, and from all of them, not for one in special.

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
Basit Profile Picture

Basit 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans