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)

How is PPV (Purchase price variance) calculated in AX?

(0) ShareShare
ReportReport
Posted on by 2,365

How is the PPV calculated in AX? I am trying to manually calculate and reconcile PPV.

A definition would be greatly appreciated :) 

Thank you!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: How is PPV (Purchase price variance) calculated in AX?

    Hi, it's the difference between your standard costs defined and the actual price you pay for your purchase. Best regards, Ludwig

  • Suggested answer
    Brandon Wiese Profile Picture
    17,788 on at
    RE: How is PPV (Purchase price variance) calculated in AX?

    That's the conceptual definition, but the actual process is slightly more complex.

    For example, you could have Purchase indirect costs (landed freight, duty, etc.) in your cost sheet, and therefore incorporated into your standard costs.  Or, you could be using Misc. charges of type Item to apply additional fees into your receipt inventory value (something I have not yet tried while on standard cost).  

    AX calculates PPV as the difference between the inventory receipt value it WOULD have applied to the inventory under FIFO and the inventory receipt value it MUST apply to the inventory under Standard cost.  The key here is that more than just the purchase price can factor info the inventory value it WOULD have applied.  Under the hood, AX does almost exactly the same work it would do under FIFO, and then just prior to posting makes a comparison to Standard cost when configured and offsets the difference appropriately.  Thus, understanding FIFO in AX is still useful even here.

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