Question Status

Suggested Answer
maram fraij asked a question on 5 Mar 2014 5:18 AM

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  ?

Reply
Dick Wenning responded on 5 Mar 2014 8:14 AM

strange, your query looks correct

in case of using count(recid), (just a test, does that one work?)

Kind regards, 

Kaya Solutions

Dick Wenning

+31 6 147 989 53 

Landjuweel 5

3905 PE - Veenendaal

 

OTHER CONTACT INFORMATION

Reply
maram fraij responded on 5 Mar 2014 10:26 AM

the above query is executed using 2009.

I applied the same logic on regular table in AX 2012, the query returns RecID min value

Reply
Suggested Answer
Denis Macchinetti responded on 5 Mar 2014 11:01 AM

Hi Maram

I have run a similar query on table SalesLine on my AX 2009 Env, and work fine.

   SalesLine   testTable;

   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 ?

Regards

Thanks & Regards

Denis Macchinetti

Senior Technical Architect

Reply
Suggested Answer
Denis Macchinetti responded on 5 Mar 2014 11:01 AM

Hi Maram

I have run a similar query on table SalesLine on my AX 2009 Env, and work fine.

   SalesLine   testTable;

   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 ?

Regards

Thanks & Regards

Denis Macchinetti

Senior Technical Architect

Reply