This may seem stupid, but I'm having a hell of a time trying to build a Saved Search that shows the Transaction Currency Amount converted into the Subsidiary Currency Amount using the Consolidated Average Exchange Rate (P&L Accounts). I have the Consolidated Exchange Rate set to "Average" in the Results screen of the Saved Search. For transactions where the {Currency} and {Subsidiary.Currency} don't match, I can see a value in the Amount field. The problem is that when I multiply the value in the Amount field by the Consolidated Average Exchange Rate (offline), the calculated amount does not equal the original Amount (Foreign Currency) value of the transaction. I know the Exchange Rate I can query in the Saved Search is the Daily Exchange Rate, so I can't calculate into an Amount using that field. I am a bit at a loss for how to correctly query the Consolidated Average Exchange Rate. Furthermore, when I change the Consolidated Exchange Rate to "None" on the Saves Search, I can see that the Amount then equals the Amount (Foreign Currency), suggesting that the system is performing a lookup. Could there be a bad setup where the results are not using the correct exchange rates? If so, how could I most easily verify this? Any help is appreciated. Thanks