| commit | e82609315054d220e72effa2d1a6d649af205aa9 | [log] [tgz] |
|---|---|---|
| author | ruthra kumar <ruthra@erpnext.com> | Fri May 13 14:08:22 2022 +0530 |
| committer | ruthra kumar <ruthra@erpnext.com> | Fri May 13 14:24:06 2022 +0530 |
| tree | d83612091216e905fc22e6b9535719e1b9058752 | |
| parent | ebbe27c183370bc64c857e19de2340fb45fa4392 [diff] |
fix: multiple entries for same payment term
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"),