Hi Adrian
Thanks for your quick reply.
I tried what you suggested but the "foreign amount" field only translates the transactions on the specific date of report and not the closing balance.
I don't know why there is not a field for "foreign Balance" which was in desk top version.
Below is a sample of what I need. On desk top version I was able to pull the columns required but I could only get current balances and was unable to go back and balances at a specified date.
| | | | | 8:51 AM |
| Bank Balances Report | at specified date | | | 22/02/23 |
| All Transactions | | | | |
| | Account name | Currency | Foreign Balance | Balance (EUR) |
| | USD bank account | USD | 108,108.60 | 100,000.00 |
| | STG bank account | GBP | 880.75 | 1,000.00 |
| | Eur bank account | EUR | 100.00 | 100.00 |
| | | | | |
| | Total | | | 101,100.00 |
| | | | | |
| | | | | |
| | | | | |
Any further suggestions would be greatly appreciated.
Fiona
