select sum(pd3.Payment)
from
POSDocuments3 pd3
join POSDocuments pd on pd.ID = pd3.Parent_ID
where
(
(pd.Opened = 'A') or
(pd.IsPaychange = 'A')
) and
pd3.IssuedDepositInvoice_ID = :IssuedDepositInvoice_IDGenerated by ABRA Software a.s. 27.10.2021 16:34:30