Hello All,

Thanks for your reponses so far.

@ Apmuthu, you suggested I do a new Installation and see if this Standard Cost Alteration still persist. I have installed version 2.4.11 and it still persist.

Please this might sound stupid. How do I enter cost of Good so that when I do Inventory Valuation Report, It uses the standard cost to calculate and not average cost.
Cost when I got value different from my Standard cost which I know is average cost, I updated the Standard Cost but its not reflected in the Report.
Please help out.

Thanks

Popsicles12

While creating inventory or its from category the  COGS account set to use it and also inventory account..

From that it will make the entry.

Thanks for your reponses so far.

@ Apmuthu, you suggested I do a new Installation and see if this Standard Cost Alteration still persist. I have installed version 2.4.11 and it still persist.

Please this might sound stupid. How do I enter cost of Good so that when I do Inventory Valuation Report, It uses the standard cost to calculate and not average cost.
Cost when I got value different from my Standard cost which I know is average cost, I updated the Standard Cost but its not reflected in the Report.
Please help out.

Thanks

Popsicles12

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

But on existing  data you need one developers  help to identify  the data which gone wrong  and correct that data without affecting GL Transaction.

I know Frontaccounting uses Standard cost. Why do the Cost change over time when you try to get your Inventory Sales Report. This report is so valuable to me because it shows the performance of all products. they one that is fast selling and the one with the most profit.
So how do I configure it to make sure it adheres strictly to the standard cost or do I just leave out the standard cost. so It uses the purchase price and the selling price to calculate the profit per product or what do you think.

Since my installation has gone through several upgrade, do I do a new installation. In so how do I correct this nomaly?

expecting your reply

Thanks

Popsicles12

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

thanks. expecting your reply.

Popsicles12

Here search  type =35. You will  get cost update entry. Find them connected with wrong  amount.  And than only you can able to fix it

Thanks for the response. But I dont get it. How do i get cost update entry? Kindly assist cos after a while the inventory report begins to give negative profit margin. On the report you see the Cost far higher than the Selling price.

I will be waiting.

thanks

Popsicles.

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

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