fix: v14, Bank Reconcile Tools not cover case JV debit bank (#35000)
diff --git a/erpnext/accounts/doctype/bank_transaction/bank_transaction.py b/erpnext/accounts/doctype/bank_transaction/bank_transaction.py
index fcbaf32..b441af9 100644
--- a/erpnext/accounts/doctype/bank_transaction/bank_transaction.py
+++ b/erpnext/accounts/doctype/bank_transaction/bank_transaction.py
@@ -281,10 +281,13 @@
)
elif payment_entry.payment_document == "Journal Entry":
- return frappe.db.get_value(
- "Journal Entry Account",
- {"parent": payment_entry.payment_entry, "account": gl_bank_account},
- "sum(credit_in_account_currency)",
+ return abs(
+ frappe.db.get_value(
+ "Journal Entry Account",
+ {"parent": payment_entry.payment_entry, "account": gl_bank_account},
+ "sum(debit_in_account_currency-credit_in_account_currency)",
+ )
+ or 0
)
elif payment_entry.payment_document == "Expense Claim":