Team Is there a way to retrieve the value of the "TAX RATE" field for each line item on a sales order using a saved search, please ?

Hi @Yougodan Plays Have you tried a formula field and pulling the {salesorder.taxrate} value?

NO can you help me on this one please ?

If you choose the field "Formula (Currency)" and in the "Formula" field of that line enter {salesorder.taxrate}. What do you get?

i get ERROR: Field Not Found

https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/script/record/salesorder.html (for reference) And if you use {salesorder.taxrate1}

I'm not that good with those as well. Maybe @Edgar Valdes can help

You want the tax item on the line

no i want the tax rate

In Saved Searches, you have the COGS line and TAX line as independent lines. So @C_Billings is right, the value you are looking for is the

rate

or

fxrate

in a

Tax Line : True

So the real question is are you using legacy tax and if so are you using out of the box or an integration. If legacy and out of box you can derive the rate from the tax amount vs the line item amount but generally you use the tax item (then the join for rate). I'm literally an SME here. Thats how its done

Have you tried tax item... fields and then rate?