физ остаток на дату:
select sum(Qty) from inventTrans
where
inventTrans.ItemId == "MyItem" &&
inventTrans.DatePhysical <= dateTo &&
inventTrans.StatusIssue <= StatusIssue:
educted &&
inventTrans.StatusReceipt<= StatusReceipt::Receipt
join inventDim
where inventDim.InventDimId == inventTrans.InventDimId &&
inventDim.InventLocationId == "MyLocation";