This chapter contains these topics:
Integrity reports supplement your internal balancing procedures and locate any data inconsistencies. You should print these reports before you close an accounting period or fiscal year, as well as between closings, so that you can correct problems in a timely and efficient manner. Integrity reports are also an integral part of the installation of and conversion to the JD Edwards World system.
These reports are DREAM Writer reports.
Integrity reports are current the day that you print them. That is, you cannot print them as of a specific date. Some of the integrity reports are exception reports that:
Print only discrepancies
Alert you to discrepancies between ledgers
Caution:
If you do not print integrity reports on a periodic basis, you risk compromising your accounting data.Use batch header reports to locate and correct problems in the Batch Header table (F0011).
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Unposted Batches
Print the Unposted Batches report to locate any unposted batches. This report:
Should be run prior to period-end procedures
Is sequenced by batch type, then batch number
Is a printed version of General Journal Review
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Transactions to Batch Headers
Print the Transaction to Batch Headers report to locate and correct inconsistencies in the Batch Header table. You should print this report weekly to locate:
Transactions without a batch header record in the Batch Header table. The system produces a combined report that is sorted by batch type for the Accounts Receivable Ledger (F0311), Accounts Payable Ledger (F0411), and Account Ledger (F0911) tables.
Unposted transactions with a batch header record of D (posted).
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Batch to Detail and Out of Bal
Print the Batch to Detail and Out-of-Balance report to:
Locate batches posted out of balance.
Locate batch header records with no detail records.
Delete empty batch headers.
Update a batch header record to a post status if the detail records in the Accounts Receivable Ledger, Accounts Payable Ledger, and Account Ledger batches are posted, but the batch header record is not posted.
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Company by Batch Out of Bal
Print the Company by Batch Out-of-Balance report to locate out-of-balance postings by company within a batch.
For example, if you have a batch with a debit amount of 500 for company 1 and a credit amount of 500 for company 100, the journal entry and the batch net to zero. This batch appears on the Company by Batch Out-of-Balance report. It does not, however, appear on the Batch to Detail and Out-of-Balance report.
General ledger integrity reports are helpful during the conversion process. Print them to verify that:
Accounts are in balance on a period-by-period basis
All transactions within a company are in balance
Intercompany settlement accounts are in balance
The company number in the Account Master table matches the following tables:
Business Unit
Account Balance
Account Ledger
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Companies in Balance
Print the Companies in Balance report to review each company's net balance, which should be zero. This report is based on the Account Balances table and should be run as often as possible. Printing this report is important if you do intercompany settlements.
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Intercompany Accts in Balance
Print the Intercompany Accounts in Balance report to locate imbalances between corresponding intercompany accounts. This report:
Prints only discrepancies
Shows when the hub or detail intercompany method is not in balance
Compares account balances among various companies
Prints intercompany accounts if they do not net to zero
You should print this report when you print the Companies in Balance report.
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Accounts w/o Business Units
Print the Accounts without Business Units report to locate records in the Account Master table (F0901) that do not have a:
Business unit master record
Valid company number
The system uses the company number assigned to a business unit on Business Units by Company to update the company number in the Account Master table.
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Acct Balance w/o Acct Master
Print the Account Balance without Account Master report to locate records in the Account Balance table that do not have a:
Master record
Valid company number
This integrity report updates the company number from the account master record.
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Transactions w/o Acct Master
Print the Transactions without Account Masters report to locate records in the Account Ledger table that do not have a:
Account Master record
Valid company number
This integrity report updates the account number from the account master record.
From General Accounting (G09), choose Integrity Reports & Updates
From Integrity Reports & Updates (G0922), choose Acct Balance to Transactions
Print the Account Balance to Transactions report to locate imbalances on a period-by-period basis between the Account Balances and Account Ledger tables. You can print this report by:
Fiscal year
Ledger type
Company