| commit | 44139fbac5ed73fa2be82fb8ae029c3bdb6023ad | [log] [tgz] |
|---|---|---|
| author | Saqib Ansari <nextchamp.saqib@gmail.com> | Mon Sep 13 16:50:11 2021 +0530 |
| committer | Saqib Ansari <nextchamp.saqib@gmail.com> | Mon Sep 13 16:50:11 2021 +0530 |
| tree | 9ec2647efd0ff08b13a3941da8295cf4e4399c73 | |
| parent | 7292f5476d7f0c3a9a5d78da7ad664dcc1f7d51a [diff] |
fix: cancelled sales invoices are considered in billed quantity calculation
diff --git a/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py b/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py index 805c3d8..5c4d8b6 100644 --- a/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py +++ b/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py
@@ -73,7 +73,7 @@ `tabSales Order` so, `tabSales Order Item` soi LEFT JOIN `tabSales Invoice Item` sii - ON sii.so_detail = soi.name + ON sii.so_detail = soi.name and sii.docstatus = 1 WHERE soi.parent = so.name and so.status not in ('Stopped', 'Closed', 'On Hold')