Assign status details to Square inventory

You can now assign inventory detail for a line item that has inventory assigned to different statues. This is applicable for the following flows:

• Square Order to NetSuite Cash Sale
• Square Refund to NetSuite Cash Refund

Before you configure your Integration App, enable the Inventory Status setting (Setup > Company > Enable Features > Items & Inventory tab > Inventory sub-tab) in your NetSuite account. You can configure separate mappings for the inventory adjustments to know the status of inventory details lines.

Configure the sub-record mapping

1. Login to your integrator.io account.
2. Click the Square – NetSuite Integration App tile.

Square Order to NetSuite Cash Sale

1. Go to Flows > Order.
2. Click on the “Square Order to NetSuite Cash Sale” flow below to navigate to the “flow builder” page.
3. Below “Post Cash Sale to NetSuite”, click Import.
4. Configure import settings:
   1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from “Which Cash Sale field should this subrecord set? ” drop-down list, select Items: Inventory Details.
   3. In the “Path to node that contains item data” option, select the appropriate “line_items”.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. Below “Post Cash Sale to NetSuite,” next to the Import icon, click on the Field Mappings icon.
   2. On the “Please select which mapping you would like to edit” window, select Post Cash Sale to NetSuite - Items: Inventory Details (Subrecord).
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail : Status (InternalId)
      Select the “Quantity”	Inventory Detail : Quantity
      “true”	Inventory Detail : Replace All Lines

Square Refund to NetSuite Cash Refund

1. Go to Flows > Refund.
2. Click on the “Square Refund to NetSuite Cash Refund” flow below to navigate to the “flow builder” page.
3. Below “Post Cash Refund to NetSuite”, click Import.
4. Configure import settings:
   1. On the “Edit Import” window, below “How would you like the data imported?” field, click +Add subrecord.
   2. On the “Add subrecord import” window, from “Which Cash Refund field should this subrecord set? ” drop-down list, select Items: Inventory Details.
   3. In the “Path to node that contains item data” option, select the appropriate “return_line_items”.
   4. Click Save on the “Add subrecord import” window.
   5. Click Save on the “Edit Import” window.
5. Configure field mappings:
   1. Below “Post Cash Refund to NetSuite,” next to the Import icon, click on the Field Mappings icon.
   2. On the “Please select which mapping you would like to edit” window, select Post Cash Refund to NetSuite - Items: Inventory Details (Subrecord).
   3. On the “Define Import-Mapping” window, new fields are added to the Import Field (NetSuite) list. You can configure these fields as per your business needs.
      

      Export Field (HTTP)	Import Field (NetSuite)
      Select the default status which we want to assign it to the line items	Inventory Detail : Status (InternalId)
      Select the “Quantity”	Inventory Detail : Quantity
      “true”	Inventory Detail : Replace All Lines