The Bank Entries Journal Header table doesn’t store the GL account of the Bank account that the transaction actually posted to. The posting journal (BK1477) prints the GL account that the Bank account is currently assigned to.


To reproduce: Find existing bank entry, print the Bank Entries Posting Journal. Note the GL accounts on the Posting Journal. Go to the Banks screen and select one of the banks from the report. Under the Account tab, change the Bank Account that the Bank posts to and save the change. Reprint the Posting Journal and you’ll see that the account now reflects the current Bank account setup and not what was sent to the GL when the transaction was originally posted.


Solution: Add GLACCOUNT field to BKJENTH to hold the Bank’s Bank Account at the time that the transaction is posted.


Not tested in 2018 but the BKJENTH table in 2018 doesn’t have any placeholder for the Bank’s Bank Account and so I assume that the issue remains.

Suggestion added: 2018-04-26

by: Django D. | over a year ago | General Enhancements