Understanding the Account Balance to Transactions Report
The Account Balance to Transactions report reviews balances in the F0902 table, verifies the amounts against the posted transactions in the F0911 table, and prints any out-of-balance conditions by period. If this integrity report does not locate F0911 records with the same account number, period number, fiscal year, and ledger type as the F0902 records, it deletes the invalid period balance from the F0902 table as long as these conditions apply:
A processing option is set to clear invalid period balances.
The affected ledger type has the Prevent Direct Balance Update check box selected in the Ledger Type Master Setup program (P0025).
If the Account Balance to Transactions report locates F0911 records with corresponding F0902 records, the system does not delete invalid period balances from the F0902 table, regardless of the processing option and ledger type master setup.