How to set pricing precision/rounding on system calculated prices

  • 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 8 months ago 2 Members · 1 Reply
  • 1 Reply
  • Kelly Gustafson

    Moderator
    June 27, 2023 at 11:07 am

    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.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!