Hi, is there an easy way to produce a report the shows the bank balances in their actual currency rather than base currency? I'd also want a column with the currency. We have accounts in 26+ currencies. Also, would it be possible to set the search criteria and base it on the "restrict by location" field in the account set up. TIA.

amount (foreign currency). This will have the currency symbol if that is sufficient, but you can also pull in the Currency field if you need it in words. Don't think what you're asking for on the account is possible in saved searches if I'm understanding correctly. Might be doable in Suiteanalytics Workbook, but you'd have to go check.

Not sure exactly how it will impact your account. But do check out currency revaluation as well. We are not able to use foreign currency due to some reasons as sometimes even 1-2% fluctuations in currency exchange have a high impact when the transaction volume is in millions. Depending upon your use case you may or may not need it. Just wanted to give you a heads up.