AUTHOR NOTE: 2021-02-10 – There is a Dynamics 365 Business Central Repo showing how to handle this in Business Central. https://github.com/SpareBrainedIdeas/Demo-BigText I’ll try to update the blog with a new post walking through it, but it’s very functionally the same as below: Generally speaking, enabling huge text fields in NAV is bad design because it … Read more
It’s pretty easy to run Microsoft Dynamics NAV (RTC or otherwise) as another user while you’re inside the domain (shift right click on most Windows machines to find a “Run as another user” option, if you did not know). We had a situation come up where, for training purposes, it was necessary to use a … Read more
This is not so much a training document as outlining how I had to troubleshoot a weird error. I think the process taught me a variety of things, so I wanted to share the process of finding the answer. I was trying to setup a new Dynamics NAV 2016 service tier in a test environment … Read more
Since Luc Van Vugt started the NAV Clean Team, I’ve been very lazy and emailing him little things I find. Now that I’m spending more time in NAV 2016, I’ll step up and start being more vocal on Clean Team topics (and perhaps much more, since I’ve not blogged for a year). This one I came … Read more
Last week we discussed how to apply standard formatting codes for currencies and dates to Microsoft Dynamics NAV 2009 RTC reports. As I mentioned in that blog post, there are some hoops we have to jump through in order to show more than one culture’s formats on the same report. In the typical report the … Read more
Microsoft Dynamics NAV 2009 RTC report design using RDLC has a lot of flexibility when formatting dates, times, and numbers. While you can create custom number formatting (which we will cover in a future blog post) many of the standard formatting options will often do the trick far more easily and without requiring the developer … Read more
Take the right color pill with this post about the Matrix control in the RTC Report and how it can help you. But, this topic is not for the novice, so make sure you buckle up. In this post, we’ll talk about how to bring together diverse data into a dynamic table – we’ll use … Read more
The Classic reporting engine and the RTC reporting engine are two very different animals. Hopefully, we can highlight the differences today for some of the deeper topics we’ll cover this week. Microsoft Dynamics NAV classic reports are highly iterative. For example, this Customer/Item Statistics report is a great example: The engine will loop through the … Read more
This is for folks that install Microsoft Dynamics NAV components. I have not confirmed for certain if this is still necessary in 2009 R2, but I’ve seen this multiple times on 2009 and 2009 SP1. If you ever intend to use any SMTP related functionality, such as the NAV Approvals system or the Serenic Navigator … Read more
We ran into a peculiar issue today – a report that kept adding extra pages for no discernible reason. A quick check of the usual community sites didn’t yield a solution, so I thought it was blog-worthy as a topic. In our case, we have a report that is printing a 2nd page with nothing on it … Read more
