All,
I would like to know if we can track the details of GP Workflow (General Ledger). Is there any table that maintains who Submitted and Posted the GL batch using Workflow?
Actually, i have a Smartlist report in GP that shows posted transactions. I have the columns to see who created and posted the batch. But i would also like to see who Submitted and Posted the batch in Workflow.
Thanks,
Neha
*This post is locked for comments
In case one is still wondering about the WF tables, this KB article should help:
There is even a small SQL script at the end to link some of the WF approver & originator, and the status (which can be taken from the KB list)
Everything "workflow" is stored in the company db with tables names of WF*.
The "workflow steps" and such seems to be in the WFI10x tables. Biggest trick seems to be to figure out the GUID of the transaction to see how it all pieces together. I did that a bit but don't have it down solidly.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (