True confession: Sometimes, someone asks me to code something in Microsoft Dynamics NAV and it involves some odd things. Things that are so odd that I don’t find any good documentation online about how they work. When this happens, I make a note about it and write a blog entry. Partially for the good of… Continue reading How to Show Notes from a Related Table
Category: Dynamics NAV
Microsoft Dynamics NAV 2009 Classic Client – How to Set Up the Job Queue
I’m often asked to schedule processes in Microsoft Dynamics NAV. This blog explains how to do so in the Classic Client. From MSDN: Job Queues in Dynamics NAV enable you to specify, request, and control when certain processes are run, such as the processing of a report or executing a codeunit. You enter your requests… Continue reading Microsoft Dynamics NAV 2009 Classic Client – How to Set Up the Job Queue
Local Dad Amazes Users with Active Session Table!
Today I had an issue with a customer. They’d run out of user licenses, and it was a mystery as to why. They actually had more concurrent user licenses than they needed, so that wasn’t it. We looked into the Active Session table to see what might be going on. In Microsoft Dynamics NAV 2013,… Continue reading Local Dad Amazes Users with Active Session Table!
CALCSUMS, and SIFT, and Addition! Oh My!
In previous versions of Microsoft Dynamics NAV, if you wanted to add Decimal amounts, you had to either have a SumIndexField defined at the key level so you could use CALCSUM, or you would have to loop through each row and keep a running total. CALCSUMS behavior has been changed in Dynamics NAV 2013 and… Continue reading CALCSUMS, and SIFT, and Addition! Oh My!
How to Use “Item Type” for Non-Stock Items
One of the least known features in Microsoft Dynamics NAV is the “Type” field on the item card. This is a new field that provides some functionality that did not previously exist in NAV. Most of us aren’t aware of this field because you don’t see it on the item card page. You can identify… Continue reading How to Use “Item Type” for Non-Stock Items
Installing NAV 2013 Beta
Finally, NDA has been lifted, and we can FINALLY start sharing what we know about the new version of the product that we all know and love. Well most people actually DON’T know it, which is why we love sharing this with you :). As mentioned earlier this week we’ve been very fortunate to have… Continue reading Installing NAV 2013 Beta
NAV 2013 Beta – OData Introduction
With NAV 2013, Microsoft has added the capability to expose data from your NAV system as OData Web Services. Where that differs from regular Web Services (which in the NAV Server management snap-in is now identified as ‘SOAP Services’), is that OData only exposes data feeds, and within the context of Dynamics NAV is read-only.… Continue reading NAV 2013 Beta – OData Introduction
NAV 2015: Column Indenting and Disabling Interactive Sorting
Microsoft Dynamics NAV 2013 R2 introduced the concept of interactive column sorting on list pages such as Sales Lines or the Chart of Accounts. This is a very handy feature, but at times, an errant click can send the data into a sort that you can’t get back to unless you close the page and… Continue reading NAV 2015: Column Indenting and Disabling Interactive Sorting
Easily Finding a Dimension Set ID in Microsoft Dynamics NAV
With the advent of the Dimension Set feature in Microsoft Dynamics NAV (Navision), it can be tricky to figure out how to change the Dimension Set ID assigned to a record in code or how to assign new dimensions to code. If you don’t know what you’re doing, you’ll spend a few hours writing stuff… Continue reading Easily Finding a Dimension Set ID in Microsoft Dynamics NAV
Dynamics NAV Web Service Error: “Index was outside the bounds of the array.”
Are you having trouble with web services and seeing a message like: “Index was outside the bounds of the array” in the event viewer? Are you using an Extension codeunit (I’ve also heard them called Helper Codeunits) with a published page in web services? If so, there’s a chance that your extension codeunit contains a… Continue reading Dynamics NAV Web Service Error: “Index was outside the bounds of the array.”