| commit | e28e6726f17954ba292a57e0c90d4b28a143f5e9 | [log] [tgz] |
|---|---|---|
| author | ruthra kumar <ruthra@erpnext.com> | Thu Apr 14 18:34:47 2022 +0530 |
| committer | ruthra kumar <ruthra@erpnext.com> | Thu Apr 14 18:37:46 2022 +0530 |
| tree | a675d908fda7dfb319ea32111ce6ce08812ba16a | |
| parent | b12fe0f15bcc5d71c16d5bebc4d494518b6220b4 [diff] |
fix: SO analysis rpt will fetch SO's without Delivery note as well
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 a410513..dcfb10a 100644 --- a/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py +++ b/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py
@@ -81,7 +81,7 @@ ON sii.so_detail = soi.name and sii.docstatus = 1) LEFT JOIN `tabDelivery Note Item` dni on dni.so_detail = soi.name - RIGHT JOIN `tabDelivery Note` dn + LEFT JOIN `tabDelivery Note` dn on dni.parent = dn.name and dn.docstatus = 1 WHERE soi.parent = so.name