WFR Negative AmountDiscount Value is not Correctly Validated in 1007G AP Project (Doc ID 2154151.1)

Last updated on JULY 01, 2016

Applies to:

Oracle WebCenter Forms Recognition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

If a discount amount is printed on the invoice as a negative value, it does not validate against the AmountTotal correctly in the 1007G AP Project.  The algorithm for validating the Amount total on the invoice is documented in the AP guide as:

Invoice Total = Subtotal + Total Tax + Freight + Miscellaneous Charge – Discount – Withholding Tax – ISR Retention

If the Discount value is denoted as a negative value, it is still subtracted in the algorithm as a negative value (and therefore added to the amount).  In this case, the discount is printed on the invoice as "-1.81":

Total = 33.99

Subtotal = 32.99
Tax = 2.81
Discount = -1.81

If processed in the 1007CA project, the Total comes through as valid (green) since the Discount is extracted as "1.81":

33.99 = 32.99 + 2.81 - 1.81
33.99 = 33.99 (VALID)

However in 1007G the project total comes through as invalid since the Discount is extracted as "-1.81":

33.99 = 32.99 + 2.81 - (-1.81)
33.99 = 37.61 (INVALID)

 

Cause

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