47 Purge Selected Equipment Information

This chapter contains this topic:

47.1 Purging Selected Equipment Information

Navigation

From Equipment/Plant Management (G13), enter 27

From Advanced Operations (G1331), choose Fixed Assets Global Updates

From Advanced Operations (G1231), choose Purge Selected Asset Files

You can delete out-of-date or obsolete equipment information from your system. When you use the Purge Selected Asset Files program, you can purge entire data tables or specific data within the tables. You can also archive the records that you purge.

Use DREAM Writer versions to delete only those records that you specify in Processing Option Revisions. Company number and item number are mandatory data selections for this procedure.

Run the purge program to perform one or both of the following:

  • Purge a piece of equipment that you disposed of in a prior year

  • Purge the Item Balances table (F1202) for a prior year

When you run this program, all information that the system purges is transferred to a separate purge table. The purge table name is the same as the original table name with a P at the end. For example, the purge table for F1201 is F1201P.

If a purge table does not currently exist in your system, the program creates purge tables in the same library in which the corresponding tables exist. If the purge table already exists in your system, this program adds purged records to the existing table.

JD Edwards World strongly recommends that you back up any of the following tables you plan to purge:

  • Item Master (F1201)

  • Item Balances (F1202)

  • Location Tracking (F1204)

  • Item Messages (F1205)

  • License Master (F1206)

  • Maintenance Schedule (F1207)

  • Parent History (F1212)

  • Equipment Rental Rate (F1301)

  • Status History (F1307)

  • Maintenance Loops (F1308)

  • Associated Service Types (F13907)

  • Language Preference (F1201D)

After you run the purge program, you can save the purge tables on a diskette or tape to archive the information. You can then delete the purge tables from your system. You do not have to archive your purged equipment information. If you do not want to save the information in a purge table, delete it from the system without saving it on a diskette or tape.

Note:

Ensure that no one accesses the general accounting or equipment tables while you run this procedure. The program is unable to purge information in tables that are locked by other system applications. Any information in tables that a user accesses elsewhere in the system will not be purged.

When you select Purge Selected Asset Files, a versions list appears. The versions list includes DEMO versions that you can run or copy and modify to suit your needs. When you run a version, Processing Options Revisions appears before the system submits the job for processing.

After the purge is complete, the program prints a report that includes the equipment number, description, responsible business unit, and disposal date (if applicable) of the purged equipment. The report also shows which tables included records that were purged and a summary showing how many records were purged from each table.

47.1.1 Before You Begin

  • Run the Asset Account Balance Close program

  • Back up any tables that you plan to purge