Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
select ItemId,Sum(Qty),minof (RecId) from TestTable group by ItemId
the value of the RecId from above query is zero although there are values returned for ItemId & Qty ?
strange, your query looks correct
in case of using count(recid), (just a test, does that one work?)
the above query is executed using 2009.
I applied the same logic on regular table in AX 2012, the query returns RecID min value
I have run a similar query on table SalesLine on my AX 2009 Env, and work fine.
select ItemId, Sum(SalesQty), minof(RecId) from TestTable group by ItemId;
info( QueryValue( testTable.recid ) );
info( QueryValue( testTable.SalesQty ) );
The Roll-up installed is the same for both AX 2009 Client and AOS ?