Creating a report with opening and closing balances plus debits and credits


  • I'm trying to produce a report that shows opening balances, debits, credits and closing balance for each account.

    The opening balances are stored in the table under the period "0" and closing balances are stored under the period "99"

    Now I'm struggling to find a way to get the report to show all accounts including ones with no balance, then getting it to place the rows with a value of "0" and "99" in the correct columns while also displaying the debits and credits as if I filter by period No. then I can only get it to show either the credits debits or the opening or closing balances.

    So basically I need to filter by coloumn which I can't figure out.

    Any help would be much appreciated.

    Monday, March 25, 2013 5:01 PM


All replies