Search options (Page 2 of 5)

Thanks kvvaradha,

Solved my problems.

Thanks kvvaradha,

I am most grateful for your prompt reply. I will attach the report for you to see. Then I am thinking I will install the latest version maybe version 2.4.10 or 2.4.11 and get my opening balances and enter them and start afresh.

When I do this, do I still need to enter any standard cost or I just enter the purchase prices and the selling prices and let the software do the calculation for Standard Cost or I just enter a standard cost which can be changed say once or twice yearly.

With these scenarios, what will be the resultant effect on this very report "INVENTORY SALES REPORT". This report is very critical to our business as it tells us what Product is fast selling and what product we make good profit.

I will be expecting your reply.

Thanks

Popsicles12

Hello kvvaradha,

Thanks for your reply.
Once this process is done. How do I make sure this issue does not reoccur?

thanks. expecting your reply.

Popsicles12

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