Just like with processing of shipments, there are four ways to process receipts of inventory in Microsoft Dynamics NAV. Choosing the most suitable method is important in order to get the software to support the business as efficient as possible. Below is a description of each of the four methods together with some of the pros and cons. If you have read the previous blog post describing processing of shipments then you will notice that there are lots of similarities between the options on the receiving and shipping side, in fact a lot of the functionality just ‘mirrors’ each other. On the...
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)....
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…)
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...
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...
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...
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…)
Here is a small tip (some of you might already know it): the GETURL together with the HYPERLINK can be used to run objects in NAV 2013 (even tables 🙂 ). I am working on a tool to delete records from a database (to ‘clean’ a company from transactional data for example). Part of this tool is a function to view the data in the tables, and for this I needed a way to run a table from the NAV 2013 windows client (not the development environment). This turned out to be quite easy using the GETURL and HYPERLINK functions. (more…)
For those of you that are reading my blog posts you probably know that I have been working on a Shop Floor Terminal role center for Microsoft Dynamics NAV (mostly for my own training, kind of how I learn). I have finally got some time to finish it (was stuck at Tampa airport for 3 hours before a 3 hour flight, more or less an entire work day in transit), so here it is! The concept with the Shop Floor Terminal role center is to provide an interface for a terminal in the production where the operator can see upcoming...
One of the new features in Microsoft Dynamics NAV 2013 is the ability to enter formulas like ‘%me’ and ‘%myitems’ while setting filters. Dynamics NAV then replaces the formula with values while applying the filter. Some of the formulas that comes standard are for example; ‘%me’ and ‘%user’ will be converted in to the USERID, ‘%company’ will be converted into the COMPANYNAME, ‘%myitems’ will be converted into a string with the item numbers you listed in the My Items role center part (same goes for ‘%mycustomers’ and ‘%myvendors’). This is nice but what is great is that you can also...
