commit c7ceb37b63bc34d954024045bc9738b8c5522941
author Deepesh Garg <42651287+deepeshgarg007@users.noreply.github.com> Tue Sep 14 10:05:36 2021 +0530
committer GitHub <noreply@github.com> Tue Sep 14 10:05:36 2021 +0530
tree 42f96d84e81a10a760054d7bd2bcf7e243829d3d
parent a5baf909b7b9defd046b23e11d2c0c3a32737e2c
parent 44139fbac5ed73fa2be82fb8ae029c3bdb6023ad

Merge pull request #27465 from nextchamp-saqib/so-analytics-report-fix

fix: cancelled sales invoices are considered in billed qty calculation

erpnext/selling/report/sales_order_analysis/sales_order_analysis.py

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')