Кстати, вот пример кода от Дипака, который мне пришлось в конечном итоге дебажить и править в выходные:
X++:
while select ProjId, DataAreaIdUnion, TransDataAreaId from projUnpostedTransGroup
group by ProjId, DataAreaIdUnion , TransDataAreaId
where (projUnpostedTransGroup.TransactionOrigin == ProjOrigin::VendorInvoice ||
projUnpostedTransGroup.TransactionOrigin == ProjOrigin::ExpenseManagement)
&& projUnpostedTransGroup.TransType == ProjTransType::Cost
{
ttsbegin;
lendingEntity = projUnpostedTransGroup.TransDataAreaId;
borrowingEntity = projUnpostedTransGroup.DataAreaIdUnion;
projectId = projUnpostedTransGroup.ProjId;
qbds = query.addDataSource(tableNum(ProjUnpostedTransView));
qbds.addRange(fieldNum(ProjUnpostedTransView, ProjId)).value(projectId);
qbds.addRange(fieldNum(ProjUnpostedTransView, DataAreaIdUnion)).value(borrowingEntity);
qbds.addRange(fieldNum(ProjUnpostedTransView, TransDataAreaId)).value(lendingEntity);
qbds.addRange(fieldNum(ProjUnpostedTransView, TransType)).value(queryValue(ProjTransType::Cost));
...
queryRun = new QueryRun(Query);
while(queryRun.next())
{
projUnpostedTransView = null;
projUnpostedTransView = QueryRun.get(tableNum(ProjUnpostedTransView));
...
Где ошибка?