Added two new helpers date_comp, sql_date_comp.
[fa-stable.git] / reporting / rep309.php
index bf6aebd4549b422145b418645ecd13cd811bef6e..a306a4330fab62e4a630f95fbf31b7a97d04c2c9 100644 (file)
@@ -37,7 +37,7 @@ function getTransactions($category, $from, $to)
                        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,
@@ -103,7 +103,7 @@ function print_inventory_sales()
                                    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);
 
@@ -163,4 +163,3 @@ function print_inventory_sales()
     $rep->End();
 }
 
-?>
\ No newline at end of file