Shopify Netsuite IA Error – Failed to create Customer Deposit for Shopify Order

Error: Failed to create Customer Deposit for Shopify Order XXXXXX due to the Invalid reference key of Order XXXXXX for Customer XXXXXX.

Reason: If you map the payment method on the sales order, NetSuite restricts to a create customer deposit.

Solution:

1. Remove the payment method mappings on the Shopify order to NetSuite order (cash sale or sales order) flow.
2. Create the mappings on the Shopify transaction to NetSuite customer deposit (add)flow.
3. Remove the existing payment record on the NetSuite sales order.
4. Retry the error on the integration app Dashboard.