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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Standard Cost rounding issue

(0) ShareShare
ReportReport
Posted on by 1,632

Based on my research, I want to do the opposite of everyone else.  I want to have standard costs rounded to 2 decimal points.  The issue I'm running in to is that standard cost is calculated correctly, but as the Quantity increases, the math just doesn't add up.  Here is the example:

Quantity = 1 Standard Cost = $50.99 - This is correct

Quantity = 2 Standard Cost = $101.98 - This is correct

Quantity = 7 Standard Cost = $356.91 - Would expect $356.93

Quantity = 10 Standard Cost = $509.88 - Would expect $509.90

Where we see the issue is when doing a production order, I get the correct math to 2 decimal places on the cost and estimation, but when compared against standard cost, I'm getting a variance.  I don't want a variance, even if it is less than a dollar, they are transactions that are unnecessary and as quantities increase, so does the variance. 

Any help or direction would be appreciated.

*This post is locked for comments

I have the same question (0)
  • amarsingh Profile Picture
    247 on at

    Hi Ansel,

    Which costing method are you using for your raw materials?

  • FAC.Ansel Profile Picture
    1,632 on at

    Standard Costing

  • Weaveriski Profile Picture
    23,620 Moderator on at

    Please show the costings of the $50.99. My assumption is you have lower level items that have figures >2 dp or you are using indirect elements, and this cascades as it extends.

    You do not want rounding on the parent, you have that, your issue is at a lower level I believe.

  • FAC.Ansel Profile Picture
    1,632 on at

    You are correct.  The lower level items did have more than 2 dp's.  We have updated those and still get the same numbers.  My guess now, is that the indirect costs from the costing sheet are causing the additional decimal places.  Is there a way to control this?  For example, Labor is $20.91/hr and Overhead is 300.76%

    So, does this mean that when calculated, the cost at the highest level will always have additional decimal precision that makes the total cost off from what will be used on the Production order, thus always giving a variance at the higher quantities?

  • Weaveriski Profile Picture
    23,620 Moderator on at

    In the version values setting in the recording tab of you costing version do you have "round off" ticked? I would try ticking it first, then check my home currency has rounding set.

    AX holds figures to many decimal places, and this may be a process that uses it to the detail and rounds the end result giving you the result you do not want, you would probably need to get a developer to de-bug it and tell you the points roundings are made.

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

News and Announcements

Season of Giving Solutions is Here!

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

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#3
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans