UoM Mapping Tab: Step 4

Objective: To begin the initial steps in setting up the integration between Duro and NetSuite.

Difficulty: Easy 

In this article:

1. Video Tutorial
2. Enabling Internal IDs in NetSuite
3. Steps to setup

To ensure accurate syncing between Duro and NetSuite, each Unit of Measure (UoM) used in Duro must be mapped to its corresponding UoM in NetSuite. This mapping relies on NetSuite Internal IDs, which must be enabled and visible in your NetSuite account. This step guides you through enabling internal IDs, locating the correct values, and completing the UoM mapping inside the Duro integration wizard.

Video Tutorial: Mapping the UoM

---

Before you get started, there is 1 critical item that will need to first be resolved.

Enabling Internal IDs in NetSuite

This allows you to see internal IDs throughout NetSuite, including the UoM list.

• In NetSuite, go to the top menu and hover over:
  Home → Set Preferences.
  • Click “Set Preferences”.
• Stay in the General tab.
• Under Defaults, check the box labeled SHOW INTERNAL IDS.
• Click “Save”

---

1. Locate UoM Internal IDs in NetSuite

• In NetSuite, go to the top menu and hover over:
  Lists → Accounting → Units of Measure.
  • Click “Units of Measure”.
• Record your Internal IDs for relevant Base Units.
  • You may need to create “New” Base Units of Measure to complete the mapping.
    • Click “New” and follow NetSuite’s instructions.
• Click the “Name” on each relevant Base Unit. 
  • Record your Internal IDs for relevant Units Type.
    
    
    

2. Configure UoM Mapping in Prismatic

• In Prismatic, locate the UoM Mapping field.
• Line by line, add the relevant NetSuite Base Unit Internal ID to each UoM. 
  • [Optional] Add the relevant NetSuite Stock Unit Internal ID.
  • [Optional] Add the relevant NetSuite Purchase Unit Internal ID.
  • [Optional] Add the relevant NetSuite Sale Unit Internal ID.
  • [Optional] Add the relevant NetSuite Consumption Unit Internal ID. 

By filling in each field, you are ensuring this is mapped to NetSuite upon creation. Leaving any field black will stop any value from being mapped to that specific field. 

• Toggle the “Push on Update” for each field you want to be updated in NetSuite with every Change Order the relevant inventoryItems and assemblyItems are on.
• Double-check that each ID is correct to avoid sync errors.
  
  
  

3. [Optional] Non-Default Duro Units
   If your Duro environment has >19 UoM follow these steps.

• In Prismatic,  Click “+ Add to”.
• Type the missing Duro Unit in the blank field.
• Repeat steps 2 - 3 in this article.
  
  
  

4. ✅ Click “Next”.

• Now your NetSuite integration is able to map over the Units of Measure from Duro! 
• Click “Next” in Prismatic.