Purchased item rounding

(0) Share

Report

Posted on by Community Member 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

All responses (3)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

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.
Yohann Rolland Axcible 3,111 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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