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?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the issue you're experiencing with the Celigo Shopify to NetSuite Integration App is not uncommon. There are several potential causes and solutions that have been discussed: 1. Rounding Discrepancies: NetSuite and other applications like Shopify may handle rounding differently, which can lead to discrepancies in the total amounts. This is particularly relevant when dealing with multiple currencies and tax calculations. 2. Tax Calculations: Differences in tax calculations between Shopify, NetSuite, and other tax applications like Avalara can also cause discrepancies. For example, Avalara calculates tax to the rooftop (i.e., very specific location-based), while other programs might only calculate to the zip code. 3. Address Information: The warehouse location address in NetSuite might be used differently by Shopify and Avalara, leading to discrepancies. 4. Overwriting Tax Amounts: Some users have found success by creating specific tax codes per state in Shopify, overwriting the tax using the Celigo connector, and then uploading those transactions to Avalara instead of using the AVATAX code. 5. Adding an Extra Line Item: If rounding issues persist, Celigo integrations can add an extra line item to the transaction to square it up. This might be a potential solution for your variance item not appearing on the Sales Orders. Remember to review your configuration or mapping in the Celigo integration between Shopify and NetSuite. Ensure that the appropriate transaction types and payment methods are correctly mapped and synchronized between the two systems. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******