Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
duplicate entry in Bank Account Payments Matching
04-12-2020, 07:37 PM,
#1
duplicate entry in Bank Account Payments Matching
We are finding that there are duplicate entries in the Bank Account Payments Matching and Receipts Matching.

This appears to only happen when a 'Bank Account Payments Entry' is entered -

the user selects the Bank Account, date, etc. - and then select an account and amount in the General Ledger Payment Analysis Entry.

When troubleshooting this issue - there are clearly no duplicate entries in the General Ledger - only one entry in the bank account and one entry in the expense account - but definitely there are two entries in the Payment Matching screen - and if one just matches the duplicate (two entries) -there is no impact on the reconcilation - just a very confusing entry for the user matching the payments.

Has anyone see this before.?

Reply
04-12-2020, 07:47 PM,
#2
RE: duplicate entry in Bank Account Payments Matching
Are there duplicate entries in the banktrans table?

Tim
Reply
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
04-20-2020, 10:31 PM,
#4
RE: duplicate entry in Bank Account Payments Matching
Hi, sorry about the very late reply. I tried and failed to replicate your problem, and then personal issues came up and I am only just back to work. Is the problem solved, or are you still having the issue?

Tim
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)