My Oracle Support Banner

E1: 43: Receipt Reversal Caused A .01 Commitment Variance (Doc ID 2562121.1)

Last updated on JULY 05, 2019

Applies to:

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

Symptoms

G/L Post Program (R09801)

After Posting (R09801) a Receipt Reversal OV document for a J-line type purchase order, the Amount Received in the PA Ledger (F43199.AREC) was -268.13 but the Amount Relieved (F43199.ARLV) was incorrectly set to 0.01. This resulted in the Commitment Integrity Report (R40910) for the G/L Account showing a .01 variance between the Purchase Order Open Amount (F4311.AOPN) and the Audit Trail Open Amount (F43199.AEXP).

Steps to duplicate

  1. Create a new G/L Account that has never been used before.
  2. Enter a J line type PO for this Account Number for 2.5 Units at 107.25 per unit for an Extended Amount of 268.13 at status 220/280.
  3. Use the databrowser to check the Commitment Audit Trail (F43199) PA ledger records. A record was inserted for the commitment of 268.13.
  4. Run PO Receipts (P4312) for the full amount of 268.13.
  5. Post the Receipt Batch 47806.
  6. Use the databrowser to check the Commitment Audit Trail (F43199) PA ledger records. A PA Ledger record was added by the Post Program (R09801) with Amount Received (AREC) of 286.13 and an Amount Relieved (ARLV) of 268.13.
  7. Reverse the receipt a new document is created for the reversal.
  8. Confirm the reversal and notice there is a new batch number for the reversal of 47807.
  9. Post the Reversal.
  10. Use the databrowser to check the Commitment Audit Trail (F43199) PA ledger records. After the reversal was posted, the record had an Amount Received (AREC) of -286.13 and an Amount Relieved (ARLV) of 0.01. It should be 0.00.
  11. Receive the Purchase Order one more time.
  12. Post the Receipt.
  13. Use the databrowser to check the Commitment Audit Trail (F43199) PA ledger records. After the second receipt was posted, the record had an Amount Received (AREC) of -286.12 and an Amount Relieved (ARLV) of 268.13. Amount Received (AREC) should be 0.00.
  14. Now run the Commitment Integrity Report (R40910). Now there is a 0.01 variance between the Order Detail Amount (0.00) and the Audit Trail Open Amount (0.01).

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
References


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