Hello Anoopmb,I would also like to have the source code. I have similar needs here for the license and expiry date too.
Kindly email me the link.corkernel@gmail.com
Thank you.
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 popsicles12
Hello Anoopmb,I would also like to have the source code. I have similar needs here for the license and expiry date too.
Kindly email me the link.corkernel@gmail.com
Thank you.
Thanks for the reply.
The System I am using is a Core2 Duo CPU with 500GB Hard Drive and a 3GB RAM. I have about 6 users on it. So I do not think that is the cause of it. Is there any configuration in php.ini that I need to change so that this backup goes on. Cause I discovered that when I start backing up, it will continue until i stops by itself. sometime it show the error mark and sometime it does not. What other options do I need to exploit.
thanks.
Popsicles12
Thanks apmuthu for your reply.
I had to delete my SQL audit trail using phpmyadmin and still I cannot back up. what do you advice that I do to even know what is causing the problem and solving it.
Thanks.
Popsicles12
Hello Joe,
Thanks for your continued support.
I tried to backup my database for version 2.2.24 and it did not backup. It will initialize backup and after a while it will stop without any indication of backup complete message.
I later discovered the database is big about 245MB. how do I correct and get my backup done.
thanks.
popsicles12
Hello All,
I am confused about this allocate customer Payment option. There is a customer that is supposed to have a nil balance, but on checking it, it is showing -3500.00 which was allocated. how do I revert this and what is the function of allocate Customer Payment.
Secondly how do I make the forms update automatically. I am using ver. 2.3.11 and when I void a payment and try to post again, it will be telling me "the reference has been used before". how do I change this?
Thanks
Popsicles12
Hello All,
I have a situation right now. I upgraded from 2.2.11 to 2.3.11 and now when I enter invoice say 24511 which is deference from the what is setup (say 11522) in the system and save the invoice, when I open a fresh invoice, it is still showing me 11522. Previously, it automatically updates itself and brings 24512 which is the next number to the new invoice I just entered. How do I correct this as it so in the customer payment.
please help.
thanks.
Popsicles12
Hello Janusz,
I commented out the default company but the login page will not display on the browser. it was showing error of not connecting to the default database.
If I may ask, since there is a difference on the database schema of the default company and the other companies as the default company has 79 tables while the other companies has 75 tables, how do I make the other companies upgrade to 79 tables. The missing tables as as follows; 0_crm_category, 0_crm_contacts, 0_crm_persons and 0_sys_prefs.
What if I create one of the companies with the 2.3 database schema and dump the database, will it upgrade? please help out.
thanks
Popsicles12.
hello Janusz,
the schema diff between the default company and the other companies are as follows:
the default company has "0_crm_category, 0_crm_contacts, 0_crm_persons and 0_sys_prefs but the other companies does not have them.
What do I do next?
thanks.
Popsicles12
Hello Janusz,
Thanks for your response.
I followed the procedure you gave me by going to the *_sys_pref table to manually change the Version number to 2.3rc. On changing it, the default company worked but the other companies are still showing the error "Access to application has been blocked until database upgrade is completed by system administrator."
How do I make the other companies work since it is a multi-company setup.
Thanks so very much
Popsicles12
Hello Janusz,
Thanks for your effort to make my upgrade work.
This is what I got when i tried again to upgrade from 2.2.11 to 2.3.12.
I followed the procedure of upgrade and overwrite the files of 2.2.11 with 2.3.12 files. I logged in and when I checked the if it has upgraded, it was showing the following
Version Description Sqlfile Install force Upgrade
2.1 Upgrade from 2.0 - 2.1 alter 2.1 Installed
2.2 Upgrade from 2.1 - 2.2 alter 2.2 Installed
2.3 Upgrade from 2.2 - 2.3 alter 2.3 Installed
when I try to check on customers and start working it shows the following:
System is blocked after source upgrade until database is updated on System/Software Upgrade page
so what do I do with the above error.
thanks, expecting your reply.
Popsicles12.
Hello Janusz,
thanks for your support.
Could you please tell me how I can locate the fix the database scheme respectively. What I mean is how to I go about the fixing of the database to allow for the upgrade.
Pls, kindly help out.
thank you
Popsicles12
Hello Janusz,
Thanks for your reply.My database is a multi-company database where I used 0_ as prefix for the first company, while 1_ as a prefix for the second company.
In this circumstances, how do I do the upgrade manually using PHPMYADMIN. Please help
Thanks,
popsicles12
Hello Joe,
Thanks for your reply. I have done forced upgrade severally and it is still showing thesame errors.
Kindly, help me out.
Thanks.
Popsicles12.
Hello Joe,
I have a problem upgrading from 2.2.11 to 2.3.1. On upgrading and i get an error symbol on the screen. below are the following errors.
Version Description Sqlfile Install force Upgrade
2.1 Upgrade from 2.0 - 2.1 alter 2.1 Installed
2.2 Upgrade from 2.1 - 2.2 alter 2.2 Installed
2.3 Upgrade from 2.2 - 2.3 alter 2.3 partially Installed (1/4)
Database upgrade marked as partially installed cannot be installed automatically.
You have to clean database manually to enable them, or try to perform force upgrade.
Error Message
PHP Fatal Error: Cannot redeclare Class line_details in C:\xamp\htdocs\frontaccounting\purchasing\includes\po_class.inc on line 121.
Upgrade error
You have missing or invalid sales Document in database (type:30, number:1)
Call to undefined function get_payment_terms () in C:\xamp\htdocs\frontaccounting\sales\includes\class_class.inc on line 300.
On logging in
undefined property: app_function:: C:\xamp\htdocs\frontaccounting\theme\aqua\renderer.php at line 159, 179.
please help. what do I do. how do I correct this?
thanks
Popsicles12.
Thanks for your response.
I am using version 2.2.11. please help.
thanks in advance.
popsicles12.
Hello Joe,
I appreciate you and your team's commitment to the success of Frontaccounting. Kudos.
I just started getting this error when i entered a new Item. when I try to modify the item it will not modify but throws the following errors
Undefined index: NewStockID in file: c:\xampp\htdocs\frontaccounting\inventory\manage\items.php at line 269
Undefined index: NewStockID in file: c:\xampp\htdocs\frontaccounting\inventory\manage\items.php at line 271.
what is this error, how to I rectify this?
thanks
Popsicles12
Hello Joe,
thanks for your reply. To be candid, I believe the files are huge because we sell retails and a lot of little transaction you need to enter. so one has to enter like about 70 to 100 records per day.
So how do I resolve this?
Thanks.
Popsicles12.
hello joe
thanks for your reply.i had to enable the debug feature to let me know what is really happening. This is the error i found.
maximum execution time of 60seconds exceeded in C:\xampp\htdocs\frontaccounts\includes\db\connect_db.inc in line 112.
where do i correct this. I have gone to php.ini file to increase the max_execution_time but to no avail.
please help.
thanks in advance
popsicles12.
Hello Joe,
Thanks for your prompt response to all my questions.
I have a situation right now with backup. When I try to back up, you see the activity bar showing that the backup is being carried out but after some time, the backup is complete but the backup file cannot be found. what do I do.
I was thinking it is the max_execution_time. I increased it and it is still the same thing. there is no error whatsoever. I am using version 2.2.11.
thanks for your response.
popsicles12
Hello Joe,
I have been able to login. there was a problem with the table security_roles.
When I login, I went to Setup and software upgrade. but I could not find an option to click install box to do the upgrade. the two options state had installed on it.
Another thing i discovered is that On the direct invoice, there is no payment option in mine installation as it is on the demo site. The customer menu list does not drop down. i still need to type * there and press enter to reveal the customer.
how do I rectify this.
I still believe that the payment option will help me detect which invoice issued with cash only payment or delayed payment to rectify the automatic payment on invoice issued for a later payment.
thanks.
Hello Joe,
After doing all you advised me to do regarding autopayment of invoice once it is issued, I decided to upgrade to FA 2.2.11.
After changing my config.php file, i decided to login to the default company as admin but could not. when I try to login to the other company because we have multiple company running on FA, it logged in with the same admin name and password that I use for all of them.
What could probably be my error.
thanks.
popsicles12
Hi Joe,
Thanks for your immediate reply.
I am not sure I am using cash invoicing. I am using version 2.2.8. Is there another way to know if I am using cash invoicing. Presently, all customers are debtors and the have at lease 30 day to make payments for goods supplied to them.
Please how else do I know if I am using cash invoicing.
thanks.
popsicles12.
Hi Joe,
Thanks for your reply.
The question I am asking is this.
when I enter an invoice for a customer, FA automatically credit the customers' payment. The customer is a customer that buys now and pay later. the customer has a time period of 30 day to make payment which was effected when the customer was created. So now why is it that FA automatically credit the customer when He has not paid.
please help as this is a major challenge.
Secondly, If I want to get a detailed report on a customer as par what he has bought and what he has paid so far and the balance he is owing, how do I get this?
thanks.
Popsicles12.
Hello Joe,
thanks for your support so far.
I have a series of challenge with FA.
1. It automatically credit an invoice like a POS when the customer entered is a debtor customer i.e. he buys now pays later. what must be my error?
2. How do I make customers that dont transact with us again not to appear in the report printout. e.g. Debtors balances report.
3. what is the function of Customer transaction inquiry? What is the function of the RB column. I am asking because when I try to find out the cash collection over a period, the summation is not sequencial. I am missing something?
thanks.
Popsicles2.
hello Joe,
I really appreciate your response. Thanks a lot. May I say that we do not manufacture. We buy and sell. What I mean now is that purchase price have changed for about six times and within those period i have been changing the purchase prices. Now that you have enlighten me on what to do, I want to know the following:
1. What will be the purchase price figure now? is it just any of the price or the very first opening purchase price? since I have manually computed the average price.
2. We do a monthly check on profit so that we can give a percentage of the profit to the sales rep. How do I get the accurate report of the each month's profit. Does FA only calculate the average based on that month in question of do it use the overall average?
thanks for your prompt response
popsicles12.
FrontAccounting forum → Posts by popsicles12
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.