Hi, I'm attempting to write a script that will mark an order as non-taxable under certain circumstances. After submit, I'm setting

taxable

to

false

,

taxitem

to

-7

( the -Not Taxable item), and

taxrate

to 0. When saving, I'm getting the error:

"TRANS_UNBALNCD","message":"Transaction was not in balance."

with the same amount as the tax I'm trying to remove. Anyone know how to resolve this? Changing to before submit just throws an unexpected error

Is the error message giving you two numbers that are a penny off from each other? It can happen with rounding issues that come from script handling any pricing or discounts being used.

It gives me the full amount of tax I'm trying to remove. Ex/

"name":"TRANS_UNBALNCD","message":"Transaction was not in balance. Total = 3.48"

The record is loaded in dynamic mode

Are there any other changes to the record besides the tax thing being made? Dynamic mode can be tricky sometimes as some changes need to be made in a certain order. If any other changes affect any pricing they may need to be done before messing with the taxable. Have you tried doing it in standard mode?

Currently I'm setting the 3 fields in that order:

istaxable

,

taxitem

,

taxrate

. In the UI, unchecking Taxable and selecting the -Not Taxable- item automatically sets the Tax Rate to 0

See if there is anything reflecting tax on the GL?

Standard mode throws the same error, unfortunately

Are you using Acalara AvaTax by chance?

Yes, we're using Avalara

https://hairball.io/blog/common-netsuite-order-errors-and-how-to-solve-them/#:~:text=ERROR%3A%20TRANS_UNBALNCD%20%E2%80%94%20Transaction%20was%20not,to%20handle%20taxes%20in%20NetSuite.

now you're wearing your thinking cap (not your drinking cap)

Of course the Avalara article linked isn't there anymore... why would they make this easy 😖

Sounds like they did what SuiteAnswers did when they updated their site

Of course, the real issue is PEBKAC