SELECT sum(A.Quantity), A.SerialNumber FROM sys$posdocumentsoffstore S LEFT join POSDocuments2 A ON S.document_id=A.Parent_ID where A.StoreCard_ID =:StoreCard_ID and A.Store_ID =:Store_ID group by A.SerialNumber
Generated by ABRA Software a.s. 27.10.2021 16:34:30