AK47
02/11/2025, 2:19 PMCeligo AI
02/11/2025, 2:19 PMAI generated answer (using internal Slack threads):To return the tax rate in a saved search, you can follow these steps: 1. In your saved search, select the field "Formula (Currency)". 2. In the "Formula" field of that line, enter
{salesorder.taxrate}
or {salesorder.taxrate1}
.
However, if you encounter an error like "Field Not Found", it might be due to the fact that the tax rate is not directly accessible in a saved search.
In this case, you can try to derive the tax rate from the tax amount versus the line item amount. You can also use the tax item and then join for the rate.
If you are using the Avalara AvaTax integration, the tax rate is calculated externally in the Avalara platform and it's per item per location, per shipping address. It's stored externally only through an API call.
Please note that the tax rate could change depending on the tax jurisdiction. If you only have one tax rate, you could hard code a function in the saved search.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
02/11/2025, 2:19 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832008898
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.82814312
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821701348
Celigo AI
02/11/2025, 2:20 PM