Hey, guys I encountered some critical technical issue while working on CSV import. Is there anyone know the solution, please note down. Thank you. Is It Possible to Programmatically Disable Tax Lookup Per Transaction When Using Advanced Tax? We are importing Sales Orders from Shopify via CSV. In Shopify: • VAT is already calculated. • Shopify is our legal source of tax calculation. • The VAT amount from Shopify must be preserved exactly. In NetSuite: • We are using Advanced Tax (Legacy Tax / Nexus-based tax). • “Enable Tax Lookup on Sales Transactions” is enabled. • Shipping addresses imported from Shopify are valid. • As a result, NetSuite automatically recalculates tax based on nexus and overrides the imported VAT amounts. Business Requirement For Sales Orders created via CSV import (identified by a custom field such as custbody_order_source = "Shopify Order by CSV"), we need: NetSuite to not recalculate tax • The system to accept the VAT amount provided in the CSV • The VAT amount to be stored as the actual tax amount per item line We cannot: • Disable Tax Lookup globally • Modify shipping addresses to avoid nexus determination • Create hundreds of custom tax codes to match Shopify • Add additional tax adjustment lines • Change our overall Advanced Tax configuration Technical Question Is there a supported way (via configuration or SuiteScript) to: 1. Disable automatic tax calculation on a per-transaction basis when Advanced Tax and Tax Lookup are enabled? 2. Programmatically override tax1amt and taxtotal fields without NetSuite recalculating them during save? 3. Prevent tax recalculation when a record is created via CSV import? If this is not supported, what is the recommended architecture when an external system (Shopify) is the authoritative tax engine and NetSuite is used only for financial reporting?

The one important piece of information while working with gross amounts is that there are 2 ways to calculate it