Cannot delete items from items table NAV 2017

(0) Share

Report

Posted on by Community Member

Hello, I have a fresh install of NAV 2017. I uploaded items with the rapid start tool and had a few junk items get caught in the mix. No sales or transactions have ever occurred on this company and I get a error while trying to delete the item.

Error Message: You do not have the following permissions on TableData Item Identifier: Delete

I am a super user and a super user (data)

I have checked security permission on the server and I have a user role that should be able to delete.

Any suggestions.

Chad

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (1)

Suggested answer

Suresh Kulla 50,233 Super User 2025 Season 2 on at

Like (1)

Report

RE: Cannot delete items from items table NAV 2017

Hello,

Check if your user permission SUPER is assigned to a specific company. If the company value is filled in, clear the value and then try deleting it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Cannot delete items from items table NAV 2017

Sorry I meant to add that in the original questions details. I do not have a company selected for the super user so it is global

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,233 Super User 2025 Season 2 on at

Like (0)

Report

RE: Cannot delete items from items table NAV 2017

Please send us a screen shot of your user permission set.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: Cannot delete items from items table NAV 2017

Verify you had assigned super user rights to your user:

msdn.microsoft.com/.../dd568740(v=nav.90).aspx

msdn.microsoft.com/.../dd568744(v=nav.90).aspx

Also check table properties (table permission settings): https://msdn.microsoft.com/en-us/library/dd338822(v=nav.90).aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Cannot delete items from items table NAV 2017

Yes this user is the only user in the system at this point. it is a fresh install. It has permission set SUPER and Permission Set Super (data) I would not think licensing would have a problem but here is my license details just in case

350 Starter Pack 1

450 Full Concurrent CAL 5

8100 Codeunits (each) 10

Country Code: United States 1

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Cannot delete items from items table NAV 2017

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

RE: Cannot delete items from items table NAV 2017

Hi,

Please check the company that you are in. If it is company specific permission set, then you have to change it before deleting.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Cannot delete items from items table NAV 2017

Hello Appletree,

As per other members, check all, And Send us screenshot of error that you got while deleting Item.

Note: Also check, OnDelete Trigger of Table and page, it might be error called something like;

ERROR('You do not have the following permissions on TableData Item Identifier: Delete');

if it so, then you can't delete also.

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

RE: Cannot delete items from items table NAV 2017

I would point to license, can you check if you have permission for table Id. 7704 Item Identifier. Try to run this table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Cannot delete items from items table NAV 2017

The error reads exactly as you stated.

I also cannot design table 7704 item identifier. I tried a "run" on it and nothing happened. Trying a "design" on it produced a permission error

Also I have gone to table 27 and tried to specifically give it a permission

Was this reply helpful? Yes No