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

Technical Architect

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!

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

Technical Architect

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!

Reply