0002177: Currency problem in Item Sales Summary Report
authorJoe <unknown>
Mon, 16 Sep 2013 21:27:52 +0000 (23:27 +0200)
committerJoe <unknown>
Mon, 16 Sep 2013 21:27:52 +0000 (23:27 +0200)
reporting/rep309.php

index 4c8f449e3f30f39ca832a09b7fdddc195e2ab077..1bb9ba06a7df49c8abd83794b3da93cd48c800a0 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,