Merge pull request #3914 from nabinhait/patchfix
[fix][patch] Repost reserved qty for stock item
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