E1: 04: A/P Payment to G/L Integrity (R04712) Accumulates Columns Distribution Amount (F0911) and Automatic Offset Amount (F0911) When Using Duplicate Payment Numbers in the Same Batch (Doc ID 3009869.1)

Last updated on AUGUST 02, 2024

Applies to:

Symptoms

Enhancement Bug 36324836 - Use PYID to Join the F0413, F0414 AND F0911 for the R04712 Report was written to join the tables together using the field PYID - Payment ID. However, if this enhancement is not completed, then the columns Distribution Amount (F0911) and Automatic Offset (F0911), need to be corrected so that each payment amount prints for the duplicate Payment Number (DOCM).  Note the total of all entries within the duplicate Payment Number and batch. Document 3006013.1 - E1: 04: Enhancement to Use Payment ID (PYID) to Join F0413, F0414 and F0911 Tables Together for R04712 - A/P Payments to G/L Integrity with Adjust explains this Enhancement Bug.

Our process is to create separate/detailed Account Ledger (F0911) records for each payment. When the R04712 accumulates the Distribution Amount (F0911) and Automatic Offset Amount (F0911), it uses the payment number with the batch number. This is causing the program to accumulate the amounts for all the duplicate payment numbers in the batch on this report.

For example, batch number 1111111, contains three payments for 700.00, 0.00, and 113.30. All three payments have the same payment number of 222000. On the report for each payment, the Distribution Amount and Automatic Offset show as 813.30 (which is the sum of the three payments) instead of 700.00, 0.00, and 113.30 respectively. The report says that the amounts do not match the payment amount and prints out an exception.

The issue can be reproduced at will with the following steps:

1. P0411 - Enter 3 vouchers for three different suppliers.
2. Update the Manual Payment with Match program (P0413M) ensuring that the following processing options are set:
    - Default Processing option 3. Assign Payment Numbers (DOCM) is set to Blank = Manually enter payment number in the Default tab
    - Processing Processing option 2. Duplicate Number Error Message set to 1 =Issue a warning
3. Create separate payments (P0413M) for the above suppliers however, assign the same Payment Number to each payment. Warning message "Check Number is a Duplicate - WARNING" is given when entering the subsequent checks.
4. Post results (R09801).
5. Run the A/P Payments to G/L Integrity report (R04712).
6. The R04712 totals the same payment number in the columns Distribution Amount and Automatic Offset when each payment should contain it's actual amount in these fields and not total the three payments together.

Cause

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