Configure Routings
Routings in NetSuite, or in any manufacturing context, refers to a sequence of operations or steps that a product must go through during the manufacturing process. These steps can include various operations such as assembly, machining, laser and inspection.
For the NetSuite module, SharpSync only adds routings to BOMs that do NOT ALREADY have routings. This is to prevent overwriting existing manufacturing processes which may have been defined already. Please engage us for upgrading this functionality should you have need for it.
To configure routings for NetSuite in SharpSync, add 2 property mapping with the setting enabled:
Is Manufacturing Operation(let's refer to this asoperationStep)AND 1 more mapping
Is Manufacturing Step(let's refer to this asmanufacturingStep)
Step 1: Manufacturing operation
For the property operationStep use the settings:
Primary source Property
(Unmapped)
Secondary source Property
(Unmapped)
Is Manufacturing Operation
Yes
Is Manufacturing Step
No
Rendering Type
Advanced List
List Display Selector
name
List Value Selector
id
List Items
See List items for Operation Step and Finding the subsidiary and location IDs
List items for Operation Step
[
{
"name": "Location - Inhouse",
"id": 1,
"value": {
"name": "SharpSync routing via rest",
"subsidiary": { "id": 1 },
"location": { "items": [{ "id": 5 }] }
}
},
{
"name": "Location - External",
"id": 2,
"value": {
"name": "SharpSync routing via rest",
"subsidiary": { "id": 1 },
"location": { "items": [{ "id": 6 }] }
}
}
]Finding the subsidiary IDs
To find your available subsidiary ids you can simply select Setup > Other Setup > Subsidiaries, and then grab the INTERNAL ID.
For the more technical users, use POSTMAN to authenticate, then
/GET https://[companyId].suitetalk.api.netsuite.com/services/rest/record/v1/subsidiary
and then followup with
/GET https://[companyId].suitetalk.api.netsuite.com/services/rest/record/v1/subsidiary/{id}
Finding the location IDs
To find your available location ids you can simply select Financial > Lists > Locations, and then grab the INTERNAL ID. (Note: make sure you use a valid combination of subsidiary and location)
For the more technical users, use POSTMAN to authenticate, then
/GET https://[companyId].suitetalk.api.netsuite.com/services/rest/record/v1/location
and then followup with
/GET https://[companyId].suitetalk.api.netsuite.com/services/rest/record/v1/location/{id}
Step 2: Manufacturing operation steps
For the property manufacturingStep use the settings:
Primary source Property
(Unmapped)
Secondary source Property
(Unmapped)
Is Manufacturing Operation
No
Is Manufacturing Step
Yes
Rendering Type
Advanced List
List Display Selector
name
List Value Selector
id
List Items
See List items for Manufacturing Step
List items for Manufacturing Step
Operation steps are groupings of steps performed on an operation. Say you have a default set of steps for an assembly. Let's say it's to be powdercoated, cut, galvanized, then you'll want setup the steps accordingly (let's call this Set 1):
You mileage may vary, but the default items required for setting up a routing are:
Sequence,
Name,
WorkCenter
CostTemplate
SetupTime
RunRate
This leads us to a JSON array body (Let's call this Set 1) that looks something like the following:
[
{
"operationsequence": 10,
"operationName": "10 - Cutting",
"manufacturingCostTemplate": { "id": 6 },
"manufacturingWorkCenter": { "id": 48 },
"setupTime": 5,
"runRate": 1
},
{
"operationName": "20 - Galvanize",
"operationsequence": 20,
"manufacturingCostTemplate": { "id": 6 },
"manufacturingWorkCenter": { "id": 48 },
"setupTime": 5,
"runRate": 1
},
{
"operationName": "30 - Powdercoat",
"operationsequence": 30,
"manufacturingCostTemplate": { "id": 6 },
"manufacturingWorkCenter": { "id": 48 },
"setupTime": 5,
"runRate": 1,
"lagType" : { "id" : "qtypercent"},
"lagAmount" : 50
}
]Take note that there are some limitations imposed by NetSuite that must be followed. In the example shown above you cannot have lagTime at any step in the list of steps except the last.
Finding the Manufacturing Cost Template IDs
To find your available manufacturing cost template ids you can simply select Financial > Manufacturing > Manufacturing Cost Templates, and then grab the INTERNAL ID.
Finding the Manufacturing Work Center IDs
(Work in progress)
However for a different type of assembly you might not require the cutting part as that is subcontracted out, so you have a different set of steps (Let's call this Set 2):
[
{
"operationName": "10 - Galvanize",
"operationsequence": 10,
"manufacturingCostTemplate": { "id": 6 },
"manufacturingWorkCenter": { "id": 48 },
"setupTime": 5,
"runRate": 1
},
{
"operationName": "20 - Powdercoat",
"operationsequence": 20,
"manufacturingCostTemplate": { "id": 6 },
"manufacturingWorkCenter": { "id": 48 },
"setupTime": 5,
"runRate": 1
}
]You can group both of these "sets of steps" in an object list as follows:
[
{
"name" : "Set 1 - Cut, Galv, Powder",
"id" : 1,
"value" : [] // "{paste the values from set 1}",
},
{
"name" : "Set 2 - Galv, Powder",
"id" : 2,
"value" : [] // "{paste the values from set 2}",
}
]You finally paste this list in the List Items of the Manufacturing Step property mapping, then save the mapping.
Add Routing Mappings Export Rules
For each of the above defined property mappings, go to rules and add a Text Manipulation Export rule.
Paste the following JavaScript expression :
if (s === "")
{
return s;
}
else
{
const listItem = JSON.parse(pm.objectListItems).find((item) => item.id == s);
return listItem.value;
}Check the checkbox for NetSuite
Then save the rule.
Using / Setting BOM Routings
You can now use / set routings by loading a BOM and edit the corresponding routings BOM cells.
Last updated