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.
1 11/25/2009 01:04:16 am
Topic: Truncate General Ledger Transactions (2 replies, posted in Banking and General Ledger)
2 11/10/2009 07:22:36 pm
Re: duplicate payment bank transaction found (15 replies, posted in Banking and General Ledger)
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.
3 11/10/2009 12:58:38 am
Re: duplicate payment bank transaction found (15 replies, posted in Banking and General Ledger)
Well, we only have one bank account. That's why I was asking. I hope your solution still applies. Thank you.
4 11/10/2009 12:38:04 am
Re: duplicate payment bank transaction found (15 replies, posted in Banking and General Ledger)
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.
5 11/09/2009 10:06:33 pm
Re: duplicate payment bank transaction found (15 replies, posted in Banking and General Ledger)
Ok. I can void the transaction but I still can not see the voucher. I get the same error. Thank you.
6 11/09/2009 10:02:27 pm
Re: duplicate payment bank transaction found (15 replies, posted in Banking and General Ledger)
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.
7 11/09/2009 09:28:46 pm
Re: duplicate payment bank transaction found (15 replies, posted in Banking and General Ledger)
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.
8 11/09/2009 08:02:31 pm
Re: duplicate payment bank transaction found (15 replies, posted in Banking and General Ledger)
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.
9 11/08/2009 04:58:41 pm
Topic: duplicate payment bank transaction found (15 replies, posted in Banking and General Ledger)
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.
10 06/05/2009 04:30:27 pm
Re: How to print a check posted through GL module? (5 replies, posted in Banking and General Ledger)
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.
11 06/01/2009 04:24:22 pm
Topic: How to print a check posted through GL module? (5 replies, posted in Banking and General Ledger)
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.
12 05/29/2009 04:40:54 pm
Re: TCPDF error: Could not include font definition file: dejavu.php (10 replies, posted in Reporting)
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.
13 05/28/2009 05:57:31 pm
Re: TCPDF error: Could not include font definition file: dejavu.php (10 replies, posted in Reporting)
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.
14 05/27/2009 11:32:19 pm
Re: GL Account created by admin not available to accountant (2 replies, posted in Banking and General Ledger)
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.
15 05/26/2009 09:18:41 pm
Topic: GL Account created by admin not available to accountant (2 replies, posted in Banking and General Ledger)
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.
16 05/20/2009 10:20:40 pm
Re: Module : Chequing Accounts & Cheque Issue / Print (10 replies, posted in Modules Add-on's)
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.
17 05/20/2009 02:29:20 am
Re: Module : Chequing Accounts & Cheque Issue / Print (10 replies, posted in Modules Add-on's)
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.