Помогите начинающим!!!

[Protey]

в обычно SQL запросе остатки выглядят так:

Declare @Location As VarChar(20)
set @location = 'Склад'

select itemid, sum(postedQty + received - deducted + registered - picked) as QtySum
from bmssa.inventsum
where inventdimid in (select inventdimid from bmssa.inventdim where inventlocationid = @location and dataareaid = 'rus')
and dataareaid = 'rus'
group by itemid

делаем connection и все