Search options (Page 2 of 5)

Hello Apmuthu,

Thanks for your reply.
I am thinking the problem with this report is due to the fact that I have been upgrading the software from version 2.3.6 to 2.4.6.
Is that the cause? if yes what do I do.
Do i do a new install and just pick the beginning balance for a for a fresh installation?

Kindly advise.

thanks

Popsicles12

Hello Apmuthu,

I am back again with the issue of Sale Report. I will show you the report for November 2021. It is show a negative Contribution (Profit per product). There are selected products that has this issue. I do not know why? It always brings negative contribution. How do I correct this anomaly.
How do I prevent this from re-occurring?
1. did I forget the standard cost i.e. make it zero so that the purchase price is used as cost?
2. do I always change standard cost whenever there a new purchase?

Now I need to rectify this. I need to file in the database that I need to manually correct these cost to reflect the true picture of the profit per product. This is crucial as it is used to know the product that performs well in terms of sales and profit margin.

thanks apmuthu.

expecting your response soonest.

Popsicles12

Thanks Notrinos for your response. But it is not working. I have done that about 10 time and the error remains thesame.

It is not working. Can anyone help me for this has made us remain on a standstill.
Pls.

Thanks.

Popsicles12

Thanks Joe.

Sorry to bother you a little. Is there a table in the database that I can correct this for the meantime as we use this report to check the profit margin per product and to know which product is doing well and the one not doing well.
Please.
Secondly, I wanted to install 2.4.7 fresh and import my database into it. but the database is large 150MB and it is complaining of timing out. I increase the timing in php.ini and now it is complaining of table duplication. The database in question is an update from 2.2. Any ideas?
thanks.

Popsicles12

Hello Apmuthu,

Please could you kindly attend to my initial post before boxygen answer. As boxygen answer does not answer my question.

I updated from 2.4.3 to 2.4.7 thinking as you suggested that the negative figure for Contribution will be rectified. But after the update the problem still persist.
Present more problems have erupted as I cannot do Location transfer, I cannot void any document, etc.

What I need you to help me do is how do I eliminate the negative figure for the Contribution (profit) per product, How do I prevent it from happening in future?
Moreso, How come the system calculates a cost that is higher that your selling price. How can I stop this from happening?
How do I make this current update void documents and do location transfer.
How do I upload my database into a new 2.4.7 installs seeing that my database is very large 150MB.

thanks Apmuthu in anticipation of your prompt response.

Popsicles12

Hello apmuthu,

I am still expecting your reply please.

thanks
Popsicles12

Hello apmuthu,
Thanks for the response. I did the change to the file but it did not work. I think there is something we must add to rep101 and 102.
Could you pls tell me what to correct and how to correct it.
Thanks.

Popsicles 12

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

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.