The views and opinions expressed in this blog are those solely of the author(s) and do not necessarily reflect Microsoft’s current policy, position, or branding. For official announcements and guidance on Dynamics 365 apps and services, please visit the Microsoft Dynamics 365 Blog.
Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
The NAV/BC 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.
Kyle posts on Yammer: "Has anyone else seen that even if you do Record.Insert(false), Business Central Still fires the OnBeforeInsert and OnAfterInsert triggers?"
Matt T. responds: "That is by design. The event subscribers have a parameter that is passed, named Retrigger. If you only want the code in your subscriber to execute when Insert(true) is called, you need to stick 'If not RunTrigger then exit' at the top of your subscriber."
Kyle is adamant: "This. This is why Yammer attendance should be mandatory. Not only did I learn something important, but Matt fixed my customer problem, too. Keep caring and sharing, mad ArcherPoint peeps..."
Bill W. adds: "If not RunTrigger then exit' should probably be the default based on this Vjeko post on OnTable Event Subscriber Patterns and Antipatterns."
Saurav adds: "In upgrades, when subscribing all table trigger events other than Rename Trigger, developers need to have this line mandatory: 'if not RunTrigger then Exit'. We faced this issue early on with upgrades and also did code corrections for add-on partners to add the first statements when they subscribe to these events."
Faithie asks: "In NAV 2018 is there ANY way to tell who is producing a record lock? One client has them on occasion, and when they do, it becomes a proverbial train wreck! Please and thank you!"
",serif">",sans-serif">Bill W. helps out: “See this",sans-serif"> article on SQL Server Extended Events to Produce a Blocked Process Report. ",sans-serif">You won't be able to see the user, but you'll be able to see the process. Turn on the feature in SSMS. Instead of creating the extended event report, I go to SQL Profiler and choose the ‘blocked process report’. You'll see the SQL statements of the blocking and blocked processes.”
",serif">Ryan provides a helpful tip: “",sans-serif">If you create an .AL report that uses a ",sans-serif">DefaultLayout",sans-serif"> of Microsoft Word, and that report name has spaces, you can't use that same .docx file to import a custom layout in Business Central. ",sans-serif">I created an .AL report with a ",sans-serif">default layout",sans-serif"> of Word, and it created ",sans-serif">my",sans-serif"> .docx for me. I then edited the .docx, built, and published the app. The app was published to the sandbox. Now, I want to make some changes to the Word layout, so I took the original .docx and changed a few things. ",sans-serif">However,",sans-serif"> when I tried to import the layout in the sandbox, I got an error. Here's why:
",sans-serif">When you build the app, it will create the .docx for you, using the report name in the template. ",sans-serif">However,",sans-serif"> when you export a custom layout, it will replace the spaces with underscores. ",sans-serif">It’s",sans-serif"> not a big deal if you remember to export the custom layout first, and then edit it before importing it. I just spent a certain amount of time editing the original one, which now I need to do again (you can't copy and paste the content controls).",sans-serif">”
If you are interested in Dynamics NAV and Business Central development, be sure to see our collection of NAV/BC Development Blogs.
Read the "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.
Business Applications communities