April 15, 2016
ArcherPoint Dynamics NAV Developer Digest - vol 92
The ArcherPoint technical staff—made up of developers, project managers, and consultants – is constantly communicating internally, with the goal of sharing helpful information with one another. As they run into issues and questions, find the answers, and make new discoveries, they post them companywide on Yammer for everyone’s 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 group—so we thought, wouldn’t it be great to share them with the rest of the Microsoft Dynamics NAV Community? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from the ArcherPoint staff. We hope these insights will benefit you, too.
Kyle Hardin on using the Navigate feature in NAV:Silly NAV tip of the day: From the Search box, type the word Navigate. Run Navigate from any of the 1,000,006 choices it presents. From the blank Navigate Page, you can enter a Document No. and then click Find. If you leave the Posting Date blank, it will search through everything looking for that document number – ledger entries, posted documents, whatever.
Saurav Dhyani on retrieving the Current Company in NAV:To get the Current Company Name, NAV has a built-in function: "COMPANYNAME". I was struggling to find out the company name after I used ChangeCompany with Events. But with NAV 2016 a new function has been introduced that returns the company name associated with a Record or RecordRef. The new function is CURRENTCOMPANY. Read more about this function in MSDN: CURRENTCOMPANY Function (Record) CURRENTCOMPANY Function (RecordRef)
Jon Long shared on integrating Dynamics NAV with Office:Looking for ways to integrate NAV and Office? These links may help: Walkthrough: Setting Up Outlook Synchronization Integrating with Microsoft Office
Michael Heydasch shared an article on SQL Server on Linux:In addition to the announcement of the many impressive new capabilities found in SQL Server 2016, comes another unexpected turn from Microsoft: Support on Linux. In a blog by Scott Guthrie, Executive Vice President, Cloud and Enterprise Group at Microsoft, he writes: “Today I’m excited to announce our plans to bring SQL Server to Linux as well. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. We are bringing the core relational database capabilities to preview today, and are targeting availability in mid-2017.” Read the entire blog: Announcing SQL Server on Linux If you are interested in NAV development, check out our collection of NAV Development Blogs. For step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV, see our collection of How-To blogs. If you found this post useful, you might also be interested to read through our archive of the Dynamics NAV Developer Digest.
- 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