5 Overview to Integrity Reports

This chapter contains these topics:

Section 5.1, "Objectives"
Section 5.2, "About Integrity Reports"

5.1 Objectives

To locate out-of-balance conditions
To locate data inconsistencies
To locate unposted batches
To locate transactions without batch header records
To locate unposted transactions with a posted batch status
To delete batch header records
To update batch header records
To recreate missing batch header records
To verify account balances on a period-by-period basis
To review a company's net balance
To locate company and business unit discrepancies
To locate incorrect company numbers
To update company numbers

5.2 About Integrity Reports

Integrity reporting is an integral part of any financial system that supplements internal balancing procedures. Integrity reports identify potential balancing problems and data inconsistencies.

Use integrity reports to supplement your internal balancing procedures.

Integrity reports are DREAM Writer programs.

Working with integrity reports consists of:

Printing unposted batches
Correcting transactions to batch records
Correcting out-of-balance batches
Correcting out-of-balance batches by company
Correcting company imbalances
Correcting intercompany account imbalances
Correcting chart of accounts discrepancies
Correcting account balances to transactions

5.2.1 Why Should You Run Integrity Reports?

Running integrity reports helps you:

Ensure that your system functions correctly and tables remain in balance
Correct any problems in a timely and efficient manner

5.2.2 When Should You Run Integrity Reports?

Integrity reports are an integral part of the JD Edwards World system. You should run them:

During installation
During conversion
Daily, if necessary

Caution:

If you do not run integrity reports periodically, you could compromise your accounting data.

5.2.3 What Do Integrity Reports Provide?

These reports provide information that is current at the time that you run them. That is, they have no as of capability. Some integrity reports are exception reports that:

Print only discrepancies
Alert you to discrepancies between data tables

5.2.4 What Are the Types of Integrity Reports?

There are two types of integrity reports. They are:

Batch header reports. Run these to locate problems in the Batch Control Records table (F0011).
G/L integrity reports/updates. Run these to verify that the:
- Transactions within a company are in balance
- Intercompany settlement accounts are in balance
- Company number in the Account Master table (F0901) matches the following:
  - Business Unit Master (F0006)
  - Account Balances (F0902)
  - Account Ledger (F0911)
- Accounts balance on a period-by-period basis

5.2.5 Which Integrity Report Should You Run?

To decide which integrity report you should run, review the following list. It contains the report title, reasons you use the report, and where to find additional information.

Topic	Description
Unposted Batches	Prints a list of unposted batches. This report should be run last in the series of batch integrities.
Transactions to Batch Headers	Reports any discrepancies between the posted status on the batch header and the transactions within the batch, as well as any transactions that are missing a batch header. It also reports on any invalid pay status. Provides transaction level information. Transactions without a batch header record in the Batch Control Records table. Recreates missing batch header records Unposted transactions with a batch status of D (posted).
Batch to Detail and Out of Balance	Provides batch level information. Automatically deletes any empty batch header records, while reporting any batches that were posted out of balance. Locates batches posted out of balance. Deletes batch header records with no detail records. Updates the batch status of a batch header record to D (posted) if the detail records in the Accounts Receivable Ledger, Accounts Payable Ledger, and Account Ledger batches are posted, but the header record has an unposted status.
Company by Batch Out-of-Balance	Locates out-of-balance amounts by company within each batch.
Companies in Balance	Prints each company's net balance.
Intercompany Accounts in Balance	Locates imbalances between corresponding intercompany accounts.
Account without Business Units	Provides business unit information in the Account Master table (F0901). Locates company and business unit discrepancies in the Account Master table. Updates the Account Master table from the Business Unit Master table (F0006).
Account Balance without Account Master	Locates company and account discrepancies between the Account Master and the Account Balances tables.
Transactions without Account Master	The Transactions without Account Master Integrity Report (P097021 or R097021) verifies that the company number on each transaction in the Account Ledger table (F0911) matches the company number on the Account Master table (F0901) for that same account. It also verifies that the account number on every transaction in the Account Ledger table ( F0911) exists in the Account Master (F0901) table.
Account Balances to Transactions	Locates imbalances on a period-by-period basis between the Account Balances table and the Account Ledger table.