Thanks.
227 03/14/2014 03:58:19 pm
Re: Restored hosting account problems with FA (3 replies, posted in Installation)
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
228 03/14/2014 03:52:01 pm
Re: Version 2.3.20 not displayed after upgrade (4 replies, posted in Installation)
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
229 03/10/2014 08:30:53 pm
Re: Version 2.3.20 not displayed after upgrade (4 replies, posted in Installation)
Joe
It contains the version 2.3.20 inside the code. The template is the default option.
230 03/10/2014 06:50:37 pm
Topic: Version 2.3.20 not displayed after upgrade (4 replies, posted in Installation)
Hi
Cannot get above version to display after upgrade.
Regards
231 03/10/2014 06:45:01 pm
Re: 404 error for pdf reports after upgrade (14 replies, posted in Installation)
FA 2.3.19. PHP5.4; Same error occurred after server crash and host restored.
Cannot get PDF to display. Urgent fix needed.
Regards
232 03/10/2014 04:39:50 pm
Topic: Restored hosting account problems with FA (3 replies, posted in Installation)
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.
233 03/10/2014 08:13:49 am
Re: Cash Flow Statement (28 replies, posted in Banking and General Ledger)
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.
234 03/10/2014 07:50:49 am
Re: How to prevent multi-users to access with the same password (2 replies, posted in Setup)
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.
235 03/10/2014 07:48:31 am
Re: Different users are trying to use the same invoice number (6 replies, posted in Accounts Receivable)
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.
236 03/10/2014 07:43:20 am
Re: Size limit on restoring backup (14 replies, posted in Reporting)
Have same problem. It indicates that "You can only upload *.sql backup files"
237 02/19/2014 04:05:18 pm
Re: Cash Flow Statement (28 replies, posted in Banking and General Ledger)
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
238 02/19/2014 03:55:49 pm
Re: Recapitulative Statement Report (5 replies, posted in Reporting)
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
239 02/19/2014 03:50:58 pm
Re: Cash Flow Statement (28 replies, posted in Banking and General Ledger)
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
----------------------------------------------------------------------------------------------------------------------------------------------------
240 01/19/2014 08:46:12 pm
Topic: Amount Changes when adding an item (0 replies, posted in Accounts Receivable)
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
241 11/13/2013 09:49:08 pm
Re: Receipts and Remittance Error (4 replies, posted in Accounts Receivable)
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.
242 11/13/2013 09:38:02 pm
Re: Receipts and Remittance Error (4 replies, posted in Accounts Receivable)
Thanks. It still worked with 2.3.18.
SQL version is: 5.0.96-community
regards
243 11/13/2013 12:40:35 pm
Topic: Receipts and Remittance Error (4 replies, posted in Accounts Receivable)
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
244 10/13/2013 05:13:51 pm
Re: Print Customer Statement (4 replies, posted in Reporting)
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
245 09/04/2013 08:28:34 pm
Re: Include a Purchase Repeating Invoices (2 replies, posted in FA Modifications)
I think it might work.
246 08/20/2013 02:05:45 pm
Re: TAX INVOICE (12 replies, posted in Accounts Receivable)
Thanks Janusz. Done that
247 08/16/2013 06:58:23 am
Re: TAX INVOICE (12 replies, posted in Accounts Receivable)
Thanks will give it a try. Once edited where do I send the file?
249 08/15/2013 01:23:59 pm
Re: TAX INVOICE (12 replies, posted in Accounts Receivable)
How do you edit them?
Regards ![]()
250 08/15/2013 01:20:10 pm
Re: [Resolved] FA Database Backup not working (1 replies, posted in Report Bugs here)
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.
