category.description AS cat_description,
item.stock_id,
item.description,
- line.unit_price,
+ line.unit_price * trans.rate AS unit_price,
SUM(line.quantity) as quantity
FROM ".TB_PREF."stock_master item,
".TB_PREF."stock_category category,
1 => array('text' => _('Period'),'from' => $from, 'to' => $to),
2 => array('text' => _('Category'), 'from' => $cat, 'to' => ''));
- $rep = new FrontReport(_('Sales Summary Report, Detailed'), "SalesSummaryDetailedReport", user_pagesize(), 9, $orientation);
+ $rep = new FrontReport(_('Item Sales Summary Report'), "ItemSalesSummaryReport", user_pagesize(), 9, $orientation);
if ($orientation == 'L')
recalculate_cols($cols);