Discussions – Dynamics 365 F&O/AX – Dynamics Communities

How to set pricing precision/rounding on system calculated prices

Tagged: F&O, Pricing, Sales Price Model

Dynamics 365 F&O/AX

How to set pricing precision/rounding on system calculated prices

Posted by Lyle Henderson on June 20, 2023 at 4:25 pm

On some of our products we resell, we are calculating the Sell Price by using the Contribution Ratio function against the Base Cost. Unfortunately, in cases where the ratio used may be out to two decimal places, the corresponding calculated price may be out to four decimal places, even though the system will only display two places. For example, if the calculated sell price is 25.6654, it would display as $25.67.

However, if a customer were to purchase 100 boxes, the system would show the unit price as $25.67, but the net amount would be displayed as $2,566.54,

How can I get the system to store the price as $25.67 and not $25.6654 after being calculated using the Contribution Ratio Sales Price Model? Or do I just need to update all the contribution ratios to whole numbers?

Kelly Gustafson replied 1 year, 4 months ago 2 Members · 1 Reply
1 Reply

Kelly Gustafson

Moderator
June 27, 2023 at 11:07 am

Up
0
Down
::
Hi Lyle, this is tricky because the system SHOWS one thing but the numbers tell a different story. One way to get to the root of the cost is to change the per unit to 100 (or 10 or 1000… whatever you want to see completely baked out) or, as you suggested, use whole numbers to calculate.

The discussion ‘How to set pricing precision/rounding on system calculated prices’ is closed to new replies.