This chapter contains these topics:
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
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
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
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.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
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
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.
|
Batch to Detail and Out of Balance | Provides batch level information.
|
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).
|
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. |
See Also: