Understanding the Purge Prior Year Account Balances Program

To increase disk space, you can purge account balance records using the Purge Prior Year Account Balances program (R09912). This program:

• Copies records with a date that is prior to the current fiscal year from the F0902 table to the purge F0902P table.

• Deletes records that have a date that is prior to the current fiscal year.

• Prints a report that lists the number of records that were purged by company, date, and time that the F0902P table was created.

You can purge records only one year at a time. After the purge process is complete, you should copy the F0902P table to another medium. If you keep this table on your system and you purge again, the system adds newly purged records to the existing F0902P table which decreases available disk space.

You also might want to defragment the F0902 table and rebuild the table indices. Contact your database administrator for more information about this process.