| commit | 052333ea63fa43fd6e5c9323e1f072ab4602e1d4 | [log] [tgz] |
|---|---|---|
| author | Nabin Hait <nabinhait@gmail.com> | Fri Mar 09 14:30:32 2018 +0530 |
| committer | Nabin Hait <nabinhait@gmail.com> | Fri Mar 09 14:30:32 2018 +0530 |
| tree | a445bdd01f6a77ae14a80eb69f5ef9ac6f4f3bbf | |
| parent | aadd30d1947d768751d981335affa4393d4fc8bd [diff] |
subctracting stock entry should also be considered as consumed qty
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 e1249ea..cc47ad9 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
@@ -51,7 +51,7 @@ sum(se_item.transfer_qty) as 'consume_qty' from `tabStock Entry` se, `tabStock Entry Detail` se_item where se.name = se_item.parent and se.docstatus = 1 - and ifnull(se_item.t_warehouse, '') = '' %s + and (ifnull(se_item.t_warehouse, '') = '' or se.purpose = 'Subcontract') %s group by se_item.item_code""" % (condition), as_dict=1) cn_items_map = {}