[fix] fix planned qty
diff --git a/erpnext/patches/v6_0/fix_planned_qty.py b/erpnext/patches/v6_0/fix_planned_qty.py
index b523350..e8ed1d0 100644
--- a/erpnext/patches/v6_0/fix_planned_qty.py
+++ b/erpnext/patches/v6_0/fix_planned_qty.py
@@ -6,8 +6,9 @@
from erpnext.stock.stock_balance import get_planned_qty, update_bin_qty
def execute():
- for item_code, warehouse in frappe.db.sql("""select distinct production_item, fg_warehouse
+ for item_code, warehouse in frappe.db.sql("""select distinct production_item, fg_warehouse
from `tabProduction Order`"""):
- update_bin_qty(item_code, warehouse, {
- "planned_qty": get_planned_qty(item_code, warehouse)
- })
\ No newline at end of file
+ if frappe.db.exists("Item", item_code) and frappe.db.exists("Warehouse", warehouse):
+ update_bin_qty(item_code, warehouse, {
+ "planned_qty": get_planned_qty(item_code, warehouse)
+ })