Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
duplicate entry in Bank Account Payments Matching
04-12-2020, 09:13 PM, (This post was last modified: 04-12-2020, 09:48 PM by mjel@mjel.com.)
#3
RE: duplicate entry in Bank Account Payments Matching
Hello Tim,

Indeed there is a duplicate entry in the bank trans.

That is odd that the GL entry shows it only once - and the bank account inquiry shows only one - but the bank trans table has it twice
I would expect that an entry in the banktrans table should show in the Account Inquiry??

Bank Account Inquiry - https://snipboard.io/qLdviC.jpg
HST Recoverable Account Inquiry - https://snipboard.io/ieaBA8.jpg
Communication Expense Account Inquiry - https://snipboard.io/B9PJrX.jpg
---
there are the three accounts that comprise this bank payment - there is only one entry in the account -

gltrans from that date - only shows one entry - https://snipboard.io/mweCkX.jpg

DUPLICATE bank payment (same transno) - banktrans table in DB - https://snipboard.io/L8v0Ta.jpg

DUPLICATE bank payment - Matched payments - https://snipboard.io/Qd7xwh.jpg

General Ledger transaction Enquiry - https://snipboard.io/6ICA1a.jpg

Check Listing (shows the payment entry twice) - https://snipboard.io/vxiyDb.jpg

--
Thanks very much in advance for your support.

Hello Tim,

Further to my reply to your message, I have a dev instance setup and did a bit of testing - when i created a 'Bank Account Payments Entry' - if I only enter a single 'General Ledger Payment Analysis Entry' - there was no duplicate banktrans -- but when I enter two (1. the expense account, 2. the HST Recoverable account) - then there is a duplicate bank trans entry -- seems like that is where the error happens.

see my screen video showing the issue reproduced - https://drive.google.com/file/d/1lpMP9Ul...sp=sharing
Reply


Messages In This Thread
RE: duplicate entry in Bank Account Payments Matching - by mjel@mjel.com - 04-12-2020, 09:13 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)