Does anyone know how I can find out who approved timesheets in AX2012 after they have been approved and posted. I need this information for reporting purposes. I cannot seem to track the approver, even though I can easily see the status.
The approver or more than one (depending on the workflow setup) are stored on the workflow history. The work items do have the person and a status.
André Arnaud de Calavon | Microsoft Dynamics AX Solution architect | My blog | My company
This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.
Thanks for getting back to me. Would this information be stored in the WorkflowWorkItemTable? Or is the information in a different table.
Yes the information should be in this table. I tried to check again, but this table in my test environment is empty.
I have posted a timesheet but it doesn't show up on the WorkflowWorkitemTable. It says 'posted' on the approval status in the all timesheet form.
Why is that?
Posted means that it had been passed the approval and therefor posted. Probably someone approved the timesheet or there is a rule for automatic approval.
You can view the workfllow history starting from the timesheet details.
You can also look at the WorkflowTrackingTable, it provides a lot more information about what happens in workflow, not just workitems themselves. We've normally used this when trying to trace history.
General AX Enthusiast and Blogger