R12: AP: Multiple Accounting Entries Created for a Payment Discount (Doc ID 3072771.1)

Last updated on FEBRUARY 20, 2025

Applies to:

Symptoms

A payment shows multiple discounts were created for a check for a higher amount than the actual discount.

 
The issue can be reproduced at will with the following steps:
1. Create an invoice.
2. Account for the invoice.
3. Pay the invoice.
4. Account for the payment.
5. Clear the payment
6. Account for the clearing of the payment.
7. Adjust the invoice. This creates invoice adjustment and payment adjustment events
8. Account for the changes.
9. The accounting completes, but the discount is calculated multiple times

For example, the discount lines for a toal discount of 110.09 can look like the following after multiple adjustments:

Accounting Class            Accounted DR        Accounted CR       Comments
============          ==========        ==========      =================================
Discount                                                             37.14             Extra discount entries on Payment <--Adjustment
Discount                                  19.63                                        Extra discount entries on Payment <--Adjustment
Discount                                                             92.15             Extra discount entries on Payment <--Adjustment
Discount                                                         2999.34             Extra discount entries on Payment <--Adjustment
Discount                                  17.49                                        Extra discount entries on Payment <--Adjustment
Discount                                                         1814.99             Extra discount entries on Payment <--Adjustment
Discount                              4906.50                                        Extra discount entries on Payment <--Adjustment
Discount                                                              17.59            Matches with discount on Invoice <--Initial Accounting (matches the discount amount of 17.59)
Discount                                                              92.60            Matches with discount on Invoice <--Initial Accounting (matches the discount amount of 92.60)

Cause

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