Skip Headers
JD Edwards World General Accounting I Guide
Release A9.3.x

E21540-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

47 Print Integrity Reports

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.

47.1 Overview

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.

47.1.1 Before You Begin

  • Ensure that you have posted all transactions.

47.2 Batch Header Integrity Reports

Use batch header reports to locate and correct problems in the Batch Header table (F0011).

47.2.1 Unposted Batches Report

Navigation

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

47.2.2 Transaction to Batch Headers Report

Navigation

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).

47.2.3 Batch to Detail and Out-of-Balance Report

Navigation

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.

47.2.4 Company by Batch Out-of-Balance Report

Navigation

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.

47.3 General Ledger Integrity Reports

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

47.3.1 Companies in Balance Report

Navigation

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.

47.3.2 Intercompany Accounts in Balance Report

Navigation

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.

47.3.3 Accounts without Business Units Report

Navigation

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.

47.3.4 Account Balance without Account Master Report

Navigation

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.

47.3.5 Transactions without Account Masters Report

Navigation

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.

47.3.6 Account Balance to Transactions Report

Navigation

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