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 →
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 →
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 →
A few days ago I received the following email from Microsoft: Needless to say I’m really honored and thankfull. I want to express thanks to everyone who helped me since a became involved in the NAV world, now about ten years ago. It’s been a fantastic ride… As a trainer and consultant, I have met … Read More →