This blog post is to describe how fields can be added to the Item Tracking Lines in Microsoft Dynamics NAV. Adding additional fields to this page is a common requirement; it could for example be to add a vendor lot number, some quality measurements, a manufacturing date or any other type of property that should be stored against an inventory lot or serial number. When you first look at it seems like a simple modification but it is actually a bit (or a lot) more involved than just adding the field to the table and the page. The Item Tracking...
One of the cool new features in Microsoft Dynamics NAV 2016 is the options to use Events. Through events you can create functions that are published and subscribe to them in other objects. The great part here is that Microsoft have incorporated a long list of published functions as part of the standard application which can be subscribed to in custom code. This will simplify maintaining and upgrading the objects since modifications can be done completely separated from the standard objects. To demonstrate this new feature I have programmed a simple field level security add-on (maybe add-on is the wrong...
If you have a relative large number of items to plan it could take a while to run the MRP calculations in Microsoft Dynamics NAV, an hour to do a full calculation is not uncommon, especially if you have been using the system for a while. In order to not have the MRP calculations to interrupt with the daily operations (such as posting orders) you typically want the calculations to take place during the night. This is a very common requirement and in fact a lot of people I talk to are surprised that this is not something Dynamics NAV...
Using alternative production BOMs or routings is quite common in a manufacturing environment. It could for example be that larger orders are run in higher capacity machines, versions of products are produced with slight variations in components (like different colors), or you might produce the same item in two different locations and therefor need two different routings. These are just some examples, there are many more scenarios like that where you might need to change the production BOM or routing based on different factors. Microsoft Dynamics NAV allows you to manually change both the routing and production BOM used on...
In one of my previous blog posts about processing shipments I mentioned a batch job I developed many years ago to automatically create warehouse shipments. I have since that post received many requests and questions about this batch job, so here it is! The objects themselves are available in the downloads section and the details about the functionality is described below. I hope you will find this useful. (more…)
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…)
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…)
Microsoft Dynamics NAV has multiple ways in which you can handle scrap in the production. There are scrap related to an operation in the routing, there are scrap related to individual components and there are scrap related to the product being produced. Just like any other functionality, it is important to know all the options when configuring and implementing Dynamics NAV. The scrap related setup has an impact on both the material and capacity planning. If you are using the standard costing method to value your inventory then the scrap related setup also has an impact on the cost roll-up....
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...
A common request is to activate item tracking (lot numbers and/or serials numbers) for items that already have transactions (item ledger entries). In Microsoft Dynamics NAV you can’t really do this without going ‘behind the scenes’ and tweaking the data. What I have done a couple of times is to change the check on the item tracking code to only check for open item ledger entries. This way you can adjust the inventory out, change the item tracking code, and then put the inventory back in with the lot and/or serial numbers. This is a one line code change that...
