Vishal Chaudhari
06/02/2025, 12:48 PMCeligo AI
06/02/2025, 12:48 PMAI generated answer (using internal Slack threads):Based on the conversations, it seems that you can't directly retrieve the tax rate from a line item in a sales order using a saved search. The tax rate is not directly associated with the line item but is calculated based on the tax item associated with the sales order. However, you can derive the tax rate from the tax amount and the line item amount. You can also use the tax item and then join for the rate. Here is a sample formula that was mentioned in the conversations:
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. Otherwise, it uses the tax amount.
Please note that this formula might not work for your specific case, as it depends on your tax setup and the SuiteScript version you are using.
******
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
06/02/2025, 12:48 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.852236152
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838734448
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838343799
Celigo AI
06/02/2025, 12:48 PM