Processing of Shipments
There are four ways to process shipments of inventory in Microsoft Dynamics NAV. Which way to choose depends on the business requirements and what processes that are most suitable. I typically discuss the different options early in the analysis phase of an implementation to establish the preferred method as soon as possible (if it is not obvious which one to apply that is). It is important to get it right early since the procedures, work instructions, potentially modifications and printouts all will depend on the method chosen (and you don’t want to change your mind half way through the project)....Block Postings
This might be 'the oldest trick in the book’ but it is still a frequently asked question and therefor I thought it was worth a small blog post. The question is how do you block/prevent users from posting something in Microsoft Dynamics NAV? (more…)Work Centers vs. Machine Centers
A topic that is discussed on all manufacturing implementations is Work Centers vs. Machine Centers. Questions like ‘should we be using machine centers?’ and ‘what are the differences?’ are always raised and discussed. It is very important to understand the differences and how to apply the functionality in Microsoft Dynamics NAV. I have seen several installations where the setup has been much more complicated than it needed to be and therefor the system became hard to work with. I have also seen cases where standard functionality that could have added lots of value was not utilized and even modifications being...Kill Sessions in Dynamics NAV
In the older versions of Microsoft Dynamics NAV where the classic client was available you could go to the sessions table and just delete a session to kill it. This was very useful for a number of reasons but it does not work like that anymore in the windows client of version 2013 and 2015. Fortunately this feature can easily be replicated by adding an action item to the ribbon on the sessions page in Dynamics NAV. Here is how you can add a ‘Kill Session’ action item to the sessions page: (more…)Record Deletion Tool for Dynamics NAV 2015
Several people that have read my previous post, Run Objects in NAV 2013 using GETURL, has asked me about the record deletion tool that I was working on. So, here it is! :-) It is available for NAV 2015 on the downloads page. This data deletion tool is useful if you want to ‘clean’ a company from transactional data. It could for example be that you have been testing transactions in a company that you want to use for a go-live or you just want to have a clean company without transactions for a demo, training or testing session. Here is...Run Dynamics NAV as Different User
A question that I receive frequently is; 'how do I run Dynamics NAV as a different user?'. A basic question it seems, but not everybody is aware of how it can be done. It could for example be that you are testing permissions and you want to run one client with SUPER user access to do the permission setup and another client with limited access to test the setup at the same time. Another common scenario is that you want to debug something on a users computer and for this you need your own log-in to have full permission and access...Guide to Successful MRP Implementation
Implementing MRP (material requirements planning) successfully in Microsoft Dynamics NAV is one of the more complex tasks. There are lots of moving parts and to make it work in an efficient way you not only need to know Dynamics NAV and the theories behind MRP but also the product structures and how the business wants to operate. This is my guide to how to make it work, it is based on my experience and how I normally approach MRP. It does not guide or dictate how you should setup NAV, just some guidance on how to get there (I guess...Functionality Improvements in NAV 2015
Microsoft Dynamics NAV 2015 was released a couple of weeks ago. I have download and installed it and so far it seems like it can co-exist with Dynamics NAV 2013 R2 without any issues (which was not the case with my 2013 and 2013 R2 versions, so this is great). To me the improvements that the users will see (e.g. the functionality in the NAV clients) are the most important ones (and also the most fun to review). The improvements of the technology behind the scenes (such as OAuth support for web services, merge utilities, multi-tenant architecture, etc.) are also important...Write C/AL Code in Excel
This is something that I did some days ago and I thought it was creative enough to be worth a blog post. The task was to do a onetime mass update to the item records. There were more than 85.000 items in the company and they all had two production bin fields that needed to be updated according to a table with some rules provided in Excel. For items starting with ’10’ the two fields should be ‘RAW’ and ‘RAW’, for items starting with ‘11’ the two fields should be ‘TREATED’ and ‘CUT’, etc. like the below table, nothing strange. (more…)My Dynamics NAV Partner
