Accounting Transactions: The Detail aging report does not tally with ledger balances

Select Housekeeping from the pull-down menu, select Check Records in Files.

Click on Look for Bad Records and Check.

Click on 'List' to view which transactions need to be edited due to errors.

Note down the Batch Number (Batchno) and Transaction Number (Tranno) to use in the search.

Exit.

Select "Housekeeping" from the pull-down menu, then select "Check Records" in the Files section.

Click on Data Integrity Check and select T06 - Abnormal Bill Age found in transaction and T07 - Abnormal date found in transaction.

Note down the Batch Number (Batchno) and Transaction Number (Tranno) to use in search and edit the mistakes.

Bill age for I (Invoice) type is always 0, and P (Payment) type is always 11.

You can also run a full check to make sure all data is maintained properly.