Olof Simren - Dynamics NAV Blog

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 XML Buffer and CSV Buffer tables. The concept is the same, a table with functions to create or read files, this time XML/CSV files instead of Excel files. Just like with the Excel Buffer table, the XML buffer and CSV buffer table should be used as temporary tables. This blog post describes how those tables can be used.…

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 XML Buffer and CSV Buffer tables. The concept is the same, a table with functions to create or read files, this time XML/CSV files instead of Excel files. Just like with the Excel Buffer table, the XML buffer and CSV buffer table should be used as temporary tables. This blog post describes how those tables can be used.…

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 windows client is more or less the same as with version 2016, and I was happy that it could co-exists with all my older installations of NAV (always interesting when installing a new version). Below are some of the new functionality that I have looked into, starting with the parts that I think…

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 windows client is more or less the same as with version 2016, and I was happy that it could co-exists with all my older installations of NAV (always interesting when installing a new version). Below are some of the new functionality that I have looked into, starting with the parts that I think…

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 purchase orders as well, but that’s a topic for another post). But when you post more than you wanted you need to be able to reverse it. Luckily reversing production output and consumption is easy if you know how to do it (if the production order has not been finished that is). This blog post describes how…

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 purchase orders as well, but that’s a topic for another post). But when you post more than you wanted you need to be able to reverse it. Luckily reversing production output and consumption is easy if you know how to do it (if the production order has not been finished that is). This blog post describes how…

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 or to get it repaired. For this they need an authorization, an RMA. So, how is this done in Dynamics NAV? The short answer is by using a sales return order, which is similar to a sales order but it goes the ‘other way’ and is received instead of shipped…

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 or to get it repaired. For this they need an authorization, an RMA. So, how is this done in Dynamics NAV? The short answer is by using a sales return order, which is similar to a sales order but it goes the ‘other way’ and is received instead of shipped…

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 post describing how you can create sales quotes in Dynamics NAV without having a customer record. This is especially useful for companies that are doing a lot of quotes to prospects that might not turn into customers. With this method you then don’t ‘muddy’ the customer list with companies…

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 post describing how you can create sales quotes in Dynamics NAV without having a customer record. This is especially useful for companies that are doing a lot of quotes to prospects that might not turn into customers. With this method you then don’t ‘muddy’ the customer list with companies…