Mass Delete Closed Shop Orders and Clockings

Explanation

This activity is used to remove old shop order data, indirect and downtime clockings in order to maintain optimum database performance.

Prerequisites

This activity requires that orders be created in Shop Order, then processed and closed. Also, if you want to maintain any history of the data being deleted, you must first archive it.

A closed Shop Order must meet the following criteria to have information deleted:

In order to delete an indirect clocking record, the corresponding indirect transaction must have been transferred to the finance system.

System Effects

Essentially the mass delete closed shop order process will delete all the information found at the shop order client level.

As a result of this activity, the system will delete the following for closed shop orders that meet the above prerequisites:

As a result of this activity,

The following information will not be deleted:

Window

Mass Delete Closed Shop Orders and Clockings

Related Window Descriptions

Mass Delete Closed Shop Orders and Clockings

Procedure

Procedure A

  1. Enter the site from which you want closed shop order data purged. Click List to select a site from the available sites. Enter the percent (%) sign to make the system purge all sites.
  2. Enter the date up to which you want to purge closed shop order data.
  3. Select one or more of the following five check boxes to specify how much of each shop order's data is to be removed.
  4. Select the Remove Orders check box within the Shop Order - Canceled area, if you want to remove all shop order data for shop orders in the Canceled status.
  5. Select the Remove Indirect Clockings check box, if you want to remove indirect clocking data.
  6. Select the Run in Background check box, if you want to perform mass delete as a background job.
  7. Click OK.

Procedure B:

Click Schedule to open the New Database Task Schedule window. Set the required scheduling parameters and save (Instead of Remove to Date you have to enter Days to Keep). Scheduled tasks can be seen in the Scheduled Database Tasks window