I have a customer which has a bank account in CAD and a bank account in USD. They want to be able to manage projected cash flows for these bank accounts separately, using the above-mentioned report. If you run the report in Detail, with no particular selections, it will pick up all payables and receivables expected cash transactions. But if you select on a particular bank account, it picks up only payables expected payments, but no receivables. Digging further, this is because the report considers all receivables expected receipts to have no particular bank account, and classifies those expected receipts as Unassigned. Unfortunately, the user loses the ability to see expected cash flows by bank account or by currency. The only way they can see any effect is to select All, but then there is simply a mixture of apples and oranges -- impossible to manage with a lot of transactions.
Has anyone figured out a better method to manage treasury tasks like this? I suspect that would mean a new report, or a revised report. Would very much like to hear your responses.
Thanks,
Marilyn Connor
ISA Inc.
