Running MS Dynamics GP 10.0 (yes, I know it's long in the tooth, but it works!).
I did an update on table IV00108 in SQL Mgt Studio to globally change item prices.
Afterwards, initially no item prices were displayed in Price List Maintenance screen. :-O
I discovered that in my table update process I had lost all the Indexes, Triggers, Constraints, etc that were attached to that table (I think I know why - I actually would up deleting that table from my database and importing that table from a backup I had made, and I think that's when the objects got dropped).
So, I ran GENERATE SCRIPTS against a good backup copy of that table to get the code to recreate the missing objects (Indexes, Triggers, Constraints, etc), then ran that code against the table, which SEEMED to work fine - item prices were indeed now displayed in the Price List maintenance window, and I could edit the prices.
BUT - I discovered a few days later that ONLY the user SA can edit prices - when any other user tries to click on a price to modify it, they get "The selected record has been deleted by another user".
I have stopped & restarted SQL Server, no joy.
Any advice is greatly appreciated!!!
I think Beat probably has the issue. if you have something that works for 'sa' but not other users, the issue is usually related to access to DYNGRP at the SQL Level which is fixed by running Grant.sql on the database.
I would also HIGHLY recommend updating to the latest modern lifecycle release of Microsoft Dynamics GP, currently v18.4.
That Dexterity error usually occurs when a record is created, but is then out of the range or not accessible for some reason.
Kind regards
David
When you drop a table in GP and recreate it, depending on how you recreated the table, the permissions got dropped as well.. To grant GP users access to all objects, you need to run the GRANT.sql script that is in the GP program folder under the SQL subfolder.
Run it against the company DB and you should be fine.
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,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148