From e13220712d819bef3cfd7e77e5d537e12cf181db Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Tue, 1 May 2007 07:44:30 +0000 Subject: [PATCH] Missing measure of units when printing sales orders --- CHANGELOG.txt | 2 ++ reporting/rep109.php | 2 +- 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 311cefa..d641d38 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -20,8 +20,10 @@ Legend: $ -> Affected files 01-May-2007 Joe Hunt + # Missing measure of units when printing sales orders # Update of Sales People caused a database error $ /sales/manage/sales_people.php + /reporting/rep109.php 30-Apr-2007 Joe Hunt + The selected menu tab is now shown with same background as hover color. diff --git a/reporting/rep109.php b/reporting/rep109.php index 5ce04c3..087c9f5 100644 --- a/reporting/rep109.php +++ b/reporting/rep109.php @@ -25,7 +25,7 @@ function get_sales_order_details($order_no) { $sql = "SELECT stk_code, unit_price, ".TB_PREF."sales_order_details.description, ".TB_PREF."sales_order_details.quantity, discount_percent, - qty_invoiced, + qty_invoiced, units, ".TB_PREF."stock_master.material_cost + ".TB_PREF."stock_master.labour_cost + ".TB_PREF."stock_master.overhead_cost AS standard_cost FROM ".TB_PREF."sales_order_details, ".TB_PREF."stock_master WHERE ".TB_PREF."sales_order_details.stk_code = ".TB_PREF."stock_master.stock_id -- 2.30.2