We discovered that (and this is also confirmed by Netsuite support) single order processing in UI differs from bulk processing when it comes to calculating taxes. Bulk processing uses a different method of calculation or rounding sometimes end up being different than what Avatax reports.
Example;
Sales Order shows tax amount $12.32. Avatax tab also shows the same amount (i.e. Avatax service returned the value of $12.32 and Netsuite recorded it correctly). When this Order is bulk processed (Invoiced/Cash Sale'd) with others, it creates the transaction record with a tax of $12.31. When I look at the Avatax tab of this record, it was calculated as $12.32, and not $12.31. Meaning, Netsuite did not record this number, instead it used some shortcut method or something to calculate the tax.
My suspicion (and the only reasonable explanation I can think of) for this is having multiple taxes (city, state, county) and how they are being calculated (e.g. calculate each tax percentage then round, vs calculate using one average percentage like 6.3231% on the total, then round). Since Avatax tab shows the correct amount, they are naturally claiming this is not an error on their end, and their system is returning the correct tax amount per the logs. However, Netsuite is still insistent upon not addressing this issue and blaming Avatax for the error. The last correspondence with support suggested that it must be the older Avatax bundle. I tried the newest 9.1 bundle on our Sandbox, and created an identical transaction. Avatax calculated the tax as $12.33 (now this is on Avatax, and Avatax tab also shows $12.33).
I am posting this with the hopes of getting some exposure and support. Avatax support is trying to buy some time by asking the same questions and screenshots that I already sent, and Netsuite support is asking me to deal with the Avatax support hoping that the issue would go away magically or until I get tired.
All I am hoping that Netsuite records this as a bug, and roll out a fix that records the tax amount that was reported by Avalara in bulk processed transactions.