Which integrity reports should be run?

Nova614

Active Member
Hi JDEList, do we have white paper/s that could list all the integrity reports that a company should run periodically as a standard practise? In the absence of any white paper are there any guidelines that could be referred?

Thanks !
 
Here is a list of reports we run regularly.

TYPES OF INTEGRITIES

JD Edwards provides two main types of Financial Integrity reports, Batch Header reports and General Ledger reports. The Batch Header reports locate problems in the batches and their corresponding detail. The G/L reports compare transactions within a company, Intercompany settlement, account balances to detail, and compare the Account Master F0901 to the BU Master F0006, Account Balances F0902, and the Account Ledger F0911.

We will also utilize four subsidiary forms of integrities, Accounts Payable, Fixed Assets, Accounts Receivable, and Inventory. These reports compare each subsystem to the General Ledger.

AVAILABLE INTEGRITY REPORTS

A list of currently available reports and brief descriptions of their purposes:

GENERAL LEDGER INTEGRITIES

Companies in Balance (G0922, R097001) – Compares all postings on a single company number. Amount should balance to zero. Out of Balance conditions will be shown for current year, prior year, and future periods.

This is the primary report to identify that an out of balance condition exists.

Intercompany Accounts in Balance (G0922, R097011) – Balances the machine generated intercompany accounts to each other. All of these accounts, system wide, should net to zero. (Does not work with detail Intercompany settlements, only HUB method)

Accounts without Business Units (G0922, R097041) – Lists records (Accounts) in the F0901 file with Business Unit and Company discrepancies. Also, it is capable of updating the F0901 from the F0006, BU Master.

Account Balance without Account Master (G0922, R097031) – Compares Object Accounts in the F0901 to the Balances in the F0902 file.

Transactions without Account Master (G0922, R097021) – Compares Object Accounts in the F0901 to the Transactions in the F0911 file.

Account Balance to Transactions (G0922, R09705) – Compares Detail Transactions, F0911, to the Account Balance, F0902, on a period-by-period basis.

Global Update BU/OBJ/SUB to F0902/F0911 from F0901 (G09316, R09806) – Updates obsolete Chart of Accounts values (Business Unit, Object Account and Subsidiary) in the Account Balances and Account Ledger tables to current values.

BATCH HEADER INTEGRITIES

Unposted Batches (G0922, R007011) – Prints all batches shown as non-posted regardless of the reason.

Company by Batch Out of Balance (G0922, R09706) –Shows out of balance for each company within each batch.

Normally a follow up, details report once an out of balance condition exists.

Transactions to Batch Headers (G0922, R007021) – Compares the F0011 Batch Header File to the F0413 Batch Header Records file. Shows transaction records without a batch header record and unposted transactions with a batch status of “D” (posted).

Batch to Detail & Out of Balance (G0922, R007031) – Shows batches posted out of balance. Also has update capability to delete batch header records with no detail records and update batch status to D (posted) if the detail records all show posted.
Normally a follow up, details report once an out of balance condition exists.

ACCOUNTS PAYABLE INTEGRITIES

A/P Original Document to G/L by Batch (G0421, R04701, ZJDE0001) – Shows posted A/P ledger F0411 amounts and the corresponding posted Account Ledger F0911 amounts by batch, tests for any differences. Also shows invalid pay status conditions for each record within an A/P batch.

A/P Payments to G/L by Batch (G0421, R04702A) – Locates possible integrity problems in the payments records, only reviews posted payments.

A/P to G/L by Offset Account (G0421, R047001A, ZJDE0001) – Prints open (posted) A/P Ledger F0411 amounts and the corresponding A/P control offset account amounts in the Account Balances File F0902.

ACCOUNTS RECEIVABLE INTEGRITIES

A/R to G/L by Batch (G03B21, R03B701) - Shows posted A/R ledger F0311 amounts and the corresponding posted Account Ledger F0911 amounts by batch and tests for any differences. Also shows invalid pay status conditions for each record within an A/R batch.

A/R to G/L by Offset Account (G03B21, R03B707, ZJDE0001) - Prints open (posted) A/R Ledger F0311 amounts and the corresponding A/P control offset account amounts in the Account Balances File F0902.

FIXED ASSET INTEGRITIES

Fixed Assets to G/L Integrity (G1224, R127011) – Compares balance records in the Fixed Assets Item Balances File to the General Ledger Account Balances File.

Unposted to F/A Transactions (G1224, R12301, ZJDE0001) – Prints a list of all transactions that have been posted to the General Accounting System but have not yet been posted to Fixed Assets.

Fixed Asset Transaction Integrity/Report (G1224, R127012) – Reports a detail list of all transaction records from the F0911 Account Ledger for a particular account in the current year for a particular company. Similar to a detail G/L report, normally a follow to investigate outages.

G/L to Fixed Assets Integrity (G1224, R127013) – Compares the General Ledger Account Balances File to balance records in the Fixed Assets Item Balances File.

INVENTORY INTEGRITIES

Item Ledger/Account Integrity Report (G41111, R41543) – Shows discrepancies that exist between the Item Ledger File F4111 and the Account Ledger F0911.

Item Balance/Ledger Integrity Report (G41111, R41544) – Compares the Item Ledger File F4111 to the Item Balance File F41021. Shows variance in amounts, quantities, or both.

PAYROLL INTEGRITIES

Tax History Integrity Report (G07BUSP3, R077011) – Identify errors in your Tax History table (F06136).
PDBA Integrity Report (G07BUSP3, R077021) – Identify errors in the Employee Transaction History Summary table (F06146).

Note: We run these two reports during the Final Update process of every payroll.

J.D. EDWARDS RECOMMENDED SCHEDULE

REPORT - WHEN TO RUN

Companies in Balance (R097001) - Weekly during month (minimum) and nightly during the 1st through the 6th business day (close).

Intercompany Accounts in balance (R097011) - Twice Monthly, 15th and End of Month

Accounts without Business Units (R097041) - Twice Monthly, 15th and End of Month

Account Balance without Account Master (R097031) - Twice Monthly, 15th and End of Month

Transactions without Account Master (R097021) - Twice Monthly, 15th and End of Month

Account Balance to Transactions (R09705) - Twice Monthly, 15th and End of Month

Unposted Batches (R007011) - Monthly for Batches over 45 days old.

Transactions to Batch Headers (R007021) - As needed to investigate out of balance

Batch to Detail & Out of Balance (R007031) - As needed to investigate out of balance

Company by Batch Out of Balance (R09706) - As needed to investigate out of balance

A/P Original Document to G/L by Batch (R04701) - Twice Monthly, 15th and First of Month

A/P Payments to G/L by Batch (R04702A) - Twice Monthly, 15th and First of Month

A/P to G/L by Offset Account (R047001A, ZJDE0001) - Twice Monthly, 15th and First of Month

A/R to G/L by Batch (R03B701) - Twice Monthly, 15th and First of Month

A/R to G/L by Offset Account (R03B707, ZJDE0001) - Twice Monthly, 15th and First of Month

Fixed Assets to G/L Integrity (R127011) - Twice Monthly, 15th and 7th Business Day

Unposted to F/A Transactions (R12301, ZJDE0001) - Twice Monthly, 15th and 7th Business Day

Fixed Asset Transaction Report (R127012) - As needed to investigate out of balance

G/L to Fixed Assets Integrity (R127013)

Item Ledger/Account Integrity (R41543) - Twice Monthly, 15th and First of Month

Item Balance/Ledger Integrity (R41544) - Twice Monthly, 15th and First of Month
 
Ray's list is excellent.

Document WFN-01-0009 on the KG may also help. It suggests a particular order that the GL/AR/AP integrity reports should be run, and has links to other white papers.

For inventory, R41544 relies on data generated by R41542 - Solution ids 200782051/200782122 will help with this.
 
Ray, Thanks a lot for a detailed reply!! It is very help ful and I will get back in case of any issues. Thanks again!
 
Back
Top