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, is there any way to retrieve the tax code for a PO line using suiteQL?
If I select all lines for a PO I can see the "TaxItem" lines where the item is the tax code in the table "salestaxitem" but I cannot find the relation between the Item line and the tax line to know which tax codes belong to which item lines.
Has anyone done this before?

I haven't tried it, but you can see the joins in the Records Catalog

Thanks, unfortunately, the transactionTaxDetail table is only available with SuiteTax

In case somebody is interested in the solution, this is what I had to do:
1- Define a custcol field to store the tax code
2- create a User Event beforeSubmit to copy the taxcode on the line to my custcol
3- select the custcol in my SuiteQL statement.
It works actually.