FrontAccounting forum — Quick Entries, accounts missing in drop down box

Re: Quick Entries, accounts missing in drop down box

2012-05-10T09:17:38Z

Thanks Pete,
I edited the mistakes I made with phpmyadmin. It wasn't too bad changing an amount but changing a date was a headache,won't do that again:)
I have all the historical transactions entered now, and everything working ok. Your script sounds cool. Could I use it to create a clean chart of accounts? would be useful to set up a friend with FA and use my own COA as a starting point.
I think my first problem with the quick entry was that I had the drawings account tied to a bank account, bank accounts aren't shown in the drop down.
I also had a problem with creating a new customer where the auto created branch wasn't visible, I couldn't create an invoice because there were no branches setup but I couldn't delete the customer because there was an existing branch. There was a fix for this on Mantis but didn't work in my scenario, what did work was deleting the branch from 0_cust_branch, I never had a problem with this before or since.
I have everything working well now including quick entries, starting to get easier now that I am getting to understand the accounting side of the things.
Look forward to trying your script
cheers

Re: Quick Entries, accounts missing in drop down box

2012-05-10T05:02:28Z

Hello Miles
I have a PHP script that removes all transaction data from FA. It's only for use by those technically minded. I think I posted it on this site somewhere ages ago, but let me know if you want me to re-post it. Not sure if the administrators want me to post it as a forum response though, as it's more a developer tool (and will destroy all transaction data).

The script simply runs through ALL transaction tables (and only those tables) in FA, clears them and resets the autonumber fields.

One other thing: to see what went wrong, you could set debugging of SQL on in your config file, then check the SQL's to see why your account was not visible.

Pete

Re: Quick Entries, accounts missing in drop down box

2012-05-07T22:08:36Z

Thanks for the reply Joe,
I couldn't work out what was wrong. The account was set up the same as the others with Account status: active. I had a few transactions I had entered wrong anyway so I just did a fresh install with General US 4 digit COA which was the same as the first time. Everything seems to be ok. I am going to enter a few old transactions, what would be the best way to correct any mistakes If I type the date or amount wrong? I have myphpadmin installed if necesssary.
Thanks for your assistance,

Re: Quick Entries, accounts missing in drop down box

2012-05-07T06:14:25Z

Did you put the drawings account in an account group that is visible? Do you see the account in other drop down lists?

/Joe

Quick Entries, accounts missing in drop down box

2012-05-07T00:38:38Z

I'm trying to set up a quick entry as follows:
for phone where 50% of the payment is drawings. Of the remaining 50%, 15% is GST, remainder is Telephone account(expense) something like this:

Description: Phone
Entry Type: Bank payment
% amount of base 50%: drawings
Taxes added, reduce base:GST
remainder: Telephone

However when I drop down the Account box, not all GL accounts are available, drawings doesn't appear on the list. I have a new installation with only a few transactions.