Using M3 Graphical Lot Tracker with M3 Business Engine

The pre-configured solution for interfacing M3 Business Engine contains the following Trace Steps:

  • Purchase

  • Manufacture

  • Reclassification

  • Scrap

  • Distribution

  • Customer

  • SubContract

  • Blend

Any logical connection allowed in M3 Business Engine is a valid connection when interfacing M3 Graphical Lot Tracker. For a complete list, refer to M3 Graphical Lot Tracker Administration Guide for M3 Business Engine.

The Step ID for most of the above configurations is built upon the following logic:

TT.Whs.Item.Lot, where

  • TT represents the transaction type used to create the lot (available options are PO - Purchase receive, MO - Manufactured, RC-Reclassified, SC - Scraping)

  • Whs represents the warehouse where the action took place

  • Item and Lot represents the item number and lot number (object).

A Trace step might be of the type "Unknown" with a Step ID XX.Whs.Item.Lot. This represents a lot transaction that is not created by any of the valid traceable ways. A lot created by a requisition order or stock count will get a Step ID of the type XX and the transaction will be rejected and shown on the Rejected Transaction Report. For more information, see Rejected Transaction Report in Reports Not Relating Directly to a Trace Object

Note: 
Manufacturing

Manufacturing lot L1 for item I1 in warehouse W1 will create a Trace Step with: Step: Manufacture Step ID MO.W1.I1.L1

Depending on the setting of the Trace Line, the Step ID for manufacturing of a lot might be following an alternate logic and be MO.Whs.Item.ManufacturingOrder

Scrap Scrapping of a lot is a possible end point of a trace. The Step ID for scrapping is SC.Whs.Item.Lot
Distribution

Shipping to a customer is the other possible end point of a trace. The Step ID for shipping to a customer depends on the database configuration. The Step ID is either 'CO.OrderNumber.Linenumber.Deliverynumber' or 'CO.Ordernumber.Linenumber.Deliverynumber.Lotnumber'.
SubContract The Step ID for shipping a lot to outside processing (Subcontract) is built using the requisition order number and line: SU.OrderNumber.OrderLine

The following example shows the transactions and steps created by the following processes:

  • Receiving the purchased lot L1 for item I1 into warehouse W1

    Transaction: From Step=Create, From Step Id=blank, To Step=Purchase, To Step Id PO.W1.I1.L1

    Trace Step: Step=Purchase, Step Id PO.W1.I1.L1

  • Consume lot L1 item I1 in warehouse W1 to produce lot L2 item I2 in warehouse W1

    Transaction: From Step=Purchase, From Step Id= PO.W1.I1.L1, To Step=Manufacture, To Step Id MO.W1.I2.L2

    Trace Step: Step=Manufacture, Step Id MO.W1.I2.L2

  • Distribute lot L2 item I2 to warehouse W2

    Transaction: From Step=Manufacture, From Step Id= MO.W1.I2.L2, To Step=Distribute, To Step Id MO.W2.I2.L2

    Trace Step: Step=Distribute, Step Id MO.W2.I2.L2