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

name,Supplier,

date,Inv.Date,

number,Qty,

price,Price,

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

    , `suppliers`.`name` AS name

    , `purchases`.`date` AS date

    , `purchases`.`invoice` AS invoice

    , ROUND(`purchases`.`discount`,2)

    , `purchases`.`org_qty`*-1 AS number

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

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

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

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

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

    , `purchases`.`description` AS description

    , `bufc`.`name` AS category

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

FROM

    `purchases`

    INNER JOIN `suppliers` 

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

    INNER JOIN `bufc` 

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

        

WHERE othertype > 0

AND cnote = 1

AND purchases.f_status < 101

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

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