Import/export template >  Module Manufacturing >  Import/export template MKM (Import Material Tracking)  

Display all Hide all

Use this template to import material tracking bookings, with or without work orders, using the automatic processes developed for the production tracking plan.

Prerequisites

Parameters to be entered

The following parameters must be entered

Manufacturing

  MKMTRSNUM (defined at level Company) : Import material tracking TRS

Mandatory fields in the template

According to the tracking type:

Tracking on WO

  • WO number
  • Line number for the released product
  • BOM sequence number
  • Component reference
  • Consumed quantity

Tracking on BOM

  • BOM and BOM alternative
  • BOM sequence number
  • Component reference
  • Production site
  • Consumed quantity

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Date greater than the current date!

Control message for the posting date (if not imported then the current date).

Non-existing site

Production site control message.

Non-existing material for WO

WO material record existence control message.



Messages linked to the control of work order numbers:

  • Non-existing work order
  • It is only possible to track one WO with the status FIRM
  • Incomplete allocation. Tracking impossible
  • The WO is not printed: Tracking impossible



Messages linked to the control of products (BOMs) and components:

  • Non-existing product code
  • A material is in shortage and the tracking is prohibited for this WO
  • Product not managed in stock for the site
  • No stock transaction associated with the product
    A transaction of the type "WO issue" must be associated with the product (via the Production tab in the Product-Site record or stored in the material tracking transaction used).
Tracking unexpected material on a versioned product

This warning is displayed if the import file contains an additional component for a work order that is for a product (BOM) that is version-managed.



All messages linked to the product (BOM) are written to the System log.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

MFGHEADTRK [MTK]

Manufacture tracking - header

MFGMATTRK [MKM]

Manufacture tracking - materia