Hey I'm encountering an issue with the Celigo Shopify to NetSuite Integration App for a client with multiple Shopify stores using different currencies (EUR, SGD) that are converted to CAD in Shopify before syncing to NetSuite. Problem: Small discrepancies exist between the Shopify CAD total and the NetSuite Sales Order total, likely due to currency rounding or conversion precision. Current Setup: I've followed Celigo documentation and configured a NetSuite variance item (non-inventory/other charge) to track these differences and reconcile the totals. The expectation is that this item would be added as a line item to the NetSuite sales order to match the Shopify total. Issue: The variance item is not appearing on the Sales Orders, resulting in a total mismatch. • Has anyone else experienced a similar issue where the configured variance item dosnt get created on NetSuite Sales Orders? • Are there any specific conditions, settings, or limitations (e.g., related to tax, currency handling in either Shopify or NetSuite, or Shopify store configurations) that might prevent the variance item from working as expected? • Are there any recommended workarounds or custom scripting solutions?

Hi Mb, James here from Celigo. This is odd. Is the variance showing in the eTail custom tab on the SO?

Thank you very much for your feedback. However, my customer is currently on NetSuite with only one subsidiary.

Mb, did you submit a support ticket for this by chance? Please send me a note! Thanks.