You do not have permission to modify records posted table

yukon

Hi,

I know this error is already discuss before i post here. But my case is different. One of our client hit below error when they try to rename the customer no. Specially those customer no. does not exist in posted shipment table (all of posted table). Why system giving error without posted shipment record and not directly modify the table. I try to set permission on customer table and customer card. It does not work.
And I set posted R/I/M/D permission on his/her role. So they can directly amend on table. But the error is come out when they rename the customer no. ](*,) ](*,)

Any way to solve this problem.

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
You do not have permission to modify records in the Sales Shipment Header table.

Contact your system administrator to have your permissions changed.

---------------------------
OK   
---------------------------

Regards,
Yukon

william_akihisa

modifying posted table is not recommended [-X you should return order first and then make a new order to fix it.

ssingla

william_akihisa wrote:

modifying posted table is not recommended [-X you should return order first and then make a new order to fix it.

Post is discussing about renaming Customer No. and not modifying records (renaming will also modify records but AFAIK that is permissible in NAV).

rsaritzky

yukon wrote:

Hi,

I know this error is already discuss before i post here. But my case is different. One of our client hit below error when they try to rename the customer no. Specially those customer no. does not exist in posted shipment table (all of posted table). Why system giving error without posted shipment record and not directly modify the table. I try to set permission on customer table and customer card. It does not work.
And I set posted R/I/M/D permission on his/her role. So they can directly amend on table. But the error is come out when they rename the customer no. ](*,) ](*,)

Any way to solve this problem.

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
You do not have permission to modify records in the Sales Shipment Header table.

Contact your system administrator to have your permissions changed.

---------------------------
OK   
---------------------------

This appears to be a straightforward permissions issue. The Sales Shipment Header table is not a "Posted" document table - it is an open document table.

So I would make sure the user has permissions to table 110. Easiest way to test is to log in as a user with SUPER permissions and try it again. If that works, then you need to add a role for that user that has all the table permissions necessary. It's hard to determine which records they are, but if you are using the standard NAV roles, I would start with the "S&R-Q/O/I/R/C, POST" role - that should have most of the tables necessary to do a Customer No. RENAME. If you get additional permission errors, then you can create a new Role for those tables or find another Role that includes those records.

Good Luck!

bbrown

The Sales Shipment Header table IS a "Posted" document table - it is NOT an open document table.

vivek4121

Agreed with bbrown "Sales Shipment Header" table is a Posted document table, the record only enters into that when we Post the Sales Order as Ship. Open document table is rather "Sales Header" table