commit 5f5bbf622af9c869c60e07968771206298c2750a
author Deepesh Garg <42651287+deepeshgarg007@users.noreply.github.com> Thu Jun 24 10:22:07 2021 +0530
committer GitHub <noreply@github.com> Thu Jun 24 10:22:07 2021 +0530
tree d8d4d00f238a348fc6e17d4af9371bb6bf1b1ca4
parent 53fefd751338676d1b33d1bdbfce298cebade785
parent 70823b6d9a5a8e9655fe05f10cf2ac25362c24ef

Merge pull request #26179 from deepeshgarg007/sales_order_billed_qty_develop

fix: Incorrect billed qty in Sales Order analytics

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 f5feb95..8cb2446 100644
--- a/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py
+++ b/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py
@@ -59,7 +59,7 @@
 			IF(so.status in ('Completed','To Bill'), 0, (SELECT delay_days)) as delay,
 			soi.qty, soi.delivered_qty,
 			(soi.qty - soi.delivered_qty) AS pending_qty,
-			IFNULL(sii.qty, 0) as billed_qty,
+			IFNULL(SUM(sii.qty), 0) as billed_qty,
 			soi.base_amount as amount,
 			(soi.delivered_qty * soi.base_rate) as delivered_qty_amount,
 			(soi.billed_amt * IFNULL(so.conversion_rate, 1)) as billed_amount,