My Oracle Support Banner

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:

Oracle Order Management - Version 11.5.9 and later
Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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