The existing Plus Work Order CSV import program allows the user to create Plus Work Orders based on the default product structure and routing. This feature will allow the user to create a Plus Work Order with customized components.

The menu option Bill of Material Processor-> Processing-> Production Order Entry-> Process-> Plus Work Order-> Import has been split into two options: Plus Work Order Import and Plus Work Order Import with Customized Components. The new option, Plus Work Order Import with Customized Components, supports the importing of customized components.

Plus Work Order Import with Customized Components has three menu options: Pre-Interface, Interface, and Layout.

The Pre-Interface and Interface options will prompt the user for the following information:

CSV File Name – Enter the full path and file name of the CSV file to be processed. The application will remember the last file name entered. 

Import File With Header Row – If the CSV file contains a header row, enter Y. Otherwise, enter N. The application will remember the last entry.

Default Job No – Job number to use if not provided.

Default To Allocate Inventory – Blank will use the Global Setup default value. Making this flag Y will allocate components for this order

Default Exact Qty Flag – Blank will use the Global Setup default value. Setting this flag to Y means when this order is completed or closed the system would expect the quantity of the finished parent item to match or exceed the order quantity.  Otherwise, the system will consider it an exception.

The new interface supports the following fields for import:

A.      Order No – This is optional; if not provided the order number is sequentially assigned. Only new orders are supported.

B.      Item No – Required – Parent item number.

C.      Location – Required – Warehouse location.

D.      Quantity – Required – Quantity of the parent to be produced.

E.      Start Date – Optional  - Start date when work should begin on the order.

F.      Due Date – Optional – Due date when the work order should be completed.

G.      Job No – Optional – Job number associated with the order.

H.      Description – Optional – Work order description.

I.        Allocate Inventory Flag – Optional – Allocate inventory flag for the work order. If not provided, the value from the parameter screen will be used.

J.        Exact Qty Flag – Optional – Exact Qty flag for the work order. If not provided, the value from the parameter screen will be used.

K.      Copy From Base WO# - Optional – Base Work Order to copy routing form.

L.      Sales Order No. – Optional – COP Order No.

M.    Sales Order Line No. – Optional – Non-customized COP Order Line Item.  

N.      Operation No – Required. The operation must exist in the routing (standard routing or in the Base WO). This field must be numeric.

O.      Sequence No – Required. The sequence must be unique per routing. This field must be numeric.

P.      Component Item No. – Required – The item number must be unique per routing.

Q.    Component Qty Per – Required – The quantity of the component required to produce one parent. This field must be numeric.

R.      Component Scrap Factor – Optional - The percentage of this component, which it is anticipated will be lost due to scrap, shrinkage, etc.

S.      Component Item Description 1 – Optional; if not provided, the component’s item description will be used.

T.      Component Item Description 2 – Optional; if not provided, the component’s item description will be used.

Columns A through M are part of the order header, while columns N through T are part of the components. Since operation details are not specified in this structure, the operation detail is either from the standard routing or routing defined in the Base WO#.

For example, if a Plus Work Order will have 50 components the same, columns A – M will be repeated 50 times in the CSV file, while columns N – T represent the different components for various operations.

When the value in columns A – M is changed, then it is assumed that a new work order is being processed.

The Pre-Interface and Interface options will perform standard error checking. If there’s any error with the CSV, the error will be printed on the pre-interface edit list or interface journal. In that case, the application will not import any records in the CSV until the error is fixed.

This project does not create the sales order.

Note: COP orders with customized components should be imported using Plus Work Order Import instead of Plus Work Order Import with Customized Components. Otherwise, the user will receive the following error: COP Order Has Customized Components. Run Plus Work Order Import.

Warning Conditions:

Warning - Item Scheduled To Be Obsolete – Component item is scheduled to be obsolete.

Error Conditions:

Order Already Existed! Cannot Add This Order – This application only supports adding new Plus Work Orders at this time.

Cannot Copy From Both COP and Base Work If Customized – You cannot specify both a base work order and a customized COP order since the components are provided in the CSV import file.

COP Order Has Customized Components. Run Plus Work Order Import – COP orders with customized components should be imported using Plus Work Order Import instead of Plus Work Order Import with Customized Components.

Operation No is Invalid – Operation number must be numeric and is required.

Operation No Not Found In Base Work Order Routing – Operation number must exist in base work order routing.

Operation No Not Found In Parent Item Default Routing -  Operation number must exist in the parent item’s standard routing.

Sequence No is Invalid – Sequence number must be numeric and is required.

Duplicate Sequence No Not Allowed – Sequence number must be unique for each operation number.

Component Item Size Cannot Be Greater Than 15 – Component item number must be 15 characters or less.

Component Item No Not Found – Component item number must be in file in the Item Master file.

Component Cannot Be The Same As Parent Item – Component item number provided cannot match parent item number.

Component Cannot Be A Kit Item – Component item cannot have the item end item code set to “K.”

Component Cannot Be A Feature Item - Component item cannot have the item end item code set to “F.”

Component Cannot Be A Short Cut Item - Component item cannot have the item end item code set to “C.”

Component Cannot Be A Desc Item - Component item cannot have the item end item code set to “D.”

Obsolete Item, Not Allowed – Component item activity code is set to Obsolete and BOMP is configured to not allow obsolete components.

Duplicate Component Item Not Allowed – Component item must be unique for each operation number.

Component Item No Is Required – Component item number must be provided.

Quantity Per Field is Invalid – Component quantity per must be numeric and must be provided.

SCRAP Factor Field is Invalid – Component scrap factor must be numeric.

Component Desc1 Size Cannot Be Greater Than 30 – Component Description 1 must be 30 characters or less.

Component Desc2 Size Cannot Be Greater Than 30 – Component Description 2 must be 30 characters or less.

Programs Modified: BM1703, BMORDIMS

Programs Added: BMORDICS, BMORDICP