habla español

Hello,

Stock value is calculated for the current price/cost. This is the query used.

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

Mian Saleem What is the current Cost price? Amount from the Purchase Order or Amount we fix during adding the product.

Mian 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.

Hello,

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

Mian Saleem Can you make this for me? What will be the cost?

Hello,

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

Mian Saleem Will you suggest what types of developers I need? Which programming language?

Hello,

PHP developer should be able to modify the item code. The item is developed with CodeIgniter php framework.

Thank you