def repost_item_projected_qty(): for data in frappe.db.sql(""" select `tabBin`.item_code as item_code, sum(`tabBin`.projected_qty) as projected_qty, `tabItem`.total_projected_qty as total_projected_qty from `tabBin`, `tabItem` where `tabBin`.item_code = `tabItem`.name group by `tabBin`.item_code having projected_qty <> total_projected_qty """, as_dict=1): update_item_projected_qty(data.item_code)
def repost_item_projected_qty(): for data in frappe.db.sql(""" select `tabBin`.item_code as item_code, sum(`tabBin`.projected_qty) as projected_qty, `tabItem`.total_projected_qty as total_projected_qty from `tabBin`, `tabItem` where `tabBin`.item_code = `tabItem`.name group by `tabBin`.item_code having projected_qty <> total_projected_qty """, as_dict=1): update_item_projected_qty(data.item_code)
def execute(): frappe.reload_doctype("Item") from erpnext.stock.doctype.bin.bin import update_item_projected_qty for item in frappe.get_all("Item", filters={"is_stock_item": 1}): update_item_projected_qty(item.name)
def execute(): frappe.reload_doctype("Item") from erpnext.stock.doctype.bin.bin import update_item_projected_qty for item in frappe.get_all("Item", filters={"is_stock_item": 1}): update_item_projected_qty(item.name)