Background: Manufacturing Execution System Interface Maintenance

Use the Manufacturing Execution System Interface Maintenance (TMESM) program to enter manufacturing execution system interface parameters for selection in the System Options Maintenance (XM) (Manufacturing Execution System Options) program. See Road Map for work flow.

Manufacturing Execution System (MES) Interface Process

If you have automated equipment and need to interface changes in inventory you can set up this interface to handle the task.

Once the interface is defined, you simply generate a transaction file in a specified directory. A background process recognizes the presence of the file and processes it as if someone was manually inputting inventory adjustments. There are a number of manufacturing processes that include a “vision” type inspection and this interface allows you to track the scrapping of inventory as desired.

The MES process defines how often the process is executed. Each time a transaction file is available for processing the updates are completed. In the event of an update issue, the application allows sending an email to a defined email address.

Siemens Interface

A Siemens interface for importing adjustments is provided.

Field Name

Length

Adjustment type

One of the following codes:

  • CO (consumable)

  • OH (on hand)

  • SC (scrap)

  • FS (floor stock)

Item number

24 alphanumeric, required

Control number

16 alphanumeric, conditional

Adjustment code

10 alphanumeric, required (from the table maintained by Inventory Adjustment Codes Maintenance)

Quantity

12 numeric; required

The impact on inventory is determined by the adjustment type:

  • CO: A positive value decreases inventory you consume but do not track; a negative value is not valid

  • OH: A positive value increases inventory; a negative value decreases inventory

  • SC: A positive value decreases inventory; a negative value increases inventory

  • FS: A positive value increases floor stock; a negative value decreases floor stock

Note
For negative quantities, the sign can be leading or trailing

User ID

6 alphanumeric

Transaction date

8 date in the format YYYYMMDD

Branch

4 optional (uses the login branch of the user if branch is not provided)

Warehouse

2 alphanumeric, conditional

Bin location

8 alphanumeric, conditional

Reference

20 alphanumeric, optional

Our system will receive scrap transactions from the external system (Siemens) and update it as an inventory adjustment, just as if you had entered a scrap transaction in the Material Issues and Adjustments (IMI) program. After receiving the transactions, use the IMI program to process the register. All of the normal audit trails update as the individual transactions are processed.with MIJ.

QC Interface

The QC interface processes manufacturing receipts and adjustments to inventory based on data received from a QC system. Quantities received from the QC Interface are assumed to be for good units.

Field Name

Length

Manufacturing order number

12 alphanumeric, conditional

Item number

24 alphanumeric, required

Control number

16 alphanumeric, conditional

Quantity

12 numeric, conditional (quantity is assumed to be 1 for serialized items)

User ID

6 alphanumeric, optional (if not provided, Default user ID from MES Interface Options is used)

Transaction date

8 date in the format YYYYMMDD

Branch

4 alphanumeric, optional (uses the login branch of the user if branch is not provided)

Warehouse

2 alphanumeric, conditional

Bin location

8 alphanumeric, conditional

The MES Receipts Log Inquiry (MESLQ) program lists the receipts processed by the interface. A file named MESRTN is written to the drop file directory for the QC system to pick up and provides a closed loop that the receipt update was completed. The file includes the receiver number on which the update was completed.