hi guys, how do I go about adding a field in an invoice saved search that shows the USD-converted amount from the base currency? Is there like a formula that takes the base currency and converts it to USD based on the exchange rate of the transaction date?

@DX 1. What is the transaction currency; 2. What is the subsidiary currency 3. Are there parents above the subsidiary that are USD?

its a saved search that shows all invoices with different subsidiaries and transaction currency and yes, there are subsidiaries that are USD. what I did was create a new field that calculates the USD field and source this field in the saved search