Service Items - BOM & Cost Update allowed without side-effects

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

diff --git a/reporting/rep301.php b/reporting/rep301.php
index 56398b710b2c4302c2127c253936bfd073837458..bc8b1085de5b08e3f5d1ca99c4971b2aa951318c 100644 (file)
--- a/reporting/rep301.php
+++ b/reporting/rep301.php
@@ -44,6 +44,7 @@ function getTransactions($category, $location)
                        ".TB_PREF."stock_moves
                WHERE ".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id
                AND ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
+               AND ".TB_PREF."stock_master.mb_flag<>'D'
                GROUP BY ".TB_PREF."stock_master.category_id,
                        ".TB_PREF."stock_category.description, ";
                if ($location != 'all')