Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Limiting A/P to only use certain GL Accounts (Naturals)

Posted on by 7,365

GP 10.0  I was wondering if anyone had a suggestion as to the easiest way to restrict access to certain GL Accounts for A/P.  I have a list of natural accounts in a 4 segment COA that the Finance folks asked that A/P not code to (generally these are allocation accounts).  But they still code to them.

My first idea was to limit them from lookup in the Purchasing series on the account card, but I think they can still manually key those in.  Would Organizational Structure work here?  If so, is it a pain to set up to be used just for this task?

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Limiting A/P to only use certain GL Accounts (Naturals)

    Hi Kay,

    Hopefully someone will come up with another suggestion, but unfortunately I think you have interpreted the Account Level Security setup procedures correctly. I don't know enough to speak to your issue, but I remember a 3rd party product that did something to restrict account access (boy that was helpful - NOT). You may want to search http://www.isv-central.com/search/products.aspx to see if there is something out there that might help.

    Kind regards,

    Leslie

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: Limiting A/P to only use certain GL Accounts (Naturals)

    I have been looking at the manual and I will do some testing, but in case anyone has done this before, I had a question.  It seems like one of setups where I would want to grant access to all, then take away a few as opposed to picking all the thousands of accounts to grant access to with the exception of a few.

    We have a class for AP called AP COORDINATOR.  I have created an organizational structure with Company, under that A/R and A/P and under those Manager and Processor.  I have Assigned the AP COORDINATOR task to the Processor under the A/P division.  There is this check box that says Grant Access to All accounts.  I was hoping that I could Grant Access to all accounts, and then be able to take away the 5 "Natural Accounts" they can't use.  This doesn't seem to be working like I would want it.

    The other issue I have is setting up everyone.  As soon as I turn on "Account Security" if all the other 15 classes we use have not been assigned to a level of the organizational tree, do they automatically "not" have access to any accounts unless specifically granted?

    As you can see, my issue is really restricting about 10 users out of 100 in a particular class to not be able to use 5 natural accounts (about 350 accounts out of 3500 total).  But if I have to spend days trying to set-up the entire organizational structure for just this task and every user Class, when no other class or user needs to be changed, it seems like overkill.

    Suggestions?

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Limiting A/P to only use certain GL Accounts (Naturals)
    Hi, Yes, I think Account-level security will fulfill or objectives. As far as setting it up, this one where you will want to read the manual (acessible from the help menu) first.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans