E1: 43: Automatic Account Reconciliation (R09150) Reconciles Summarized Voucher (PV) to Detail PO Receipt (OV) (Doc ID 2949200.1)

Last updated on MAY 16, 2023

Applies to:

Symptoms

Automated Account Reconciliation (R09150) is reconciling a Summarized Voucher (PV) record to an Unsummarized/Detail PO Receipt (OV) record.

According to 986024.1 - E1: 43: Voucher Logging and Received Not Vouchered (RNV) Clearing Account Reconciliation (R09150) Summarization is supported as long as summarization is on for both receipts and voucher or off for both receipts and voucher. If summarization is on for the receipt but off for voucher match, automatic reconciliation will not occur. If summarization is off for the receipt but on for voucher match, automatic reconciliation will not occur. Manual reconciliation must be performed for these records.

Also refer to 2716046.1 - E1: 43: G/L Account Reconciliation (R09150) Does Not Reconcile Correctly if Purchase Order Receipt (P4312) and Match Voucher to Open Receipts (P4314) Transactions Do Not Have Consistent Summarization

Steps to Duplicate:

1. Create a purchase order with 3 lines, non-taxable, against the same expense account as follows:
   1. Quantity = 1, Line Type = J, Unit Cost = 200,00, Extended Cost 200.00, G/L Date =5/14/2023
   2. Quantity = 1, Line Type = J, Unit Cost = 100,00, Extended Cost 100.00, G/L Date =5/14/2023
   3. Quantity = 1, Line Type = J, Unit Cost = 200,00, Extended Cost 200.00, G/L Date =5/14/2023
   4. Total $500.00 G/L Date = 5/14/2023
2. Setup a Version of PO Receipts (P4312) as follows:
   1. Process Tab Option #13 (Journal Entries) = Blank (Do Not Summarize)
3. Receive the Purchase Order (P4312) and Post the batch,
4. Use databrowser to verify three Journal Entries (F0911) were created in the Received Not Vouchered Account (1.4111)
5. Setup a Version of Voucher Match (P4314) with A/P and G/L Summarization on 
6. Create a 3-Way Match Voucher (P0411/P4314) using the version with G/L Summarization setup and Post the Batch.
7. Supplier Ledger Inquiry (P0411) shows A/P was summarized into one line for 500.00
8. Use databrowser to verify one Journal Entries (F0911) was created in the Received Not Vouchered Account (1.4111) for a Debit of 500.00.
9. Go into Financial AAIs (P0012) and set the Reconciliation AAI for Received Not Vouchered account 4111
10. Setup a version of the Refresh Reconciliation (R09130) UBE for the Received Not Vouchered Account (4111) with a Start and End date the same as the transactions. 
11. Run the Refresh Reconciliation (R09130) UBE for the Received Not Vouchered Account (4111) against the unreconciled Journal Entries.
12. Bank Account Reconciliation (P09131) shows four records were selected for reconciliation
    1. Three unconsolidated OV records for Received not Vouchered Credits summing to -500,00
    2. One consolidated PV record for Received not Vouchered Debit of +500.00
    3. All of the records have a Blank in the Reconciliation Code and Reconciliation Reference Number fields
13. Setup a version of Automated Account Reconciliation (R09150) for the Received Not Vouchered records.
    1. Process Tab Option #1 (Type of Account) = 4 (Received not Vouchered)
    2. Options Tab Option #1 (Reconciled Code) = R (Reconciled)
    3. Print Tab Option #1 (Report Output) = 3 (Detailed Report)
14. Run the job with Data selection on Received Not Vouchered account id.
    1. Report PDF shows +500.00 PV record is matched to -200 OV
    2. If amounts don’t match we should not mark any records as summarized.
15. Check Bank Account Reconciliation (P09131) shows two of four Received Not Vouchered entries reconciled.
    1. Select the two unreconciled OV receipts and Row Exit to Reconcile Toggle.
16. All the records for this Purchase Order are now shown as reconciled.

Cause

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