Purging Job Cost Transactions

When you no longer want to retain any accounting records for the job, you can purge the records by running the Job Cost Purge program (R51840). When you run the Job Cost Purge program, the system:

  • Selects job master records (F0006) that are assigned a posting edit code of P.

  • Locates all transactions for the job form the Account Ledger (F0911) and Account Balance (F0902) tables for all accounts and all ledgers, across all fiscal years, that are associated with that job (including any records summarized using program R09811)

  • Writes the records to the corresponding purge tables (F0911P and F0902P).

  • Removes records from the tables F0911 and F0902.

You can use data selection to limit the purge to a specific job, or fiscal year, or ledger type. Otherwise, the system selects the records to remove based solely on those jobs in which the posting edit code is P. The purge program does not have associated processing options.

After you purge jobs, you can save the F0911P and F0902P tables to a tape or other media type for storage. If you want to remove the actual job and related accounts from the Business Unit Master (F0006) and Account Master (F0901) tables, you must additionally purge any accounts payable and accounts receivable transactions associated with the job.