It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by seahawk
Janusz
You are correct. It seemed that their was difference in pointing and what we saw on the main domain.
The host then send me a link to the server of the shared account that is a temporary link. The install was then successful and the site is reading the version file correct. It also seems that after the server crash the PHP and Mysql was not installed correctly. Once they host fixed that the problem was resolved.
Thank you for everyone's help.
Regards
Wynand
Janusz
The server crashed and the hosting provider reinstated a backup to the website. I then upgraded the FA on the site but for some or other reason that is still not clear to me, it seemed that the information on the hosting account was duplicated on another server linked to the main server PC.
I deleted the FA files but on refreshing the browser it kept on running with the old info.
I then removed the complete installation and database. I created a new database and did a complete new install. On the main domain it did not want to accept the installation. The host then send me a link to the server of the shared account that is a temporary link. The install was then successful and the site is reading the version file correct.
Thank you for everyone's help.
Regards
Wynand
Joe
It contains the version 2.3.20 inside the code. The template is the default option.
Hi
Cannot get above version to display after upgrade.
Regards
FA 2.3.19. PHP5.4; Same error occurred after server crash and host restored.
Cannot get PDF to display. Urgent fix needed.
Regards
One one of the shared hosting domains, we had a crash of the server. The hosting provider only had a backup of 20/02/2014.
All other backup's were lost. The provider then restored the backup which included FA database and files. Now FA does not want to print any reports.
I did the following:
1. Restored the database and tables (Did not work)
2. Reloaded FA 2.3.19 (Did Not work)
3. Looked at System info and it kept on showing installation file to be removed. There is no installation file at that point. The Backup screen also continued to show old backups that was removed.
4. Installed the new 2.3.20 (Did not work - FA still sees it as 2.3.19. Cleaned the browser cache and used different browsers.)
5. Deleted the whole data base and created new database. (Did not work. FA shows splash screen and does not want to do reinstall) Login Screen still shows 2.3.19 although I installed clean 2.3.20)
6. Removed the config and config.db files, still showed 2.3.19 and was running without these files. Do not know how this is possible.
Any advice will be appreciated. Have searched the forum but could not find something similar.
Joe
Sorry for only getting back to you now. I think it looks great. Will test it on a number of installation with multiple bank accounts and see what it does.
See it will give you last twelve months which is great. Some might want a from and to date to do the report for quarter of six months.
Thanks for the development. Will keep you posted.
I agree, they can only login with some-one else's password if they shared it or if the person have saved it on their browser and they use that person's computer.
Two invoices can be enetered by two different users at the same time, but obviously they invoice number hav eto be unique. FA uses database transactions, so there is no way to entry two invoices at the same time: just one will be stored, and second user will encounter error message. Then you just have to incement the invoice number suggested in input field and try store the invoice again. You do not need to abandon edition and change the number in Forms Setup.
Janusz
I agree with Janusz. When I train multiple people at a company it happens. Then the person who receives the error message can just resubmit their invoice and it then allocates the next number, otherwise just update the invoice.
Have same problem. It indicates that "You can only upload *.sql backup files"
It would be similar to the report: Annual Expense Breakdown - Detailed. The only difference is that it will only reflect all cash receipts and payments and not all sales and purchases like this report.
Regards
Joe
The sale summary report does not give you a list of invoices. Just a summary of total business for a given period with a particular client.
Is there a way to just get a list of invoices (Documents) with invoice numbers and amounts for a given period.
Regards
Wynand
Cash Flow statement would be done with the bank and cash accounts setup.
It will receive all the cash receipts minus the cash payments for each account. The balance would be you positive or negative cash flow. This is not sales on credit or purchases on credit. These will only reflect when you receive payment on those sales or when you pay your supplier.
Depending how you have setup your accounts, will determine how one would write the report.
Let's for example say that you have two bank accounts set up. Bank Account A (Current Account) and Bank Account B (Cash Account).
Need to add all the receipts in Account A for a given period together and then subtract the expenses that was paid from that account.
Then you need to do the same for Account B.
Each account will then have an opening and closing balance and the difference would be you negative or positive cash flow.
To that one need to decide how many periods should be included in this cash flow report. 1,2,3,4,5,6 periods and the total for those periods. Say from 01/01/20xx to 31/01/20xx would be one period.
------------------------------------------------------------------------------------------
Example:
CASH Flow
As at 01-Mar-2011
Account
October 10 - November 10 December 10 January 11 February 11 March 11 Total
0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Cash Flow
0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Bank Balance
0.00 0.00 0.00 0.00 0.00 0.00 0.00
----------------------------------------------------------------------------------------------------------------------------------------------------
I have tried to find some info in the forum without much success.
When adding some items from the inventory and you add the item on a direct invoice, it changes the quantity from 1 to three and changes the price from 1850 to 666.67 which is then equal to 1850.01.
I have checked the item code and there is no characters in the code.
When I go back and edit the line item the quantity can be changed but the amount now remains at 666.67 and needs to manually changed back to the selling price of 1850. When I then add, the amount and the price is correct. There is also no characters in the description field.
Any idea what could cause this?
Regards
Wynand
https://frontaccounting.com/punbb/viewtopic.php?pid=18394#p18394
Thanks tm. This solved the problem. Have added the changed file to my 2.3.19 installation for the other updates that I still have to run.
Thanks. It still worked with 2.3.18.
SQL version is: 5.0.96-community
regards
Hi
After Installation of FA 2.3.19 I get the following error on Print Receipt after receipt and remittance of Payment.
DATABASE ERROR : query for bank transaction
error code : 1305
error message : FUNCTION iingcoza_frontacc.IFNULL does not exist
sql that failed was : SELECT bt.*, act.*, IFNULL(abs(dt.ov_amount), IFNULL (abs(st.ov_amount), bt.amount)) settled_amount, IFNULL(abs(dt.ov_amount/bt.amount), IFNULL (abs(st.ov_amount/bt.amount), 1)) settle_rate, IFNULL(debtor.curr_code, IFNULL (supplier.curr_code, act.bank_curr_code)) settle_curr FROM bank_trans bt LEFT JOIN debtor_trans dt ON dt.type=bt.type AND dt.trans_no=bt.trans_no LEFT JOIN debtors_master debtor ON debtor.debtor_no = dt.debtor_no LEFT JOIN supp_trans st ON st.type=bt.type AND st.trans_no=bt.trans_no LEFT JOIN suppliers supplier ON supplier.supplier_id = st.supplier_id, bank_accounts act WHERE act.id=bt.bank_act AND bt.type='12' AND bt.trans_no = '33' ORDER BY trans_date, bt.id
Any advice will be appreciated.
regards
Wynand
The customer statement uses the contact defined on the customer and not the branch contact.
Setup a customer contact with relevant type (invoice).
Joe
Isn't there a way that one can copy the first branch that is created to the company as well as branch contact. Most Companies will have one contact with one branch.
At the moment only the one item is normal selected to be email and you have to manually add the rest of the documents that needs to be emailed, example Invoice and statement.
Can't we get all selected when the auto branch is created as well as creating a contact in the company for Statements.
regards
Wynand
I think it might work.
Thanks Janusz. Done that
Thanks will give it a try. Once edited where do I send the file?
How do you edit them?
Regards
There was a misconfiguration on the ISP's MySQL that caused the time outs on my package.
They have corrected that and it is now working fine.
Thanks Janusz. Much appreciated.
Wynand
FrontAccounting forum → Posts by seahawk
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.