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 cost per ite...
Microsoft Dynamics AX (Archived)

inventory cost per item is not correct after recalculation or closing of the month (weighted average model group)

(0) ShareShare
ReportReport
Posted on by Community Member

Dears,

im facing an issue where the average cost of a lot of issued items isn't correct after recalculation or closing at the end of the month.

where the average purchase and receipt price lies between 1.28-1.3 in all transactions in particular month but the issuance have some tranasctions with 1.04 !! 

Below is receipt list from the item trans page:

844075.Capture.PNG

and below is some issuance with wrong average cost 1.04 where it should be not less than 1.27

2100.Capture1.PNG

Recalculation is done many times.

model group is weighted average.

Please support.

*This post is locked for comments

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: inventory cost per item is not correct after recalculation or closing of the month (weighted average model group)

    Hello Ahmed,

    Calculating the average price in Excel might give you wrong results because you do not see transactions have been marked against each other and are therefore excluded from the recalculation.

    In AX2012 and d365fo you can open a cost explorer and trace form that give you an insight into the origin of the costs of the transactions.

    You can find those forms in the inventory transaction form for your item

    2100.inv.png

  • Community Member Profile Picture
    Community Member on at
    RE: inventory cost per item is not correct after recalculation or closing of the month (weighted average model group)

    Hi Ludwig,

    the average in the screen shot calculated in excel after exporting the transactions of the item from AX.

    can u elaborate more about cost trace functionality?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: inventory cost per item is not correct after recalculation or closing of the month (weighted average model group)

    Hi,

    How did you calculate the average yellow highlighted column and where did you export the values from?

    Have you tried following the origin of the issue by have a look at the inventory cost trace functionality?

    Best regards,

    Ludwig

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,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans