Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Permissions to view Qty on purch order

(0) ShareShare
ReportReport
Posted on by 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

  • azelaya59 Profile Picture
    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
    7 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
    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
    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
    7 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
    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
    7 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
    7 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
    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
    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

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans