I’ve been watching companies buy expensive third-party mobile applications for Business Central for years now, and I keep asking myself: why? I get it—old habits die hard. For decades, if you wanted warehouse staff scanning barcodes or shop floor workers capturing production data on a tablet, you had to buy something from an ISV. That’s just how it was. But somewhere around Business Central version 23, that stopped being true. Microsoft gave us native barcode scanning, tablet support, and AL extensibility in the standard mobile app—and most people are still acting like it’s 2015. I just came back from the...
10+ years ago I created a Record Deletion tool for Dynamics NAV that I published here on my blog. It was a tool that could be used to clean up test transactions in a company in Dynamics NAV, and it quickly became very popular. People have reach out to about getting this tool available for Business Central (I also think some have done the work of converting this tool into a BC extension themselves). So here we go; it is now available via AppSource and can be accessed for FREE here: Record Deletion Tool for Business Central The functionality is...
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....
