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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Large Rounding and Purchase Price Variances with Foreign Currency & Discounts

(0) ShareShare
ReportReport
Posted on by 25

Hello,

We are experiencing very large Rounding Variances coupled with very large Purchase Price Variances when posting PO receipts. There is also a foreign currency involved. Can anybody help explain why this behavior is happening?

The PO total we see here is $37K. However, when I look at the voucher, there are over $114K of Rounding and Purchase Price Variances. When looking at the Standard Cost Transactions for a single item, there is a massive variance for these items.

PO-Total-_2400_37K.pdfRounding-_2600_-PPV.pdfStandard-Cost-Transactions.pdf

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,130 Super User 2025 Season 2 on at

    Hi rlyoungb,

    I do assume you are using standard cost? What is the actual active cost price? Can you share the details from the posted invoice? What values were provided?

  • rlyoungb Profile Picture
    25 on at

    Invoice-Lines.pdfSTD-Cost-Price.pdf

    Hi Andre,

    I think the STD Cost price actually may have an impact, but I'm not sure if it is just that. Please find the STD Cost and Invoice Lines as follows:

  • rlyoungb Profile Picture
    25 on at

    Here's the STD Cost Transaction for that item as well.STD-Cost-Transactions-CW0306T.pdf

  • André Arnaud de Calavon Profile Picture
    301,130 Super User 2025 Season 2 on at

    Hi rlyoungb,

    I don't have a clear overview as the screenshots are not telling all small details. What I noticed is that you have enormous discounts on the purchase order invoice. It could be the case that this is causing the variance.

    When you have e.g. a standard cost of $100, a purchase order with unit price of $120 and 75% discount, then the line amount is $30.

    The actual price posted for the inventory is $100 which is standard cost. For the difference (100-30=70), this will be posted as standard cost variance.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans