How to Easily Improve Traceability via M3 and your Delivery Note

Scenario: The Quality Department have informed you that they want the trailer number pirnted on every delivery note from now on however, the despatcher will only find out the trailer number at the time of loading.

For the solution I will use the Ext tracking no: textbox in the MWS410/F panel.

Solution Part 1: StreamServe

  1. Open the PageOut and add a label to the header section of your delivery note
  2. Enter the following text into the label: Trailer Number
  3. Drag the field AHOQETRN from the Field folder in the Message window and place it opposite (or beneath) the label Trailer Number
    1. If you have multiple pages you need to complete this step for each page
  4. Export and deploy the project

Solution Part 2: M3

  1. Open MWS410 (Delivery. Open Toolbox)
  2. Right-click on the delivery that you are currently despatching and select Change
  3. The panel MWS410/E opens however, you need to click Next (or hit Enter) to open panel F
  4. In the highlighted textbox in Figure 1, enter the trailer number which is being used for the despatch and click Next.
  5. Click the Back button until you return to MWS410 and proceed with the despatch as normal.

Figure 1: Snapshot of MWS410/F
When the Delivery Note is generated it will display the trailer number used for the despatch.



How to control the display of a label based on the value of a spool-field

SCENARIO: Some of your customers require their VAT number to be displayed on the invoice document. Your M3 customer master file only has the VAT number for several customers however you do not want to have the label VAT Number appearing with no accompanying value on an invoice.

  1. Open the OIS1990H event and transform the spool-field 0HWYVRNO into a variable 
  2. Open the PageOut and insert a Static Text object (this will be your label) to your canvas
  3. Rename the label to VAT Number
  4. In the Message window, collapse the Variable folder and drag the variable $0HWYVRNO to your canvasto the right/below of the label.
Figure 1: The Variable folder on the PageOut canvas
  1. Right-click on the label and select Edit Script…
  2. Insert the following code:

    if ($0HWYVRNO = “”) {
    else {

The label VAT Number will now only appear if a value exists for the spool-field 0HWYVRNO. If the spool-field 0HWYVRNO value is blank then the label will be skipped (i.e. not appear).

Export and deploy and test!