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

Hi, must have been asked a 100 times, but is there any way I can find the tax amount of a transaction line, starting from the transactionline table (not using suitetax) ? Alternatively, is there any way to find the tax code used on a transaction line ?

```SELECT item, ratepercent, foreignamount FROM transactionline WHERE taxline = 'T' ```

<@U03A2UBF6BE>, thanks but I probably did not explained correctly. Let say that in the UI I am have 1 invoice with 3 lines. The first two lines are using the same tax code, the last one has a different tax code. 

Querying the transactionline table, NetSuite would give me 6 lines (1 main line, 3 transaction lines, 2 taxlines).

But on the 3 transaction line, I can’t seem to find a way to either get the taxcode or connect them to the taxline. 


You can see the list of all the records/fields here:
<https://nlcorp.app.netsuite.com/core/media/media.nl?id=127972055&amp;c=NLCORP&amp;h=34f6d25f34ab89fef9af&amp;_xt=.xls>

As you can see there, the details are in `transactiontaxdetail` , but are not available via SuiteQL. I think they only become available with SuiteTax.