Thanks Albertino, I found help from a friend. Now every thing is running well. Thanks a lot. I really appreciate your help.

Best Rgds.

Thanks Alberto with your help I have been able to login separately into the earlier company I created by changing the password to be the same as I created before. But now I'm creating a 3rd company and that is where I'm having problems with the SQL stuff. The thing is that I'm running on ubutu linux OS and I believe that is the challenge. When I was on windows, as soon as I select the browse at "database script" I get stuff like what you described but with ubuntu its sort of complex as I can't locate the SQL folder. Any clue on how to fix it on linux?

Thanks a lot for your help. Really grateful.

Thanks a lot Alberto. I had this error message "When creating a new company, you must provide a Database script file." probably cos I did not choose anything at Database Script. Actually I did not know where or how to choose  dbase script. I'm familiar with logging into phpmyadmin and I 'm not sure if i can do this from over there.

Thanks Alberto, I did that before several times but when I try to login into the newly created company it says "
Incorrect Password

The user and password combination is not valid for the system.

If you are not an authorized user, please contact your system administrator to obtain an account to enable you to use the system.
Try again"

This is how I fill it out;
Company    : I enter the desired company name
Host    : localhost
Database User: the original db user I used in setting FA up. (acct)
Database Password: the db password originally used in setting uFA
Database Name:
Table Pref: 2, 3, 4 etc as by default established.
Default: no
Database Script: not sure what to put there.
New script Admin Password: not sure what to put there.


I would be very glad if any one could help me out as I'm stranded on this.

Thanks.

Ok Thanks, but where do I select company database to begin with. Do I have to login into phpmyadmin to do that?

You see, I know FA can have up to 50 different companies set up and logged in separately with various pass words maybe.  f.i  to be able to have say, company A, B, C D etc in the "Company"drop down list after user name and pass word at the initial login page. so that each company you wish to work on at any time is chosen. Hope you get my point and can anyone help me out please?

Thanks.

7

(10 replies, posted in Setup)

Sorry for my long absence. When I say "not successful" I simply mean I'm not able to get what I need done much as I try.

You see, I know FA can have up to 50 different companies set up and logged in separately with various pass words. f.i having company A, B, C D etc in the "Company"drop down list after user name and pass word at the initial login page. so that each company you wish to work on at what time is chosen. Hope you now get my point and can help

Thanks.

8

(9 replies, posted in Accounts Receivable)

Hi Joe,
After I place an invoice, I get various options such as view, print, email etc but unfortunately it gives me this error message "Sending document by email failed" any time I try to email. I'm running on version2.2.8.

Could you kindly help me fix this?

Thanks.

9

(13 replies, posted in Setup)

Thanks Joe, but at least it must allow me to edit the existing fiscal year, but when I try to edit, it becomes inactive.

10

(13 replies, posted in Setup)

In the fiscal year tab, when I click on the date icon and the calender pops up, and I choose a date,  31st Dec, 2010 supposed to appear as 31/12/2010, it appears as  12/31/2010, even though in the display tab I have set it to appear DDMMYYYY. Why? could any body help?

11

(13 replies, posted in Setup)

I think the problem posted by Koeznandar was not really adressed in
https://frontaccounting.com/fawiki/index … iscalYears.
I'm facing the same problem countless number of times the error"Invalid BEGIN date in fiscal year." keeps appearing.
I'm trying to create a fiscal year of 1st Jan 2010-31st Dec 2010. Originally, I have 01/01/2008-31/12/2010.

Mistakenly, I created 01/01/2009-    31/12/2010 and now FA says I can't delete it, even not able to edit, Why is it so? Could it be some kind of bug?

12

(10 replies, posted in Setup)

I do accounts for several companies and I need to be able to create FA for each company I prepare accounts for. Each time I try at "Create and Update Companies" I'm not successful. I tried reading up on the fawiki page but the info over there is scanty. Could any one help me out please.

13

(24 replies, posted in Accounts Payable)

If I understand from your post #22, are you saying that the system automatically fails to calculate purchase VAT (from the same item sold) just to account for the Purchase tax reclaimable?

Cos, I have a tax liability account named Sales tax to which the sales invoices entered credits the VAT element and further credits the net to the sales account.

On the other hand, I also have a current asset purchase tax account to which purchase tax is supposed to be debited and the net purchases figure further debited to the relevant purchases account.

The sales invoice aspect is done perfectly but the purchases aspect is not done because the purchase invoice tax is not calculated (though the field shows up in the form and appropriate tax group of 15% selected) in oder to post the tax element to the respective purchase tax account. I hope you understand my problem.

14

(24 replies, posted in Accounts Payable)

This is not really the same item purchased for resale, in fact most of my purchase lines are expenses, even though others are for resale. I discovered the quick entry yesterday and realised that it does calculate the purchase tax alright.

I'm very sure "tax group"  selected is not fully tax exempt, cos "exempt selected items do not show the tax field at all, but in my case, the fields are shown but just wouldn't  calculate.

Please throw more light on creating quick entries with tax exempt items. I might be better off using the quick entries for all my supplier invoices since I don't make use of POs now.

Thanks.

15

(24 replies, posted in Accounts Payable)

Well, I'm having a similar problem with purchase tax.

When I enter a supplier invoice the tax field fails to calculate and remain zero. The sales field on the sales invoice calculates alright posting the VAT element into its sales tax liability account and that is really cool.

But the purchase tax is really a pain for me since I manually calculate the VAT and use journal entry to post the tax element into its relevant account.

I would deeply appreciate any help to fix this. I'm running on version 2.2.8

What happens accounting-wise when supplier payments are entered. Does it credit the Bank account from which payment is processed as the case should be?

Henry.

Using version 2.2.8, what happens when when you enter supplier invoices or process customer invoices. Does the system automatically post the amounts to AP or AR accounts as the case may be? Please help. Thanks

Henry.

After formatting my laptop on which frontaccounting is installed and run how do I get back access to the software. I backed up on an external hard drive before formatting.

Any help?

19

(1 replies, posted in Setup)

Could some body help me change my current fiscal year to 2010.

20

(7 replies, posted in Reporting)

I'm using version 2.1.3. Just installed it but I can't view customer balances. I'm relying on the sample data anyway. Any help?

Thanks again for the response Joe.

I now have an idea what the allocation fields do but I still have that same problem of the outstanding fields recording no figures when there should be some outstanding balances.

Could you help please, I really need to fix this urgently.

Thanks

Thanks a lot Joe for your response,

I'm generally aware that the outstanding column must display what the customer owes but for some reasons I don't read the correct balance or read zero when there should be an amount owing and am very sure about the invoice and payment entries such that I know manually what should be owing.

I would also be grateful if you could tell me what the absolute value is allocated to.

Thanks again.

Hi there,
I sent a message concerning customer reporting but have not had a reply yet.

My issue is this.

When you enter a credit invoice it is supposed to debit the customer's account and throw the balance to the outstanding column when you open the customer report page so that at a glance one would know how much a credit customer owes. Similarly when a payment is effected by a customer, that customer's account is suppose to be credited to show a reduction in his indebtedness but it is observed to the contrary that the balance is thrown under a column named 'ALLOCATED' which fails to give you at a glance the balance of that customer.

Could this be a bug or something needs to be done.

Please help out.
Thanks

Hi there,

Could you kindly explain to me the functionality of allocations. I've realized that when a customer is invoiced as a credit transaction and you log in to the customer's account to check transactions, you have the cost debited to the account alright but instead of the amount appearing at the balance (which is termed outstanding) column it goes under allocations.

This does not tell you right away what the customer owes. How can I fix this? Is there something am not doing right?

Thanks for your courtesies.

Hi Joe,

Could you kindly assist me address a few concerns.

1. I have been trying to invoice a few customers that I've created but any time I click on direct sales invoice this error msg reads 'the selected customer has no branch' or something like that.
Now I managed to get the invoice box appearing alright but it always comes with an already filled out page of a customer and item and so on. When I change it to my desired info and click 'process invoice' the error msg says 'You must enter at least one non empty item line'. When I click ''add item'' to enter another line and click, then it works but I don't need the additional item line any way.
So what does the system mean by non empty item line?

2. Why doesn't the general ledger journal entry process when you enter a figure of 0.00?

3. How do I enter new stock arrivals into inventory for it to reflect on the stock level.
   
4. Upon successful invoicing of a customer does the system debit the customers account accordingly?

Thanks.