In this video I will show you How Do I Use Time Series API in Microsoft Dynamics NAV 2017. You will see how to get an Azure Machine Learning experiment, publish an end point and use the Time Series API to get predictions. In the end we will then use these predictions to create a purchase order.
In this video you will see how to develop a wizard page for html clients.
In this example, we will keep things simple. Let’s imagine that a user wants to send a Sales Quote. For that Sales Quote document to be useful, it must contain their company name and Email address. Let’s create a wizard to guide a user through specifying their company name and Email address, using 5 steps.
In this video you will see how to create beautiful, professional looking email cover letter templates, including images, and invoice information such as totals, due date and payment terms, and use these when sending emails to customers:
Have you heard of Microsoft Flow? No, well then please have a look here: https://flow.microsoft.com You can use it to create automated workflows between apps and services to get notifications, synchronize files, collect data, and more. So, in the context of let’s say Power BI, you can use Flow to synchronize data sources. In this blog … Read More →
When you use Power BI Desktop (or Power Query) to connect to a Dynamics NAV ODATA feed, the URL you pass looks like this: http://thinkaboutit:7048/NAV2016CU6/OData/Company(‘CRONUS%20BELGI%C3%8B%20NV’)/ where thinkaboutit is the server running your service tier, 7048 is the ODATA port and NAV2016CU6 is the Service Tier Instance. Company(‘CRONUS%20BELGI%C3%8B%20NV’)/ means that you are retrieving data from a … Read More →
Today Microsoft announced Microsoft Dynamics 365 and Microsoft AppSource to bring our customers new, modern, enterprise-ready intelligent business apps. See this article here: Turning business process into business advantage for organizations everywhere. Dynamics 365 apps are designed so they can be easily and independently deployed. That means you can start small and pay only for … Read More →
I have been asked this question a couple of times, during Power BI trainings and presentations. For some companies it’s important to know where exactly, in which country, data is stored. Well, in PowerBI.com, you can go to Help, About and find out: And voila, now you know 🙂
SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. This release features: improved compatibility with … Read More →
This video demonstrates how to use CAL query objects to create nested loops in Microsoft Dynamics NAV. … Read More →
This video demonstrates how to perform a select distinct with queries in Microsoft Dynamics NAV. The demonstration covers the following steps: What is a Select Distinct? Create the Query Add more information Select Distinct with Queries in Microsoft Dynamics NAV on Vimeo
Recently I had the honor of presenting a webinar about Power BI and Microsoft Dynamics NAV.
The recording has been uploaded and is available here. Enjoy 😉
And, of course, I would like to thank Mark Brummel for inviting me for this webinar!
This video demonstrates how to implement the activity log pattern in Microsoft Dynamic NAV. The demonstration covers the following steps:
– Record the Activity
– One Centralized View
– Present to the User … Read More →
This video demonstrates how to implement passwords encryption to protect sensitive data in Microsoft Dynamic NAV. The demonstration covers the following steps:
– Encryption
– Masked text
– Single point of access
– Data encapsulation … Read More →
This video demonstrates how to approve an invoice on a phone in Microsoft Dynamics NAV 2016. The demonstration covers the following steps:
– Create the Invoice
– Approve the Invoice … Read More →
Recently someone asked me how to print barcodes in a Dynamics NAV RDLC report. And I hade done something similar, years ago in NAV2009. So I had a look at my code and updated it to NAV 2015. As you can see, it still works: Usually a barcode is no more then a font you … Read More →