Finance | Project Operations, Human Resources, ...

The selected record has been deleted by another user (while trying to change item price)

(0) Share

Report

Posted on by bugman

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!!!

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

David Musgrave MVP ... 13,932 Most Valuable Professional on at

Like (0)

Report

RE: The selected record has been deleted by another user (while trying to change item price)

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
Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: The selected record has been deleted by another user (while trying to change item price)

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.