My Oracle Support Banner

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

Last updated on MARCH 14, 2019

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:

This account contains entries that are created by the G/L Post program (R09801) during the voucher and payment entry processes.

This account contains entries that are created by the G/L Post program (R09801) during the invoice and receipt entry processes.

This account contains entries that are created by the G/L Post program (R09801) during the logged voucher and voucher journal entry redistribution processes.

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.

The clearing account reconciliation process includes the following steps:

  1. 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).
  2. Run the G/L Account Reconciliation program (R09150) to mark transactions as reconciled.
  3. 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!


In this Document
Purpose
 Overview
Scope
Details
 Reconciling Clearing Accounts Automatically
 Accounts Payable Trade Accounts
 Accounts Receivable Trade Accounts
 Voucher Logging Accounts
 Received Not Vouchered (RNV) Accounts
 Setup
 Intercompany Settlements GA Constants
 Offset Method
 Reconcilable AAIs Range (GLRCxx)
 Process
 1. Running Refresh Reconciliation File Program (R09130)
 2. Running Clearing Account Reconciliation (R09150)
 Overview
 Program Functionality
 Setup
 Reviewing the Report
 Error Messages
 9.1 Update 2
 Frequently Asked Questions
References

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