Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Dynamics GP Workflows - Different Approvers for Different GL Batch IDs - Is it Possible?

(0) ShareShare
ReportReport
Posted on by 39

Hi All,

I inherited some workflows that weren't working quite right, and I haven't been successful with making them work either.  I'm hoping one of you can tell me if what we're hoping for is possible or not.

  • The scenario is that once a month any one of three Corporate accountants needs to approve and post 2 GL batches.  These batches always have either "DEPR" or "LEASE" in the Batch ID.  One of these batches is set up as Recurring, and I think the other could be too if that would be helpful.
  • All of the rest of the GL batches need to be approved and posted by any one of two Plant accountants.

FIRST ATTEMPT

Images 1, 2 and 3 show the current set up.

In this configuration someone from both of the steps ends up having to approve the batch, and we really only need someone from the Plant list or someone from the Corporate list - depending on the Batch ID.

I added one of the Corporate accountants to the list of Plant approvers to see if we could get by with just having her approve twice.  This wouldn't be ideal, but for a few batches a month we could have lived with it.  This seemed to work on one or two of the batches, but then we started to see unreliable results in some of our other GP databases.  Perhaps this was because we were recalling and resubmitting? 

GL-Workflow-1.pngGL-Workflow-2.pngGL-Workflow-3a.png

SECOND ATTEMPT

Image 4 shows a change I made.  The steps are exactly the same, but one is the second step rather than an additional first step.

This configuration worked okay for those responsible for approving the first step batches, but when step one conditions were not met, the step two people still weren't required to approve.  They could just go ahead and post.

GL-Workflow-4.png

I see on the Workflow Name window that there is a checkbox for "Always require at least one approver".  Perhaps checking that would make scenario 2 work. 

i probably need to figure out how to deactivate my email triggers in the Test environment so I can start testing this thoroughly there.

Thanks in advance for any thoughts or suggestions you have about this.

Lynne

*This post is locked for comments

  • Lynne Mosiman Profile Picture
    39 on at
    RE: Dynamics GP Workflows - Different Approvers for Different GL Batch IDs - Is it Possible?

    Hi Jeffrey,

    Thank so much for trying to help.  Those spots actually said "Or" when I first started working on them.  Since the condition says, "Does Not Contain" I thought this would make more sense.

    Thanks to your advice on my other thread, I might be able to test this a little more thoroughly.

    Lynne

  • Suggested answer
    twelvestrikes Profile Picture
    3,657 on at
    RE: Dynamics GP Workflows - Different Approvers for Different GL Batch IDs - Is it Possible?

    Hi Lynn

    On your 3rd image (JE review) try using an OR instead of an AND in your conditional statement.

    On your second attempt, for the 3 different conditions use an OR instead of an AND.

    When you use an AND all of the conditions must be present and as you know a batch id will only contain one of them.

    The OR should work.

    Let me know

  • Lynne Mosiman Profile Picture
    39 on at
    RE: Dynamics GP Workflows - Different Approvers for Different GL Batch IDs - Is it Possible?

    FYI - In the "Second Attempt" scenario, I marked the "Always require at least one approver" checkbox, and it sent the approval request to the Manager I have on the Workflow Type window, so that checkbox was not helpful in this situation.

    It seems that the configuration in "First Attempt" really ought to work.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,233 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,982 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans