Added non closed work order requirements on On Order in Inventory Items Status

[fa-stable.git] / reporting / rep303.php

diff --git a/reporting/rep303.php b/reporting/rep303.php
index f50361e5e4251b651b361628976fe848cd25068c..ffeb9b8195c091966e85aa3fd7c82ba67f117d74 100644 (file)
--- a/reporting/rep303.php
+++ b/reporting/rep303.php
@@ -86,7 +86,7 @@ function getDemandAsmQty($stockid, $location)
        $sql .= TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent > 0 AND
                                   ".TB_PREF."bom.component='$stockid' AND
                                   ".TB_PREF."stock_master.stock_id=".TB_PREF."bom.parent AND
-                                  ".TB_PREF."stock_master.mb_flag='A'";
+                                  (".TB_PREF."stock_master.mb_flag='M' OR ".TB_PREF."stock_master.mb_flag='A')";
 
     $TransResult = db_query($sql,"No transactions were returned");
        if (db_num_rows($TransResult)==1)