Custom bi-directional Microsoft Dynamics 365 Integration for Lookup Tables: a practical example.

It could be considered quite a typical request to integrate a custom supplemental table (Dynamics 365 for Sales Lookup table) in Dynamics NAV when dealing with integration projects. The scope of this blog post is to provide a general guidance at high-level which are the tasks to accomplish to be successful in achieve this goal….


Working with WordWaiter class with Microsoft Dynamics NAV

SinceDynamics NAV 2017 Cumulative Update 13 – and also in Dynamics NAV 2018 – the Office Integration experience has been enriched by a new interop assembly to handle non-modal calls to Microsoft Word and retrieve document close events. The .NET Type added to Microsoft.Dynamics.Nav.Integration.Office DLL are the following: Microsoft.Dynamics.Nav.Integration.Office.Word.WordDocumentWaiter Microsoft.Dynamics.Nav.Integration.Office.Word.WordDocumentWaiter+DocumentCloseHandlerEventArgs A typical example where this…


QR Code with Microsoft Dynamics NAV App

An interesting extension of the Microsoft Dynamics NAV Phone app has to do with the ability to retrieve pictures using the device camera, where available. This feature is duly described in MSDN: How to: Implement the Camera in C/AL If you would like, then, to scan QR codes and Data Matrix in order to have…


Coffee Break: NAVDiag

In the previous two posts, Automation Part 1 and Part 2, we talked about how to easily bring PowerShell into Dynamics NAV. Based on the applicability and interest shown so far we wanted to continue on the previous thread and address some of the suggestions we received, as well as add some functionality. We called the…


Coffee Break: Automate it, part 2

This is a continuation of our previous post, with further examples of how to utilize Windows PowerShell from Dynamics NAV. The samples provided here just demonstrate how easy it can be to integrate the two, so you can build on this using any of the great (Dynamics NAV) PowerShell tools out there from a familiar development environment….


Coffee Break: Automate it!

The Coffee Break Team is back, and this time we will unite the best of the two worlds and show how we can utilize the power of Windows PowerShell, using your favorite application: Dynamics NAV. While we do recognize that scripting complex PowerShell tools and modules is not to everyone’s taste, C/AL is something we…

New TimeStamp fields in Microsoft Dynamics NAV 2016

In Dynamics NAV 2016, you may have noticed that a new field has shown up in the development environment: Timestamp. We mentioned this in the What’s New topic in the MSDN Library, but here is a bit of background. Since the first version of the SQL Server option for Dynamics NAV, every Dynamics NAV table has…

Design Pattern: Data-driven Blocked Entity

This pattern implements a generic mechanism for dynamically restricting and allowing usage of a record by the business process administrator. Problem A Dynamics NAV record can be used in a number of functionalities across the application. There are situations, however, when the administrator wants to restrict the consumption of such a record, as well as…


Design Pattern: Observer

Microsoft Dynamics NAV has the built in ability to track all record changes against any table, however it does not always fire the triggers for every table. But with the Observer pattern, you can track all record changes against a defined table or set of tables. This pattern is a good example of how classic…


NAV Design Pattern: Activity Log

The Activity Log pattern tracks execution of activities. This is a Dynamics NAV specific implementation of the generic Audit Log pattern. In general, integrating with external systems can be very challenging, due to the complexity of the situation – connectivity issues, asynchronous operations, user errors, etc. These challenges require sometimes re-trying several times, polling the…