Hello,
i would like to select the last entry a period in the JmgPayStatTrans Table.
Can anyone help me,
thx
Hello,
i would like to select the last entry a period in the JmgPayStatTrans Table.
Can anyone help me,
thx
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.
thx
Something like select maxOf(FromDate) from JmgPayStatTrans group by PayCostType, Worker?