Hello, is it possible to search for TAX CODE in dataset? We are using only expenses in the bill transaction and need to create dataset for each expense line with TAX CODE

Tax item no ?

I found it in the Transaction Line (Item TAX CODE) … but now I have another issue …

What’s your issue? Item not expense ?

The issue is when I want to get TAX CODE from Related transaction (Bill Payment and Bill) If I create dataset for one level (bill trasaction) I got internal id for TaxCode But when I went use Related transaction there is no Tax code internal id Screenshots are attached

Create Other Record Field on your Tax Code Free form text Update by csv or by wf your tax code New custom field = Name of your tax code On the Dataset you can use this field

Thank you @Marc Finally, I found out what’s the problem. REVERSE CHARGE TAX CODE NetSuite puts the TaxCode only at TAX LINE, and then creates two independent Custom GL Lines with no TAX Code Item…. Unfortunately for me, the financial department needs info for RC Tax transactions

Yes you have activate a supplementary tax calculation plugin when you use reverse charge tax code you have 2 lines like you said

Exactly, I know that, and I have bad news for the financial department

As the line-field taxcode isn't available through suiteql. I've seen cases where people have resorted to creating a custom transaction column that will copy the tax code.