web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Approval history
Microsoft Dynamics AX (Archived)

Approval history

(0) ShareShare
ReportReport
Posted on by sg1 90

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

I have the same question (0)
  • Suggested answer
    Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • sg1 Profile Picture
    sg1 90 on at

    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.

     

  • Community Member Profile Picture
    Community Member on at

    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.

  • Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Volodya Profile Picture

Volodya 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans