web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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 507

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

I have the same question (0)
  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator 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 ?

  • Shakil khan Profile Picture
    Shakil khan 507 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,

  • 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 507 on at
    Re: Approval Hierarchy error in GP Business Portal

    Hi,

    I checked this table but it is already empty.

    Regards,

  • Verified answer
    Shakil khan Profile Picture
    Shakil khan 507 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.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator 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.

  • Shakil khan Profile Picture
    Shakil khan 507 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

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 experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans