Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by 70

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:
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,932 Most Valuable Professional on at
    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 Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    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.

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans