Archive or Delete Items

This document explains how you archive or delete items that are no longer in use. When you archive or delete items, you can keep your registers up to date.

In order to avoid archiving or deleting items that are still in use, you can define different checks that will be performed automatically.

This document also explains how you delete the product costing data connected to the archived item, and how you delete fashion items (styles, SKUs, and so on).

Outcome

  • The item is either archived in a library or deleted.
  • The item has status 90 (Item no longer stocked).
  • The product costing data connected to the archived item is deleted.

    Archived and deleted items are stored in the CJBCMD file.

This routine is used to keep your item master up to date.

Before you start

The basic settings for item archiving and deletion must be defined. See Settings for Item Archiving and Deletion.

Follow these steps

Specify type of selections

  1. Start 'Item – Qualify for Filing/Deletion' (MWS810/B).

  2. Set the panel sequence:

    • Alternative 1=E, F (Settings, selections From–To)
    • Alternative 2=E, G (Settings, specified selections)
    • Alternative 3=E, H (Settings, fashion selections).

      All three alternatives have the E panel in common.

    Note: For detailed instructions on deleting fashion items, see the section Delete Style and SKUs.

  3. Select 1=Create.

  4. Press Enter. The E panel is displayed and an archiving/deletion number is created.

  5. Fill in the Description field and press Enter.

  6. Depending on the panel sequence you selected, different panels are displayed. See below:

    • The F Panel=Selections From–To

      Fill in the 'Warehouse From/To' fields, the 'Item number From/To' fields, and the 'Item type From/To' fields.

      Go to Archive and Delete.

    • The G Panel=Specified Selections

      Fill in the 'Item number' field, the Warehouse field, and the 'Item type' field.

      Go to Archive and Delete.

    • The H Panel=Fashion Selections

      The H panel is used for mass deletion/archiving in the fashion area.

      Note: For detailed instructions on the deletion of fashion items, see the section 'Delete Style and SKUs.'

Archive and delete

  1. Press Enter. The (MWS810/B) panel is displayed again. The current status is 20 (In progress).

  2. Press F5=Refresh. The status will be one of the following:

    • Status 30 (Completed with errors)
    • Status 40 (Completed, no errors).

  3. Select option 22=Execute to continue the archiving and deletion of the item.

  4. Press F5=Refresh. The item will receive status 90.

    The archiving and deletion is completed when the status is 90 (Finished).

Analyze item archiving and deletion (Status 30=Completed with Errors)

  1. If the item status is 30 (Completed with errors), you can analyze the problem.

  2. Start 'Item. Qualify for Filing/Deletion' (MWS810). Select option 23=Analyze. This starts 'Item Filing/Deletion Analysis' (MWS811).

  3. If there are problems with the archiving or deletion of certain items, you might want to select option 4=Delete for those items.

  4. Then return to (MWS810/B) and select option 21=Qualify before pressing Enter. The status of the item will now be 40 (Completed, no errors).

Delete product costing data connected to the archived item

  1. Currently, product costing data cannot be archived according to the field item since no archiving routines currently exist. Instead, you must delete records in the costing files using 'Product Costing. Delete' (PCS270). It is recommended that you select the following values on the E panel:

    • Deletion type 2: In addition to the detail files, the total record for the costing ID is deleted.
    • Save previous 0: Whether the last costing ID of the specified costing type should be saved, regardless of the costing date.

      The following files are deleted by running PCS270:

      • MCCWAR (Calculation warnings)
      • MCBOMS (Saved costing fields material)
      • MCCMAT (Material costing components Standard cost)
      • MCSEM (Semi-finished material cost components Standard cost)
      • MCROUS (Saved costing fields operations)
      • MCCOPE (Operation costing components Standard cost)
      • MCCOMA (Costing components aggregated)
      • MCCOML (Costing components this level)
      • MCCOPU (Purchase costing file)
      • MCHEAS (Saved costing fields header)
      • MCHEAD (Costing header file)
      • Attached texts (attached via TXID) cleaned up in MSYTXH (Text header file) and MSYTXL (Text line file).

Delete style and SKUs

  • Delete all SKUs when acquisition code is 1 or 2

    These steps apply to deletion when all SKUs have acquisition code 1=Manufactured or 2=Purchased in every warehouse (MMS002/E).

    1. Start 'Item. Qualify for Filing/Deletion' (MWS810).

    2. On the (MWS810/B) panel, set panel sequence EH.

    3. Create a new archiving/deletion round. The archiving/deletion number is automatically created.

    4. Open the (MWS810/E) panel.

      Activate; Delete items, Delete style

      Deactivate; Delete alias

    5. Open the (MWS810/H) panel.

      Fill in the style number. Leave the remaining fields blank (if you want to delete all SKUs). Press Next.

    6. Perform the deletion. See Archive and delete.

      Result: All SKUs are now deleted from:

      MITMAS MMS001
      MITBAL MMS002
      MITFAC MMS003

      MITSUG

      		 MMS076/077
      MMMODMA MMS016/017
      MMMODFE MMS017
      MMMODCO MMS018/028
      MITMAH Item hierarchy
  • Delete all SKUs when acquisition code is 1 and 3

    These steps apply to deletion when all SKUs have acquisition code 1=Manufactured in one warehouse (the production warehouse) and 3=Distributed in the rest of the warehouses (MMS002/E).

    The SKUs must be deleted in the following order:

    • 1. Delete SKUs in all warehouses with acquisition code 3.
    • 2. Delete the SKUs in the production warehouse with acquisition code 1 and in MITMAS.

    1. Start 'Item. Qualify for Filing/Deletion' (MWS810).

    2. On the (MWS810/B) panel, set panel sequence EH.

    3. Create a new archiving/deletion round. The archiving/deletion number is automatically created.

    4. Open the (MWS810/E) panel.

      Deactivate; Delete item, Delete alias, Delete style

    5. Open the (MWS810/H) panel.

      Fill in the style number, item number (if some SKUs should be deleted, if all should be deleted, leave this field blank), and warehouses. Press Next.

    6. Perform the deletion. See Archive and delete.

    7. Then you create a second deletion round with exactly the same settings as in ''Delete all SKU's when acquisition code is 1 or 2''. These will delete the SKUs in the production warehouse and in MITMAS.

  • Delete Specific SKUs

    1. Start 'Item. Qualify for Filing/Deletion' (MWS810).

    2. On the (MWS810/B) panel, set panel sequence EH.

    3. Create a new archiving/deletion round. The archiving/deletion number is automatically created.

    4. Open the (MWS810/E) panel.

      Activate; Delete items

      Deactivate; Delete alias, Delete style

    5. Open the (MWS810/H) panel.

      Fill in the style number and item number. Press Next.

    6. Perform the deletion. See Archive and delete.

      Result: Specific SKUs are now deleted from:

      MITMAS MMS001
      MITBAL MMS002
      MITFAC MMS003

      MITSUG

      		 MMS076/077
      MMMODMA MMS016/017
      MMMODFE MMS017
      MMMODCO MMS018/028
      MITMAH Item hierarchy
  • Delete SKUs in Specific Warehouses

    1. Start 'Item. Qualify for Filing/Deletion' (MWS810).

    2. On the (MWS810/B) panel, set panel sequence EH.

    3. Create a new archiving/deletion round. The archiving/deletion number is automatically created.

    4. Open the (MWS810/E) panel.

    5. Open the (MWS810/H) panel.

      Fill in the style number, item number, and warehouses. Press Next.

    6. Perform the deletion. See Archive and delete.

  • Delete Style only in Warehouses and Facility

    This will delete the style from the MITBAL (MMS002) and MITFAC (MMS003) tables. The style will not be deleted from MITMAS (MMS001).

    1. Start 'Item. Qualify for Filing/Deletion' (MWS810).

    2. On the (MWS810/B) panel, set panel sequence EF or EG.

    3. Create a new archiving/deletion round. The archiving/deletion number is automatically created.

    4. Open the (MWS810/E) panel.

      To delete the style only, select the Delete style check box and clear the Delete alias and Delete item check boxes.

    5. Open the F panel (or the G panel).

    6. Enter the style number in the 'Item number' field. Leave the remaining fields blank. Press Next.

    7. Perform the deletion. See Archive and delete.

Features on the (MWS810/H) panel

  • Feature Connected to Quality

    1. Enter the ID of the feature connected to feature group Z in the Feature field.

    2. Enter the option connected to option group Z in the 'Option from and to' fields.

  • Feature Connected to Sizes

    1. Enter the ID of the feature connected to feature group X in the Feature field.

    2. Enter the option connected to option group X in the 'Option from and to' fields.

  • Feature Connected to Color

    1. Enter the ID of the feature connected to feature group Y in the Feature field.

    2. Enter the option that applies for the feature color in the 'Option from and to' fields.

    3. Enter the item numbers for which the archiving or deletion should be valid in the 'Item number from and to' fields.

    4. Fill in the 'Season from and to' fields. These are used to connect styles to the time periods for which the styles are valid.

    5. Fill in the 'Warehouse from and to' fields.

Related topics