| commit | 5edd1dbb35dc6651444edbf6179ba21be38fece3 | [log] [tgz] |
|---|---|---|
| author | Deepesh Garg <deepeshgarg6@gmail.com> | Fri May 20 07:53:40 2022 +0530 |
| committer | GitHub <noreply@github.com> | Fri May 20 07:53:40 2022 +0530 |
| tree | 1608ffaa4d5a7e0dbee94cbc4560a15f26da7c9e | |
| parent | 6d6616dbcdfec4171022bac9c0538c04a1fa5cd5 [diff] | |
| parent | e82609315054d220e72effa2d1a6d649af205aa9 [diff] |
Merge pull request #31004 from ruthra-kumar/bug_payment_terms_status_rpt fix: duplicate entries in payment terms report output
diff --git a/erpnext/selling/report/payment_terms_status_for_sales_order/payment_terms_status_for_sales_order.py b/erpnext/selling/report/payment_terms_status_for_sales_order/payment_terms_status_for_sales_order.py index cb22fb6..91f4a5e 100644 --- a/erpnext/selling/report/payment_terms_status_for_sales_order/payment_terms_status_for_sales_order.py +++ b/erpnext/selling/report/payment_terms_status_for_sales_order/payment_terms_status_for_sales_order.py
@@ -187,8 +187,9 @@ .on(soi.parent == so.name) .join(ps) .on(ps.parent == so.name) + .select(so.name) + .distinct() .select( - so.name, so.customer, so.transaction_date.as_("submitted"), ifelse(datediff(ps.due_date, functions.CurDate()) < 0, "Overdue", "Unpaid").as_("status"),