Hi everyone Using

transactionline

table to get items and taxes. In the UI, the

tax code

and

tax amount

are in the same line, but in SQL there is a separate line for item and tax. Is it possible to join this two lines to get the tax applied to a specific item in a transaction?

I think you need to enable SuiteTax to have that information available via SuiteQL, but I didn't try it out. It's available for free with NetSuite 2024.1