Apparently you have to turn off the property “Load User Profile” in the IIS application pool manually or you will be given the following error message:
Error accessing Website Microsoft Dynamics NAV 2017 Web Client
Type: Microsoft.Dynamics.Nav.Types.NavSecurityNegotiationException
Message: The Service Principal Name (Delegation) configuration has been set incorrectly. Server connect URL: “net.tcp://localhost:7046/DynamicsNAV365/Service”. SPN Identity: “DynamicsNAV/localhost:7046”
The X.509 certificate CN=XXXX, OU=PositiveSSL, OU=Domain Control Validated is not in the trusted people store. The X.509 certificate CN=XXXX, OU=PositiveSSL, OU=Domain Control Validated chain building failed. The certificate that was used has a trust chain that cannot be verified. Replace the certificate or change the certificateValidationMode. The revocation function was unable to check revocation because the revocation server was offline.
Read the rest of this entry »
Tags: Dynamics NAV, Error, Microsoft Dynamics NAV, Microsoft Dynamics NAV 2017, Web Client, Windows Server 2016
I have previously written a blog post (Dynamics NAV Reports (RDLC): SetData, GetData And Line Numbers) that explains how to easier see which number a certain data has in the setdata/getdata functions by using Visual Studio and line numbers. Unfortunately the most guides on the net that deals with getdata/setdata functions takes for granted that you are using Visual Studio with document outline but sometimes that choice isn’t available. Hopefully after this blog post you will find it easier to find the setdata/getdata functions in the report, know where to add a new field. If you only want to see which number a certain field has. Scroll to the bottom and you will find a list of the fields and numbers.
Read the rest of this entry »
Tags: Dynamics NAV, Microsoft Dynamics NAV, Repo, Reports
In Dynamics NAV reports we use SetData and GetData functions to retrieve data certain data in page headers and footers due to different scopes. In this blog post I’m not going to explain why and how but I’m going to give links to some good posts that does it at the bottom this post. Instead I’m going to give you a tip on how to make the process of adding/finding which data that has a certain index in the SetData function call by using line numbers.
Read the rest of this entry »
Tags: Microsoft Dynamics NAV, NAV, RDLC, Reports, Tips & Tricks, Visual Studio
In the classic version we could run tables straight from the object designer and the object designer was always included in the client. In the Role Tailored Client (RTC) however we don’t have an object designer. Instead it is located in the developement environment. But sometimes you need to run a table but you don’t have access to the development environment (end user computer, ClickOnce and so on..).
So what to do then?
Read the rest of this entry »
Tags: Dynamics NAV, Microsoft Dynamics NAV, Tips & Tricks
The last couple of years I have started to use an new trick to make my everyday life with Dynamics NAV easier.
Usually I have the problems like this:
- How do I easy see all the locations of a certain field name in the database?
- How can I quick look up a datatype for a certain field?
- How can I quick see if a field is a flowfield?
- How can I search on database fields using captions?
For me the solution became to make a page on the virtual table field (How to: Create a Page to View a Virtual Table).This is real handy when you have an addon table with 355 fields were the captions don’t really match the field names.
Read the rest of this entry »
Tags: Dynamics NAV, Microsoft Dynamics NAV, Virtual Table
You can export data from tables to XML by using XMLPorts. But you can also use XMLPorts to export data from temporary tables.
The principle is to set the Temporary property on the table line and then create a function in XMLPort that inserts all the data into the temporary record.
Read the rest of this entry »
Tags: Microsoft Dynamics NAV, NAV, XMLPort
NAVfreak 