Understanding the Account Balance to Account Master Program

Use the Account Balance to Account Master program (P097031) to verify that each record in the Account Balance table (F0902) has a valid record in the Account Master table (F0901). The Account Balance to Account Master program displays the same information that is available when you run the Account Balance without Account Master report (R097031).

See Understanding the Account Balance without Account Master Report.

Use the Account Balance to Account Master program to quickly correct the following errors:

• To correct missing account master record errors, select Accounts on the Form menu. Use the Review and Revise Accounts program (P0901) to add a missing account master record to the F0901 table.

  Note: You will also have to update the associated records in the Account Ledger table (F0911) and run the Repost Account Ledger report (R099102).

• To correct company mismatch errors, select Update Company on the Form menu. The system automatically corrects company values in the F0902 table to match the company values in the F0901 table.

  Note: The system does not modify the records in the F0911 table. To change the company in the F0901 records, use the P097021 program.

Use the Account Ledger Inquiry program (P09200) to review the account ledger transactions for a specific range of dates, accounts, and ledger types.

After you correct errors, you can run the Repost Account Ledger report (R099102) by selecting Repost from the Report menu.

The information that is displayed in the Account Balance to Account Master program is stored in the Account Balance to Account Master table (F097031W). When you close the program, the system deletes this information.