Question Status

garyb asked a question on 9 Dec 2013 9:10 PM



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.



André Arnaud de Calavon responded on 10 Dec 2013 2:13 PM

Hi GaryB

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.

garyb responded on 11 Dec 2013 6:54 PM

Hi Andre,

Thanks for getting back to me.  Would this information be stored in the WorkflowWorkItemTable?  Or is the information in a different table.

Thanks again


André Arnaud de Calavon responded on 11 Dec 2013 11:09 PM

Hi Gary,

Yes the information should be in this table. I tried to check again, but this table in my test environment is empty.

Sagar Dhuri responded on 16 Feb 2015 4:21 PM

Hi Andre,

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?


André Arnaud de Calavon responded on 17 Feb 2015 12:51 AM

Hi MasterBlaster,

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.

Jonathan Halland responded on 17 Feb 2015 1:37 AM


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.