Header (W7158MOHdr)

Column	Description
MANUFACTUREORDER_I	This column is the Key for the table. If the MO Receipt should create a new MO and post the receipt, a unique Manufacturing Order number MUST be provided. This will be used to create the MO in GP. Manufacturing Order numbers may NOT be duplicated. If the MO Receipt should be recorded against an existing MO, provide the MO Number and mark the Allow Receipts on Existing MOs box on MOGen. Do not use a numbering sequence that includes a dash “-“. Such as MO0123-16384. Since the MO Receipt Integration also uses a dash, this will prevent it from correctly identifying the “parent” MO.
SEQUENCE1	This column is the Key for the table. This may be zero. If multiple receipts for an MO are added to MOHdr, SEQUENCE1 should increment by 1 for each receipt. If only one receipt is created per MO, SEQUENCE1 may be zero or one.
ITEMNMBR	The Item Number produced. The Item Number must be an existing Dynamics GP Item Number, which has at minimum, a MFG BOM Header and Primary Routing. The Item Number must be Active. 30-character, upper-case string. Not required is posting a receipt for an existing MO.
QUANTITY	The quantity of the Item Number produced. This will be the End Quantity for the MO. As is standard functionality within Dynamics GP, the Base UOM will be used when processing MO’s. The quantity must be compatible with the Item’s Quantity Decimals in GP. For example, if the item has zero quantity decimals, entering a Receipt Quantity of 1.25 will result in an error.
SERLTNUM	For non-serial/lot tracked items, leave this field blank. 20-character, upper-case string. If the MO Receipt produces one Lot Number or Serial Number, populate this field. For multiple serial numbers, leave this field blank and use the W7158MOSer table to list the serial numbers. For multiple lot numbers, create a separate MO Receipt record for each Lot Number received.
LOTATRB1	May be populated for Lot Controlled items. Ignored for all other items. 10-character string
LOTATRB2	May be populated for Lot Controlled items. Ignored for all other items. 10-character string
LOTATRB3	May be populated for Lot Controlled items. Ignored for all other items. 10-character string
LOTATRB4	May be populated for Lot Controlled items. Ignored for all other items. Date
LOTATRB5	May be populated for Lot Controlled items. Ignored for all other items. Date
MFGDATE	May be populated for Lot Controlled items. Ignored for all other items. Date
EXPNDATE	May be populated for Lot Controlled items. Ignored for all other items. Date
DATE1	Not used.
TIME1	Not used.
LOCNCODE	The Post To site for the MO. This may be blank if the Default Scheduling Preference, or the MOHdrOpt Scheduling Preference, provides a Post To Site. See Using MORI: Sites for more information.
ImportBOM	A value of 0 or 1 will be entered: 0 – The standard components and quantities from the Bill of Materials should be used to generate the Manufacturing Order’s Pick List. 1 – The staging table for the MO Pick List should be used to generate the Manufacturing Order’s Pick List. If ANY of the Components are serial/lot tracked, you must set ImportBOM = 1 and provide the complete component list in the MOPick table. The MO Receipt Integration will NOT auto-select serial/lot numbers.
ImportRoute	A value of 0 or 1 will be entered: 0 – The Primary Routing, its sequences and Setup Time, Labor Time and Machine Time should be used. 1 – The Primary Routing and its Routing sequences (including Setup Labor Code, Labor Code and Machine ID’s) should be used, however, the Routing’s Setup Time, Labor Time and Machine Time should populate from the staging table for the MO Routing.
STATUS	Always enter zero. A value of 0 means that the MO record has NOT been processed. The MO Receipt Integration will only process records with a value of 0. The MO Receipt Integration will update the value to 2 if the MO record was processed successfully. The MO Receipt Integration will update the value to 1 if the MO has an error. If errors are encountered, resolve the errors and change the STATUS back to zero to have the MO Receipt Integration attempt to process the receipt again. 9999 – Status will temporarily be 9999 while the record is being processed.
NOTEINDX	Always enter zero. A short error message will be entered by the MO Receipt Integration in the SY03900 (Record Notes) table if the MO was unable to be processed. Every error encountered will be reported by writing a message to the Note. Examples of the error message include: >MO Number already exists >Item Number does not exist >A Bill of Material does not exist >A Primary Routing does not exist >The Post To Site does not exist >The Item Number is not assigned to the Post To Site The following SQL statement can be used to build a simple report to view errors of failed Manufacturing Orders which require review: select a.MANUFACTUREORDER_I, b.TXTFIELD from W7158MOHdr a (nolock) join SY03900 b (nolock) on a.NOTEINDX = b.NOTEINDX where a.MANUFACTUREORDER_I NOT IN (select c.MANUFACTUREORDER_I from WO010032 c (nolock))
LastReceipt	Set to zero. If you are integrating the final receipt for an MO, and the total quantity received is less than the End Quantity on the MO, set the LastReceipt flag to 1. MORI will then post the receipt and close the MO (or Cancel it if there were several partial receipts). If the last receipt brings the total quantity received equal to (or greater than) the End Quantity, MORI will automatically Cancel the source MO. If you are going to Allocate inventory to the MO, or use Outsourcing, or perform WIP Data Collection, you may integrate one and only one receipt for the MO, and the LastReceipt flag must be set to 1 (true).