in a saved search formula (currency) field, how can i get the transaction tax amount and the subtotal in the foreign currency?

AI generated answer (using internal Slack threads):

To get the transaction tax amount and the subtotal in the foreign currency in a saved search formula (currency) field, you can follow these steps: 1. For the transaction tax amount in foreign currency: - Set the main line to false in your search criteria. This will allow you to access line-level information. - Use the

Amount (Foreign)

field on the tax line. This field represents the value of the amount in the foreign currency. - You can then use formula fields to create a 'tax column' that represents the tax amount in the foreign currency. 2. For the subtotal in foreign currency: - Use the

Amount (Net of Tax)

field in your saved search. This field represents the amount net of tax. - You can then use a formula to convert this amount to the transaction currency. The formula would be

(amount net of tax internal id)/(exchange rate internal id)

. - If you select 'None' in the 'Consolidation Type' field under the Results tab, all the amounts will be in the foreign currency, so you won't need to convert. Please note that these methods may be subject to rounding errors due to the conversion between currencies. Also, make sure to understand the [Consolidated Exchange Rate Types for Transaction Searches](https://system.netsuite.com/app/help/helpcenter.nl?fid=section_n1409190.html) before attempting these steps. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******