Additional changes for delivery notes implementation

[fa-stable.git] / inventory / inquiry / stock_status.php

diff --git a/inventory/inquiry/stock_status.php b/inventory/inquiry/stock_status.php
index 9b16d753396a44c634f5771061adcbce1292540a..e9ffcf60f7b367338a9585aca92aebe10f0356d0 100644 (file)
--- a/inventory/inquiry/stock_status.php
+++ b/inventory/inquiry/stock_status.php
@@ -66,11 +66,11 @@ while ($myrow = db_fetch($loc_details))
 
        alt_table_row_color($k);
 
-       $sql = "SELECT Sum(".TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_invoiced) AS DEM
+       $sql = "SELECT Sum(".TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent) AS DEM
                FROM ".TB_PREF."sales_order_details, ".TB_PREF."sales_orders
                WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no
                AND ".TB_PREF."sales_orders.from_stk_loc='" . $myrow["loc_code"] . "'
-               AND ".TB_PREF."sales_order_details.qty_invoiced < ".TB_PREF."sales_order_details.quantity
+               AND ".TB_PREF."sales_order_details.qty_sent < ".TB_PREF."sales_order_details.quantity
                AND ".TB_PREF."sales_order_details.stk_code='" . $_POST['stock_id'] . "'";
 
        $demand_result = db_query($sql,"Could not retreive demand for item");