what is meanign of taxtotal and totalamount search...
# ask-stanley-ai
w
what is meanign of taxtotal and totalamount search fields
c
AI generated answer (using internal Slack threads):
In NetSuite saved searches, the
taxtotal
and
totalamount
fields are used to retrieve specific financial data related to transactions. The
taxtotal
field is used to get the total tax amount of a transaction. This field is useful when you want to exclude the tax amount from the total transaction amount. For example, in a saved search, you can use
{amount} - NVL({shippingamount},0) - NVL({taxtotal},0)
to get the subtotal of a transaction excluding shipping and tax. The
totalamount
field, on the other hand, is used to get the total amount of a transaction. This includes all charges, taxes, and discounts applied to the transaction. This field is often used in criteria or filters in saved searches to limit the transactions based on their total amount. For example, you can use
{totalamount}
in a criteria to only display transactions with total amounts under a certain value. ****** 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.818054318
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.811950743
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.809936523
Please provide your feedback on this answer.