$VAR1 = {
          'columnsettings' => 'date,Invoice Date

name,Supplier Name;

debit,Debit,number:yes;align:right;total:sum;

credit,Credit,number:yes;align:right;total:sum;

document,Description',
          'selector' => '2',
          'data' => 'SELECT

    `accounts`.`date`

    , `suppliers`.`name`

    , `accounts`.`debit`

    , `accounts`.`credit`

    , `accounts`.`document`

FROM

    `oakdale_1`.`accounts`

    INNER JOIN `oakdale_1`.`suppliers` 

        ON (`accounts`.`entityid` = `suppliers`.`id`)

        

       WHERE account = 2 

       AND DATE >= \'2018-03-01\' 

       AND transaction_type = \'Cash\'



AND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';',
          'description' => 'Cash Payments',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'name',
          'id' => '80',
          'title' => 'CASH REPORT',
          'category' => 'OAKDALE - REPORTS',
          'code' => '80'
        };