Contracts

More precise calculation for Range pricing

We've improved the calculation for quantity-based billing usage pricing for billing price list entries with the following configuration:

  • Price type = Range
  • Rounding = Round up

We've increased the number of decimal places evaluated to 14 when rounding the number of groups. Previously, Intacct only evaluated 2 decimal places when rounding up the number of groups value. This change correctly increases the price charged when the number of groups value has a remainder greater than 2 decimal places.

What's changed

Range pricing is used to price items by groups. For example, price per thousands, price per hundreds, and so on. The calculation for Range prices is as follows:

(recorded usage quantity / Variable unit divisor) rounded per the Rounding setting = number of groups

number of groups * Variable unit rate = price

For example, let's say that the Variable unit divisor is 1000, the Rounding setting is Round up, and the Variable unit rate is 50.00. We recorded the usage quantity for a contract line item at 5001.

The number of groups is calculated as follows:

5001 / 1000 = 5.001

Previously, Intacct only evaluated 2 decimal places in the number of groups value. Using this example, it rounded the number of groups to 5 instead of rounding up to 6. The price charged was 5 * 50.00, or 250.00.

We've increased the number of decimal places evaluated in the number of groups value to 14. Using this example, Intacct now rounds 5.001 up to 6. The price charged will now be 6 * 50.00, or 300.00.

Requirements

Subscription

Contract Billing

Regional availability

All regions, excluding France

Permissions

Billing price list: List, View, Add, Edit, Delete

Dependencies or other requirements

Price type = Range

Rounding = Round up