Skip to main content

Notifications

Microsoft Dynamics RMS forum

How block editing itemlookupcode field in Dynamics RMS in Maintenance Mode.

Posted on by Microsoft Employee


The end user does not allow you to edit the field itemlookupcode

*This post is locked for comments

  • raelhefn Profile Picture
    raelhefn on at
    RE: How block editing itemlookupcode field in Dynamics RMS in Maintenance Mode.

    if you have hq and stores you must close any editing / creation of item lookup codes in store level because if any one define or edit items at store level hq will not takes updates on items from stores because its one way synchronization between HQ and stores.

    To disable it in store level just go to security and disable OK button on Item card it will disable updates in item card as whole also you can give read only permissions for all fields.

    On HQ level you can select disable change for item lookup code.

    steps:

    To set up a security level (Refer to Help : Setting up a security level)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How block editing itemlookupcode field in Dynamics RMS in Maintenance Mode.

    in HQ administrator NewUser

    DENY UPDATE ON dbo.Item(ItemLookupCode) TO NewUser;

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How block editing itemlookupcode field in Dynamics RMS in Maintenance Mode.

    Understand option for SQL Updated and DENY.

    The new rol work perfectly in new query sql

    but

    How link user HQ Manager with login o New ROL SQL

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How block editing itemlookupcode field in Dynamics RMS in Maintenance Mode.

    you could use Sampurna Nepolean steps for all users/cashier except one.  That user/cashier would have access to edit and create new items.

    Alternatively user could follow this article's  advise.  Just note you will have to use a different username in SO Admin for the database as "sa" always has complete access.

    dba.stackexchange.com/.../restrict-update-on-certain-columns-only-allow-stored-procedure-to-update-those

    SQL Server allows column-level permissions. Just for example:

    GRANT UPDATE ON dbo.Item(ItemLookupCode) TO SampleRole;

    DENY UPDATE ON dbo.Item(ItemLookupCode) TO SampleRole;

    replace SampleRole.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How block editing itemlookupcode field in Dynamics RMS in Maintenance Mode.

    very good but coud not create new ítem,

    only want lock editing itemlookupcode.

    If know other alternative for SQL  or whatever.

    thanks for the help.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How block editing itemlookupcode field in Dynamics RMS in Maintenance Mode.

    Hi Roderick,

    Below steps should get you started.

    1. Enable Security Mode: Select from menu: File->Security->View Security

    2. Select Edit Item option.

    3. Open the property of any item.

    4. Press buttons: Ctrl + s ( Press button s while holding down Ctrl button )

    5. Click on Item lookup code box.

    6. Select/Check 'Disable Change' option for the security level appropriate for the user group.

    7. Click OK to save.

    8. Press buttons: Ctrl + s ( Press button s while holding down Ctrl button ) again.

    9. Disable Security Mode: Select from menu: File->Security->View Security

    All the best.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans