Our auditors have asked for a list of all general journals raised in the year with who they were created by and who they were approved by. Is there an easy of way of producing a report on this, or do we have to look at each seperate workflow history?
Thanks
*This post is locked for comments
Hi.
You can try perform the following links:
1. [Your table] joined to
2. WorkflowTrackingStatusTable (using [Your Table].RecId == WorkflowTrackingStatusTable.ContextRecID && [Your Table].TableId == WorkflowTrackingStatusTable.ContextTableId) joined to
3. WorkflowTrackingTable (using WorkflowTrackingStatusTable.RecId == WorkflowTrackingTable.WorkflowTrackingStatus)
Filter on:
1. WorkflowTrackingTable.TrackingContext == WorkflowTrackingContext::Step
2. WorkflowTrackingTable.TrackingType == WorkflowTrackingType::Completion
You can then use the User field on the WorkflowTrackingTable
Hi Sg1,
Have you tried the report in path
AX 2012 - Under Organization administration > Reports > Workflow > Workflow tracking
Will that be helpful ?
Otherwise:
your dev can either write X++ job or SQL Query utilizing below tables.
LedgerJournalTable
WorkflowTrackingStatusTable
WorkflowTrackingTable
WorkflowElementTable
WORKFLOWSTEPTABLE
Thanks for the swift replies!
For a General Journal that is submitted there may be multiple people who can approve, however only one person is required to approve it to complete the workflow. e.g.
1. journal submitted by x
2. journal enters workflow for approval by a, b or c
3. journal approved by b
4. workflow completes (greater than 1% of approvers)
What we would like to present to our auditors is that the journal was submitted by x and approved by b. We have AX 2012.
Hi,
I don't know which version you are using. Going through separate workflow history is tedious task.
AX 2009 - no standard report available. You could ask dev to write a SQL query from Workflow tables (as Jonathan mentioned)
AX 2012 - Under Organization administration > Reports > Workflow > Workflow tracking. Check if that is any useful for you.
I would rather go for SQL query joining Workflow tables to gather details for auditors irrespective of AX versions. This is pretty much easier.
Hi SG, it is certainly possible to do so using the workflow tables in AX. But remember that there may be a one to many relationship between a journal and approvals. i.E. Many people may have approved a certain journal. Can you perhaps give an example of how you want the output to look.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156