formula to show the tax amount on a column in as saved search for each customer

AI generated answer (using internal Slack threads):

To show the tax amount on a column in a saved search for each customer, you can use a formula field in your saved search. The formula would depend on the specific tax calculation you are using. For example, if you are using a tax item and you want to calculate the tax amount based on whether the tax item is an ECC code or a reverse charge, you could use a formula like this:

CASE WHEN {taxitem.iseccode} = 'T' OR {taxitem.isreversecharge} = 'T' THEN ({amount} * 0.21) ELSE {taxamount} END

This formula checks if the tax item is an ECC code or a reverse charge. If it is, it calculates the tax as 21% of the amount. If it's not, it uses the tax amount field. If you want to break out the tax by state, county, and city, you could use a formula like this:

CASE WHEN {taxitem.taxtype} = ‘County’ THEN ({taxitem.rate}/100) END
CASE WHEN {taxitem.taxtype} = ‘State’ THEN ({taxitem.rate}/100) END
CASE WHEN {taxitem.taxtype} = ‘City’ THEN ({taxitem.rate}/100) END

These formulas check the tax type and calculate the tax rate accordingly. Remember to replace the field names and tax rates with the ones you are using in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******