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

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

diff --git a/reporting/rep302.php b/reporting/rep302.php
index fc600e965739f212f06a5e1522d8cedccdf3a3aa..f2297d8915b0333a111f3d50e0f6711d304e765f 100644 (file)
--- a/reporting/rep302.php
+++ b/reporting/rep302.php
@@ -87,7 +87,7 @@ function getCustAsmQty($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)