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.
https://www.youtube.com/watch?v=u_nWPvBkU9w
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 →
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 was working with Dynamics NAV in the Web Services page of the RTC. I added some web services, deleted others and then also renamed some of them. No problem, I do that all the time, for demo purposes. But then, suddenly, when I tried to test a web service, by copy/pasting it’s URL … Read More →
Yesterday I attended the Dutch Dynamics Community NAV event. It started with a very interesting keynote presentation by Vincent Nicolas about Engineering @Microsoft & Agile Software Development: After that there were 3 parallel sessions: NAV Performance Testing and Monitoring Tools David Worthington Test Automation Suite in Dynamics NAV 2016 Luc van Vugt PowerBI for Dynamics NAV Steven … Read More →