M3 Graphical Lot Tracker Configuration

The M3 Graphical Lot Tracker configuration is built using the assumption that a full lot trace is available in M3 BE. Lot control method 2 or higher (MMS001/E) must be used for semi-finished or end products that should be included in the trace line. For purchased products, lot control method 1 can be used as well.

The Trace Line configuration for M3 BE is included in the installation of the M3 Graphical Lot Tracker. The trace line contains the following trace steps:

  • Purchase

  • Manufacture

  • Reclassification

  • Scraping

  • Distribution

  • Customer

  • SubContract

  • Blend

The configuration has the following features:

  • Presents a selection of information related to each trace step.

  • Includes a number of relevant search panels in the configuration.

  • Includes a customer, a stock, a material report and a lot audit in the standard configuration.

  • Supports any number of production steps, distribution chains, and levels of reclassifications.

  • Supports customer returns performed by M3 BE OIS390.

  • Supports subcontracted production and direct shipment from supplier to customer.

The configuration does not support customer order return via credit order.

Trace Steps, Routes, and Transactions

A trace step is the smallest traceable unit that describes the steps involved in a production process. For example, if raw material is processed to produce a product, the change of state can be represented by the trace step Production.

A trace route describes the movement between trace steps in a production process. For example, the movement of an item from the warehouse to production represents one trace route.

Each trace route represents a transaction. A transaction describes the input that is legal in the current configuration.

Trace Object Description and Details

All queries for Object Descriptions and Object Details are found in the ASP.scmd file. The following Object Description and Object Details are included in the M3TE configuration:

Trace Step Icon Query
Purchase DataInformation_DBV_Purchase
Manufacture

DataInformation_DBV_Manufacture

DataDetails_DBV_Manufacture
Distribution DataInformation_DBV_Distribute
Reclassify DataInformation_DBV_Reclass
Scrap DataInformation_DBV_Scrap
Customer Order

DataInformation_DBV_Customer

DataDetails_DBV_Customer
SubContract

DataInformation_DBV_SubContract

DataDetails_DBV_SubContract
Blend

DataInformation_DBV_Blend

DataDetails_DBV_Blend

Search Panel

All queries for the search panels can be found in the TraceEngine.scmi files.

Trace Step Query Drop-down
Purchase

GetQyeryData_

PurchaseSeach

 WarehouseList
Manufacture

GetQyeryData_

ProductionSearch

FacilityList

WorkCenterList
Stock (includes reclassification and transactions for scrapping)

GetQyeryData_

StockSearch

WarehouseList

LocationList

TraceStepList
Customer Order

GetQyeryData_

SaleSearch

 WarehouseList
Distribution

GetQyeryData_

DistributeSearch

WarehouseList (as from warehouse)

WarehouseList (as to warehouse)
Lot GetQyeryData_LotSearch none
Attribute GetQyeryData_AttributeSearch AttributeList

Reports

The queries for the reports can be found in the TraceEngine.scmi file, located in the folder for your trace line in the configuration folder.

The stock reports can be used to reclassify current stock in M3 and can be run directly from the M3 database (to obtain real-time stock report). Set the M3TE specific configuration entry .M3REPORT:SOURCESTOCK to GLT or M3 to select source of the report.

For the necessary configuration settings, refer to the List of Configuration Entries.