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?)
+31 6 147 989 53
3905 PE - Veenendaal
OTHER CONTACT INFORMATION
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 ?
Thanks & Regards
Respect the provided answers from other community members. Don't provide or do not copy the same answer to the same thread. Additional insights are welcome!