Select entry from the last period in JmgPayStatTrans


i would like to select the last entry a period in the JmgPayStatTrans Table.

Can anyone help me,


As with your previous question, it’s not clear what problem you have with the requirement. Please give us more information.

Also, please attach tags related to your question, most importantly your version of AX.

Version: Dynaimcs AX 2012 R2

I need a select statement (axapta) to select the last entry (from date) of each “Paycosttype” and that for each worker.


Something like select maxOf(FromDate) from JmgPayStatTrans group by PayCostType, Worker?