Understanding Account Ledger Table Updates

The G/L method uses payment information that is stored in the Account Ledger table (F0911); therefore, you must ensure that this table contains current information.

To ensure that all transactions have been updated in the F0911 table, run the following programs on the Enterprise Server in sequential order:

  • Update BU.Obj.Sub to Journal Entry (R09806)

    This program updates the F0911 table with any changes that you have made to the chart of accounts. If you have made no changes, you do not need to run this program.

    The Update BU.Obj.Sub to Journal Entry program (R09806), which you must run before you update payment information, updates the Account Balances (F0902) and Account Ledger (F0911) tables with any changes to business units, object accounts, and subsidiary accounts from the Account Master table (F0901).

    The Update BU.Obj.Sub to Journal Entry program produces a report that shows changes made to the F0902 and F0911 tables. Compare the changes on the report with the AAI setup to ensure that the account numbers for AAI item PXxxxx are still within the specified ranges.

    If you have not made changes to the F0901 table, you do not need to run this program.

  • Update Payment Information - Receipts (R045131)

    If you use the Procurement system to create vouchers using three-way matching, you must run the Update Payment Information - Receipts program before you run the Update Payment Information program. If you do not, you might get unpredictable results.

    You do not need to run this program if you do not use the Procurement system, or if you use the Procurement system, but only for purchase order-matched (two-way matched) vouchers.

  • Update Payment Information (R04513)

    This program updates the F0911 table with valid payment numbers and dates.