- To supplement your internal balancing procedures.
- To locate potential balancing problems and data inconsistencies.
- Ensure that your system functions correctly and that tables remain in balance.
- Enables you to correct any problems in a timely and efficient manner.
You should run integrity reports at these times:
- During new Software Installation.
- During Data Conversion.
- Daily, if necessary.
- At the end of the fiscal period.
- At the end of the fiscal year.
The more often you run integrity reports, the easier it is to determine when a problem occurred. Consequently, this provides huge benefits to business, reduces downtime and assists with growing
audit, compliance and regulatory pressures.
The General Accounting Integrity Reports can be classified into four categories:
- Batch Header Reports - Identify discrepancies between the Batch Control Records table (F0011) and the Account Ledger (F0911) table.
- Out-of-Balance Reports - Identify whether transactions within a company are in balance, whether Accounts Balance (F0902) match with Account Ledger (F0911) on a period-by-period basis and if Intercompany settlement accounts are in balance.
- Chart of Account Reports – Locate inconsistencies within chart of accounts.
- Multicurrency – Identify discrepancies within Foreign Account Balances (F0902).
For more information on how to run and troubleshoot the General Accounting Integrities, you may refer to How To Troubleshoot EnterpriseOne General Ledger Integrity Issues (Doc ID 1541001.1).
You can also play a recording from the EnterpriseOne General Accounting Integrity Overview Advisor Webcast from Advisor Webcast JD Edwards EnterpriseOne Schedule and Archived Recordings (Doc ID 1450327.1), select tab Archived 2013 and locate the recording dated January 22, 2013.