Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Complex Requisition workflow approval

(0) ShareShare
ReportReport
Posted on by

We just upgraded from GP2010 to GP2015R2

We had until then Business portal to prepare and approve all our requisitions. We configured the workflow approval but I find it completely unmanageable vs BP

In my current setup I have 55 steps and 19 of them are first level steps

The way it was configured under BP

User submits REQ, goes to department manager, if amount is higher than x$ then goes to location manager or vice-president and if higher then y$ goes to the president for final approval. Also some users had the option to change approver.

It looks pretty much the same right now but each first level step is the user and I had to add the manager, VP and President to each step which adds a lot of layers and the workflow verification is long because it checks all the steps. For the users that can create requisitions I configured a step using the Site ID maintenance to be able to send to another approver as it seems impossible to do.

Is there a document somewhere that shows how to use the workflow for more complex or it's just the way the workflow is built, I couldn't find any documentation that would go deeper than just a basic workflow ?

Thanks

*This post is locked for comments

  • Brian P Connell Profile Picture
    859 on at
    RE: Complex Requisition workflow approval

    We did. We run it about every 15 minutes. It does not help with the email notice though. The email still had all the notifications in it. We removed the lines from the email template. 

    The main benefit of the job now is to eliminate the detail entries from future inquiries. We need to change the solution to trigger based and figure out how to get it in place prior to the email being generated. We will only do that IF the client requires the workflow notification details on the email notice. 

    Other than that it is dependent on future enhancements. 

  • Community Member Profile Picture
    on at
    RE: Complex Requisition workflow approval

    Hi Brian -

    Did you end up implementing your timed SQL job to remove the "No approval is required for this step" records from the WFI10003 table?  If so, did it go well?  Any advice?  We are considering doing the same.  How frequently did you have the scheduled job run?

    I appreciate any feedback you can give me.

    Jeff Davis - Senior ERP Engineer, USA Compression

    jdavis@usacompression.com

  • Brian P Connell Profile Picture
    859 on at
    RE: Complex Requisition workflow approval

    We too had the same problem with many workflow steps appearing with the description "No approval is required for this step". We ended up setting a timed sql agent job that removed all of those steps from the WFI10003 table where the status was 1. We are still in test phase , so if anyone does this you need to test this. 

  • Community Member Profile Picture
    on at
    RE: Complex Requisition workflow approval

    I just have added commentary reinforcing your issues than a solution...

    We have the same issue but with 200+ first steps.  I literally built out the same last 3 steps for almost all of the approval trees in the workflow which was tedious.  Our problem is now that the workflow history buttons do not work at all (GP crashes), the action emails contain 200+ step rejections as comments which is atrocious to scroll through, and we cannot edit the workflow after it has requisitions moving through the process.  Compared to the business portal, the new workflow is a step backwards in my opinion.  I would also be interested in finding out if anyone can answer your questions or has solutions to the ones I mention here.

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.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans