MO Receipt Integration

MO Receipt Integration (MORI) is a utility for integrating production which is recorded outside of Dynamics GP into the Dynamics GP Manufacturing module. Information for the receipts is provided through an integration into several staging tables. MORI can run unattended, automatically processing new receipts as they are added to the staging tables. Since MORI runs as part of the Dynamics GP client, it requires a User License and GP Client dedicated to running the processor.

It can either create a new MO and post an MO Receipt for the MO all in one step, or create and post a receipt for an existing MO.

When provided with an Item Number and Quantity, the MORI will create an MO in GP for the Item, create the Picklist, and post an MO Receipt for the desired quantity.  This will consume the raw materials from the Picklist and post the finished good into inventory.

The MO can consume raw materials based on the Bill of Materials, or a Picklist can be imported along with the MO.  Likewise, standard labor and machine costs can be pulled from the Routing, or, the labor and machine time/costs to consume can be imported along with the MO.

MORI can also create and post receipts for MOs that originate in GP (i.e. the MOs were created manually). There are some restrictions that are described later in this document.

Using the MORI requires developing a direct-to-table import from the external manufacturing system into the Integration Tables provided by MORI.  This is discussed in more detail in the Staging Tables section.

MO Receipt Integration (MORI) can either (1) create an MO and then create and post a receipt for the MO all in one step, or (2) create and post receipts for existing MOs.  These two methods are referred to below as One Step and Two Step.  Two Step refers to the fact that the MO is created manually (step 1) and then later one or more receipts are posted (step 2).

MORI can also create MO Receipts by importing an Excel Spreadsheet.  There are several features of the staging table-based integration that are NOT available when using the Excel Import method, which will be discussed further below.