E1: 09: Overview of General Accounting Integrity Reports (R007021/R007031/R007011/R097001/R09706/R007032/R097011/R09705/R099102/R097041/R097031/R097021/R09707) (Doc ID 664780.1)

Last updated on JANUARY 07, 2022

Applies to:

JD Edwards EnterpriseOne General Ledger - Version XE and later
JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
JD Edwards EnterpriseOne Accounts Payable - Version XE and later
Information in this document applies to any platform.

Purpose

Overview

Why you should run Integrity Reports?

Integrity reports are an integral part of the JD Edwards EnterpriseOne General Accounting system. Running integrity reports helps you:

To supplement your internal balancing procedures.
To locate potential balancing problems and data inconsistencies.
Ensure that your system functions correctly and that tables remain in balance.
Enables you to correct any problems in a timely and efficient manner.

When you should run Integrity Reports?

You should run integrity reports at these times:

During new software installation.
During conversion.
Daily, if necessary.
At the end of the month.
At the end of the fiscal year.

NOTE: Integrity reports have no "as of" capability, as they provide information that is current at the time you run them. Consequently, the more often you run them, the easier it will be to determine when a problem occurred.

Preferred Order to Run Integrity Reports

The integrities should be run in following sequential order:

Transactions to Batch Headers (R007021)
Batch to Detail & Out of Balance (R007031)
Unposted Batches (R007011)
Companies in Balance (R097001)
Company by Batch Out of Balance (R09706)
Batches Out of Balance (R007032)
Intercompany Accounts in Balance (R097011)
Account Balance to Transactions (R09705)
Repost Account Ledger (R099102)
Accounts without Business Units (R097041)
Account Balance without Account Master (R097031)
Transactions without Account Master (R097021)
Foreign Account Balances (R09707)

Scope

This document provides an overview of the General Accounting Integrity Reports, why and when to run the General Accounting integrity reports, the preferred order in which to run the reports, suggestions for preventing integrity issues, a brief overview of the functionality of each report and links to more detailed documents for each Integrity Report.