Summarize and Purge Account Ledger Transactions
You can purge Account Ledger (F0911) transactions for a job that is not closed if you summarize the transactions first using the Summarize Transactions program (R09811). The Summarize Job Transaction program creates a new transaction for each account by period to represent the total amount of the transactions for the period of time specified. For example, if there are 100 transactions entered for account 5001.02200.1341 for period 6 of 2008, the system generates one record with a document type of BF for account 5001.02200.1341 with the summarized amount.
After you summarize transactions, you can purge them from table F0911 using the Purge Prior JEs program (R09911). The purpose of creating summarized records is to maintain an audit trail between F0911 detail records and the F0902 balance records, which is critical if you ever need to repost account balances. Both the Summarize Transactions and Purge Prior JEs programs rely on AAI ranges that you set up to specify the eligible accounts. These processes are described in detail in the JD Edwards EnterpriseOne General Accounting guide.