Picklist (W7158MOPick)
The MO Pick List Staging Table must be populated if the W7158MOHdr table has column ImportBOM set to 1. If MOPick is used, the MO Receipt Integration assumes it will provide ALL component information. The Picklist in GP is deleted and built entirely from information in the MOPick table. If there are serial/lot controlled components, the serial/lot number provided must exist as available inventory in GP. MO Receipt Integration will not override shortages for serial/lot controlled items.
| Column | Description |
|---|---|
| MANUFACTUREORDER_I | This column is a Key for the table.
30-char upper-case string. The Manufacturing Order Number must be entered. A corresponding record in the W7158MOHdr must exist. The ImportBOM column in the W7158MOHdr table must be set to 1. |
| SEQUENCE1 | This is a Key for the table.
Currency This should match the SEQUENCE1 column in MOHdr. |
| LNITMSEQ | This column is a Key for the table.
Long integer. A unique Sequence number must be entered for each picklist line associated with a Manufacturing Order. The Component Item Number’s Sequence Number – otherwise known as Pick List Position – may be utilized as the LNITMSEQ. |
| ITEMNMBR | The Component Item Number. The Item Number must be an existing Dynamics GP Item Number which is Active.
30-character upper-case string. |
| QUANTITY | The quantity of the Component Item Number consumed will be entered. If the Item is Serialized, the QTY must be set to 1. |
| SERLTNUM | If the Component Item Number is Lot Controlled, the Lot Number will be entered. Only one (1) Lot Number is allowed per record. If multiple Lot Numbers of a Component Item are consumed, enter them as separate lines in the MOPick table.
If the Component Item Number is serialized, the Serial Number will be entered. Only one (1) Serial Number is allowed per record. If multiple Serial Numbers of a Component Item are consumed, enter them as separate lines in the MOPick table. 20-char upper-case string. |
| UOFM | Enter the U of M in which the component should be consumed. This must be a valid U of M for the Item. |
| LOCNCODE | Enter the Site ID from which the Component Part will be consumed. The Site ID must be an existing Site ID within GP and must be assigned to the Item Number.
10-character upper-case string |