Settings for Item Archiving and Deletion

This document explains how you define the settings for item archiving and deletion.

Items that are no longer in use will either be archived in a library or deleted.

Outcome

These settings define if items should be archived or deleted.

You can also define check criteria before archiving and deletion in order to avoid archiving or deleting items that are in use.

  • Items will be either archived in a library or deleted.
  • Items are in status 90 (Item no longer stocked).

The settings for archiving and deletion are stored in the MMFADS archive.

Before you start

No prerequisites needed.

Parameters to Set

Program ID/Panel Field The field indicates …
(CRS799/E) To library … in which library the archived records should be saved.
(MWS815/E) Filing/deletion

… whether to archive items or delete them. The archived items will be stored in the library specified in ‘Settings – Filing’ (CRS799).

The valid alternatives are:

1 = Filing

2 = Deletion.

(MWS815/E) Check lot master

… whether a check for records in the lot master (MILOMA) for the selected items should be performed.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Delete item records

… whether item records are archived and deleted when you run item archiving and deletion and have included a warehouse in your selection.

The valid alternatives are:

0 = No, item records (MITMAS) will not be archived and deleted.

1 = Yes, item records (MITMAS) will be archived and deleted even if a warehouse is selected.

(MWS815/E) Check serial number

… whether a check for records in the serial number archive (MILOIN) for the selected items should be performed.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Delete alias

… how alias numbers are deleted.

The valid alternatives are:

0 = Delete alias numbers along with items

1 = Delete alias only; do not delete items or styles.

Alternative 1 can only be used when style and season are selected.

(MWS815/E) Check catch weight Archive

… whether a check for records in the catch weight archive (MILOMC) for the selected items should be performed.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Delete style

… whether the style should be deleted when all items have been deleted.

The valid alternatives are:

0 = No, the style will not be deleted.

1 = Yes, the style will be deleted.

(MWS815/E) Check order sales statistics

… whether a check for records in the order sales statistics (OSASTD) for the selected items should be performed.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Check stock transaction history

… whether the movement of an item is checked. Movement is checked in the transaction history for the number of days specified in the ‘Number of days’ field. Note that this only checks the movements of an item.

A check is always made to ensure that all accounting is done.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Check sales statistics

… whether a check for records in the sales statistics (OSBSTD) for the selected items should be performed.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Number of days … how many calendar days back the transaction history should be checked.
(MWS815/E) Check customer order lines

… whether a check in the customer order line (OOLINE) for the selected items should be performed. The check is performed for orders with status 77 or higher.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Status

… the item’s status. Items with an item status specified will be raised to status 90.

Example:

Item 7000 has status 20. If status 20 is entered, the item status for items that have status 20 will be raised to 90 when performing a filing and deletion round. Only items that have status 90 can be archived or deleted.

The valid alternatives are:

00–14 = User defined, unreleased item

20 = Released item

30 = Alternative items available

40 = Low turn over—mass update can be done in (MMS530)

80 = No longer in stock—returns are permitted

99 = No longer in stock due to number change—the item is only in the item archive.

(MWS815/E) Check customer order return

… whether a check for records in the customer order return (OCHEAD) for the selected items should be performed. The check is performed for orders with status 99.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Check distribution and requisition order lines

… whether a check in the distribution or requisition order line (MGLINE) for the selected items should be performed. The check is performed for orders with status 77 or higher.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Check purchase order lines

… whether a check in the purchase order line (MPLINE) for the selected items should be performed. The check is performed for orders with status=99.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Check work order header

… whether a check in the work order header (MWOHED) for selected items should be performed. The check is performed for orders for which actual costing and production statistics have been calculated.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

(MWS815/E) Check alternative material Archive

… whether a check in the alternative material archive (MWOMAA) for the selected items should be performed.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are

0 = No

1 = Yes.

(MWS815/E) Check product data alternative material Archive

… whether a check in the product data alternative material Archive (MPDMAA) for the selected items should be performed.

If a record exists for an item, the item will not be archived or deleted.

The valid alternatives are:

0 = No

1 = Yes.

Follow These Steps

  1. Start ‘Settings – Filing’ (CRS799/E). Enter the library in which you want to save the archived records.

  2. Start ‘Settings – Item Filing/Deletion’ (MWS815/E).

  3. Select 1=Filing or 2 = Deletion in the ‘Filing/Deletion’ field.

  4. Select which checks you want to be performed before the item can be archived or deleted.