425
I am hoping someone else has done this and can share their wisdom (or maybe even their package file). I am trying to update the General Ledger Posting Journal and the General Ledger Edit List with the Workflow Approval Information for a customer using the General Ledger Batch Workflow. Right now the default reports contain the approval information if the customer is using the old Setup Posting Posting method of approvals.
Any insight is greatly appreciated.
*This post is locked for comments
This can be done, but it's not an easy request with Report Writer. One method I can think of is as follows:
1. You will probably want to store the workflow instance in the DUOS table (SY90000) by separating the Workflow Instance Id and the Batch Number from the Workflow Business Key columns, respectively stored in the WFI10002 table. This can be done with a simple T-SQL trigger on the instance table, to write into the DUOS.
2. You will want to write out (to the DUOS) the latest workflow state, stored in the Workflow History table (WF30100) corresponding to the instance Id in the WFI10002 as a third property.
3. You can then use VBA and the DUOS object model to retrieve the workflow information in Report Writer and write it to the existing fields.
While this method will work, keep in mind that VBA customizations are not compatible with Web Client.
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (