From 0a6ba584ca896ba3b592c54e2421a6ab75207c42 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 16 Nov 2015 18:43:25 +0100 Subject: [PATCH] Fixed regression in Sales Invoice. --- sales/includes/db/sales_order_db.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sales/includes/db/sales_order_db.inc b/sales/includes/db/sales_order_db.inc index 95f2ead3..05dbe246 100644 --- a/sales/includes/db/sales_order_db.inc +++ b/sales/includes/db/sales_order_db.inc @@ -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"; -- 2.30.2