E1: 43: Duplicate Supplier/Invoice Number (1912) Error When Evaluated Receipt (R43800) Processes Multiple Partial Receipts on Multiple PO Lines (Doc ID 2855537.1)

Last updated on DECEMBER 01, 2023

Applies to:

Symptoms

If Evaluated Receipts (R43800) processes a purchase order with multiple partial receipts on multiple PO lines, the EDI Inbound Invoice/Match to P.O. Edit/Create (R470412) creates a voucher for only the first PO Line and returns an error for the second PO line.

Oracle Support duplicated the issue using demo data in the JD Edwards Test Environment with the steps below:

1. In Work with Inbound EDI Invoices (P47040) delete all the old records that are no longer needed.
2. In Accounts Payable Constants (P0000), Duplicate Invoice Number Edit is set to “H” (Hard error upon duplication).
3. In Supplier Master (P04012) for Supplier 59335, Set Purchasing Tab 2, Evaluated Receipt = “Y”.
4. Create a Purchase Order Header First with Supplier 59335 in Branch 30.
5. Take the Form Exit to “Additional Info”.
6. On the Additional Information screen, Evaluated Receipt = “Y”.
7. Add 2-lines to the  purchase order:
   1. Line 1, Item 2001, Line Type S, Quantity 10, Extended Amount 2,000
   2. Line 2, Item 9013, Line Type N, Quantity 10, Extended Amount 400
   3. Order Number 6785 OP is created.
8. Create a Partial Receipt for Quantity 5 of Each Line with a Supplier Remark of 6785-I1.
9. Create a second Partial Receipt for Quantity 5 of Each Line with a Supplier Remark of 6785-I2.
10. In the databrowser verify there are two different receipt documents (5609 and 5610 OV) in the receiver table (F43121) for the two purchase order lines.
11. Setup a version of Evaluated Receipts (R43800) as follows:
    1. Processing Tab Option #1 (Invoice number) is set to 1 (Use the Supplier remark field)
    2. Processing Tab Option #4 (Receipt Summary method) is set to 2 (By Invoice)
12. Run Evaluated Receipts (R43800). In the Data selection add the Address Number and the Purchase Order Number.
13. When the job is completed, view the PDF for EDI Inbound Invoice Match (R470412). The Report PDF shows that a voucher was created for Line 1.000, but Line 2.000 has an Error in the Header.
14. Reinquire on the Receiver (F43121) records in databrowser and verify only the first of two purchase order lines receive a match type 2 voucher.
15. Check the Work Center and verify “Error: Duplicate Supplier/Invoice Number (1912) was sent for the second line.

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.