Merge branch 'develop'
diff --git a/erpnext/__version__.py b/erpnext/__version__.py
index 20940dc..bace881 100644
--- a/erpnext/__version__.py
+++ b/erpnext/__version__.py
@@ -1,2 +1,2 @@
from __future__ import unicode_literals
-__version__ = '5.7.1'
+__version__ = '5.7.2'
diff --git a/erpnext/hooks.py b/erpnext/hooks.py
index 9c12a94..160e99b 100644
--- a/erpnext/hooks.py
+++ b/erpnext/hooks.py
@@ -27,7 +27,7 @@
"""
app_icon = "icon-th"
app_color = "#e74c3c"
-app_version = "5.7.1"
+app_version = "5.7.2"
github_link = "https://github.com/frappe/erpnext"
error_report_email = "support@erpnext.com"
diff --git a/erpnext/patches/v4_2/repost_reserved_qty.py b/erpnext/patches/v4_2/repost_reserved_qty.py
index f91968c..a2cd4d8 100644
--- a/erpnext/patches/v4_2/repost_reserved_qty.py
+++ b/erpnext/patches/v4_2/repost_reserved_qty.py
@@ -18,10 +18,18 @@
select distinct item_code, warehouse
from `tabPacked Item` where docstatus=1 and parenttype='Sales Order'
)
- ) items
+ ) so_item
+ where
+ exists(select name from tabItem where name=so_item.item_code and ifnull(is_stock_item, 0)=1)
""")
-
+
for item_code, warehouse in repost_for:
update_bin_qty(item_code, warehouse, {
"reserved_qty": get_reserved_qty(item_code, warehouse)
- })
\ No newline at end of file
+ })
+
+ frappe.db.sql("""delete from tabBin
+ where exists(
+ select name from tabItem where name=tabBin.item_code and ifnull(is_stock_item, 0) = 0
+ )
+ """)
\ No newline at end of file
diff --git a/setup.py b/setup.py
index d857447..326b469 100644
--- a/setup.py
+++ b/setup.py
@@ -1,6 +1,6 @@
from setuptools import setup, find_packages
-version = "5.7.1"
+version = "5.7.2"
with open("requirements.txt", "r") as f:
install_requires = f.readlines()