E1: 43: 47: AICU (Difference Amount) Calculated with Incorrect Total Running the R470412 (EDI Inbound Invoice/Match to P.O. Edit/Create) for 2-way Match of Multiple Suppliers (Doc ID 3074086.1)

Last updated on FEBRUARY 26, 2025

Applies to:

Symptoms

When running the R470412 (EDI Inbound Invoice/Match to P.O. Edit/Create) over two EDI documents with two different suppliers, the amount total amount entered (AICU) on the batch header (F0011) is not totaling correctly. It appears the program is adding the first record processed twice in the calculation for the amount in the batch header. This occurs when performing a 2-way match using the R470412.

STEPS

1. Create two non-stock purchase orders (J line type) using the P4310 with two different suppliers. Enter the amounts 41.20 & 358.25.
2. Manually add data in the F47041, F47042 and F47044 using the P47040 (Inbound EDI Invoice Revisions) by creating two different EDI documents for each order and supplier.
3. Run the R470412 and data select on both EDI document numbers created above.
4. Review the pdf report to ensure no errors were received and verify the vouchers were created in the P0411.
5. Go into the P0011. The total amount in the AICU (Difference Amount) is 440.65. The expectation is that the amount would be the total of the two vouchers (399.45). From the calculation, the total is taking the amount from the first EDI record twice when performing the total calculation.

Changes

Cause

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