My Oracle Support Banner

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 MAY 06, 2022

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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