$VAR1 = {
          'columnsettings' => 'db_profile_name,Shop,

shop_id, Shop ID,

stname,Cost Center,

date,Invoice Date,

sname,Supplier Name,

invoice,Invoice Nr,

name,Product Name,

pqty,QTY,align:right,

price,Price,align:right,

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

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

amount,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`

    , `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`*.14,2) AS vat

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

    , `stockitems`.`name`

    , `stockitems`.`type`

    , `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 purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';























 















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

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