Search options (Page 4 of 6)

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 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 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,

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.

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.

Hello Joe,

thanks for always being there.
I still have a problem. I have updated the the average cost and I got the figure. But the challenge now is that every month, we pay the sales reps a certain amount of commission if they exceed a certain amount  of sales. Presently we have a five months report (May - September). When we decided to use FA to check the profit made for June, it was too high because, as at that time the sales price was high compared to the average. presently, the sales price is about N20 less than what is it was going for as at June.
What do I do seeing that the business calculates the commission based on FIFO. How do I still get the exact commission for the reps so that nobody is cheating the other.

Since the purchase price is changing the sales price is also changing. How do I alter the sales price?

expecting your response,

thanks

Popsicles12.

Hello Joe,

thanks for your prompt response.

Let me explain. This is the scenario. I bought a product for N50 each in may. In june my suppliers reduced the price to N43. In July the price further went down to N40. and September the price went to N48 per each product. As these prices were changing, I was changing the purchase price and sales price under inventory, so that the COGS can be calculated as sales are made. At the end of september, I decided to check the Inventory sales report from May to September and I discovered that under cost for this product, it was showing N48 from May till september.
My question is this?
How am I supposed to change the purchase price in FA when there is change in it?
How do I correct this as it is giving me false report?.

Thanks for your support

Popsicles12

Hello Joe,

Thanks for your reply. I am using version 2.2.8. The file created when i press backup/Restore is named as "backup" and it is an html file with nothing inside.

Thanks.

Popsicles12