btamulis 1/3/2023 10:24:22 AM

Work Flow Tables - Change Approver via SQL

Does anyone have any experience with SQL Tables for GL Workflow approvals?

We have multiple subledger batches that are showing in GP as waiting for an alternative final approver. 

Our problem is the final alternative approver is a very old windows account that has been inactive for a long time.

I would like (if possible) to simply change the approver to a current user.

Here's a screen shot - tried using table finder but I don't think it listed the tables:

Version: All
Section: Dynamics GP


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3