My Oracle Support Banner

E1: 43: Open Amount Is Different Than Expected On Subcontract Order After Two Partial 2-Way Match Vouchers (Doc ID 3048093.1)

Last updated on SEPTEMBER 17, 2024

Applies to:

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

Symptoms

Open Amount Is Different Than Expected On Subcontract Order After Two-Way Match Vouchers. The client expects the Amount Received and Amount Relieved to be the same even though the Supplier Invoiced for the items at higher unit costs than were on the purchase order.

Steps to Reproduce:

Note: All Data presented below is from JD Edwards Test Environment. No customer or personal data is revealed.
  1. Create a J-Line type Purchase Order (P4310) for 1,515 EA, Unit Cost 44.00 EA, Open Amount 66,660.00. Commitment Inquiry (P40230A) shows Amount Committed 66,000.00 and Units Committed 1,515.0000.
  2. Supplier sends a Partial Invoice for 250 units at 44,00 per unit for a Total Amount 11,000.00,
  3. User mistakenly creates a Partial 2-Way Match Voucher with Quantity of 44 instead of 250 and Amount of 11,000.00
    1. This calculates a Unit Cost of 250.00 EA
    2. Post the Voucher (R09801).
  4. Commitment Inquiry (P40230A) shows Amount Relieved is 1,936.00 (Unit Cost of 44.00 per Unit x Units Relieved 44.00 Units)
  5. PO Detail (F4311) record shows Open Amount 64,724,00 (1471 units x 44.00), Amount Received 11,000.00, Amount Relieved 1,936.00.
  6. PO Receiver (F43121) record shows Voucher 20892 PV was for 44 units and 11,000.00 received at a Unit Cost of 250.00 per unit.
  7. Supplier sends a second Invoice for 650 units at 44 per unit for a Total Amount of 28,600.00.
    1. User creates a Partial 2-Way Match Voucher for Invoice Amount 28,600.00 with Quantity Received of 650 (Unit Cost 44.00 EA)
    2. Post the Voucher (R09801).
  8. Commitment Inquiry (P40230A) shows Amount Relieved on the second voucher is 28,600.00 (Unit Cost of 44.00 x Units Relieved 650.00 Units.
    1. Amount Relieved for the PO Line between the two receipts is 30.536.00 and Units Relieved is 694.00.
  9. PO Detail (F4311) record shows Open Amount 36,124.00 (821 units x 44.00), Amount Received 39,600.00, Amount Relieved 30,536.00.

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
Cause
Solution


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