Options

1. Clear invalid period balances

Specify whether the system deletes period amounts in the F0902 table that have no corresponding records in the F0911 table. Values are:

Blank: The system does not delete period amounts for invalid records in the F0902 table and prints the invalid records on the report.

1: Delete period amounts for invalid records in the F0902 table and prints the invalid records on the report. The system deletes period amounts for invalid records only if no records exist in the F0911 table and the corresponding ledger type has the Prevent Direct Balance Update option selected in the Ledger Type Master Setup program (P0025).

Example: If an account in the F0902 table for ledger type AA has a balance of 600 in period 6 of fiscal year 2007 and no records for the account exist in the F0911 table for the same period, fiscal year and ledger type, the system deletes the F0902 amount only if the AA ledger type has the Prevent Direct Balance Update check box selected. In this situation, the system deletes the period balance from the F0902 and prints the out-of-balance amount and the message Balance Cleared on the report.

Example: If an account in the F0902 table for ledger type AA has a balance of 600 in period 6 of fiscal year 2007 and the same account has a balance of 400 in the same period, fiscal year, and ledger type in the F0911 table, the system does not delete the amount from the F0902 table because the account has a balance in the F0911 table for the same period number, fiscal year and ledger type, regardless of whether the Prevent Direct Balance Update option is selected.

2. Exclude inactive accounts.

Specify whether the system excludes inactive accounts when comparing period balances in the F0902 table to corresponding records in the F00911 table. Values are:

Blank: Include active accounts.

1: Exclude inactive accounts.