Understanding How to Update the Beginning Balance for Subsidiary Items

You run the Update Subsidiary Balances File program to update the F75C902 table with the balances for the periods for which you run this report. This report retrieves the transactions for the period that you specify in the processing options from the F0911 table and the subsidiary item IDs associated to the account number from the F75C011 table. The system retrieves and displays the relevant details for that subsidiary item. For example, if the subsidiary ID is supplier, then the system retrieves the supplier number for that transaction. Then, for the combination of account ID and subsidiary item, the system updates the beginning balance in the F75C902 table. If there is no record for a combination, the system creates a record in the F75C902 table.