feat: filter on voucher no
diff --git a/erpnext/accounts/doctype/sales_invoice/sales_invoice.js b/erpnext/accounts/doctype/sales_invoice/sales_invoice.js
index fe931ee..7043818 100644
--- a/erpnext/accounts/doctype/sales_invoice/sales_invoice.js
+++ b/erpnext/accounts/doctype/sales_invoice/sales_invoice.js
@@ -219,6 +219,8 @@
add_filters_group: 0,
date_field: "posting_date",
columns: ["voucher_type", "voucher_no", "allocated_amount"],
+ primary_action_label: "Un-Reconcile",
+ title: "Un-Reconcile Payments",
get_query() {
return query_args;
},
diff --git a/erpnext/accounts/doctype/unreconcile_payments/unreconcile_payments.py b/erpnext/accounts/doctype/unreconcile_payments/unreconcile_payments.py
index ed978cb..dfd2d29 100644
--- a/erpnext/accounts/doctype/unreconcile_payments/unreconcile_payments.py
+++ b/erpnext/accounts/doctype/unreconcile_payments/unreconcile_payments.py
@@ -4,6 +4,7 @@
import frappe
from frappe import qb
from frappe.model.document import Document
+from frappe.query_builder import Criterion
from frappe.query_builder.functions import Abs, Sum
from erpnext.accounts.utils import unlink_ref_doc_from_payment_entries, update_voucher_outstanding
@@ -78,6 +79,11 @@
_dn = filters.get("docname")
ple = qb.DocType("Payment Ledger Entry")
if _dt in ["Sales Invoice", "Purchase Invoice"]:
+ criteria = [(ple.delinked == 0), (ple.against_voucher_no == _dn), (ple.amount < 0)]
+
+ if txt:
+ criteria.append(ple.voucher_no.like(f"%{txt}%"))
+
res = (
qb.from_(ple)
.select(
@@ -85,7 +91,7 @@
ple.voucher_no,
Abs(Sum(ple.amount_in_account_currency)).as_("allocated_amount"),
)
- .where((ple.delinked == 0) & (ple.against_voucher_no == _dn) & (ple.amount < 0))
+ .where(Criterion.all(criteria))
.groupby(ple.against_voucher_no)
.run(as_dict=True)
)