I know, officially it’s Dynamics NAV, but honestly, is there anyone in the real world that doesn’t still call it Navision? Anyway, this post is not about naming, it’s about Power. Yes, these days the new buzzword seems to be power. PowerView, PowerShell and PowerPivot to be more precise. [Ah, and PowerPoint, but that’s not … Read More →
The latest weeks I have received a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ‘$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You … Read More →
What if a user asks: Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. 🙂 In the ‘old’ days … Read More →
Recently I had to change the list of available fields in a DropDown box on a page. As you might already know, a DropDown is a result of a field having a TableRelation. For example, on a Sales Order page there’s a field “Sell to Customer No.“. This field has a table-relation towards the Customer table and as a … Read More →