X++:
static void JobTest(Args _args)
{
InventTrans InventTrans;
InventJournalTrans InventJournalTrans;
;
select sum(Qty), count(RecId) from InventTrans group by TransRefId
join sum(Qty), sum(CostAmount) from InventJournalTrans
where InventJournalTrans.InventTransId == InventTrans.InventTransId
&& InventJournalTrans.JournalId == "СЖ00546541";
info(strfmt("%1 %2 %3 %4",InventTrans.Qty, InventTrans.RecId, InventJournalTrans.Qty, InventJournalTrans.CostAmount));
}
Результат:
-9 720,00 2 -9 720,00 -57 639,60