R09707 - Foreign Account Balances

The Foreign Account Balances report (R09707) reviews account information in the F0902 table and prints an integrity report that displays account setup issues caused by:

• Changes to an account.

  If you change an account from a non-monetary account to a monetary account after you post a foreign transaction, the report prints the error message Monetary account with incorrect transaction (CRCD) or company currency code (CRCX).

  If you change an account from a monetary account to a non-monetary account after you post a foreign transaction, the report prints the error message Transaction currency (CRCD) populated but not in PBC AAI range or a monetary account.

• Changes to AAI items.

  AAI item PBCxx is used for posting account balances by currency. If you add a range of accounts to AAI item PBCxx after you post a foreign transaction, the report prints the error message Account within PBC AAI range with no currency in the transaction currency field (CRCD).

  If you remove a range of accounts from AAI item PBC xx after you post a foreign transaction, the report prints the error message Transaction currency (CRCD) populated but not in PBC AAI range or a monetary account.

In proof mode, the Foreign Account Balances report lists any accounts with issues. Make sure that the accounts that appear on the report are set up accurately and were not inadvertently changed. If necessary, correct any errors and rerun the report in proof mode.

In final mode, the Foreign Account Balances report deletes CA records. If you run this report in final mode, you must also:

• Run the Repost Account Ledger program (R099102) to create the correct CA and AA records.

• Delete the "bad" AA records in the F0902 table.

  The Foreign Account Balances report does not automatically do this when it deletes the CA records. This should be done by the database administrator.

• Run the Foreign Account Balances report again in proof mode to verify that no accounts have error messages.