The end user does not allow you to edit the field itemlookupcode
*This post is locked for comments
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)
in HQ administrator NewUser
DENY UPDATE ON dbo.Item(ItemLookupCode) TO NewUser;
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
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.
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,129 Most Valuable Professional
nmaenpaa 101,154