Round Your Pricing
See how rounding and precision affects prices on order lines.
Note
-
Use the Manage Currencies task to set precision for the currency.
-
Use the Precision attribute to specify the number of decimal places to the right of the decimal point.
-
Use the Extended Precision attribute when you need even more precision. It also specifies the number of decimal places to the right of the decimal point, but you can set Extended Precision to a higher value.
-
-
Use the Manage Rounding Rules task to set precision for rounding.
-
Use the Manage Rounding Rule Assignments task to assign currency to the rounding rule.
-
Use the Edit Price List page to edit the charge for your item on the price list and to set the currency precision for the charge.
-
Create a sales order and see how Pricing applies your set up at run time.
-
The Extended Precision attribute that you set on the currency affects the Your Price attribute on the order line. In this example, it's six decimal places, rounded up from 36.2255779.
-
The Currency Precision attribute that you set on the charge affects the Amount attribute on the order line.
-
Pricing starts with the Base List Price attribute on the price list, uses your rounding rule to round the value, then applies other set ups that you have for the item, such as discounts, other charges, and so on.
-
Assume you sell the AS54888 Desktop Computer in the USD currency. You need to round the USD currency with a precision of 2, extended precision of 7, and round it up according to a precision of 6.
Try it.
-
Go to the Setup and Maintenance work area, then go to the task.
-
Offering: Sales
-
Functional Area: Company Profile
-
Task: Manage Currencies
-
-
On the Manage Currencies page, search for the value.
Attribute
Description
Currency Code
USD
-
Expand the row in the search results.
-
Set the values, then click Save and Close.
Attribute
Description
Precision
2
Extended Precision
7
-
Go to the task.
-
Offering: Order Management
-
Functional Area: Pricing
-
Task: Manage Rounding Rules
-
-
On the Manage Rounding Rules page, click Actions > Add Row.
-
Set the values, then click Save and Close.
Attribute
Description
Name
Round Up to Precision
Type
Round to Precision
Round To
6
Direction
Up
Setup Enabled
Active
Contains a check mark.
-
Go to the task.
-
Offering: Order Management
-
Functional Area: Pricing
-
Task: Manage Rounding Rule Assignments
-
-
On the Manage Rounding Rule Assignments page, click Actions > Add Row.
-
Set the values, then click Save and Close.
Attribute
Description
Currency
USD
Rounding Rule
Round Up to Precision
-
Create a charge.
-
Make sure you have the privileges that you need to administer pricing.
Go to the Pricing Administration work area.
-
Click Tasks > Manage Price Lists.
-
On the Manage Price Lists page, search for and open the Corporate Segment Price List.
-
On the Edit Price List page, in the search results, click Actions > Add Row, then set the values.
Attribute
Description
Item
AS54888
-
Click Create Charge.
-
In the AS54888 Charge area, expand Additional Information, then set the values.
Attribute
Description
Currency Precision
7
-
Click Save and Close.
-
-
Test your set up.
-
Go to the Order Management work area, create a sales order, then add 3 order lines.
Order Line
Item
Quantity
1
AS54888
1
2
AS54888
2
3
AS54888
3
-
Verify the price and amount for the AS54888 item. Assume that Your Price is $36.225578.
Quantity
Amount
1
$36.23
Here's the calculation.
-
Multiply 36.225578 by a quantity of 1 equals 36.225578.
-
Round 36.225578 up according to a decimal precision of 2, equals 36.23.
2
$72.45
Here's the calculation.
-
Multiply 36.225578 by a quantity of 2 equals 72.451156.
-
Round 72.451156 up according to a decimal precision of 2, equals 72.45.
3
$108.68
Here's the calculation.
-
Multiply 36.225578 by a quantity of 3 equals 108.676734.
-
Round 108.676734 up according to a decimal precision of 2, equals 108.68.
Your Price is six decimal places, rounded up from 36.2255779.
-
-