Completing the General Accounting Preconversion Integrity Checklist

These integrity reports apply to the JD Edwards EnterpriseOne General Accounting system:

Report Name (Program Number)

Description

Unposted General Journal (R09301)

This report prints a general journal of unposted transactions in the F0911 table.

Accounts without Business Units (R097041)

In proof mode, this report locates account master records with an invalid company number and without a business unit record in the F0901 table.

In final mode, this report updates the F0901 table with the company number from the business unit master record.

Account Balance without Account Master (R097031)

In proof mode, this report locates account balance records with an invalid company number and without an account master record in the F0901 table.

In final mode, this report updates the F0902 table with the company number from the account master record in the F0901 table.

Transactions without Account Master (R097021)

In proof mode, this report locates transaction records with an invalid company number and without an account master record in the F0901 table.

In final mode, this report updates the F0911 table with the company number from the account master record in the F0901 table.

Companies in Balance (R097001)

This report indicates the net balance for each company. When a company is in balance, the columns on the report are blank.

Intercompany Accounts in Balance (R097011)

This report lists imbalances between corresponding intercompany accounts.

If you have multiple companies with different base currencies, do not run this integrity report. This integrity report does not accommodate different base currencies.

Account Balance to Transactions (R09705)

This report lists imbalances between the F0902 and F0911 tables by fiscal period.

If imbalances exist between these tables, and you change an account from monetary to nonmonetary or vice versa, contact the Global Support Services consultant for a resolution plan.

Foreign Account Balances (R09707)

In proof mode, this report compares CA records to AA records in the F0902 table and prints a report that indicates CA records that do not have corresponding AA records.

In final mode, this report removes CA records from the F0902 table that do not have a corresponding AA record.

Cash Basis Integrity Test (R11C750)

This report identifies cash accounts that have different balances in the AA and cash basis ledger (AZ) after posting.

This integrity report can be accessed only from the Cash Basis Accounting menu (G09314).