Articles in this section

Assign inventory status details

Gogula R Bhavana
Updated

If your NetSuite account uses inventory statuses, you can configure the Square – NetSuite integration app to assign inventory status details to line items when syncing orders and refunds. This requires setting up a subrecord mapping in both the order and refund flows.

Prerequisites: Before configuring this feature, enable the Inventory Status setting in NetSuite at Setup > Company > Enable Features > Items & Inventory tab > Inventory sub-tab.

Configure inventory status for the order flow

Configure import settings

  1. Sign in to your integrator.io account.
  2. Open the Square – NetSuite integration app tile.
  3. Go to Flows > Order.
  4. Select the Square Order to NetSuite Cash Sale flow to open the flow builder.
  5. Under Post Cash Sale to NetSuite, select Import.
  6. On the Edit Import window, select + Add subrecord.
  7. On the Add subrecord import window, from the Which Cash Sale field should this subrecord set? dropdown, select Items: Inventory Details.
  8. In the Path to node that contains item data field, select line_items.
  9. Select Save on the Add subrecord import window.
  10. Select Save on the Edit Import window.

Configure field mappings

  1. Under Post Cash Sale to NetSuite, select the Field Mappings icon next to the Import icon.
  2. On the mapping selection window, select Post Cash Sale to NetSuite - Items: Inventory Details (Subrecord).
  3. Configure the following mappings:
Export Field (HTTP) Import Field (NetSuite)
Select the default inventory status to assign to line items Inventory Detail: Status (InternalId)
Select the quantity Inventory Detail: Quantity
"true" Inventory Detail: Replace All Lines

Configure inventory status for the refund flow

Configure import settings

  1. In the integration app, go to Flows > Refund.
  2. Select the Square Refund to NetSuite Cash Refund flow to open the flow builder.
  3. Under Post Cash Refund to NetSuite, select Import.
  4. On the Edit Import window, select + Add subrecord.
  5. On the Add subrecord import window, from the Which Cash Refund field should this subrecord set? dropdown, select Items: Inventory Details.
  6. In the Path to node that contains item data field, select return_line_items.
  7. Select Save on the Add subrecord import window.
  8. Select Save on the Edit Import window.

Configure field mappings

  1. Under Post Cash Refund to NetSuite, select the Field Mappings icon next to the Import icon.
  2. On the mapping selection window, select Post Cash Refund to NetSuite - Items: Inventory Details (Subrecord).
  3. Configure the following mappings:
Export Field (HTTP) Import Field (NetSuite)
Select the default inventory status to assign to line items Inventory Detail: Status (InternalId)
Select the quantity Inventory Detail: Quantity
"true" Inventory Detail: Replace All Lines