I operate a small restaurant which opened in August, 2009. The accountant has really mess up the numbers and I am getting rid of her. A new accountant should start next week, and I figured it would be easier to start from scratch, except for the chart of accounts. Which tables should I truncate to be able to post transactions as if I was starting from zero? Thank you for your assistance.

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.

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

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.

Ok. I can void the transaction but I still can not see the voucher. I get the same error. Thank you.

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.

There are many more, and all are bank deposits. Since I don't do the posting (an accountant does) I could not say what happened. But it's strange that only deposit transactions are affected. ID for each row are consecutive numbers. Please advise. Thank you.

Ok. I get two identical rows (except for ID) when using the transaction number that gives me problems. Is it safe to remove one of them using phpMyAdmin, or is there a utility in FrontAccounting to fix this? Thank you.

I was trying to view a specific entry in Bank Account Inquiry, but I get this error. I checked the gl_trans table and the bank_trans table and they seem to be Ok. How to solve this? Thank you.

That tip I had already considered. But in my case, for instance, it might seem impractical. Picture petty cash reimbursements, for instance, which are done by check, plus many other situations all financial officers in the forum are aware of, and which should not be handled through accounts payables. What I'm doing right now, since I need to be able to print the voucher at least, and write the check by hand, is view the journal entry  and print it via browser, and staple it to the check. Thank you.

I use one checking account only. If I pay a supplier, the voucher gets printed and check number is the same as my checkbook. But if I issue a check to someone else who is not a supplier, and use the Payments option in GL, then I can not print the voucher nor keep the numerical sequence in order. I need to do this when I pay commissions and some salaries, for instance, and I need to allocate the expense among three cost centers. How can I use the next check number as Payment Number, and how can I print the voucher as in Purchases module? Thank you.

I noticed it works perfectly on your server, but if I do that on mine, it reverts back to English and ignores the Spanish translation. I'm using Ubuntu 8.04 LTS 64 bit set to use es_HN.utf-8. All other reports work Ok except the one "Annual Expense Breakdown". If it is a matter of timing out, how can I increase the time so that FA won't report it as an error? It shows a triangle after a few seconds. Thank you for your help.

I downloaded the dejavu fonts, but now the report that shows the monthly income statements every month for the current year does not show up (fourth down the list), unless I use utf8 encoding for es_AR and not utf-8 as it should. Please advise.

No. It is not setup as a bank account. I am trying to enter the beginning balances of all GL accounts by posting a journal entry, and it was that account only that could not be posted by the accountant until I raised her privileges. Thank you.

Hi:

Logged on as admin, I created an account and asked the accountant to post an entry to it. I noticed it did not appear to her when she logged in, but I could see it as an admin. I had to change her rights to admin for her to post an entry to that account. How can that be fixed? Thank you.

I was ruinning FA under Windows XP. I installed it in my notebook running Ubuntu 8.04 and it works perfectly now. I need the Spanish translation, so I copied lang.es.php to the Numbers subdirectory, and renamed it to Words.php but now it does not work. Using the original Words.php file restores the English functionality. What am I doing wrong? Thank you.

I installed check printing module and got to the point where I had the link to print the check to a supplier. But after clicking on the link, all I get is a blank page titled http://localhost/FrontAcc/modules/checkprint/check_print.php. Where did the check go? Thank you.