как это можно сделать
X++:
query = new Query();
qbds = query.addDataSource(TableNum(RAssetTrans));
qbds = qbds.addDataSource(TableNum(RAssetTable));
qbds.relations(True);
queryRun = new QueryRun(query);
rTransList = new RecordInsertList(tableNum(TmpRAssetAmortizationReportGrouping));
if (queryRun.prompt())
{
while (queryRun.next())
{
rAssetTable = queryRun.get(TableNum(RAssetTable));
rAssetTrans = queryRun.get(TableNum(RAssetTrans));
grouping.data( );
grouping.assetId = RAssetTrans.AccountNum;
grouping.BranchId = RAssetTrans.Dimension[1];
grouping.GroupId = RAssetTable.AssetGroup;
grouping.Amount[4] = RAssetTrans.AmountCur;
rTransList.add(grouping);
}
rTransList.insertDatabase();
}
while select * from grouping
{
info(strFmt("%1 - %2 - %3 - %4", grouping.assetId,grouping.BranchId,grouping.GroupId,grouping.Amount[4]));
}