Why don't i see a field in the criterea for "Tax T...
# ask-stanley-ai
a
Why don't i see a field in the criterea for "Tax Total" when making a transaction search?
c
AI generated answer (using internal Slack threads):
The "Tax Total" field is not available as a criteria in the transaction search because it is not a standard field that can be used for filtering in NetSuite's saved search functionality. However, you can use a workaround to achieve a similar result. You can create a formula field in your search criteria that calculates the tax total. This can be done by adding a Formula (Numeric) field in your criteria and using a formula that calculates the tax total based on the tax rate and the gross amount of the transaction. Here is an example of how you can do this: 1. Go to your saved search and click on the Criteria tab. 2. Click on the 'Add' button and select 'Formula (Numeric)' from the dropdown. 3. In the formula field, enter a formula that calculates the tax total. For example, if your tax rate is 10%, you can use the formula
{grossamount} * 0.1
. 4. Set the operator to 'equal to' and the value to the tax total you want to filter by. Please note that this is a workaround and may not work in all scenarios. The tax calculation can be more complex depending on the tax rules applicable to the transactions. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83603096
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834844649
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832409203
Please provide your feedback on this answer.