Order Amount With Adjustments Does Not Equal AR Invoice Amount. (Doc ID 1626218.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.

Goal

Tax Rounding issue in Order management and Account Receivables are not
consistent

A gap exists between an OM sales order amount and the AR invoice amount
related.

This gap is due to the fact that:

In one hand: in Order Management the VAT amount is calculated and rounded
with 2 decimals for each sales order line level. Then at sales order header level,
the sum of rounded calculated VAT amounts is done.

In an other hand: in AR, for fiscal constraints, the VAT is calculated at
header level. It means that (for a same VAT code) a sum of all VAT item line
amounts is done and then the VAT is calculated and rounded.

We are here in a situation where a sum of rounding lines is different from a
rounding of a sum of lines.

This issue, as it seems standard Oracle regarding how Order Management is
built , is very critical from a business point of view, specially for situations
where the customer is preparing the payment on the base of the sales order amount
that is not the same of the invoice they will receive in the future.


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