Notifications
Announcements
No record found.
Has anyone been able to get the PO Workflow information into Report Writer?
I have tried without success in getting the POP Work Table to connect to any of the Workflow tables in Report Writer.
Look at connecting the wfBusObjKey column value from the WFI10002 table to the PONUMBER column value on the POP10100 table.
The wfBusObjKey value, in the case of PO Approval workflows, is just the PO number without anything extra on it unlike other workflow types.
From there, you could connect WFI10002 to the WFI10003, WF10004 and/or WF30100 tables, for the full Workflow history.
Thanks
If not Report Writer, you could turn the script into a SQL View and use it as a SmartList report, or Excel report or SSRS report, for other options.
Hi Derek, thanks. I tried this before but the table does not allow a link as the fields display blank for any workflow table I try to connect to POP. The user requires the ability to print the approver name on the PO and hence why I would like to get it on report writer.
Any other suggestions? I cannot use VBA due to its incompatibility with newer GP.
Actually, after my initial response, I checked about Report Writer and from what I can see, and talking to a colleague that works more with the Application side of Dynamics GP, meaning Report Writer, we don't see a way to join the POP10100 to the WFI10002 table in Report Writer because the keys don't line up, so that stops us from connecting the tables, as I believe you've run into.
The only real report options we'd have is to setup a SQL View connecting the POP and WF tables to pull the information needed, then use that View either in a custom SmartList or SQL SRS report, etc.
I don't know if there are any third-party or other products that would do what we're looking for in Report Writer, maybe others in the Community have more ideas?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 646 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
