Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

How to provide Sales order access for specific country through record level security in AX 2012

Posted on by 2,430

Can any one help on this issue to get record level security to SO for specific country.

Thanks,

Raziq.Ali

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,430 on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Thank you very much......

  • Verified answer
    sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Product Information Management >> Common >> Released Products >> Foreign Trade (TAB)

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,430 on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Hi Sohaib,

    I have one more questionto ask from you, where we provide Country Region Id for an Item in AX from front end?

    Thanks in Advance...

    Regards,

    Raziq.Ali

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,430 on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Thanks for helping, It works for me as well.

    Regards,

    Raziq.Ali

  • sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Because I want my security policy to be applicable on all security roles. It’s my choice if I want to keep it blank or I want to apply this security policy on a specific role (your case)

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,430 on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Hi Sohaib, Thanks for replicating this issue from your end.

    I have one question, why you left blank highlighted portion from below image?

    PL5-_2800_1_2900_.png

    Please let me know.

    Regards,

    Raziq.Ali

  • Verified answer
    sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    I have tested it and it is working perfectly, in my DEV system. Have a look at below screenshots, taken during my TESTING.

     

    I used a user for testing named as smcuser1

     

    PL4.png

     

    assigned "Sales Manager" role to this user. using this role user can see all inventory as we can see in next screenshot

     

     

    4265.PL2.png

     

    For testing I added values of OrigCountryRegion for 3 items as shown below

    2 items(D0001, D0002) have country code BHR (Bahrain)

    1 Item has country code NLD (Netherlands)

     

    PL3.png

     

    Next, a query was created as shown below

     

    PL4.png

     

    Next a security Policy was, based on above query.

     

    PL5.png

     

    Lets login back in AX, with same testing user.

     

    8640.PL6.png

     

     

     

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,430 on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Sure and thanks for your support.

  • sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Thank you for feedback and providing screenshots.

    I will get back to you by tomorrow, after creating scenario on my DEV Box

  • Suggested answer
    Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,430 on at
    RE: How to provide Sales order access for specific country through record level security in AX 2012

    Below are query and policy I created. Now, nothing is visible on form.

    4885.2.png

    4885.2.png

    Please let me know your valuable feedback on this.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans