51

(11 replies, posted in Reporting)

Thanks apmuthu for you reply. If you take a look at the customer balances and customer Aged receivables report, there is no option to select customer balances pee location. How do I insert this option in the report. Kindly assist.

Thanks.

Popsicles12

52

(11 replies, posted in Reporting)

Hello all,

I created about 3 locations for our 3 different warehouses. We have customers that are supplied by the sales reps of each warehouse. i.e. each warehouse has its customers.

I want to be able to generate their balances based on the location. That is if I am printing customer balances/ Aged receivable I should have the option of saying I want the report for only location 1, or location 2. Moreso if I am printing customer balances for all the location I should be able to have them group and totalled per location.

thanks.

Popsicles12.

53

(5 replies, posted in Accounts Receivable)

Hello Apmuthu,

Thanks for your continuous support.
I have another issue right now. When I raise an invoice because the rows of the invoice is much, it will get to point where when I try to add a new row, it will be looking at you and not respond. You click on add again, it will be same, after clicking like 3 to 4 times, it will now add the rows and add 4 rows indicating the number of times you clicked on add.

the slow nature of the software is alarming. sometime, when you click add, it will be there for like 5mins.

what do I do. How do I correct this anomaly. previous like 3 months back it used to be very fast. The Frontaccounting server is on a LAN with 5 users connected via LAN to the server.

Pls help.

Thanks
Popsicles12.

54

(5 replies, posted in Accounts Receivable)

Hello Apmuthu,

Thanks for your reply. This I have been doing but it always reoccur and it is causing problems. How do I stop it completely. since it is not happening in the other company, only on this.

Kindly help as I do not want the reoccurence.

thanks
Popsicles12

55

(5 replies, posted in Accounts Receivable)

Good day Joe,

I just discovered that when I raise an invoice and save in one of the companies I created, it will try to process the invoice but return with the error symbol of a triangle. when I click it to reprocess, it will do that and sometime completes the process.
When I go to check the invoice i will discover that it has duplicated the products on the invoice and created two delivery note for the duplicated products.

Eg. say this is the invoice:

10      Toothpaste                 2.5       25.00
5         Noodles                      1.0        5.00
                                                         30.00

after processing twice due to the error, i get this

10      Toothpaste                 2.5       25.00
5         Noodles                      1.0        5.00
10      Toothpaste                 2.5       25.00
5         Noodles                      1.0        5.00
                                                         60.00

How do I correct this error. It is really affecting our stock report as we have to manually check the invoices to see where the error is.

Kindly help.

Thanks

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.

57

(6 replies, posted in Setup)

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

58

(6 replies, posted in Setup)

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

59

(6 replies, posted in Setup)

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

62

(25 replies, posted in Installation)

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.

63

(25 replies, posted in Installation)

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

64

(25 replies, posted in Installation)

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

65

(25 replies, posted in Installation)

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.

66

(25 replies, posted in Installation)

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

67

(25 replies, posted in Installation)

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

68

(25 replies, posted in Installation)

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.

69

(25 replies, posted in Installation)

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

72

(6 replies, posted in Setup)

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.

73

(6 replies, posted in Setup)

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.

74

(6 replies, posted in Setup)

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.