Hi all, Has anyone succeeded in getting Transaction Tax Rate via SuiteQL? Or is it supported only via Legacy Saved Searches?

The

transactionline

table has the tax rate. Use the

taxline

field as a filter. If the

transactionline

is

taxline = 'T'

then the

rate

field is the tax rate.

@Edgar Valdes In the

transactionline

, if

taxline

is

T

, then it's tax line. But please check about this case. For example, transaction has 4 line items, first 2 lines has tax with rate 4%, and last 2 lines has no tax. In this case, in Netsuite UI, we can see the tax amount per each line, but from SuiteQL, how can we get this ?

@Mark Oriend

SELECT

taxline,

rate,

ratepercent,

itemtype,

foreignamount

FROM

transactionline

WHERE

transaction = 6754118

and

taxline = 'T'

And the result looks like this. I think multi-line must be the same

taxline  rate	ratepercent	itemtype	foreignamount

T	      16	0.16	    TaxGroup	-329.38