Hi
I have had a request from our external auditors to provide a listing of all journals for the last financial year (1 April 2019 to 31 March 2020). That includes (where applicable as not all journal names are controlled by workflow) the user that submitted the journal for approval and the user that provided the final approval. This is because they will use automated tools to search for any anomalies such in who is submitting and who is approving journals.
I don't imagine there is a standard report (there rarely is with D365 it badly lacks end user reporting tools) a long term solution obviously is to have a developer write an SSRS report over the workflow history tables (we would have to pay our Dynamics partner to do this and it will take more time than we have).
But I think there is possibly a short term excel solution using the workflow history inquiry and joining the rows from here with the workflow tracking table (that I can access through systable browser). the challenge is finding what column or columns to join. It looks like the recordid may work for this but I can not find away to add this to the workflow history enquiry.
Does any one have any ideas on how I can join the data or a more elegant solution to provide this information without developing an SSRS report from scratch?
Thanks in advance.