E1: 09: Overview of Clearing Account Reconciliation (P09131/R09130/R09150)
(Doc ID 1461344.1)
Last updated on JULY 19, 2021
Applies to:
JD Edwards EnterpriseOne General Ledger - Version XE and later Information in this document applies to any platform.
Purpose
Overview
Clearing account reconciliation is an automatic process for reconciling the offsetting debit and credit transactions in the Account Ledger Table (F0911) and the Account Reconciliation Table (F0911R) for the following Account Types:
Accounts Payable (A/P) Trade Accounts
This account contains entries that are created by the G/L Post program (R09801) during the voucher and payment entry processes.
Accounts Receivable (A/R) Trade Accounts
This account contains entries that are created by the G/L Post program (R09801) during the invoice and receipt entry processes.
Voucher Logging Accounts
This account contains entries that are created by the G/L Post program (R09801) during the logged voucher and voucher journal entry redistribution processes.
Received Not Vouchered (RNV) Accounts
This account contains entries that are created by the G/L Post program (R09801) during the process of receiving goods and creating a voucher match for the goods.
Performance Liability Accounts (9.2 Release)
These accounts contain entries including PLA, PLA Adjustment, COGS PLA, and COGS PLA Adjustment that are created by Revenue Recognition.
The clearing account reconciliation process includes the following steps:
Run the Refresh Reconciliation File program (R09130) with the Document Type Filter processing option set to include automatic entries (AEs). The R09130 program populates the WF – Account Ledger Reconciliation table (F0911R).
Run the G/L Account Reconciliation program (R09150) to mark transactions as reconciled.
Use the Manual Reconciliation program (P09131) or the Account Ledger Inquiry program (P09200) to manually reconcile any exceptions that were not reconciled by the R09150 program.
Scope
This document is intended for Finance Functional users who will be involved in Account Reconciliation in the General Accounting system.
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!