duplicate payment bank transaction found

Try to execute following sql statement in phpmyadmin to check if you really have duplicate records (using right tables prefix,  type and trans_no):

SELECT *, bank_account_name, account_code, bank_curr_code FROM 0_bank_trans, 
0_bank_accounts WHERE 0_bank_accounts.id=0_bank_trans.bank_act AND type='2' AND 
0_bank_trans.trans_no = '5' ORDER BY trans_date, 0_bank_trans.id

If there is more than one record returned you have broken database content or the above original sql is invalid.

Janusz

I think you can delete any of the two bank transaction providing they are not allocated nor reconcilled.
Anyway there should be no duplicate rows, so seems there is a bug somewhere in the code. Do you remember which operations sequence lead to this problem ?
Janusz

Ok. I think I found something. The accountant was doing this: debit the bank account and also credit the bank account in the same voucher, for the same amount. Although the effect to the account is zero, FA does not like this. Obviously it was a mistake on her part, but should not generate a problem with the dabase. Now we can not make corrections because we can not visualize the voucher. I will try and see if I can void the transactions.

I guess we must disallow bank transactions in the rows. This will always cause more than one bank account transactions and give double records.

I will have a look at this.

/Joe

Just to be sure: Please clarify the term "disallow bank transactions in the rows". Will this affect entries where you post deposits by a debit to banks and a credit to cash?

Thank you.

Well, we only have one bank account. That's why I was asking. I hope your solution still applies. Thank you.

Please allow me to clarify the scenario:

This comapny is a restaurant, and has only one bank account. So everyday, at closing time, the cashier prints a Cashier's Report using the restaurant software Aldelo for Reestaurants, cuts-off the credit card POS, counts the cash and bundles everything in a package to give to the accountant.

The following morning, the accountant checks everything and prepares one entry:

Entry # 1

Debit - Cash on Hand $1,000.00
Credit - Sales $1,000.00

And after the money gets deposited to the bank by the manager, he handles the accountant the deposit slip. She now makes another entry:

Entry # 2 (Bank Deposit)

Debit - Bank $1,000.00
Credit - Cash on Hand $1,000.00

In this case, FA behaves as it should and everything is fine.

This is an over simplication of the process. Now, for whatever reason, she made a mistake in the second entry, and did it like this:

Entry # 2 (Bank Deposit)

Debit - Bank $1,000.00
Credit - Bank $1,000.00

Now FA does not seem to like this mistake and, when trying to visualize the entry, gives an error "duplicate payment bank transaction found" when listing Bank Account Inquiry. Granted, the accountant should not make mistakes, but they do.

Maybe someone can try this and see if they get the same problem. It might just be my installation ....

Thank you.