Hello Team,
I am experiencing one issue. When order from shopify is syncing to Netsuite, there is a minor amount mismatch of total amount (0.01-0.02) when we set blank to NetSuite item to track the order variances as a line item setting.
When we select NetSuite item to track the order variances as a line item, there is same mismatch in total amount of NetSuite sales order and NetSuite Cash sale. Can anyone help here ? as we want to sync exact price of Shopify Order total to NetSuite Sales order and Cash sale.
NetSuite does not store “rounding differences” anywhere unless you give it a line to store them on.
You already mentioned “when we select NetSuite item to track the order variances as a line item”, so it sounds like you are already heading in the right direction.
The important part is that this variance logic needs to be applied consistently. NetSuite recalculates totals again when a Cash Sale is created, so if the variance line is only added on the Sales Order (or not carried over exactly), the small difference can appear again on the Cash Sale.
To get exact totals in both NetSuite transactions, the usual approach is:
- Use Price Level = -1 on all line items (including shipping/discounts)
- Use a variance item to capture the small rounding difference
- Ensure the same variance logic is applied on both the Sales Order and the Cash Sale
That way, the difference is explicitly accounted for and both NetSuite transactions will match the Shopify order total exactly.