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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Permissions to view Qt...
Microsoft Dynamics NAV (Archived)

Permissions to view Qty on purch order

(0) ShareShare
ReportReport
Posted on by Lynn23 7

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

I have the same question (0)
  • Andrea Antoniazzi Profile Picture
    Andrea Antoniazzi 285 on at

    Hi Lynn,

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

    Best regards

  • Swati Chauhan Profile Picture
    Swati Chauhan 205 on at

    Hi,

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

  • Lynn23 Profile Picture
    Lynn23 7 on at

    [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?

  • Lynn23 Profile Picture
    Lynn23 7 on at

    [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?

  • azelaya59 Profile Picture
    azelaya59 2,807 on at

    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 7 on at

    [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

  • Verified answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at

    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!

  • Verified answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at

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

  • Lynn23 Profile Picture
    Lynn23 7 on at

    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!

  • azelaya59 Profile Picture
    azelaya59 2,807 on at

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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans