Transaction search in base currency
Sorry if this has been answered before but I have trawled past posts and can't seem to find an answer.
We have multiple Subsidiaries with a Consolidated currency of USD. I am creating a transaction search for a subsidiary with base currency of GBP. The transactions are all for different currencies (GBP, EUR, USD, CAD etc.).
A transaction search in all the separate currencies is not very useful. I can get the search on the consolidated currency of USD but the local finance team need to see this in GBP. How can I do this? I don't think it is possible using a standard field so what formula can I use to get this?