Understanding the Account Ledger to Account Master Program

Use the Account Ledger to Account Master program (P097021) to verify that each record in the Account Ledger table (F0911) has a valid account number or valid company number in the Account Master table (F0901). The Transactions without Account Master program displays the same information that is available when you run the Transactions without Account Master report (R097021).

See Understanding the Transactions without Account Master Report.

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

• To correct invalid account ID errors, select a record to access the Batches program (P0011) for that particular batch. In the Batches program, select a record and click Select. Then, from the Journal Review form, use the Row menu to change the account on the transaction to a valid account.

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

• To correct missing account master record errors, select a record to access the Batches program (P0011). Then, use the Form exit to select Accounts to navigate to the Review and Revise Accounts program (P0901) and add the missing account. Then, return to the Batches program, use the Form menu to navigate into the appropriate program, and add the newly created account to the transaction.

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

To refresh the information in the F097021W table, select Refresh Data from the Form menu. You might need to refresh the date if you selected a row or batch number to correct multiple issues reported for that batch.