is there any way to get the tax schedule of an ite...
# generalj
JBL
04/20/2021, 2:01 AMis there any way to get the tax schedule of an item on an item saved search?
t
tuli
04/20/2021, 3:41 AMWhat do you mean ? Tax schedule is the column available in item saved search, you can use that.
j
JBL
04/20/2021, 3:49 AMah sorry, what I meant was, is there a way to get the sales tax code from the tax schedule, on a saved search (that is to be used in a 3rd party application
JBL
04/20/2021, 3:49 AMand ideally the rate as well
n
Netsuite Tragic
04/20/2021, 4:28 AMExtending @tuli answers maybe something like this will work for you, especially with only a few Au rates actually having tax rate:
Netsuite Tragic
04/20/2021, 4:28 AMmessage has been deleted
Netsuite Tragic
04/20/2021, 4:29 AMjust adjust this formula for the codes in your account. DECODE({taxschedule},'GST',.1,0)
20 Views