$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' };