Understanding the Delete Account Master Records

To increase disk space, you can delete accounts that do not contain transactions by running the Delete Account Master Records program (R09814). This program searches certain tables for transactions for an account and, if none are found, it does not copy accounts to a purge table. Instead, it deletes the account from the F0901 table.

The program searches for transactions in these tables:

• Customer Ledger (F03B11)

• Accounts Payable Ledger (F0411)

• Employee Transaction History (F0618)

• Employee Pay Instructions (F06106)

• Burden Distribution File (F0724)

• Account Master - Alternate Description (F0901D)

• Account Balances (F0902)

• Account Ledger (F0911)

• Cost Allocations/Flex Budgeting (F0912)

• Asset Account Balances File (F1202)

• Purchase Order Detail (F4311)

• Draw Reporting Master (F51911)

• Revenue Recognition G/L Information (G03B117)

You can run the Delete Account Master Records program in proof or final mode.