Select C.StoreCard_ID, Sum(C.Quantity) Quantity, Sum(C.QuantityAwaited) QuantityAwaited From LogStoreContents C JOIN LogStorePositions P on C.Parent_ID = P.ID Where P.ReservedForDoc_ID = :ReservedForDocID and P.ReservedForDocType = :ReservedForDocType and P.Store_ID = :StoreID Group by C.StoreCard_ID
Generated by ABRA Software a.s. 27.10.2021 16:35:19