How to Round the Sales Order Total once an Order has been priced (Doc ID 755828.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

How to Round the Sales Order Total once an Order has been priced.

Currently it is not possible to round the value of an order total. This is a business requirement for customers where the decimal value of an order is so low that this is not collected. This can lead to a discrepancy between the invoiced value and amount received.

For Example an Order may have a value of 10000.03 Rupees. The customer only pays 10000 Rupees.

The following method describes a means of creating a modifier that uses a discount amount entered on the order header. The modifier is then applied pro-rora to the lines on the order. Reducing the total order amount by the value entered.

NOTE: If you find that the sales order line price is not getting updated whenever the sales order header DFF attribute value is entered or update, then please refer to the following note, which describes a solution: <Note: 1385500.1> - Price Not Updating Based On Sales Order Header Dff Attribute Value

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.