Import/export template > Module Manufacturing > Import/export template MKI (Import production tracking)
 |
 |
Import production tracking
This function is used to import the production reporting with works order by using the automatic processes developed for the production plan.
This import uses the global variable GIMP to recover information not carried in the MKI record, knowing that:
GIMP(1): Tracking posting date
GIMP(2): Production declaration transaction to be used. (If this field is not present or empty, then the system uses the transaction present in the general setup MKITRSNUM)
GIMP(3): Closing flag (1= NO, 2 = Yes, if not entered then it will be calculated by the system)
GIMP(4): Rejected quantity
The tracking type carried out as well as any linked processes (material consumption) will be defined by the production reporting plan transaction used.
The automatic declarations of the sub-products are impossible. It is necessary that the sub-product information exists in the import file.
Mandatory fields in the template
The mandatory fields are the following:
On MFGITMTRK
production site (MFGFCY)
order number (MFGNUM)
product (ITMREF)
quantity achieved in PAC (UOMCPLQTY)
operating unit (UOM)
On STOJOU
quantity achieved in STK (QTYPCU)
packing unit (PCU)
The stock fields (lot, sub-lot, Serial no...) are to be set up in STOJOU as a function of the management method of the imported products.
The stock status not being imported in the document line, it is absolutely necessary to have a stock status by default defined in the management rule.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Date greater than today's date !
Control message for the posting date (if not imported then the current date)
Non-existing site
Production site control message
Finished product does not exist for WO
Control on product message if tracking on WO
Non-existing work order
Control on works order message.
Different messages linked to the control of the works order number :
It is only possible to track a WO with the status "FIRM"
Incomplete allocation. Tracking impossible
The WO is not printed: impossible tracking
A material is in shortage and the tracking is prohibited for this WO.
Non-existing product code
Product not managed in stock for the site
In addition all the messages linked to the BOM controls can be encountered.
Tables used
This template can be used in import and export modes. The data is updated in the following tables :
| Table |
Table description |
|---|---|
|
CPTANALIN [CAL] |
Analytical accounting lines |
|
MFGHEADTRK [MTK] |
|
|
MFGITMTRK [MKI] |
|
|
STOJOU [STJ] |
Stock journal |