Sync refunds to resolve or avoid "invalid sublist" error in Shopify – NetSuite integration app

For the refund records, NetSuite loads the records based on the values selected at the header level. For example, the Currency or Subsidiary fields. If there is an incorrect value specified in the Currency or Subsidiary fields, the Shopify refund to NetSuite refund (add) flow does not retrieve the correct records as the dependent record is not available in NetSuite and displays an error message “Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record.”

Note: The steps below are applicable only if you’ve configured multiple subsidiaries and multiple currencies for your Shopify store. You have to initialize the appropriate currency for the appropriate subsidiary.

Shopify transaction to NetSuite customer deposit (add)

For the Shopify transaction to NetSuite customer deposit (add) flow, enable the record initialization for the Currency, Subsidiary, and Customer fields. While importing Customer Deposit we apply the SalesOrder to capture. For the Currency, Subsidiary, and Customer fields where we should add the right values for the list of SalesOrders to load.

1. Log in to your integrator.io account
2. Click Shopify - NetSuite.
3. Go to Flows > Billing.
4. Next to the Shopify transaction to NetSuite customer deposit (add) flow, click Mappings.
5. On the Edit Mapping pane, click Post customer deposit to NetSuite.
6. Either configure a new mapping or next to the Currency, Subsidiary, and Customer field mappings, click Settings.
7. Check the Use this field for NetSuite record initialization box.
   
   
8. Click Save & close.

Shopify refund to NetSuite refund (add)

For the Shopify refund to NetSuite refund (add) flow, enable the record initialization for the Currency, Subsidiary, and Customer fields.

1. Log in to your integrator.io account
2. Click Shopify - NetSuite.
3. Go to Flows > Refund.
4. Next to the Shopify refund to NetSuite refund (add) flow, click Mappings.
5. On the Edit Mapping pane, click Post customer refunds to NetSuite.
6. Either configure a new mapping or next to the Currency, Subsidiary, and Customer field mappings, click Settings.
7. Check the Use this field for NetSuite record initialization box.
   
8. Click Save & close.

Shopify Payout Transactions to NetSuite Deposit

For the Shopify Payout Transactions to NetSuite Deposit flow, enable the record initialization for the Deposit Account and Currency fields.

1. Log in to your integrator.io account
2. Click Shopify - NetSuite.
3. Go to Flows > Payout.
4. Next to the Shopify Payout Transactions to NetSuite Deposit flow, click Mappings.
5. On the Edit Mapping pane, click Post deposits to NetSuite.
6. Either configure a new mapping or next to the Deposit Account and Currency field mappings, click Settings.
7. Check the Use this field for NetSuite record initialization box.
   
8. Click Save & close.