Hi all, I am trying to build a saved search, and I want all the amounts in (Foreign Currency), but only the total amount exists. How can you get the Net Amount for example in Foreign Currency? Should I use a formula and multiply by the Exchange Rate?

you want to understand Consolidated Exchange Rate Types for Transaction Searches before attempting that

Thanks 🙏

Same boat here, I need the Tax amount as it appears in the transaction itself. So far I used Consolidated Exchange Rate > None, and then a formula to get the Tax Amount in the currency of the transaction. I don't like the approach.

If you remove criteria Main line - Yes , then you get line amounts as well.