Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

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

Posted on by 2,432

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

Thanks,

Raziq.Ali

*This post is locked for comments

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,432 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
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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,432 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,432 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

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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,432 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
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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,432 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.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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,432 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.

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