Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Purchased item rounding

Posted on by Microsoft Employee

DAX is rounding everything to 2 decimal places prior to the multiple which leads to issues on our POs and in Accounts Payable.  For example, if we are buy 1000 pcs of a component that costs $0.004 each DAX rounds to $0.00 and the PO will say 1000 pcs for $0.00.  If the component costs $0.005 each DAX rounds to $0.01 so the PO says 1000 pcs for $10.00 vs. the $5.00 it actually costs.

We have lots of work arounds for this but is there a true fix anyone knows of?  It seems like there may be a setup setting that we missed.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchased item rounding

    Hi Elena, there is two solution for it but remember first solution is not advisable. I hope if Microsoft look into this and issue any hotfix for it.

    1) with the help of developer you need to change the extended data type for currency / values from 2 to 3 in your case and it will resolve the issue but remember this will effect the whole system.

    2) make a unit conversion which will lead you to 2 decimal place. but again you will have an issue in consumption where the qty is less. but if the qty is more then no issue. I hope you get it what I mean.

  • RE: Purchased item rounding

    Hi,

    It's indeed a strong constraint, you cannot add more than 2 digits.

    You need to setup a price unit for setting up your price.

    Example : your component si up to 0,004 each. So setup your price to 0,04 for a price unit setup to 10.

    You purchase 10, your price will be 0,04.

    You purchase 1, your price will be 0,004.

    In that case Ax will round the price for displaying but stored in the table it should be the correct value.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Purchased item rounding

    Hi Elena, I also experienced this issue many times. The only "workaround" that really helped was not setting up prices in 100s/1000s. Please check if you can setup prices per pcs. If you want to purchase the items in quantities of 100s/1000s... you can define a default purchase quantity but avoid those rounding issue. Hope it helps, 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

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans