Hello All,
Does any one know the stock query to get virtual stock? I use this query which has the physical stock:
<code>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
left join llx_product p on p.rowid=s.fk_product
left join llx_entrepot e on e.rowid = s.fk_entrepot </code>
How can I modify this to get virtual stock?
