December 16, 2016
ArcherPoint Dynamics Developer Digest - vol 121
The NAV community, including the ArcherPoint technical staff—is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful. As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
NAV 2016 – Insert Events Not Firing in Codeunit 1Kyle Hardin asks, “Has anyone experienced a problem in NAV 2016 with the Insert events not being fired in codeunit 1? I'm not inserting anything with code (not that it should matter), but I can't get any of these to fire: OnGlobalInsert (legacy) OnDatabaseInsert OnAfterOnGlobalInsert published event, and I am subscribed to that with my own new codeunit I can't get them to work for inserts or modifies. Which looks to me like ChangeLog isn't going to work at all. Any advice? Build 44974, which is CU4. I've been through the fix lists through CU13 for both Application and Platform.” Jon Long suggests restarting the service tier service. Suresh shares a link on how to test your event subscription and Matt suggests running the Event Subscriptions page to ensure they are active. Kyle replies, “I have tried all of the above. Still no success. This is what I did: Build new vanilla VM Install NAVDEMO for 2016 CU13 Create a new codeunit with two functions, both subscribed to Codeunit 1: LOCAL [EventSubscriber] SynchronizeOnGlobalInsert(RecRef : RecordRef) MESSAGE('3'); LOCAL [EventSubscriber] SynchronizeOnDatabaseInsert(RecRef : RecordRef) MESSAGE('4'); That is all I changed. Everything else is out-of-the-box. I get no messages for creating any of these: G/L Account Item Customer Vendor Dimension Value I tried RTC. I tried running the table and inserting that way. I tried insert with code with an INSERT(TRUE). I have restarted the NST. I have rebooted. I have stopped the NST and deleted each and every C# file in ProgramData and the restarted again. Nothing. I checked the subscribed events. Both are there. Then I added message('1') and message('2') to codeunit 1 in OnGlobalInsert and OnDatabaseInsert. I don't get any messages from there either, so this isn't an event problem. In fact, the only time I can get any message is when I add a permission set to a user, or grant new permissions to a permission set. Special tables. I am going to try this same experiment in NAV 2017, but I am stuck in 2016.” Helle Madsen figured it out. You have to actually turn on Change Log for a particular table in order for those triggers in CU1 to fire. The magic appears to happen in the CU1 function GetDatabaseTableTriggerSetup. I haven't taken apart the code, but it looks like it builds a list of "interesting" tables, and if your table isn't in that list, you don't get the insert events to fire. Problem solved!
Dynamics 365Karthik Bharathy shares how to use PowerApps and Dynamics 365 together including how to get a trial version, setting up Odata feeds, and configuring your Odata credentials in his blog, PowerApps and Dynamics 365 for Financials. If you haven’t already, you can view Microsoft’s “first look” video of Dynamics 365 here.
Dynamics NAV 2017ArcherPoint’s Saurav Dhyani shows in this video what’s new in Dynamics NAV 2017 (part 1).
New Microsoft Tools in Office 365Microsoft Teams promises to give Slack a run for their money. Why else would Slack post a snarky letter in response to the Teams announcement? We are hoping it works as advertised. And don’t forget about Microsoft Planner, launched earlier this year. My O365 tiles are becoming quite numerous!
Leadership & CultureHere’s a good read on Netflix culture. Check out their slideshare. Learn how to manage your emotions without fighting them in this HBR article. Want to be kept abreast of what's new in the Microsoft Dynamics NAV community and at ArcherPoint? Subscribe to our monthly newsletter, Better Business, by completing the form in our Resource Center. If you are interested in NAV development, check out our collection of NAV Development Blogs.
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- How to Make Measures Total Correctly in Power BI Tables
- The Microsoft Technology Stack – What It Is and Why You Should Care
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard