// Selection of data for stock adjustment (total unposted sales etc )
select sum(-a.FQtyShipped) SUMOFQTY 
from docline a join dochead b on a.WDocid = b.WDocid and b.Bposted = 0 and b.WTypeid in (10,13) 
where a.WStockid = <@WSTOCKID@> 
group by a.WStockid
union
select sum(c.FQtyShipped) 
from  docline c join dochead d on c.WDocid = d.WDocid and d.Bposted = 0 and d.WTypeid in (11,12) 
where c.WStockid = <@WSTOCKID@>

union
select IIF(OPREPORT.SOPTIONVALUE = 'True',-STOCK.FMINIMUMQTY,0) TOTALQTY from STOCK 
, opreport 
where OPREPORT.STROPTION = '<@SOURCEID@>USEMINIMUM'
and STOCK.FMINIMUMQTY <> 0 and 
STOCK.WSTOCKID = <@WSTOCKID@> 

