Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Approval Hierarchy err...
Microsoft Dynamics GP (Archived)

Approval Hierarchy error in GP Business Portal

(0) ShareShare
ReportReport
Posted on by Shakil khan 505

Dear all,

I am facing a problem in MS GP business portal requisition management site. I want to add / replace a user in the existing approval hierarchy of Requisition Management. When I try to add user at any hierarchy level, everytime it is displaying me an error :

"The Approval Hierarchy is not locked".

Please help me in this matter.

 

*This post is locked for comments

  • Shakil khan Profile Picture
    Shakil khan 505 on at
    Re: Approval Hierarchy error in GP Business Portal

    Hi,

    In our case, there was a trigger on the MultiUserManager table, its name is "MaintainClearMultiUserManagerTable ".  so we disbled this trigger and then this problem is resolved. This is not a custom trigger as you can see from its name. Its installed with business portal itself, but we dont know, how it is installed and in which scenario it is installed ?

    Thanks

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: Approval Hierarchy error in GP Business Portal

    Hi Shakil,

    Glad you solved your problem... Could you be more specific about the solution ? it could prove to be useful for other BP user that would face the same problem... I couldn't find any trigger on the table MultiUserManager, thus it must be either an Stored Procedures or something else.

    Thanks and have a good day.

  • Verified answer
    Shakil khan Profile Picture
    Shakil khan 505 on at
    Re: Approval Hierarchy error in GP Business Portal

    Ok, we resolved the issue with the help of microsoft. There is a trigger on MultiUserManager table, which need to be disabled.

    Thanks for your time.

  • Shakil khan Profile Picture
    Shakil khan 505 on at
    Re: Approval Hierarchy error in GP Business Portal

    Hi,

    I checked this table but it is already empty.

    Regards,

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    Re: Approval Hierarchy error in GP Business Portal

    Shakil,

    Could you take a backup and try the following to see if it is somehow locked?

    delete DYNAMICS..MultiUserManager

    Thanks

    Rob

  • Shakil khan Profile Picture
    Shakil khan 505 on at
    Re: Approval Hierarchy error in GP Business Portal

    Hi BUCHER

    I am using Dynamics GP 10 with Business Portal 4.0 version. There are  multiple administrators but at this time, only I am trying to change approval hierarchy.

    Regards,

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: Approval Hierarchy error in GP Business Portal

    HI Shakil,

    Which version of Business Portal and Dynamics GP are you running ? Are you the only administrator of the BP ?

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans