This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Sorry if this question has been asked and answered already. Has anyone been able to figure out how to apply tax code/tax groups to transaction line items via suitescript? We have tax groups for US and tax codes for non-US so the suitescript search I built on `salestaxitem` doesn't work for US-based sales, though does for non-US ones.

have you reviewed the account in question? lots of US accounts have taxitem at transaction level rather than line

I'm sorry i'm not sure what 'review the account in question' means but tax codes are applied on the items sublist lines of a transaction, not on the transaction header level

the default position of US nexus transactions is to use the header not lines. you have to elect for line level tax under Setup Taxes

*Per-Line Taxes on Transactions* – Check this box if you want to assign taxes to transaction line items. This enables you to charge different tax rates for items on the same transaction. Each time you add a line item to a sales transaction, you must select the appropriate tax code or tax group in the *Tax* column. You can add taxes to line items on the *Billable Items*, *Billable Expenses*, and *Billable Time* subtabs.
If this box is not checked:
• NetSuite applies the same tax code or tax group to the entire transaction.
• You can only specify whether an individual line item is taxable or not.
• Tax fields for shipping and handling are not available.


Sure, makes sense. Well then that's checked for us, the problem is building a search to query 'appropriate tax code or tax group' to assign to the lines. I built one to query salestaxitem which works for non-US transactions but does not work for US ones for whatever reason (we have a tax group set up for US and tax codes for non-US)

Interestingly on US tax nexus I don't see the line item option (whereas I do on all other countries)

AH! Sorry it's a checkbox on the left side on the US as opposed to the dropdown on the right side on other countries. :man-facepalming:

I ended up making it search either taxgroup or salestaxitem depending on if it's a US-based transaction or not

Darn! It all works *until* save at which point the line item taxes are undone.