Excel – Picklist

(A)

MONumber

MO Number that matches the MOHeader record.

(B)

Sequence

Sequence Number that matches the MOHeader record.

(C)

Line Sequence

Long Integer

A unique Line Sequence number must be entered for each picklist line associated with the Manufacturing Order.

(D)

Item Number

The Component Item Number. The Item Number must be an existing Dynamics GP Item Number which is Active.

30-character, upper-case string.

(E)

Quantity

The quantity of the Item Number consumed. 

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. For serial numbered components the quantity must be 1.

(F)

Serial/Lot Number

If the Item Number is Lot Controlled, the Lot Number will be entered. Only one Lot Number is allowed per line. If multiple Lot Numbers of a Component Item are consumed, enter them as separate lines in the Picklist worksheet.

If a Component Item is serialized, the Serial Number will be entered. Only one Serial Number is allowed be line. If multiple Serial Numbers of a Component Item are consumed, enter each one as a separate line in the Picklist worksheet.

20-character upper-case string.

(G)

Unit of Measure

Enter the UofM in which the component should be consumed. This must be a valid UofM for the Item.

(H)

Location Code

Enter the Site ID from which the Component 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.