Blog Posts

Most of us that’s been programming in Dynamics NAV for a while are aware of the Excel Buffer table. It is a super useful table that can be used to create and read Excel files from C/AL code. This table have been around as far as I remember, and now it has some siblings, the […] The post XML Buffer and CSV Buffer Tables first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Microsoft Dynamics NAV 2017 was released last week. I have installed it and poked around in the new functionality a bit and there are some awesome improvements and new features. 🙂 Through this blog post I share some of my thoughts on some of the new functionality. The look and feel when first launching the […] The post Functionality Improvements in NAV 2017 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Production orders in Dynamics NAV allows you to consume both less and more than what’s defined on the components and to output both less and more than what’s defined on the operations in the routing. There is no check when you post, which is nice (sometime I which it was like that on sales and […] The post Reversing Production Output and Consumption first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This blog post is about the return merchandise (or material) authorization process in Microsoft Dynamics NAV, this is another topic that is more or less always discussed during Dynamics NAV implementations. The typical scenario is that a customer calls and wants to return a product that they have purchased to get a refund, replacement product […] The post Return Merchandise Authorization (RMA) first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Do you know that you can create sales quotes without having a customer created in Microsoft Dynamics NAV? It’s been like that as long as I can remember but surprisingly many users and also consultants don’t know this and I have seen lots to workarounds with generic ‘quote customers’, etc. This is a quick blog […] The post Sales Quote without Customer first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

My last post about adding a field to the item tracking lines turned out to be very technical, so this time I am doing a post that is completely without any programming or changes to the application. The topic is parallel routings in Microsoft Dynamics NAV, it is nothing new but something that I get […] The post Parallel Routings first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Add Fields to the Item Tracking Lines first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Field Level Security using Events in Dynamics NAV 2016 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Schedule MRP first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This blog post describes how you activate the ‘Directed Put-away and Pick’ functionality (also known as WMS or advanced warehousing) for an existing location in Microsoft Dynamics NAV. It could for example be that you have been using Dynamics NAV for a couple of years and your business has grown or changed and you want […] The post Activate WMS Functionality for Existing Location first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

The 2016 version of Microsoft Dynamics NAV comes with a new C/AL editor. This is a big step forward for people that are writing code within Microsoft Dynamics NAV. The C/AL editor have, in my mind, always been much behind other code editors in terms of usability, but with the 2016 version Dynamics NAV catches […] The post C/AL Editor in Dynamics NAV 2016 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

One of the new super useful features in Microsoft Dynamics NAV 2016 is the capability to record table data permissions by simply going through the process in the application. For those of you that have been implementing NAV/Navision when the classic client was around are probably familiar with this process since the classic client came […] The post Record Permissions in NAV 2016 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Processing of Receipts first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

When implementing Microsoft Dynamics NAV in a manufacturing environment this question is always discussed; should the time posted against production orders be according to the expected values (e.g. the setup and run times in the routings, sometimes also referred to as nominal values) or should it be according to the actual time (entered by a […] The post Posting of Actual and Expected Production Time first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

I have previously described how production orders are posting into the general ledger which I have received a lot of positive feedback on. This time I will described how assembly orders are posting into the general ledger in Microsoft Dynamics NAV (which is a lot simpler). The assembly orders in Microsoft Dynamics NAV was introduced in […] The post Assembly Order Posting to General Ledger first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Alternative Production BOMs and Routings first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

One of the nicer things about the assembly functionality in Microsoft Dynamics NAV is the option to assemble to order. What this means is that you can stock the components and not assemble them until it is time to ship the order (very useful if you sell kits of products for example). In this blog […] The post Assemble to Order with Inventory Picks and Movements first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Batch Creation of Warehouse Shipments first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Being able to handle consignment inventory in Microsoft Dynamics NAV is a common requirement. There are four scenarios of consignment inventory that I frequently bump into; 1. Inventory at a Customer 2. Inventory at a Vendor 3. Customer Owned Inventory 4. Vendor Owned Inventory Some may argue that case 2 and 3 is not consignment, […] The post Consignment Inventory first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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, […] The post Autofill Variable Name in NAV 2015 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

A way to handle maintenance on machines in Microsoft Dynamics NAV is to create production orders with operations that represent the maintenance. The beauty of this is that you can then include the maintenance when scheduling the production orders, you also maintain history about when the maintenance was done and you have the option to […] The post Maintenance Production Orders first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Processing of Shipments first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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? This is actually quite easy. Dynamics NAV has a feature that allows you to […] The post Block Postings first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Work Centers vs. Machine Centers first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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. […] The post Kill Sessions in Dynamics NAV first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Record Deletion Tool for Dynamics NAV 2015 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 post Run Dynamics NAV as Different User first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Guide to Successful MRP Implementation first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 post Functionality Improvements in NAV 2015 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Write C/AL Code in Excel first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This is the fifth post on my blog related to subcontracting in Microsoft Dynamics NAV. It describes how you can setup and use Dynamics NAV when you are performing subcontracting on behalf of a customer (e.g. if you are a subcontractor for a customer and perform operations on parts belonging to the customer). This is […] The post Subcontracting Part 5: Perform Subcontracting first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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. […] The post Subcontracting Part 4: Warehouse Receipts first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Run Objects in NAV 2013 using GETURL and HYPERLINK first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This is the third post in a series of subcontracting blog posts, and it starting to get a bit tricky. The topic is how to handle transport charges for subcontracting operations. In other words if you have a vendor that handles parts of the production process and you receive an invoice from a shipping agent/transportation […] The post Subcontracting Part 3: Transport Charges first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This describes how to ship components to a subcontractor as part of a subcontracting process in Microsoft Dynamics NAV. It is a frequently asked question, so I thought it deserved its own blog post. As the title indicates, this is a second post in a series of posts related to subcontracting. It might make sense […] The post Subcontracting Part 2: Shipping Components to Subcontractors first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This is the first part of a series of blog posts about the subcontracting functionality in Microsoft Dynamics NAV. It describes how to setup and use the basic functionality, which is something that is very common to use for manufacturers (3 out of 4 places I go to uses some kind of subcontractors to perform […] The post Subcontracting Part 1: The Basics first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Total Cost Allocation for Multiple Outputs first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

With Dynamics NAV 2013 came the assembly management. It is a great addition to the functionality in Dynamics NAV and gives companies with basic assembly operations a simpler option compared to using the manufacturing functionality in NAV. The question when implementing Dynamics NAV is then; when do you recommend the assembly functionality instead of the […] The post Assembly or Manufacturing? first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Scrap in Production first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Shop Floor Terminal Role Center first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This is something I first discovered some months ago, and back then I didn’t think that much about it. Recently someone asked me if it was possible, and I thought it would be worth a quick small blog post. Yes, you can sort on multiple columns in Microsoft Dynamics NAV 2013 (with some limitations though). […] The post Sort on Multiple Columns in Dynamics NAV 2013 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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, […] The post Custom Filter Formula in Dynamics NAV 2013 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

I have never used Microsoft OneNote that much, never really seen a need for it (I usually just have my notes in Word). So, when Microsoft announced that there will be a OneNote integration with Dynamics NAV last year I didn’t think that much about it. But when I finally tried it out myself I […] The post Microsoft OneNote Integration with Dynamics NAV first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Sometimes a customer is also a vendor and sometimes a vendor is also a customer. It can for example be that a customer provides some components for an assembly that they have ordered or a vendor that also orders items from you. Microsoft Dynamics NAV has the option to link a customer with a vendor […] The post Connect a Customer with a Vendor first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

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 […] The post Activate Item Tracking for Items with Ledger Entries first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Here is a small trick that I have used a couple of times to turn the report selections into a selection dialog in Microsoft Dynamics NAV. The report selection table in Dynamics NAV is used to specify what report(s) to run when a user prints a document such as an order confirmation. Part of the […] The post Turn Report Selections into a Selection Dialog first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

The production lead time if you are using routings in Microsoft Dynamics NAV is the sum of the lead times for the operations that each can have 5 different time components; queue time, setup time, run time, wait time and move time. In addition to the production lead time is the safety lead time defined on […] The post Production Lead Time using Routings first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Do you know what the low-level code in Microsoft Dynamics NAV is used for? And do you know how it is maintained? The low-level codes are critical for Dynamics NAV to function properly in a manufacturing environment where material planning takes place (which is in 9 out of 10 places). In addition to this, the […] The post The Low-Level Code first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Here is an example of how to create a custom chart in Microsoft Dynamics NAV 2013 R2 using the business chart control add-in that is provided by the Microsoft.Dynamics.Nav.Client.BusinessChart.dll assembly. It sounds complicated, but it is actually quite easy. The example shows how to create a work center load chart that shows available vs. allocated […] The post Custom Business Chart Add-In Example for NAV 2013 R2 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Here is a super simple, but very useful modification for displaying the rolled-up costs on the item card in Microsoft Dynamics NAV. The item table has 10 standard fields that contain the rolled-up costs that are calculated during a regular standard cost roll-up. Those fields are not by default added to the item card; just adding […] The post Cost Roll-Up Details on the Item Card first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

How Microsoft Dynamics NAV posts into the general ledger from production orders is something that you must know when implementing it in a manufacturing environment. It is critical in order to get the posting groups and their related accounts correctly defined. This blog post will focus on the general ledger accounts and the amounts, for details about […] The post Production Order Posting to General Ledger first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

One of the new reports in Microsoft Dynamics NAV 2013 is the BOM Cost Share Distribution Report that came with the assembly functionality. It is a great looking report, and what makes it even better is that it does not only work with assembled items but also with manufactured items. You find the report in the […] The post BOM Cost Share Distribution Report first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

I thought it would be cool to be able to get the role center parts to interact with each-other in Microsoft Dynamics NAV 2013 R2. I wanted to see if it was possible to have a role center part to display different information based on what was highlighted in another role center part. This way the role center […] The post Interaction Between Role Center Parts in Dynamics NAV 2013 R2 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

In school we where told that when you invoice (voucher) received inventory you get a debit transaction against the inventory account and a credit transaction against the accounts payable. Well, in Microsoft Dynamics NAV you also get two transactions in the P&L, a debit against the purchase account and a credit against the direct cost […] The post Discrepancy Between Purchase and Direct Cost Applied first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Here is an example of how you can create a customized progress bar in Microsoft Dynamics NAV 2013 R2. It uses the System.Drawing.Graphics .net method to draw a progress bar and display it to the user in a BLOB field. This method can basically be used to generate any type of graphic and display it in […] The post Custom Progress Bar in Dynamics NAV 2013 R2 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

In one of my earlier blog posts, Dimensions on Production Orders, I described how the dimensions on the production orders in Microsoft Dynamics NAV gets populated and posted. In that blog post I described that the dimensions on the production order components are inherited from the production order lines and therefor the consumption is posted […] The post Default Dimension Priorities for Production Order Components first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

You can run production in Microsoft Dynamics NAV with only production BOMs and without any routings. A reason for this is typically that you don’t have a requirement to capture capacity costs (labor and overhead) and you don’t want to do any scheduling of work centers or machine centers. This kind of makes sense because you […] The post Simple Production with Generic Backflush Routing first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Some weeks ago I came across a requirement to be able to display GD&T symbols in the windows client of NAV 2013 R2 (as part of a quality control system). It sounded easy since the symbols was generated by a string of regular characters displayed with a special font. In the classic client it would just […] The post Display Symbols and Different Fonts in Dynamics NAV 2013 R2 first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

How do I get the Equisys ZetaDocs add-on to work with the Tectura Document Configurator? There are some tricks to know, but once you know them it is actually easier then making it work with the standard Microsoft Dynamics NAV reports (and less object changes required). ZetaDocs is a document management add-on that among other […] The post Equisys ZetaDocs with Tectura Document Configurator first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

The Change Log in Microsoft Dynamics NAV is used to log inserts, modifications and deletions of records. This is very useful and can be an option for the users to see who created the record, what was the value of a field before, when was the last modification made, etc… If it is going to […] The post View Change Log from Ribbon first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

In the manufacturing part of Microsoft Dynamics NAV there are two Lot Size fields; one is on the item or stockkeeping unit card and the other one is on the routing line. Do you know what they are used for? Here is an explanation for both of them and a trick how one of them […] The post Production Lot Sizes first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Most of us know that you can create production orders from sales orders in Microsoft Dynamics NAV. When doing this the production orders are reserved against the sales order lines and they also inherits the dimensions from the sales order lines. The quantity on the production orders equals the base quantity on the sales order […] The post Create Production Order from Sales Order for Partial Quantity first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This is an old but still relevant topic; on sales documents (quotes, orders, invoices, return orders, etc.) in Microsoft Dynamics NAV you have the option to specify a separate bill-to customer. The bill-to customer is obviously who gets the invoice and where the accounts receivables end up, while the sell-to customer is who you are […] The post Bill-to vs. Sell-to Customer first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Microsoft Dynamics NAV 2013 R2 has a web based help system; this is great since it is now much easier to modify the help to include company specific instructions (gone are the old .chm help files) and users can use their web browser to bookmark the help, etc.. If you want to change the host […] The post NAV 2013 R2 Help Server Host Name first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Items in Microsoft Dynamics NAV can have multiple units of measures, you can for example sell in one unit of measure and purchase in another unit of measure. This is great, but there are some things to be aware of when setting an item up with different unit of measures. An item must have a […] The post Multiple Item Unit of Measures first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

In 2005 I developed a simple barcode system that allowed you to put barcodes on printouts for displaying the documents in Microsoft Dynamics NAV. Initially the system was called ‘Document Lookup’ because it was exactly what it did; you scanned the barcode and Dynamics NAV displayed the form in the client. This barcode system turned […] The post Shop Floor Barcode System first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

From time to time I run into situations where users want to view a filtered list of order lines; it could for example be a list of shipped not invoiced items or a shipping queue showing outstanding items to ship. Most of the menu items in Microsoft Dynamics NAV refer to the order headers and […] The post Add Order Lines to Navigation Pane first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

The dimensions involved in posting production orders are a bit interesting. It is interesting since there is a slight difference between on how they behave compared to other parts of Microsoft Dynamics NAV (like the sales and purchase orders). It can be argued what is right and wrong, but knowing how it works in standard […] The post Dimensions on Production Orders first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

The item charge functionality in Dynamics NAV gives you the option to include additional costs such as freight, insurance, fuel charges, etc. in the unit cost or unit price of an item transaction. Item charges are something that most companies that handles any type of inventory would benefit from using. When implementing item charges there are […] The post Things to Know About Item Charges first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

The MPS/MRP suggestions in the Planning Worksheet has an ‘Accept Action Message’ field that determines if the suggestion should be accepted or not. The value of this field is by default set to TRUE if there are no warnings. This sounds great, by my experience is that most planners would like this to default to […] The post Accept Action Message in Planning Worksheet first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Having additional outputs on production orders (sometimes refereed to as by-products or reclaimed material) is a common requirement. It could be scrap that should go back into inventory for further processing (melting it down, regrinding it, etc…) or it could be multiple products that are produced at the same time in a process. This can […] The post Additional Outputs on Production Orders first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Dynamics NAV has an ‘Inventory Value Zero’ field in the item table that is not visible on the page (for some unknown reason). Adding it to the page allows you to have items with no inventory values, this is useful if you managing inventory on the behalf of someone else or if you want to […] The post Inventory With Zero Value first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

In the demo company from Microsoft (also known as Cronus) the Manufacturing Setup has been configured to use different number series for the different production order statuses. Configuring it this way make Dynamics NAV to assign a new production order number each time the status is changed (except when it is changed to finished). I have […] The post Number Series for Production Orders first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

At Convergence 2014 Microsoft presented the official number of companies using each of their Dynamics products. I thought I would share the numbers on my blog since this tells a lot about how widely used Dynamics NAV is. Have a look at the numbers below, quite impressive. Breakdown of the Microsoft Dynamics customer numbers worldwide by […] The post How Many Companies are Using Dynamics NAV first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

I was debugging something today and I noticed the ‘Break on Records Changes’ break rule, sweet… 🙂 I didn’t know this. In the older versions of Dynamics NAV I always used the code coverage to find where in the code records are modified, but this is much better. Here is how to do it; start […] The post Debugger Break Rules – Break on Records Changes first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

I have meet many experience Dynamics NAV consultants and end users that did not know that it was possible to revalue closed item ledger entries in Dynamics NAV. Most of them had used the ‘Calculate Inventory Value’ function in the Revaluation Journal and since it only brings in open transactions the assumption was that it […] The post Revalue Closed Item Ledger Entries first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Can Dynamics NAV handle statistical (unit) accounts in the General Ledger? Yes, it can! Although there is nothing in Dynamics NAV called statistical accounts, so the main thing is to make sure you are not mixing them into the regular g/l accounts. The way it can be set up is to use a prefix like […] The post Statistical Accounts in General Ledger first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

Dimensions are great in Dynamics NAV and one of the things that makes it great is that you can control the required dimensions for each type of posting into the general ledger by setting dimensions as mandatory on the general ledger accounts. Most people that work with Dynamics NAV knows this. But surprisingly many people […] The post Mandatory Dimensions by Account Type first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

From time to time I see users struggling with a list of warehouse receipts, the question is then ‘how can I find the warehouse receipt I am looking for?’. Well, you make it too complicated. A warehouse receipt should be created at the time of receiving not before that. If you create your warehouse receipts […] The post How to Work with Warehouse Receipts first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

An old but still relevant topic is the different flushing methods you can use in Dynamics NAV. Flushing basically means that you can have NAV to automatically post consumption and/or output/time based on expected quantities. The flushing could either be forward or backward. With forward flushing the posting occur during the release of the production […] The post Flushing Methods first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.

This is my very first post on this blog, my goal is to post new stuff frequently to keep it updated and interesting. Feel free to contact me or to comment on any of my posts. The post First Post on My New Blog first appeared on Olof Simren - Microsoft Dynamics NAV & 365 Business Central Blog.