- Events, Blogs & News
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 the corresponding detail. The General Ledger (G/L) reports reviews transactions within a Company, Intercompany Settlement, or ; and compares the Account Master F0901 to the Business Unit (BU) Master F0006, Account Balances F0902, and the Account Ledger F0911.
You can also utilize five subsidiary integrity reports; Accounts Payable, Fixed Assets, Accounts Receivable, Inventory and Payroll. These reports compare each subsystem to the General Ledger and will be covered in subsequent blogs in this series.
In addition to integrity reports, beginning with EnterpriseOne (E1) 9.2, some financial integrities can be run in real time to fix issues.
This is the primary report that identifies an out-of-balance condition exists. It compares all postings . 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 that identifies an out of balance condition exists.
This report balances the machine generated intercompany accounts with one another. All these accounts, system wide, should net to zero. The report verifies the intercompany settlement accounts are in balance.
Note: The report does not work with the Intercompany Settlements. It only works with the method).
This is the interactive application that identifies an out-of-balance condition exists. It compares all postings . Amount should balance to zero. Out-of-balance conditions will be shown for current year, prior year, and future periods.
Lists records (Accounts) in the F0901 file with Business Unit and Company discrepancies. Also, it can update the F0901 from the F0006 BU Master.
This is the interactive version of the R097041 described above and it lists records (Accounts) in the F0901 file with Business Unit and Company discrepancies. Also, it can update the F0901 from the F0006 BU Master.
Compares Object Accounts in the F0901 file to the Balances in the F0902 file.
This is the interactive application of the R097031 and compares Object Accounts in the F0901 file to the Balances in the F0902 file.
Compares Object Accounts in the F0901 file to the Transactions in the F0911 file.
This is the interactive application of the R097021 and compares Object Accounts in the F0901 file to the Transactions in the F0911 file.
Compares Detail Transactions in the F0911 file to the Account Balance in the F0902 file on a period-by-period basis.
In the Chart of Accounts, this report updates obsolete values (Business Unit, Object Account and Subsidiary) in the Account Balances and Account Ledger tables to the current values.
Use the Financial Integrity Worktable Purge to purge records from all the worktables in the interactive integrity programs.
These worktables include: Transactions to Batch Headers (F007021W), Batches Out of Balance (F007032W), Batch and Company Within Batch Out of Balance (F09706W), Companies Out of Balance (F097001W), Accounts to Business Units (F097041W); Account Balance to Account Master (F097031W); Account Ledger to Account Master (F097021W). (Note: no longer used in 9.2 or above).
Displays all un-posted batches as “non-posted” regardless of the reason.
Displays all out of balance issues for each company within each batch.
This is the interactive version of the R09706. It displays all out of balance issues for each company within each batch. This is normally used as part of an issue follow-up, this report provides details once an out of balance condition is identified.
This report compares the F0011 Batch Header file to the F0413 Batch Header Records file. It also shows transaction records without a batch header record and unposted transactions with a batch status of “D” (posted).
Use the Transactions to Batch Headers program to identify discrepancies between batch records in the F0011 table and its associated transactions in the F0911, F03B11, F03B13, F03B14, F0411, F0413, and F0414 tables. The Transactions to Batch Headers program displays a record count of the number of transaction detail records that have a status difference from the header record. You can review the transaction details by selecting a record to navigate to the applicable program.
This report displays all posted batches that are Out of Balance. It also has the update capability to delete batch header records with no detail records or update the 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.
This report allows the user to review batches in which the net amount is not zero.
This is the interactive version of R007032. This application allows the user to review batches in which the net amount is not zero.
Additionally, the watch list functionality works with each of the interactive applications, listed above, to receive real time notice of any new issues identified.
There are many reasons why integrity issues can arise within JD Edwards. See below for some of the most common:
Below is the integrity report order and cadence per the current JD Edwards recommendations.
After over 20 years of experience managing JD Edwards financial systems and helping clients to manage their JD Edwards financial systems, I recommend running the integrity reports in the following order. This order has proven invaluable in ensuring issues were identified and resolved quickly and completely.
There are two things that need to happen during the month to ensure your files in the general ledger and subledger systems are in balance. The first is to make sure all general ledger transaction files are posted, both in the GL and the subsystem. The second is to make sure that the companies within the trial balance file are balanced. It is recommended to run JD Edwards integrity reports or interactive applications throughout the month to catch any errors before month end, giving you more time to analyze errors and determine the required corrections.
If you have the financials set up correctly, the general ledger file and trial balance should stay in sync and in balance, allowing you to complete efficient, error-free month end closes.