Thanks for the update......
With the GL Batch workflow, when the workflow is approved, final approved, etc., if you pull up the journal entry in the Journal Entry Inquiry window, then click the View History menu option for workflow in that inquiry window, does the Workflow History window show a record(s) for the workflow being originated/submitted, then the different steps in the workflow whether needing action or not, then a Final Approve record for when the workflow was completed?
If not or if it only shows correctly some of the time, if you look in the WF30100 table, do you see the records for the workflow showing correctly in that table, such as a 'Workflow Originated' record (Workflow_Action = 1) and records for workflow steps, as well as records for when the workflow is completed/final approved (Workflow_Action = 10)?
I ask as we've seen and have a documented issue where the Workflow History window will show some but not all of the steps, but it omits other steps that require approval, even though the WF30100 table shows the records correctly.
Also, on Dynamics GP 2018 R2, if you browse to Report > Company > Workflow History and pull the Workflow Transaction History Detail report , it does show the history/workflow steps correctly.
Something else that may work to get this type of information, is the following script:
select WFI10002.Workflow_Type_Name as Workflow,
WFI10002.WfBusObjKey as Document,
WFI10002.Workflow_Originator as Originator,
WF30100.Workflow_History_User as 'Final Approver',
convert(varchar, WF30100.Workflow_Completion_Date, 101) as 'Approval Date',
convert(varchar(30), WF30100.Workflow_Completion_Time, 8) as 'Approval Time'
from WF30100 join WFI10002 on WFI10002.WorkflowInstanceID = WF30100.WorkflowInstanceID
where Workflow_Action = '10' and Workflow_Type_Name = 'General Ledger Batch Approval'
This script will show the GL batch workflows, document number information, originator and final approver and date/time.
The script is part of the following blog:
Microsoft Dynamics GP SQL Views for SmartList Designer to Enhance Reporting
community.dynamics.com/.../microsoft-dynamics-gp-sql-views-for-smartlist-designer-to-enhance-reporting
**NOTE: The GP SQL View Living Document link on this blog, is temporary down while CustomerSource and PartnerSource are being worked on, but the script for the GL Batch workflow is above.
Let us know if you have any further questions.
Thank you,
