Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Permissions to view Qty on purch order

(0) ShareShare
ReportReport
Posted on by 5

Hi all,

I want to give some of my employees the rights/permissions to view the "Qty. on Purch. Order" and "Qty. on Sales Order" fields on the article cards, but I cannot figure out which table they are connected to. Could someone help me out with this?

Thanks in advance!

Lynn b

*This post is locked for comments

  • azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Permissions to view Qty on purch order

    Now your really understanding the permission structure in NAV! That's awesome!

  • Lynn23 Profile Picture
    Lynn23 5 on at
    RE: Permissions to view Qty on purch order

    That worked! I did end up copying the permission set and only giving them read permission on all of them, because I don't want them to be able to add any purchase or sales orders.

    Thank you so much for your help!

  • Verified answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Permissions to view Qty on purch order

    Remember to "refresh" the users sessions after applying the additional "Permission Sets"

  • Verified answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Permissions to view Qty on purch order

    Lynn

    Ok you're missing permission sets! When you add the following / standard permission sets, the "Flow Fields" are visible:

    2019_2D00_06_2D00_12_5F00_0958.png

    2019_2D00_06_2D00_12_5F00_0958.png

    I hope this is what you are looking for. 

    Good Luck!

  • Lynn23 Profile Picture
    Lynn23 5 on at
    RE: Permissions to view Qty on purch order

    [quote user=""Alfredo"][/quote]

    Lynn

    I have a suggestion within standard NAV.

    1) Create a new permission set for this purpose. I copied BASIC and created BASIC APZ

    2019_2D00_06_2D00_12_5F00_0855.png

    2) Go to "permissions" and modify object 5406 & 37. Remove the "Read" ability:

    2019_2D00_06_2D00_12_5F00_0851.png 2019_2D00_06_2D00_12_5F00_0851_5F00_001.png

    3) When you look at the "Item" card, the "Flow Fields" are hidden:

    2019_2D00_06_2D00_12_5F00_0855.png

    Now apply the permission set to the users that should not be able to see the Sales & Purchase quantities.

    It's a way to look at it without adding conditional coding to the page itself.

    Hi Alfredo,

    Thank you for your answer. The issue is I DO want them to see the fields, but they don't see them at the moment. They do have read permissions for object 5406, 37 and 39. I cannot add the fields to their item table through adding columns, nor to their item card through changing the page. This is how they show up on my item card:

    Knipsel.PNG

    What am I missing?

    Thank you in advance!

    Lynn

  • azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Permissions to view Qty on purch order

    Lynn

    I have a suggestion within standard NAV.

    1) Create a new permission set for this purpose. I copied BASIC and created BASIC APZ

    2019_2D00_06_2D00_12_5F00_0855.png

    2) Go to "permissions" and modify object 5406 & 37. Remove the "Read" ability:

    2019_2D00_06_2D00_12_5F00_0851.png 2019_2D00_06_2D00_12_5F00_0851_5F00_001.png

    3) When you look at the "Item" card, the "Flow Fields" are hidden:

    2019_2D00_06_2D00_12_5F00_0855.png

    Now apply the permission set to the users that should not be able to see the Sales & Purchase quantities.

    It's a way to look at it without adding conditional coding to the page itself.

  • Lynn23 Profile Picture
    Lynn23 5 on at
    RE: Permissions to view Qty on purch order

    [quote user=""Swati"][/quote]

    Hi,

    Table 37 Sales Line and 518 Purchase line. or you can open item card and check the same fields.

    Thank you for your quick answer!

    I tried adding those tables to their permission, but the fields don't show up on their article card, nor can I add them through changing the page. Is there anything else I can do to get them to see the fields?

  • Lynn23 Profile Picture
    Lynn23 5 on at
    RE: Permissions to view Qty on purch order

    [quote user=""Andrea"][/quote]

    Hi Lynn,

    these two fields are linked to "Purchase Line" and "Sales Line" tables.

    Best regards

    Thank you for your quick answer!

    I tried adding those tables to their permission, but the fields don't show up on their article card, nor can I add them through changing the page. Is there anything else I can do to get them to see the fields?

  • Swati Chauhan Profile Picture
    Swati Chauhan 205 on at
    RE: Permissions to view Qty on purch order

    Hi,

    Table 37 Sales Line and 518 Purchase line. or you can open item card and check the same fields.

  • Andrea Antoniazzi Profile Picture
    Andrea Antoniazzi 285 on at
    RE: Permissions to view Qty on purch order

    Hi Lynn,

    these two fields are linked to "Purchase Line" and "Sales Line" tables.

    Best regards

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

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans