42Q-MES0168 NetSuite Adapter

42Q Home > Tools > NetSuite Adapter

    

 

 

Tools NetSuite Adapter   Version MES15.70 Revision B1

 

 

Introduction

The NetSuite Adapter is a middleware software that has been developed for customers to seamlessly integrate their NetSuite systems with 42Q. This adapter can be installed to the customer’s NetSuite system in order to allow NetSuite users to monitor and iterate with 42Q.

 

The below diagram explains the capabilities provided by these NetSuite Adapters:

 

Figure 1: NetSuite Diagram

   

 

FIrst of all, users must do some file setups:  

1. Go to: Documents > Files > File Cabinet.
2. Click on the 42Q MES folder.
3. Click on the Mes Config folder.
4. Users will see the following files:

 

• mes_42Q_custom_attributes: This file stores the mapping of custom attributes from NetSuite with 42Q attribute names. Users need to use the attribute ID from NetSuite in the FIELD_NAME and give the attribute name they want to see on the 42Q side in the FORTY2Q_NAME field.
• mes_42Q_global_setup: This file stores the global-based one-time setups such as Web service URL,User Details, and Routing Details.
• mes_42Q_plant_setup: This file stores the plant level setups such as Customer code, Organization code, Overcompletion percentage, Default bin, etc.
• mes_42Q_unitmultiplier_setup: If customers are using a different unit of measures other than each, like thousands or ten thousand. To send the correct work order quantity, users must set up a unit and multiplier for it, so the work order quantity is converted based on the multiplier and sent to 42Q as each.

 

5. Click on the mes_42Q_plant_setup option to download the file to your computer.
6. Open the mes_42Q_plant_setup file from your computer.
7. When users create and install their NetSuite Adapter for the first time, they have to make sure that the CUSTOMER_CODE and ORGANIZATION_CODE have a unique value for each one, if the file doesn’t need to be changed, skip step 8, if not, save the file and click on the Add File button, select the edited file and submit it to replace the old one.
8. Check out the information and make sure that the NetSuite plant information matches the 42Q plant information.

 

Figure 2: Add New File

 

 

 

Assembly Item / Product Setup

 

1. On the search bar, enter the product for product setup 42Q-MUG.
2. A list will be displayed, choose the options that says 42Q-MUG, and next to it, click Edit.

 

Figure 3: Assembly/Bill of Materials: 42Q-MUG

 

 

3. Change the value of CUSTOM FORM to Standard Group Item Form so you can see a new tab at the bottom.
4. Scroll all the way down, click on the 42Q tab and make sure the option RELEASED TO 42Q is  checked.
5. In the option WORK ORDER EXTRACTS * select one of the following options:

• Default: Select this option if you want to send WO Header, WO Route or Flex field.
• System build: Select this option if you want to send WO Header, WO Route or BOM Item.

6. Click on the Save button.

 

Figure 4: 42Q Tab

 

 

 

 

 

Create a Work Order

 

1. On the menu bar, go to: Transactions > Manufacturing > Enter Work Orders.
2. Change the value of CUSTOM FORM * to Job Creation Job Order.
3. A new window will appear, change the value of SUBSIDIARY * to Honeycomb Mfg.
4. Then in the LOCATION field, select 01 San Francisco.
5. Change the value of the ASSEMBLY field to 42Q-MUG (the item with 42Q setup in Assembly Item / Product Setup section).
6. In the field ORDER #, enter the order number.
7. If you want to send the route’s information which is your operation sequences to 42Q, then check the WIP box (the MANUFACTURING ROUTING option will be selected automatically).
8. Click the Save button.

 

Figure 5: Filling out Work Order Data

 

Work Order Priority:

New field was added in the plant configuration file for setting up order priority.

‘SCHEDULE_PRIORITY’:‘CUSTOM’ will use the custbody_cust_priority custom NetSuite field to send the order priority to 42Q in the SCHEDULE_PRIORITY XML tag.

Users can send these other fields as well in the ‘schedule_priority’ field:

• Customer - customer priority
• Location - location priority

 

Figure 6: Work Order Priority Value

 

Figure 7: Schedule Priority Value

 

Monitoring Work Order Updates

 

 

Update / Change

Users can update or change the information of a work order (e. g. change the quantity) by following the next steps:  

1. On the menu bar, go to : 42Q Monitor Screen > Work Order Create and Ack > Monitor Screen.

 

 

  Figure 8: Work Order Monitor and Acknowledge Monitor Screen 

 

2. In the TRANSACTION NAME column, click on any work order.

 

Figure 9: Work Order Create and Ack Table

 

3. A new window will be displayed, click on Edit.
4. Make any changes (e.g. QUANTITY).
5. Click the Save button.

Figure 10: Edit Work Order    

 

6. If users want to check if it was successfully updated, click on the Back button to return to Monitor Screen.

 

WIP Move Transactions

  Users can view Work Order WIP Move Transactions by following the next steps:  

1. On the menu bar, go to: 42Q Monitor Screen > WIP Move Transactions > Monitor Screen.

Figure 11: WIP Move Transactions Monitor Screen

 

2. Click on any WORK ORDER NUMBER.

 

Figure 12: WIP Move Transactions Table

 

3. A new window will be displayed, at the bottom, there is a menu bar, select the Netsuite-42Q Interface tab.
4. Click on the WIP Move Transactions option.
5. When you complete your orders in the 42Q system, click on the Close button.

Figure 13: WIP Move Transactions NetSuite 42Q Interface

 

Figure 14: Save WIP Move Transactions Changes

 

6. On the new window, click Save.

WIP Material Transactions

Users can view Work Order WIP Material Transactions by following the next steps:  

1. On the menu bar, go to: 42Q Monitor Screen > WIP Material Transactions > Monitor Screen.

Figure 15: WIP Material Transactions Monitor Screen

 

2. Click on any WORK ORDER.

 

Figure 16: WIP Material Transactions Table

 

3. A new window will be displayed, at the bottom there is a menu bar, select the Netsuite-42Q Interface tab.
4. Click on the WIP Material Transactions option.
5. When you complete your orders in the 42Q system, click on the Close button.

Figure 17: WIP Material Transactions NetSuite 42Q Interface

 

6. On the new window, click Save.

 

Figure 18: Save WIP Material Transactions Changes

 

 

Routing Updates

The updates supported under Routing from NetSuite to 42Q are the following:

1. Edit an operation restricted to release status only: Operation name.
2. Edit setup time.
3. Edit run rate.
4. Edit cost template (no update will be sent to 42Q).
5. Edit manufacturing work center.
6. Adding a new operation sequence.

 

Key Value Pairs

Key Value Pairs (Custom Attributes) allow users to send custom fields or native fields, which are not part of the standard adapter from ERP to 42Q.

Key value pairs can be sent from the following 4 ERP levels: 

1. Work Order (shop order)
2. Work Order Assembly (shop order part number)
3. BOM Item (shop order BOM component part)
4. Work Order BOM Item (specific to work order)

 

To send these custom attributes, users need to follow the next steps:  

1. Go to: Documents > Files > File Cabinet.
2. Click on the 42Q MES folder.
3. Click on the Mes Config folder.
4. In the mes_42Q_custom_attributes row, click Edit.
5. The file is divided into 4 sections to support all 4 levels. To perform the mapping of the custom attribute field, set FIELD_NAME = Field ID from NetSuite as in Figure 19.
6. Set the 42Q generic field name, called FORTY2Q_NAME =  Field name to be displayed on 42Q as in Figure 19.

  Figure 19: Custom Attributes Configuration File

 

Standard Cycle Time and Hands on Time

 

 

Standard Cycle Time

 

1. On the menu bar, go to: 42Q Monitor Screen > Work Order Create and Ack > Monitor Screen.
2. Click on any work order from the column TRANSACTION NAME.
3. Select the Operations tab.

Two types of standard times are available:

1. SETUP TIME (MIN) (Basis type is lot).
2. RUN RATE (MIN/UNIT) also known as machine run time (Basis  type is item).

  Figure 20: Work Order Operations

 

These standard times are saved in the SQC Configuration table and SOMS target table on the 42Q.

If the standard baselines are not set for an operation or require an update, follow the next steps:  

1. In the section Primary Information, users will see the MANUFACTURING ROUTING option, below that option, users will see the manufacturing routing that has been set up, click on it.
2. Click on the Edit button.
3. Add the standard baselines for each operation in the SETUP TIME (MIN) and RUN RATE (MIN/UNIT) columns.

Figure 21: Manufacturing Routing Edition

 

Hands on Time

42Q records cycle time (hands on time) for each process. The cycle time recordings are sent to NetSuite with the WIP Move transaction. The hands-on time received from 42Q is saved in Machine run time and Labor run time for that operation under the work order completion record in the related records tab.

If users navigate to: Documents > Files > File Cabinet > 42Q MES > WIP Move and Material Move XML, they will be able to see the WIP Move with the hands on time in seconds as seen in Figure 20.

 

Figure 22: WIP Move and Material Move XML

 

Work Order Completion records store the hands on time in minutes (default unit of measure for the time in NetSuite).

In Figure 23, users can see an example of the previously mentioned.

If users navigate to: 42Q Monitor Screen > WIP Move Transactions or WIP Material Transactions > Monitor Screen, click on any work order, click on the tab Related Records, click on any Work Order Completion date, they will be able to see the Machine Run Time and Labor Run Time as seen in Figure 23.


  Figure 23: Work Order Completion

 

 

 

 

Bin Values from 42Q

 

Material Consumption

Material Consumption provides the ability to define Bin for Consumption.

For materials that have Use Bins checked, under Inventory Management requires to provide the bin number on material consumption. Customers can get the material consumption quantity, lot, or serial number as well as the bin location from which the material is consumed from the 42Q system.

In order to do so, users must access Inventory Management, they must follow the next steps:  

1. Enter 42Q-SHEET1 in the top search box and then click on the option that is going to appear below.

 

  Figure 24: Top Search Box

 

 

2. Click the Edit button
3. Make sure the USE BINS checkbox has been marked.

Figure 25: Inventory Management

 

Users can define a bin for each location on 42Q, under location maintenance, in order to do so, follow the next steps:  

1. Navigate to: Shop Floor Control > Configuration > Shop Floor Configuration > Location.
2. Select one row.
3. Click the Edit button.
4. Update the information.
5. Click the Save button.

 

  Figure 26: Updating Bin Information (Material Consumption)

 

The bin number stored in the location will be sent in the material issue transaction performed on that location as seen in Figure 27 and Figure 28.

If users go to the WIP Move and Material Move XML page, they will be able to see the WIP Move with the hands on time in seconds as seen in Figure 27.

 

Figure 27: WIP Move and Material Move Xml (Material Consumption)

 

 

If users navigate to: 42Q Monitor Screen > WIP Move Transactions or WIP Material Transactions > Monitor Screen, click on any work order, click on the tab Related Records, click on any Work Order Issue date, then click on the Inventory Detail icon, they will be able to see the bin number as seen in Figure 28.

 

Figure 28: Inventory Details (Material Consumption)

 

A global default bin is defined on NetSuite under mes_42Q_plant_setup.conf file, if a bin is not sent from 42Q that global bin is used to perform material issues.

If users want to see the Default Bin Number as seen in Figure 29, they must navigate to: Documents > Files > File Cabinet > 42Q MES >MES Config, click on the file mes_42Q_plant_setup.conf to download it, and then open it.

 

Figure 29: Default Bin Number (Material Consumption)

 

Note: If the Bin number does not exist on the ERP side users will get an error as seen in Figure 30. To fix this error users will have to manually either create the Bin in the system or do the material consumption.

 

Figure 30: Bin Number Error Message

 

Finished Goods

Finished Goods provides the ability to define the Bin for Finished Goods completions.

Once the Finished Goods are ready, they will be added to a bin. 42Q has the capability to send the bin location in the WIP Complete Transaction.

Users can define a bin for each complete location on 42Q, under Location Maintenance, select the location and click the Edit button, then go to the Flex Field Form tab as in Figure 31.

 

Figure 31: Updating Bin Information (Finished Goods)

 

 

The bin number stored in the location will be sent in the WIP Move Completion Transaction when a unit reaches that complete location as seen in Figure 32.

 

Figure 32: WIP Move and Material Move Xml (Finished Goods)

 

If users navigate to: 42Q Monitor Screen > WIP Move Transactions or WIP Material Transactions > Monitor Screen, click on any work order, click on the tab Related Records, click on any Work Order Completion date, then click on the Inventory Detail icon, they will be able to see the bin number as seen in Figure 33.

 

Figure 33: Verifying Bin Information (Finished Goods) in NetSuite  

 

A global default bin is defined on NetSuite under mes_42Q_plant_setup.conf file, if a bin is not sent from 42Q that global bin is used.

If users want to see the Default Bin Number as seen in Figure 21, they must navigate to: Documents > Files > File Cabinet > 42Q MES >MES Config, click on the file mes_42Q_plant_setup.conf to download it and then open it.

 

Figure 34: Default Bin Number (Finished Goods)

 

Note: If the Bin number does not exist on the ERP side users will get an error as seen in Figure 35. To fix this error users will have to manually either create the Bin in the system or do the material consumption.

Figure 35: Bin Number Error Message

 

Work Order Over Completion

42Q allows over completion of Non-Serialized Batch type of Work Orders i.e an over completion for a lot of type order. For such orders over completion quantity (amount) or over completion percentage can be sent from NetSuite. 

Users can define over completion percentage or amount at two levels:  

1. Work order level: Over Completion amount/percentage can be set by each work order, under NetSuite-42Q Interface tab, there are two fields, one is Over Completion Percentage which sends the allowed over completion percentage for this work order to 42Q and the other is Over Completion Value which sends the allowed over completion amount for this work order to 42Q.

Note: Over Completion Value has precedence over Over Completion Percentage.


Figure 36: NetSuite-42Q Interface Tab

 

The over completion value sent to 42Q is stored against the work order under generic attributes.

If users want to see the Generic Attributes, they must follow the next steps:  

1. Navigate to: Shop Floor Configuration > Production Control > Shop Order Browser.
2. Search the shop order.
3. Select the shop order.
4. Click the Shop Order Information.
5. Click the Display Generic Attributes.

 

Figure 37: Shop Order Generic Attribute List

 

To perform the over completion on 42Q, please use the command Increase Non Serialized Batch Quantity.

In Figure 38, users can see that in 42Q Production Workbench, a batch was scanned and then used the Increase Non-Serialized Batch Quantity command, to increase the batch quantity by 1500.

 

Figure 38: Using Increase Non Serialized Batch Quantity Command

 

42Q doesn’t allow exceeding the over completion limit sent from NetSuite as users can see in Figure 39.

 

Figure 39: Exceeding the Over Completion Limit Error

 

 

When over completion happens on the 42Q side, it is sent in WIP Move XML:

If users navigate to: Documents > Files > File Cabinet > 42Q MES > WIP Move and Material Move XML, they will be able to see the WIP Move with the over completion as seen in Figure 40.

 

Figure 40: WIP Move and Material Move XML

 

NetSuite Adapter checks the tolerance value and processes the WIP Move:

 

Figure 41: WIP Move Processed

 

2. Global level: A global over completion percentage or amount is defined on NetSuite under mes_42Q_plant_setup.conf file. If an over completion is not defined at the work order level the global value is sent to 42Q.

If users want to see the Over Completion Percentage as seen in Figure 38, they must navigate to: Documents > Files > File Cabinet > 42Q MES > MES Config, click on the file mes_42Q_plant_setup.conf to download it and then open it.

 

Figure 42: Global Value Sent to 42Q

 

 

 

 

Ship Notify Process

 

Figure 43: Ship Notify Process Diagram

 

Once the user moves the unit from the COMPLETE location, the NetSuite Adapter will  receive the completed serial numbers from 42Q. After that, whenever a sales order is fulfilled using that serial number, a ship notification transaction will be sent  to 42Q, and the status of the serial will change to status 44.


Figure 44: Shop Order Information

 

 

To monitor the transactions, status, 42Q responses and errors related to Ship Notify, users can go from the menu bar, to: 42Q Monitor Screen > WO ShipNotify SerialNumber > Monitor Screen.

 

Figure 45: Customer Record

 

 

By default, when serial numbers are shipped using a sales order on Netsuite, the serial entry will be available in the ‘WO Serial Number’ screen, a serial number will be created, and that serial number will have the values of the two columns ISSHIPPED and 42Q RESPONSE, set to ‘No’.

When users create a sales order and submit the form, the NetSuite Adapter will compare the entered serial number to the serial numbers contained in the customer record to verify if that serial number already exists. Then, the entered serial number will be sent along with the XML file to 42Q. Once the 42Q processes the data and responds with a success message, it will update the entered serial number, and its status will be set as well.

 

 

Figure 46: Monitor Work Orders Ship Notify Serial Numbers

Note: Serial numbers colored in green means that the values of the columns ISSHIPED and 42Q RESPONSE are both set to Yes, therefore, these serial numbers are under shipment.

 

Serial numbers colored in white mean that the WIP Move was completed and these serial numbers are ready to ship, it also means that the values of the columns ISSHIPED and 42Q RESPONSE are both set to No.

Serial numbers colored in red mean that the value of the column ISSHIPED is set to Yes but the value of the column 42Q RESPONSE is set to No, this mean there was a technical error, therefore 42Q did not respond with a successful message; These serial numbers are ready to retry. When 42Q response with a No message, (or unsuccessful message) a record will be created in the customer record Retry WO ship notify List, and the system will retry to send each of those records to 42Q every 15 minutes.


Steps for Shipping Process on NetSuite:

Create Sales Order:

1. From the menu bar, navigate to: Transactions > Sales > Enter Sales Order.

 

Figure 47: Navigate to ‘Enter Sales Order’

 

 

2. Enter the Customer, PO number, Item and Amount, then, click Save.

 

   Figure 48: Enter the Required Information

Figure 49: Enter the Amount Value

 

3. Click Fulfill and enter the required information. Next, go to the Address tab, and select the address. On the INVENTORY DETAIL Form, enter the serial number, Bin number, Qty, next, click the OK button and then click Save, to save the form.

 

Figure 50: Click ‘Fulfill’ Button

Figure 51: Select Address

 

Figure 52: Click on the ‘INVENTORY DETAIL’ Icon

Figure 52: Enter the Required Information In the Inventory Detail Form

 

4. The status will change to Pending Bill from Pending Fulfillment, if the process is successful.

 

 

Work Order Build Process

The NetSuite Adapter sends 3 types of information to 42Q: Header details, Routing and Component, however, if certain users do not want to send the route information but only send the header details and the component from NetSuite to 42Q, there exists the Work Order Build Process form that allows users to do so.

Figure 54: Work Order Build Process Flow Diagram