Hi all,
I use dolibarr 8.0.4.
If I show Products->list I see the total physical stock amoun t of each product.
I need the physical stock of each warehouse in a new extra row. This is necessary to have a overview which products are in my factory warehouse and which products are at the suppliers warehouse.
So, how can I expand that list, to show me the physical stock of each warehouse?
Thanks for all hints.
scaleo
Look into this module. It may fit your requirements:
https://www.dolistore.com/en/modules/547-myList—personalized-dynamic-Lists.html
I tried that, but without any success.
The module discription does not have any examples and so I only try and have errors… ist a horrible way.
Do you have any examples that show, how I have to handle the module?
Without using that module:
Is there a SQL request available which returns me the amount of stock for each warehouse ?
Hi Scaleo,
Try the below SQL query:
SELECT
p.ref as ItemCode,
p.label as Item_Description,
COALESCE(p.price_ttc,0) AS Sell_Price,
e.label as Warehouse,
COALESCE(s.reel,0) as Qty,
COALESCE(p.cost_price,0) as Cost_Price,
COALESCE(s.reel*p.cost_price,0) AS Value
FROM
llx_product_stock s
RIGHT join llx_product p on p.rowid=s.fk_product
LEFT join llx_entrepot e on e.rowid = s.fk_entrepot
