category.description AS cat_description,
item.stock_id,
item.description,
- line.unit_price,
- SUM(line.quantity) as quantity
+ line.unit_price * trans.rate AS unit_price,
+ SUM(IF(line.debtor_trans_type = ".ST_CUSTCREDIT.", -line.quantity, line.quantity)) AS quantity
FROM ".TB_PREF."stock_master item,
".TB_PREF."stock_category category,
".TB_PREF."debtor_trans trans,
AND trans.tran_date>='$from'
AND trans.tran_date<='$to'
AND line.quantity<>0
- AND line.debtor_trans_type = ".ST_SALESINVOICE;
+ AND item.mb_flag <>'F'
+ AND (line.debtor_trans_type = ".ST_SALESINVOICE." OR line.debtor_trans_type = ".ST_CUSTCREDIT.")";
if ($category != 0)
$sql .= " AND item.category_id = ".db_escape($category);
$sql .= " GROUP BY item.category_id,
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);
$res = getTransactions($category, $from, $to);
$total = $grandtotal = 0.0;
- $total1 = $grandtotal1 = 0.0;
- $total2 = $grandtotal2 = 0.0;
$catt = '';
while ($trans=db_fetch($res))
{
$rep->Line($rep->row - 2);
$rep->NewLine();
$rep->NewLine();
- $total = $total1 = $total2 = 0.0;
+ $total = 0.0;
}
$rep->TextCol(0, 1, $trans['category_id']);
$rep->TextCol(1, 7, $trans['cat_description']);
$rep->End();
}
-?>
\ No newline at end of file