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

name,Supplier,

date,Inv.Date,

qty,Qty,

price,Price,

gross, Gross Amount,total:sum;

discount,Disc.Rec,total:sum;

amount,Nett Amount,total:sum;

vat,VAT Input,total:sum;

inclusive,Amount(incl),total:sum;

description,Item Detail,

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

    `purchases`.`shop_id` AS id

    , `bufc`.`name` AS category

    , `suppliers`.`name` AS name

    , `purchases`.`description` AS description

    , `purchases`.`date` AS date

    , `purchases`.`invoice` AS invoice

    , `purchases`.`org_qty` AS qty

    , `purchases`.`vat` AS rate

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

    , `purchases`.`discount`

    ,  qty*`purchases`.`discount` AS discount

    , ROUND((qty*price),2) AS `gross`

    , ROUND((qty*price)-(qty*discount),2) AS `amount`

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

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





FROM

    `purchases`

    INNER JOIN `suppliers` 

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

    INNER JOIN `bufc` 

        ON (`purchases`.`othertype` = `bufc`.`id`)

        

WHERE othertype > 0

AND cnote = 0

AND purchases.f_status < 101

AND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';',
          'description' => 'Expenses per Suppliers Report',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'name',
          'id' => '89',
          'title' => '',
          'category' => 'Accounts',
          'code' => 'S03'
        };