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…)
By accident I discovered something quite interesting last week and I thought it was worth sharing it through a blog post. When you create an object type variable in Microsoft Dynamics NAV 2015 and you leave out the name then NAV will automatically suggest the name based on the subtype. So, when creating variables that are forms, records, reports, xmlports, etc. then there is no need to enter a variable name anymore. Nice! 🙂 Here is how it works; (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…)
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...
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…)
This is the fourth post related to subcontracting in Dynamics NAV. The topic is how to use warehouse receipts together with subcontracting purchase orders (previous parts are here: Part 1, Part 2, Part 3). It is a quite common requirement to be able to use the warehouse receipts to process receipts of subcontracting purchase orders. It could for example be that your location is setup to use the ‘Directed Put-Away and Pick’ (sometimes referred to as advanced warehousing) and therefore you are required to use the warehouse receipts or it could simply be that the warehouse receipts are used standalone...
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…)
To allocate the total costs posted against a production order towards multiple outputs is a bit tricky in standard Microsoft Dynamics NAV, you more or less have to manually separate the different costs and post them against each of the production order lines (this since the cost calculations in Dynamics NAV is per production order line). For material and capacity costs this involves dividing the quantities consumed and times spent between the production order lines and then post them individually against each of the lines. And for subcontracting costs it is more or less impossible (although nothing is impossible in...
