Configure price mapping

price is a multi-value NetSuite field that accepts an array of complex objects

Price Property Mapping Settings

Setting	Value
Primary accessor	(unmapped) or mapped to a Primary Source accessor if you have one
Secondary accessor	One of: assemblyitem.price inventoryitem.price etc
Update Primary on Submit	unchecked
Update NetSuite on Submit	checked
Object Value Selector
List Name
List Value Selector
Rendering Type	Free Text
Prefer NetSuite value	checked (if existing NetSuite values are the master values)

Price Property Mapping Rules

Given this input, create the following rules:

• Text Manipulation import rule for NetSuite (check the checkbox for Process for NetSuite) with the following text:

if (s && "items" in JSON.parse(s) && JSON.parse(s).items.length > 0) {   return JSON.parse(s).items[0].price; } return "";

• Text Evaluation display rule with the following text (make sure to replace all instances of itemType in the below code with your accessor name for Item Type , see Configure itemType mapping):

const itemTypeValue =
  "itemType" in rowData.modifications
    ? rowData.modifications.itemType
    : rowData.cells.itemType;

if (itemTypeValue === pm.secondaryAccessor.split(".")[0] && s === "") {
  return { message: "Value must not be empty" };
}

• Text Manipulation export rule for NetSuite (check the checkbox for Process for NetSuite) with the following text (make sure you are using the appropriate currencyPage id and priceLevel id) :

return {
  "items": [
    {
      "currencyPage": { "id": "1" },
      "priceLevel": { "id": "1" },
      "quantity": { "value": 0 },
      "price": Number(s)
    }
  ]
}