Integrity Reports
Run integrity test programs to supplement the internal balancing procedures by locating potential balancing problems and data inconsistencies. Integrity test programs generate reports to help ensure that the JD Edwards EnterpriseOne systems remain in balance. For example, the Asset Account Balances File table (F1202) might be out-of-balance with the general ledger under these circumstances:
Journal entries are posted to the general ledger but not to fixed assets, or vice versa.
You made changes to the fixed asset (FX) range of accounts in the automatic accounting instructions (AAIs) and did not include an account that might have been previously included in the FX range, or vice versa.
You made changes to the general ledger account numbers and have not run the Update Company Number, Business Unit/Object/Subsidiary program (R12802).
Asset account records have been purged from the Account Balances table (F0902), but not from table F1202.
You can use integrity reports to identify and correct balance errors immediately. In general, you run integrity reports at least once a week during the conversion process at new installation sites or during a learning period for new users. All other users should run integrity reports on a monthly basis, at a minimum.