ArcherPoint Dynamics NAV Developer Digest - vol 170
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.
Microsoft Dynamics NAV 2018
NAV 2018 has been released and available for download. You will find the various country versions here as well as a plethora of other resources for Dynamics NAV 2018 including this list of system requirements.
Shrink Your Database with this SQL Script
Our friend Mark Brummel shared this on LinkedIn:
When you work a lot with CRONUS databases to test, develop, and train you have noticed that they always have FULL recovery model and it eats up your disk space. This link has a SQL script that changes all user databases to SIMPLE recovery and shrinks the log.
Defining Labels in a Dynamics NAV Report
Kyle notes, “I learned something new today. In a report, you can define Labels which are a quick and dirty way to get text constants into a report layout without having to define Text constants and then add them to the dataset. They show up in Visual Studio as Parameters. See attached screen snaps. They also support multiple languages.”
Figure 1 – Visual Studio Parameters
Figure 2 – Report Label Descriptions
Figure 3 – Development Client View Labels
Suresh responds, “If you are using data item column and want to use that caption then IncludeCaption on the column can be set, which is available in the same Parameters.”
“System.Out Of Memory Exception” Issue on Inventory Valuation Report
Adrian reaches out for assistance: Is anyone aware of any hotfix or solutions to solve the "System.Out Of Memory Exception" issue for the inventory valuation report in NAV 2013 R2? A client has a customized report based on the NAV inventory valuation report and the issue occurs from time to time. The report may work pretty well sometimes, but if the As-Of-Date changes, the report first gives the out-of-memory error and then it is printed with issues (the data is not correct, the title is missing, etc.). Thanks for your help in advance!
KC responds: Have you looked at the dataset for the report? I'm wondering if more lines are being sent to the report and the report is totaling them.
If that is the case, then total the lines in the code and only send the total to the report. That will save memory and increase the speed of the report.
Darren chimes in: Have you reviewed the NAV 2013R2 Cumulative Update summary that Sowkarthika Rajendran published? It would list all the little hotfixes and patches fixed.
Adrian found the hotfix, update rollup 1 for Microsoft Dynamics NAV 2013 R2.
Dynamics NAV 2018 – NAV Easy Security Update
Gwen provides an update for NAV Easy Security:
The NAV 2017 code has been tested and works when compiled in NAV 2018. Field Level and Data Security works in the same manner as before. Mergetool will deliver the permission sets two months after the NAV 2018 release date from Microsoft.
Stay abreast of what is new in the Microsoft Dynamics NAV community and at ArcherPoint by subscribing to our monthly newsletter, Better Business, by completing the form in our Resource Center.
If you are interested in NAV development, be sure to see our collection of NAV Development Blogs.
Read the "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.