E1: 09: Overview of Clearing Account Reconciliation (P09131/R09130/R09150) (Doc ID 1461344.1)

Last updated on JULY 21, 2020

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.