Fixed regression in Sales Invoice.
authorJanusz Dobrowolski <janusz@frontaccounting.eu>
Mon, 16 Nov 2015 17:43:25 +0000 (18:43 +0100)
committerJanusz Dobrowolski <janusz@frontaccounting.eu>
Mon, 16 Nov 2015 17:43:25 +0000 (18:43 +0100)
sales/includes/db/sales_order_db.inc

index 95f2ead3b740f030f28a842e492c709317ac33eb..05dbe246550d2b0d0d04b86f0ae0b1183f43594d 100644 (file)
@@ -288,7 +288,7 @@ function get_sales_order_details($order_no, $trans_type) {
                                item.material_cost + item.labour_cost + item.overhead_cost AS standard_cost
                        FROM ".TB_PREF."sales_order_details line,"
                                .TB_PREF."stock_master item
-                       WHERE line.stk_code = line.stock_id
+                       WHERE line.stk_code = item.stock_id
                                AND order_no =".db_escape($order_no) 
                                ." AND trans_type = ".db_escape($trans_type) . " ORDER BY id";