You do not have the following permissions on TableData

When we develop in Microsoft Dynamics NAV, we use a Developer License that has permissions to the standard objects different of the license of the final customer.

Using the customer’s license you may encounter error messages as follows:

You do not have the following permissions on TableData {TableName}: {Read/Insert/Modify/Delete}

An example could be running a Codeunit that modify a record in the standard table 6550 Whse. Item Tracking Line.
You do not have the following permissions on TableData

I’m pretty sure that most of you after will receive an error like this, first will search the table number of the one in the error message. Then you will realize that is in the range of the standard objects (e.g. 6550) and you will start thinking why this error didn’t happen during your tests.

Well, the answer is obvious if you think that probably you tested using the Developer license and that the Customer’s license has different permission to access to the standard objects.

Create a new Page using the wizard of type List to show all the fields of the system table Permission Range.
Then run it with the Customer’s license and filter for the object in the error message (i.e. TableData 6550)
Permission Ranges
As you can see, this TableData in the Customer’s license has Insert/Modify/Delete permission as Indirect. This means that you CANNOT do those action directly in that table.

Note: Remind that if you are saving the license in the database or you upload a new license you must restart the instance service.

In the meantime you realized (maybe debugging) that the code that caused this error is in a Codeunit. Bingo!!!

You do not have the following permissions on TableData

Open the Codeunit in design and assign in the Properties the correct Permissions to the tables

Did my solution solve your problem? Leave a comment.

“Documents.library-ms” is no longer working

“Documents.library-ms” is no longer working.

Documents.library-ms is no longer working.

Solution 1:

  1. go to Libraries in Windows Explorer
  2. right-click whichever folder gives you an error and select Delete
  3. right-click on the Libraries folder and select Restore Default Libraries

Solution 2:
Restore your system using a previous restore point.

Did my solution solve your problem? Leave a reply.

HOW TO delete VPN connection

In this post I provide you a step by step guide about

HOW TO delete VPN connection

Your VPN connections are installed in the following location:

Control Panel\Network and Internet\Network Connections

To remove/delete one:

  1. go to Control Panel
  2. click the Network and Sharing Center icon
  3. click Change adapter settings on the left panel
  4. right-click on the VPN connection and select Delete

Did my HOW TO help you? Leave a reply.

HOW TO change data for all Companies in NAV

HOW TO change data for all Companies?

You have different ways to complete this task, the choice depends from how many lines or Companies you have. In the following steps I will explain you how to change data for all Companies in C/SIDE using the CHANGECOMPANY Function (Record):

  1. Create a new ProcessingOnly Report using with the System Table 2000000006 – Company as Data Source of a DataItem.
  2. Declare a C/AL Globals Variable of DataType Record with the table that you need.
  3. Insert the following code in the OnAfterGetRecord trigger


    GLSetup.MODIFYALL("Allow Posting From", 010114D); 
    GLSetup.MODIFYALL("Allow Posting To", 310114D);




Here find another reading suggestion, this time in T-SQL: HOW TO run SQL query for multiple companies in NAV database

Did my HOW TO help you? Leave a reply.