$VAR1 = {
          'columnsettings' => 'shop,Shop Id,

name,Supplier,

invoice,Invoice Number,

date,Inv.Date,

credit,Amount,

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

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

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

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

   `suppliers`.`shop_id` AS shop

    , `suppliers`.`name` AS name

    , `branch_documents`.`invoice_date` AS date

    , `branch_documents`.`supplier_invoice` AS invoice

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

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

    , ROUND(`accounts`.`credit`,2) AS credit



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

FROM

    `branch_documents`

    INNER JOIN `suppliers` 

        ON (`branch_documents`.`branch_id` = `suppliers`.`id`)

    INNER JOIN `accounts` 

        ON (`branch_documents`.`supplier_invoice` = `accounts`.`document`)



WHERE discount > 0 

AND credit > 0

AND invoice_date >= \'[sdate]\' AND invoice_date <= \'[edate]\';

',
          'description' => 'Invoice Discount Report per Supplier',
          'settings' => 'sdate,date,Start Date

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