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 :
Microsoft Dynamics AX (Archived)

Is there a difference between the Weighted Average and the Moving Average?

(0) ShareShare
ReportReport
Posted on by 14,855

Dear 

I created two items one one Moving average and the other on weighted average and i did 2 receipts for the same exact amount ,

purchase Qty 1000 for 10

purchase Qty 1000 for 20

both items have exactly the same cost price , 15$

is there an actual difference between the cost calculation method of Moving average and weighted average?

or is it something that shows up after inventory closing?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Is there a difference between the Weighted Average and the Moving Average?

    Hi Silvano,

    The moving average and weighted average calculation methods are similar but not identical.

    That is, the moving average is a current evaluation technique that calculates the average value as you post transactions. Any differences - when recording issuance transactions - are directly recorded on variance accounts.

    The weighted average is using a temporary average cost Price - which is very similar to the moving average one. Yet, the major difference is that you need to run an inventory close to get the 'correct' moving average cost price calculated. The weighted average method is thus a retrospective valuation method and requires an inventory close that the moving average method does not require.

    For additional information, please have a look at TechNet and the other AX help sites.

    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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans