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!
Category: Dynamics NAV
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.”
The Magical World of Rectangles in Dynamics NAV RDLC Reports
One of the challenges of report writing in Microsoft Dynamics NAV’s (Navision) Report Definition Language Client (RDLC) reports is creating multiple repeating data sections pulling from a single dataset. The easiest example I can think of comes from sales orders: You want to have your sales order show the sales lines attached to the sales… Continue reading The Magical World of Rectangles in Dynamics NAV RDLC Reports
Dynamics NAV 2015: Confusingly Brilliant Dating using NAV CRM
Having worked in the Microsft Dynamics NAV (Navision) community for more than 12 years, I have seen many changes in the software, but none more confusing, yet strikingly brilliant in its marketing prowess, than the name change to “Dynamics.” Now when I say confusing, I mean confusing in the sense that it is ridiculously confusing… Continue reading Dynamics NAV 2015: Confusingly Brilliant Dating using NAV CRM
On Repurposing NAV Table Fields, or The Forbidden Fruit of Danger
Sometimes, there’s a request to add a new field to a Microsoft Dynamics NAV (Navision) table. You might hear that request and think, “Hey, I don’t need to actually add a new field for that. I can just re-use a totally different field and change the caption and it will be fine. We’re not using… Continue reading On Repurposing NAV Table Fields, or The Forbidden Fruit of Danger