I’m confused about the function of the bank_account field in the DocType Bank Clearance.
When I select Account and Bank Account, Payment Entries are dropped. I need to leave the bank_account field empty, else only Journal Entries are displayed.
Does anyone know why? What is the purpose of including the Bank Account if bank entries related to this account are dropped if they come from a Payment Entry.
When bank_account is empty Journal and Payment entries appear:
The Journal Entry is where you can work directly with the GL Accounts. The GL Accounts are hit in both ways either you record a JV or Payment Entry for a payment. The difference comes into play only when you knock accruals based payments by using Payment Entry where you hit GL accounts by choosing respective mode of payment or bank account or both at the same time.
In details, payment Entry offers you to book payments / Receipts with respect to mode of payments as well as bank account tagging hitting respective GL Accounts from chart of accounts ultimately. Since you can have a bank where multiple bank accounts can be maintained with different types and currencies and that is what is captured in payment entry.
On the other hand, Journal Entry doctype is solely available to jump itemized recording mainly serving the purpose of adjustment entries to be recorded by the end of each month to close the period efficiently. The payment, receipts and internal transfer from bank to cash accounts have to be recorded in there by using payment entries and that is how Bank Clearance will reflect clean records without any Confusion, knowing the fact Bank Clearance docytpe only serves the purpose of recording clearance dates of payment made or received.
I don’t understand what you have explained. From my perspective both Journal Entries and Payment Entries have associated Bank Transactions, yet only the Journal Entries are displayed when I add the bank account.
My two questions:
Is this behavior expected?
What’s the reasoning for excluding payment entries when they have associated bank transactions to be cleared?
This happens because ERPNext stores bank accounts differently in both doctypes:
Journal Entries link the bank account directly in the accounts table, so they appear when filtered.
Payment Entries store the bank account in the “Paid From” or “Paid To” fields, so the filter doesn’t recognize them.
How to Fix It?
Leave the Bank Account filter blank – This shows all entries, including Payment Entries.
Use a Custom Report – create Query report to check both the accounts table (for Journal Entries) and the “Paid From/To” fields (for Payment Entries).
Use GL Entries – The General Ledger table tracks all transactions by account. Filtering here will include all entries linked to the bank account.
In short, Payment Entries disappear because ERPNext looks for bank accounts in different places. To see them, adjust your filtering method or customize the report.
I just checked on my system and it picks up payment entries fine when the bank account is selected. There might be something specific to how you’ve got things configured, but unfortunately I don’t have a very nuanced understanding of how this report works to say much more.
Thanks for checking @peterg. Can you confirm that pressing the “Get Payment Entries” button after selecting the bank account doesn’t change the list of transactions?
Thank you for clarifying @peterg. I moved the site to a new server which required me to run bench migrate. It seems this fixed the symptom. Selecting the bank account does not cause dropping of Payment Entry records.
