X++:
while select CustTrans
order by TransDate asc
where CustTrans.AccountNum == accountNum &&
CustTrans.TransDate >= element.fromDate() &&
CustTrans.TransDate <= toDate &&
CustTrans.RContractAccount == contractAccount
exists join LedgerTrans
where LedgerTrans.Voucher == CustTrans.Voucher &&
LedgerTrans.TransDate == CustTrans.TransDate &&
LedgerTrans.AccountNum == ledgerAccountTab &&
LedgerTrans.PostType == LegerPostType::CustBalans
как то так. по памяти пишу