File and Delete Delivery Data

This document explains how you file and/or delete delivery (dispatch) data. These files increase in size with the number of dispatch transactions. For large customers with many transactions, these files become very large.

Outcome

Delivery data are filed or deleted. They are saved in a user-defined library.

For large customers with many transactions, these files become very large and a need to file or delete them will occur.

The following M3 programs are used in this process:

Before You Start

Outline

Solution

Delivery data filing/deletion is divided into two steps. The first step includes the selection of the data to file/delete. The second step is done by a batch job, which executes the filing/deletion. The filed data will be archived in a user-defined library.

The first step is to qualify dispatch data for filing/deletion. The main file will be the MHDISH file. If the selected delivery numbers qualify for filing/deletion, their status will be updated to status 99=Qualified for filing/deletion.

A delivery number qualifies for filing/deletion if its status is 90=Closed receipt, fully reported or 95=Closed receipt, not fully received, and if the shipment number is blank. If a shipment number exists, DCONSI must also qualify for deletion.

DCONSI qualifies for deletion if its status is 60=Shipment reported or 90=Shipment cancelled. If DCONSI does not qualify for filing/deletion, the status in MHDISH will not be updated.

Selection on the (MWS820/E) panel has to be made either on delivery numbers or shipments. It is also possible to enter a From and To selection, such as any number from 1 to 999999999.

Filing/deletion when selecting on delivery numbers is only possible for deliveries with no shipment number. If a shipment number exists, the only possible way of filing is to select on shipments. On the (MWS820/E) panel, a check is made so that selection is only possible for either delivery numbers or shipments.

When selection is made on shipments, the only other possible selection is the 'To date' field. When selection is made on delivery numbers, it is possible to fill in selection criteria in the Warehouse, 'Dispatch policy' and 'Transaction type' fields.

How

File/Delete Delivery Data

  1. Start 'Delivery Data. Filing/Deletion' (MWS820). Go to the P panel. The 'Number of days' field indicates how many days back in time a warning will be given when you are going to file/delete. For example, this number of days can be used to ensure that financial transactions for the dispatch data are done. The default is 60 days, which means that a warning will be given when you are going to file/delete for all dispatch data from today and 60 days back in time.

  2. Redisplay the B panel. Create a new filing/deletion number. Note that the number is created automatically when you go to the E panel.

  3. On the E panel, the Status field is set to 10=New. Status 20 is temporary while the filing deletion is running and the result will be 30='Completed, with errors' or 90=Completed, no errors.

  4. Fill in the 'Filing/Deletion' field with 1=Filing or 2=Deletion. The 'Delete all' field indicates 0='File/Delete only selected dispatch data' or 1=File/Delete all dispatch data.

    If you selected Delete all=0, you select the data to be filed/deleted in the following fields:

    Delete packaging, Delete picking (list), Delete document and Delete download data (used when using the Warehouse Integration interface).

  5. Fill in the 'To date' field with the date back in time to which the filing/deletion applies. Depending on the value in the 'Number of days' field (on the P panel), a warning may be displayed (see above). This warning is overridden by pressing Enter.

  6. You must select either Shipment(s) or Delivery(ies) for the filing/deletion. If you selected Shipment, no more selections are allowed.

    If you selected Delivery, you can also select Warehouse(s), Dispatch policy(ies) and Transaction type(s).

  7. The 'To library' field is user defined.

  8. Press Enter and the B panel is redisplayed. Select option 9=Run. The status will be raised to 20, and thereafter to 30 or 90.

    Analyze Errors on Filing/Deletion

  9. If the status on a Filing/Deletion number is 30='Completed, with errors', then you can analyze the run. To do so, you select option 21=Analyze on the (MWS820/B) panel.

  10. 'Delivery Data. Analyze Filed/Deleted' (MWS821) is started. The current filing/deletion number and the deliveries that have the errors from the run are displayed on the B panel. You also see the direction on the delivery - inbound or outbound.

  11. A message ID with a message text is displayed for each delivery.

    Example:

    The text says 'Deletion is not permitted - shipment number 1736 exists on delivery'. In this case, the current delivery had status 90, but the connected shipment only had status 10, and was thus not qualified for filing/deletion.

Related topics