$VAR1 = {
          'columnsettings' => 'date,CASHUP DATE

note,ACCOUNT TYPE

name,ACCOUNT NAME

code,ACCOUNT CODE

tillinvoice_id,INVOICE ID

document,DOCUMENT REFERENCE

description,DOCUMENT DESCRIPTION

credit,CASH DEPOSITS/ (CASH WITHDRAWALS),align:right;total:sum;',
          'selector' => '2',
          'data' => '(SELECT



    tillclients.name,



    tillclients.code,

    tillclients.note,



    tillclients.shop_id,



    accounts.date,



    accounts.tillinvoice_id,



    accounts.document,



    accounts.description,



    ROUND (accounts.credit,2) AS credit



FROM



    accounts,



    tillclients



WHERE



    accounts.account = 1 AND



    accounts.transaction_type = \'Cash\' AND



    accounts.credit > 0 AND



    (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND



    tillclients.id = accounts.entityid



ORDER BY accounts.account)



UNION ALL



(SELECT



    suppliers.name,



    suppliers.code,

    suppliers.notes AS note,

    suppliers.shop_id,



    accounts.date,



    accounts.tillinvoice_id,



    accounts.document,



    accounts.description,



    ROUND (accounts.credit,2) AS credit



FROM



    accounts,



    suppliers



WHERE



    accounts.account = 2 AND



    accounts.transaction_type = \'Cash\' AND



    accounts.credit > 0 AND



    (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND



    suppliers.id = accounts.entityid



ORDER BY accounts.account)



UNION ALL



(SELECT



    tillclients.name,



    tillclients.code,

tillclients.note,



    tillclients.shop_id,



    accounts.date,



    accounts.tillinvoice_id,



    accounts.document,



    accounts.description,



    ROUND (accounts.debit * -1,2) AS credit



FROM



    accounts,



    tillclients



WHERE



    accounts.account = 1 AND



    accounts.transaction_type = \'Cash\' AND



    accounts.debit > 0 AND



    (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND



    tillclients.id = accounts.entityid



ORDER BY accounts.account)



UNION ALL



(SELECT



    suppliers.name,



    suppliers.code,

    suppliers.notes AS note,



    suppliers.shop_id,



    accounts.date,



    accounts.tillinvoice_id,



    accounts.document,



    accounts.description,



    ROUND(accounts.debit * -1,2) AS credit



FROM



    accounts,



    suppliers



WHERE



    accounts.account = 2 AND



    accounts.transaction_type = \'Cash\' AND



    accounts.debit > 0 AND



    (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND



    suppliers.id = accounts.entityid



ORDER BY accounts.account);',
          'description' => 'Per Debtors/Creditors',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'note',
          'id' => '59',
          'title' => 'Cash Flow Report',
          'category' => 'OAKDALE - REPORTS',
          'code' => '106'
        };