Hi guys,
I need to create either a report or a saved search which shows accumulated amounts for a specific period for all the accounts in the subsidiary. Where the account is the row and the subsidiary, period, amount etc. are the columns. Too add some complexity I need the amount column to show all transactions in the home currency of that specific subsidiary and not the actual transaction currency.
Any idea?