Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Suggested answer

Large Rounding Variance Postings on Product Receipt

Posted on by 25

Hello, has anyone seen the following error?(we are using standard costs) It seems the system is taking into account both the activated standard cost and the last purchase price when calculating the purchase price variance.

pastedimage1680875351152v1.png

"There exists variance XXXX between total standard cost variance and total inventory cost adjustment. It will be posting as rounding variance."

pastedimage1680875495448v3.png

We purchased the item for $9,000 with an activated standard cost of $8,935.34 this leads to the expectation of a $64.66 purchase price variance. However, the system will post the variance from the last purchase price ($9K-$7,439.20 =  $1560.80) to the PPV account then post the difference between $1560.80(last purchase price variance) and the $64.66(expected purchase price variance) of $1,496.14 to the rounding variance account. Every month, we are taking the rounding variance accounts and manually adjusting the rounding variance amounts back to the PPV account.

How can I get this behavior to only post the expected purchase price variance of $64.66 and stop the system from calculating the last purchase price variance?

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,480 User Group Leader on at
    RE: Large Rounding Variance Postings on Product Receipt

    Hi rlyoungb

    I haven't seen this error before, but there is an old issue in community : community.dynamics.com/.../843138

    Please let us know if this helps.

    Thanks,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans