Hey folks, is there any easy way to get the tax ra...
# general
m
Hey folks, is there any easy way to get the tax rate (percentage) of a transaction into a saved search? I know I can use Formulas to emulate it, but I'm really hoping to grab the field value. Currently, I have not been able to find any fields to do it.
p
You can definitely get the tax amount in a saved search, but NetSuite doesn't expose the tax rate (%) as a standard field in most transaction saved searches. If you want the actual percentage, a formula is usually the most reliable workaround unless your transaction type exposes the tax detail records. If you'd like, I can help you build the saved search or show you a way to pull the tax rate based on your specific transaction type.
b
Each row of the item sublist on a transaction is represented by multiple transaction lines in the search. One (or more) of those transaction lines represents a tax item (with the tax item column checkbox being true). The item rate column of that tax item transaction line represents the tax rate
m
Thanks @Praise Heritage Abayomi for the response. I actually already have a formula... it's just not as preferrable as the field.
@battk Thanks! That column was what I needed 🙂
@battk By chance, do you know if there is a similar column for the taxable checkbox on a transaction? (The per line checkbox)?
b
probably not. closest is probably on the item join
m
@battk Thanks. Yeah, wasn't finding anything.