My Oracle Support Banner

R12: AP: Discount Amount Calculated Different For Imported And Manual Entered Invoices (Doc ID 2488473.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

Oracle Payables - Version 12.2.6 and later
Information in this document applies to any platform.


Discount amount calculated different for imported and manual entered invoices.

There is a difference when calculating discount between imported Invoice and manual entered Invoices:

For Example:

An Invoice Amount is 8210.95, which is the Total Item Lines 6842.46, plus the Tax Amount 1368.49;  6842.46 + 1368.49 = 8210.95.
The Invoice is expected to have a 0.2% discount based on Payment Terms defined.
• After Manual Entry, the DISCOUNT_AMOUNT_AVAILABLE is 16.4219, which is correctly calculated;  (6842.46 + 1368.49)*0.2% = 8210.95*0.2% = 16.4219
• After Imported, the DISCOUNT_AMOUNT_AVAILABLE calculated incorrectly as 19.16 which is 0.2% of Invoice Amount, plus Tax; (1368.49 + 8210.95)*0.2% = 19.16


Expect to have the same amount for imported invoices as it has manual invoices

The issue can be reproduced at will with the following steps:
1. Populate invoice interface
2. Import invoice with discount
3. the discount amount is higher than a manual entry having invoice having the same amount / discount.




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.