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

code,Vendor Code

sname,Vendor Name,

invoice,Reference,

stname,Cost Center,

sku,Inventory Code

name,Product Name,

units,UOM

pqty,QTY,align:right,

price,Price,align:right,

gross,Amount,total:sum;number:yes;align:right,

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

vat,Tax Type

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



      `purchases`.`id`

    , `purchases`.`date`

    , `suppliers`.`code`

    , `suppliers`.`name` AS sname

    , `purchases`.`invoice`

    , `purchases`.`vat` AS rate

    , `purchases`.`discount`

    , `purchases`.`org_qty` AS pqty

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

    , ROUND((`purchases`.`org_qty`*price),2)AS `gross`

    ,  `purchases`.`org_qty`*`purchases`.`discount` AS discount

    , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`

    , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat

    , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive

    , `stockitems`.`units`

    , `stockitems`.`sku`

    , `stockitems`.`name`

    , `stockitems`.`type`

    , `stockitems`.`vat`

    , `stocktypes`.`name` AS stname



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 = 0

AND purchases.f_status < 101

AND othertype = 0

AND`stockitems`.`units` >= 1

AND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';',
          'description' => 'COS All Invoices',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'sname',
          'id' => '95',
          'title' => 'COS INVOICES FOR PERIOD',
          'category' => 'Tests',
          'code' => 'S01'
        };