Hi, please comment if you have any ideas.
I have two tables pertaining to our general ledger for accounting data.
The first table contains our actual transaction data, which includes a list of account numbers and actual transaction amounts associated with those accounts.
The second table contains the same list of account numbers and budget amounts associated with those accounts.
I have created a report which combines data from both tables to compare budget to actual results. The tables are linked by account number.
When I start by adding account number to the report, I get the full chart of accounts.
When I then add either budget or actual amounts, I get a full list of either actual or budget amounts.
However, when I try adding both budget and actual amounts, the report drops any budget amounts that do not also have actual activity for that account.
I have been unable to resolve this, and will appreciate any feedback or suggestions.
Thanks,
Paul
IP Logged
