| commit | 39c0add5a205d584910d7dd08d091ac09df9bb27 | [log] [tgz] |
|---|---|---|
| author | Zarrar <zarrar65@gmail.com> | Wed May 30 11:56:58 2018 +0530 |
| committer | Rushabh Mehta <rmehta@gmail.com> | Wed May 30 11:56:58 2018 +0530 |
| tree | 5353cae3b19528c04e9ac01cada772f9581c2bb0 | |
| parent | 58200182b4013b58669099943e47cec54cdb0291 [diff] |
query fix sales-person-target-variance-item-group-wise (#14271)
diff --git a/erpnext/selling/report/sales_person_target_variance_item_group_wise/sales_person_target_variance_item_group_wise.py b/erpnext/selling/report/sales_person_target_variance_item_group_wise/sales_person_target_variance_item_group_wise.py index e7bb5b4..fd5bc4e 100644 --- a/erpnext/selling/report/sales_person_target_variance_item_group_wise/sales_person_target_variance_item_group_wise.py +++ b/erpnext/selling/report/sales_person_target_variance_item_group_wise/sales_person_target_variance_item_group_wise.py
@@ -98,7 +98,7 @@ END as qty, CASE WHEN so.status = "Closed" THEN sum(soi.delivered_qty * soi.conversion_factor * soi.base_net_rate * (st.allocated_percentage/100)) - ELSE soi.base_net_amount * (st.allocated_percentage/100)) + ELSE sum(soi.base_net_amount * (st.allocated_percentage/100)) END as amount from `tabSales Order Item` soi, `tabSales Order` so, `tabSales Team` st