AS
Asked
Hello, I have Product X in my system. Product Unit Cost is $70/Pcs. When I Am purchasing that product from any supplier for $80/Pcs still in warehouse Stock Chart report it's showing stock amount from Previous rate not based on purchased Rate.
If I buy 10Pcs of Product X at $80/Pcs. Stock amount need to be $800 based on my purchased amount, Not $700.
Again if I Purchase 5Pcs of Product X at $85?pcs Stock amount need to be Previous $800 + New Price $425= $1225. But it's showing
$ 1050 (Product Fixed Cost*15Pcs)
How to fix this issue?
If I buy 10Pcs of Product X at $80/Pcs. Stock amount need to be $800 based on my purchased amount, Not $700.
Again if I Purchase 5Pcs of Product X at $85?pcs Stock amount need to be Previous $800 + New Price $425= $1225. But it's showing
$ 1050 (Product Fixed Cost*15Pcs)
How to fix this issue?
- LC
Luis Alonso Rodriguez Carrillo
Answeredhabla español - MSAnsweredHello,
Stock value is calculated for the current price/cost. This is the query used.
```sql
SELECT SUM(qty * price) AS stock_by_price, SUM(qty * cost) AS stock_by_cost
FROM (
SELECT sum(COALESCE(sma_warehouses_products.quantity, 0)) AS qty, price, cost
FROM sma_products
JOIN sma_warehouses_products ON sma_warehouses_products.product_id = sma_products.id
GROUP BY sma_warehouses_products.id
) t;
```
If you wish to modify, the method name is `getStockValue` of `app/models/admin/Db_model.php`
Thank you - ASAnswered**[Mian Saleem](/u/saleem)** What is the current Cost price? Amount from the Purchase Order or Amount we fix during adding the product.
- ASAnswered**[Mian Saleem](/u/saleem)** Please check my Screenshots. Product Unit Cost In Product Details Page is: 85.
Bought product at unit Price: 90
Why is product cost at warehouse showing as per Product Details cost not based on purchased cost?
How we can get current stock valuation based on their purchased price?
Isn't it obvious we need to check the stock price based on their purchased price?
I am not a programmer. Please help me.Attachments - MSAnsweredHello,
The current price/cost is listed on the list products page. The chart doesn't use any purchase cost.
Unfortunately, there is no option to get the value by purchase cost.
Thank you - ASAnswered**[Mian Saleem](/u/saleem)** Can you make this for me? What will be the cost?
- MSAnsweredHello,
I am sorry as we are fully booked till March and unable to accept any jobs. Please feel free to hire any developer to help you.
Thank you - ASAnswered**[Mian Saleem](/u/saleem)** Will you suggest what types of developers I need? Which programming language?
- MSAnsweredHello,
PHP developer should be able to modify the item code. The item is developed with CodeIgniter php framework.
Thank you - Login to Reply