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

Last updated on JUNE 05, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Oracle Order Management - Version 11.5.9 and later
Information in this document applies to any platform.
FORM:OEXOEORD.FMB - Sales Orders

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms