| commit | 304aa44feb104dbf171facb64151c16b17734289 | [log] [tgz] |
|---|---|---|
| author | aaronmenezes <ron2805@gmail.com> | Tue Dec 14 15:18:03 2021 +0530 |
| committer | GitHub <noreply@github.com> | Tue Dec 14 15:18:03 2021 +0530 |
| tree | 771e1e5880326782be9f05163a9157f4e0c2c867 | |
| parent | b027050f77f14d43e4acf82da1cb99b8b00bb8dd [diff] |
fix: Nonstock item showing in Itemwise Recommended Reorder Level report (#28873)
diff --git a/erpnext/stock/report/itemwise_recommended_reorder_level/itemwise_recommended_reorder_level.py b/erpnext/stock/report/itemwise_recommended_reorder_level/itemwise_recommended_reorder_level.py index 314f160..3f49065 100644 --- a/erpnext/stock/report/itemwise_recommended_reorder_level/itemwise_recommended_reorder_level.py +++ b/erpnext/stock/report/itemwise_recommended_reorder_level/itemwise_recommended_reorder_level.py
@@ -48,6 +48,7 @@ conditions = [get_item_group_condition(filters.get("item_group"))] if filters.get("brand"): conditions.append("item.brand=%(brand)s") + conditions.append("is_stock_item = 1") return frappe.db.sql("""select name, item_name, description, brand, item_group, safety_stock, lead_time_days from `tabItem` item where {}"""