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

Considerations:
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.

Causes:
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

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

Did my solution solve your problem? Leave a comment.

SQL Server upgrade from Express

To upgrade SQL Server from Express edition to a different edition of the same version follow the steps:

  1. Insert the SQL Server installation media of the new edition you want upgrade to. From the root folder, double-click Setup.exe.
  2. SQL Server Installation Center click Maintenance, and then select Edition Upgrade.

Did my HOW TO help you? Leave a reply.

HOW TO gain access to local drives in RDP

Often when you are connected to a computer in a Remote Desktop Connection (RDP) you need to have access to your local drives or local files.

HOW TO gain access to local drives in RDP?

  1. Click Start, point to All Programs (or Programs), point to Accessories, point to Communications, and then click Remote Desktop Connection.
    Remote Desktop Connection
  2. Click Show Options and then click the Local Resources tab.
  3. Click More under Local devices and resources.
    Remote Desktop Connection - Local Resources
  4. Select the check box next to Drives (you could select some drives clicking the plus sign to show detail data) then click OK.
    Remote Desktop Connection - Choose local devices and resources
  5. Click the General tab, Type the name of the Computer and the Username (with format Domain\Username) and then click Connect.
  6. Type your Password and then click OK.

Did my HOW TO help you? Leave a reply.

Working with dates in NAV

To work following the standards avoids future issues.

In this post I’d like to suggest a way to convert dates in NAV.

Working with dates in NAV

A date in your system can have different formats depending on the preferences of your country and language.

You can come across different errors, for example Server and Client with different settings or ambiguous date because valid between two different formats (e.g. 05/04/2015 that could be DD/MM/YYYY or MM/DD/YYYY)

To avoid this confusion there is an International Standard that is the standard XML format that returns the date in the following format

YYYY-MM-DD

In NAV you can use the FORMAT Function (Code, Text) with the following declaration:

String := FORMAT(Value[, Length][, FormatStr/FormatNumber])

and using the FormatStr = 9 to return a string in XML format

FORMAT(varDate,0,9);

Note: Leaving the Length = 0 then the entire value is returned.

This example requires that you create the following variables:

Name DataType Subtype
varDate Date

Example:

varDate := DMY2DATE(5,4,2015);
MESSAGE(FORMAT(varDate,0,9));

It will return
Working with dates in NAV

How to convert from a string in XML format back to a field or variable of type Date?

To convert a string in a date in NAV we need to call the EVALUATE Function with the following declaration:

[Ok :=] EVALUATE(Variable, String[, Number])

It’s interesting that also in this function we can use Number = 9 to set that the string expected will be in XML format.

Using the standard XML format you will work in accordance to the standards and the configuration of your Server or Client, language or preference in your system will not affect your work and each date will be converted always in the same manner.

Remind that you can use the same functions and logic working with DateTime.

Did my post help you? Leave a reply.

HOW TO test if a DateFormula variable is empty

We can learn a lot reading Microsoft standard C/AL code.

HOW TO test if a DateFormula variable is empty?

An example is offered in the Table 5088 Profile Questionnaire Line

TESTFIELD("Starting Date Formula",ZeroDateFormula);

Solution:
Create a Global Variable named like ZeroDateFormula of DataType DateFormula and don’t assign any value to it.

Now you can use this variable to test if a DateFormula variable is empty.

IF PeriodLength = ZeroDateFormula THEN
  ERROR(Text001); 

Did my HOW TO help you? Leave a reply.

Microsoft Download Center Download button is missing

You want download a file or software from Microsoft Download Center.

In the Install Instructions section is written:

Download the appropriate file for your computer's processor by clicking one of the links below. You can run the package directly from the link or you can also save it on your local disk to install later.

But you cannot see any link or Download button.

Microsoft Download Center Download button is missing

Solution 1:
Change the URL of the page using https:// rather than http://

Solution 2 (from sam2030):
Download Button Unavailable on Windows Update Web Site

Solution 3 (from Ryan):
Try using Google Chrome

Did my solution solve your problem? Leave a comment.

HOW TO configure SMTP Mail Setup using HOTMAIL

Sometimes for testing purpose could be useful configure the SMTP Server in NAV using your HOTMAIL/LIVE account

HOW TO configure SMTP Mail Setup using HOTMAIL?

HOW TO configure SMTP Mail Setup using HOTMAIL

SMTP Server: smtp.live.com
SMTP Server Port: 25
Authentication: Basic
User ID: your full Hotmail/Live address (e.g. example@hotmail.com or example@live.com)
Password: your Hotmail/Live password
Secure Connection: Yes

Related posts:
HOW TO configure SMTP Mail Setup using GMAIL

Did my HOW TO help you? Leave a reply.