$VAR1 = {
          'columnsettings' => 'shop_id, Shop ID,

stname,Cost Center,

date,Invoice Date,

sname,Supplier Name,

invoice,Invoice Nr,

name,Product Name,

qty,QTY,align:right,

price,Price,align:right,

GROSS,Amount,total:sum;align:right,

discount,Disc.Rec,total:sum;align:right,

org_price,Nett Amount,total:sum;align:right,

vat,Vat Input,total:sum;align:right,

inclusive,Amount(incl),total:sum;align:right,',
          'selector' => '2',
          'data' => 'SELECT

      `purchases`.`shop_id`

    , `purchases`.`date`

    , `suppliers`.`name` AS sname

    , `purchases`.`invoice`

    , ROUND(`purchases`.`discount`)

    , ROUND(`purchases`.`qty`*-1,2) AS qty

    , ROUND(`purchases`.`price`,2) AS price

    , ROUND(`purchases`.`org_price`*-1,2) AS org_price

    , ROUND(`purchases`.`discount`*-1,2) AS discount

    , ROUND((`purchases`.`org_price`+`purchases`.`discount`)*-1,2) AS GROSS

    , ROUND((`purchases`.`org_price`*-1)+(`purchases`.`org_price`*.14*-1*`purchases`.`vat`)-((`purchases`.`discount`*`purchases`.`qty`*-1)+(`purchases`.`discount`*`purchases`.`qty`*.14*-1*`purchases`.`vat`)),2) AS inclusive

    , `stockitems`.`name`

    , `stockitems`.`type`

    , `stocktypes`.`name` AS stname

    , `purchases`.`vat`

    , ROUND(`purchases`.`vat`*((`purchases`.`price`*`purchases`.`qty`)-(`purchases`.`discount`*`purchases`.`qty`))*.14*-1,2) AS vat

FROM

    `purchases`

    INNER JOIN `suppliers` 

        ON (`purchases`.`supplier_id` = `suppliers`.`id`)

    INNER JOIN `stockitems` 

        ON (`purchases`.`stockitems_id` = `stockitems`.`id`)

    INNER JOIN `stocktypes`

        ON (`stocktypes`.`id` = `stockitems`.`type`)

WHERE purchases.type >= 1

AND stockitems.type >= 1

AND cnote = 1

AND purchases.f_status < 101

AND othertype = 0

AND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';























 















',
          'description' => 'COS Credit Notes per Supplier Report',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'sname',
          'id' => '91',
          'title' => '',
          'category' => 'Accounts',
          'code' => 'S02'
        };