Странно! Каким способом ты получаешь данные из запроса.
Вот такой пример работает без проблем
X++:
Queryrun main_query(boolean _count_query = false)
{
VendInvoiceJour VendInvoiceJour;
QueryRun QueryRun;
Query query = new Query();
QueryBuildDataSource qbds;
QueryBuildRange qbr;
;
qbds = query.addDataSource(tablenum(VendInvoiceJour));
qbds.addSortField(fieldnum(VendInvoiceJour,purchId));
qbds.addSelectionField(fieldnum(VendInvoiceJour,Qty), SelectionField::Sum);
qbds.orderMode(OrderMode::GroupBy);
qbds = qbds.addDataSource(tablenum(VendInvoiceTrans));
qbds.addLink(fieldnum(VendInvoiceJour,purchId),fieldnum(VendInvoiceTrans,purchId));
qbds.joinMode(JoinMode::InnerJoin);
qbds = query.dataSourceTable(tableNum(VendInvoiceJour));
QueryRun = new QueryRun(query);
while (queryRun.next())
{
VendInvoiceJour = QueryRun.get(tablenum(VendInvoiceJour));
info(strFmt("%1 %2",VendInvoiceJour.PurchId,VendInvoiceJour.Qty);
}
}