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 →
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
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:
– 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 →
When entering data in Dynamics NAV, for example in a journal, time is sometimes lost on filtering or looking for the correct Customer, Item, Vendor, … Especially when using a dropdown (table relation). Yesterday I was at a customer site, and they told me that, for example, when entering customers or vendors in a journal, … Read More →
Recently I stumbled upon this blog: http://blogs.msdn.com/b/powerbi/archive/2015/12/18/3-twitter-kpis-to-share-on-your-business-dashboard.aspx It shows how you can export your Twitter analytics and use it as a source in a Power BI Dashboard: The process is very simple. Get Your Twitter Data Go to analytics.twitter.com. You may have to log in to your Twitter account. Click on Tweets in the Twitter … Read More →
In this video I explained how to setup and configure the PowerBI.com Content Package for Microsoft Dynamics NAV 2016. Since then I have received a lot of feedback and questions from the community on how to get it to work with a local NAV 2016 instance. Well, imagine that you have NAV 2016 running on … Read More →