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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Setting security permissions to post a Purchase Order - impossible??

(0) ShareShare
ReportReport
Posted on by 510

Hi all

I am trying to setup security permissions to enable users to post Purchase Orders. I have most of it done correctly I believe.

For the final step, I need to give the user group Create access to the Items table (ProjItemTrans) in Projects module. I know this as I keep getting the following error message, when trying to post a Purchase Order with someone in that user group:

User is not authorised to insert a record in table 'PROJITEMTRANS'. Request denied.

I have gone to the table to give the appropriate access but am only able to give upto Edit access, the higher access levels are greyed out! How is this possible? I dont understand how we need to give Create access but the Create access level is not available to select! Does anyone else know about this, is it a recognised issue, or do we have some weird bug in the software???

Oh and I have the same problem with posting timesheets and project invoices too, I need to give Create access to the Hours table (ProjEmplTrans) and Fee table (ProjRevenueTrans) in Projects module, but can only select upto Edit access!!??? Has anyone managed to figure out what is going on??

Thanks for any and all help!!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi,

    Go to the ProjItemTrans table properties and set the MaxAccessMode to delete.  You should then be able to assign a higher level permission in the user group permission tree.

    Repeat with the other tables you mentioned.

    Kind Regards.

  • bigweed Profile Picture
    510 on at

    That works! Cheers!

    Any idea why it is like that to begin with - I am unsure whether changing settings in AOS is the right thing to do you see... plus if we get a new BUS layer which we will be soon, it will wipe out changes I make in the AOS anyway?

  • Community Member Profile Picture
    on at
    If you modify this in a layer outside of the BUS layer, you can move in that layer after your new BUS layer goes in.  It all depends on what layer you make your modifications in.
  • Rene Volkmer Profile Picture
    326 on at

    But how is that possible? I have Ax50Sp1 with GEE (RU7), and there are several standard tables that have MaxAccessMode set to Edit and AOSAuthorization set to CreateReadUpdateDelete

    (ie. ProjRevenueTrans, ProjInvoiceRevenue...) - from standard. There are also several calls of ProjRevenueTrans.insert() in code (also standard). Customer has made some changes in User Group Permision and now I am getting getting access permision error while making this insert from code (even with admin rights), which is actually quite logical (I should not be able to create record when MaxAccessMode is edit :]). Yes, I can walk arround with changing MaxAccessMode to add or delete, or by adding uncheck keyword around insert call. But it is standard and it worked before setting User Group Permision, why not now? Thanks for any hint! I must be missing something important.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans