Bank reconciliation calculates the allocated amount incorrectly if the same bank account is in multiple entries in the same Journal Entry

[IMS94]

Information about bug

We have a scenario where several journal entries had been created with the same bank account being used in multiple entries in the same journal entry. When reconciling a bank transaction against this journal entry, the allocated amount in the bank transaction for this journal entry is calculated incorrectly.

For example, we have the following journal entry:

We select $3.38 as the allocated amount for the journal entry.

But it has allocated $3.27 ultimately against the journal entry in the bank transaction

I looked at this from the code level, and we haven't considered this scenario in the code:

erpnext/erpnext/accounts/doctype/bank_transaction/bank_transaction.py

Line 180 in 5ae2965

def get_clearance_details(transaction, payment_entry):

Module

accounts

Version

Frappe version - 14
ERPNext version - 14.66.1

Installation method

FrappeCloud

Relevant log output / Stack trace / Full Error Message.

No response