You’re offline. This is a read only version of the page.
285
Hi guys,
Can anyone suggest me how to enter POline unit price with three decimals instead of two decimals?
Ex:
Now the system allows us to enter unit price for the purchase line in two digits.
If i enter three decimals,
The system converts this three decimals to two decimals and doing round off from 1.256 to 1.26
My requirement is the unit price must allow us to enter three decimals and it should not do round off. Because rounding off to two decimals affects my net amount calculation.
Waiting for your suggestion, as soon as possible.
Thanks in advance.
Banu.
*This post is locked for comments
Hi Banu,
Using more than 2 decimal places is complex. You can find a couple of threads where this is discussed.
Yet, as a workaround, can't you specify the price per 100 pcs instead of per peace?
Based on your example, this should overcome the problem.
Best regards
Ludwig
Hi Banu.
As already mentioned from Ludwig this is not easy. In my projects I was always able to discuss and explain this issue. At the end we always used the field "price unit". So there is no need for 3 or more digits.
If you have a price like 10,123 per piece you can enter a price of 10123,00 per 1.000 pieces. So the calculation of net amount is correct.
I agree, it is not optimal but a solution without coding.
Best regards
Christoph
Hi Ludwig,
This is not country specific requirement. As of now we need this for USA country.
My Purchase team discussed to us, there is a scenario where our vendor sends the unit price for the item in three decimals. They are asking suggestion form us, how to enter the unit price if we receive in three decimals instead of two decimals.
My first line shows excel calculation, second line shows ax calculation.
Thanks,
Banu.
Hello Banu,
Is this a country specific requirement?
In D365FO there is a new functionality for the UAE that allows using 3 decimal places.
As far as I am informed this is not available for other countries.
For which country do you need that?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (