Wrong entries when using the refactored Payment Reconciliation tool and Payment Entry using Payment Ledger entry

[centaur78]

Information about bug

While using the Payment reconciliation tool, when pulling the unreconciled entries..... the value shown in the outstanding column is the value in company currency which are in OMR ... whereas the purchase invoice are in Euro

for example the below image ,,if we take the PINV19-00001 ...Actual Invoiced amount is € 256.00 and the value in company currency is RO 107.52..... This is wrongly pulled here due to which we cannot reconcile !!!

This same issue is also seen when using Payment Entry as well

could be due to this #31136 and related PR

And Payment ledger entry for the same

Module

accounts

Version

ERPNext: v14.x.x-develop () (develop)
Frappe Framework: v14.x.x-develop () (develop)

Installation method

manual install

Relevant log output / Stack trace / Full Error Message.

No response

[centaur78]

Hi @ruthra-kumar

Could you have a look on this issue ?

[centaur78]

hi @ruthra-kumar

Any update on the above issue ?

Thanks in advance

[ruthra-kumar]

@centaur78 thanks for reporting this.
There are 2 issues here.

1. account_currency column is not populated on payment ledger entry creation due to incorrect column name.
2. Reconciliation tool using outstanding amount in company currency instead of account currency.

Should be fixed by #31499