Posting Groups in Assembly Order in NAV

In my previous articles about using of posting groups in Dynamics NAV, I didn’t describe using of posting groups in Assembly Orders. Assembly Orders are here in the few last versions of NAV and I want to show them as well.

Using of Assembly Orders is not so complex and we can use only Items on header and Items and Resources in lines. Because of that, we can use only Inventory Setup and General Posting Setup. You can see the flow chart with description of usage these posting groups:

When we post one Assembly Order, we will get the following G/L Entries:

Posting Groups in Service Management with Warranty

18/02/201618/02/2016 atotovic Microsoft Dynamics NAV Dynamics, Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, NAV, NAV 2015, NAV2016, NAVUG, service, Service Management, Service Order, warranty

I’ve already show how looks like using of posting groups in Service Management in NAV, but when you use Service Item with currently active Warranty, there are some differences. Generally, system will use Line Discounts configured on Service Item as Warranty % for “parts” and “labor”. If you have 100% warranty, posting will be as the following:

System posted inventory cost for all item line based on costing type. But for each line (Item, Resource…) system posts sales line amount and the discount with the same value.

But, when you have warranty with the less percentage than 100%, it will be a bit difference. System will post item cost again, but for each line, system posts sales line amount, discount and value as difference between sales amount and discount:

Posting Groups in Service Management in NAV

15/02/2016 atotovic Microsoft Dynamics NAV Dynamics, entries, flowchart, Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, NAV, NAV 2015, NAV2016, NAVUG, Posting, Posting Group, service, Service Management, Service Order

I’ve already wrote 27 articles about using of Posting Groups in NAV. Now, I’ll continue this series with the new topic – Service. When we use Service Order, all posting will be based on the following flow-chart:

You can notice, this is very similar with postings in Sales, but we have some specifics about using of additional fees. But if you look at the part based on Service Lines, everything is the same. I want to accent that this part is drawn for items ()because of usage Inventory Posting Group and Location); if you use G/L Account or Resource, there will not be inventory postings.

Now, let look at the posting results. First, if we decide to post “Ship and Consume” from Service Line, that means these lines have been used for servicing but cannot be included in the invoice to the customer and we will have only inventory postings if we used items (in other cases, we will not have anything for posting):

But if we decide to post “Ship and Invoice” from Service Line, the result will be different. In this case, we have some additional entries except inventory posting:

And on the end, we need to finish posting from Service Order. If we have not some additional fees for invoicing, it will not be anything for posting, but if we have additional fees, it looks the same (for “Ship and Consume” and “Ship and Invoice” examples):

MS SQL is a Global ODBMS Leader

10/02/2016 atotovic Azure, Microsoft Dynamics NAV, Power BI, SQL Azure SQL, CRM, DBMS, Dynamics, ERP, Gartner, Magic Quadrant, Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, NAV, NAV2016, NAVUG, ODBMS, Power BI, Quadrant, RDBMS, SQL, SQL Server, survey

A few days ago, I’ve wrote about place of Power BI in Gartner survey about BI & Analytics solutions. Power BI was a global leader on Gartner Magic Quadrant. Now, we have new Gartner story about Operational Database Management Systems. For the first time, MS SQL is an absolutely leader and on better position in comparison with Oracle database.

The operational database management system (DBMS) market is concerned with relational and nonrelational database management products suitable for a broad range of enterprise-level transactional applications. These include purchased business applications, such as those for ERP, CRM, catalog management and security event management, and custom transactional systems built by organizations’ own development teams. Also included in Gartner’s definition of this market are DBMS products that support interactions and observations as new types of transaction. (from Gartner)

Microsoft deserves this position because they market its SQL Server DBMS for the operational DBMS market, as well as the Microsoft Azure SQL Database (a DBMS platform as a service), and the NoSQL DBMSs Microsoft Azure DocumentDB and Azure Tables.

It is very important that Microsoft continue with working on enterprise SQL Servers and on Azure SQL as well. And finally about NAV. Microsoft Dynamics NAV (from NAV 2016) works on both of these SQL versions and I think this cooperation between strong database and ERP solution will continue to deliver amazing business solutions.

New Dynamics Exams – finally

09/02/2016 atotovic Certification, Microsoft Dynamics NAV Dynamics, Dynamicspro, dynamicspro.org, exam, exams, GP, Microsoft, Microsoft Dynamics, Microsoft Dynamics GP, Microsoft Dynamics NAV, NAV, NAV 2015, NAV2016, NAVUG

Finally we’ve started with Dynamics Exams. Currently, there are following exams available:

NAV Core Application Setup Certification
GP Core Financial Setup & Functionality Certification
GP Core Installation & Configuration Certification

As you seen, currently there are only three exams, but we will get new NAV exams in Q2 2016:

NAV Core Installation & Configuration Certification
NAV Core Development Certification

All these exams are prepared by Association of Dynamics Professionals. The vision of the Association of Dynamics Professionals (DynamicsPro) is that every Dynamics professional recognizes and adheres to high quality and certification standards for all Microsoft Dynamics products. I am part of this project and I think these exams are really good way to approve your knowledge and recognition. I know other people who are involved in these exams preparation and I strongly believe in this. Exams were written by people who know what it takes to have a successful project. They will help consultants deliver excellent service and ensure they meet professional quality standards.

Beginning this month – February, exams will be available on many different location in US and finally in Europe. You can register for exams here. Please take a look and register for the next exam in your area. If you don’t see something in your area, check back often, as DynamicsPro will be adding new exam dates and locations regularly.

Thea are currently available on the following locations, based on the next schedule:

Tuesday, February 23, 2016: Houston, Minneapolis, New York, Phoenix
Wednesday, March 2, 2016: Atlanta
Thursday, March 10, 2016: Las Vegas
Tuesday, March 15, 2016: Washington, DC
Tuesday, March 22, 2016: Minneapolis, Phoenix
Tuesday, March 29, 2016: Netherlands
Tuesday, April 5, 2016: Midlands, England
Thursday, April 7, 2016: Tampa
Tuesday, June 7, 2016: Chicago

You can expect on more location soon. Online exam delivery has been delayed, but it will be available in the future. Be among the first in the industry to prove your knowledge and skills on the latest versions of Microsoft Dynamics NAV and GP through this new certification program.

February Cumulative Updates for NAV

05/02/2016 atotovic Microsoft Dynamics NAV Application, Build, CU, Dynamics, hotfix, Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, NAV, NAV 2015, NAV2013, NAV2013R2, NAV2016, NAVUG, Platform

Today, Microsoft has been released a new Cumulative Updates for the following NAV versions:

You can download all of these Cumulative Updates from the previous links. Of course, as we already expected, the most platform and application hotfixes are intended for the newer NAV versions. For example, NAV 2013 has only one Application hotfix and two Platform hotfixes; and few local hotfixes as well. NAV 2013 R2 has some more Application and Platform hotfixes, but there are still just few.

NAV 2016 and NAV 2015 again have some common hotfixes as:
Ways to split Sync-NAVTenant into multiple transactions
The Dynamics NAV client crashes if you filter on @*
You cannot copy a company to another tenant
Cannot export to Excel from the web client if the relevant page has the SourceTableTemporary property set to Yes
Invoke-NAVCodeunit always runs in the Dynamics NAV client time zone
…

There are a lot of interesting hotfixes and you can see all details on previous links.

Posting Groups #27 – Deferrals in Sales

03/02/201603/02/2016 atotovic Microsoft Dynamics NAV Deferrals, Dynamics, entries, Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, NAV, NAV2016, NAVUG, Posting, Posting Group, Sales

Few days ago I’ve published how you can use Posting Groups in Microsoft Dynamics NAV 2016 when you have purchase where you use Deferrals. Now, I want to show you how it looks like when you use Deferrals in sales process. In my old post, you can find everything about using Posting Groups in standard sales process. Now, I’ll show difference. One of the main difference is that system doesn’t use inventory posting groups when posts sales invoice (the same as in purchase scenario).

In the following chart, you can understand how system uses Posting Groups when we have deferrals on Sales document:

When we post document and get Posted Sales Invoice, we will get the following G/L Entries. You can find completely description of them in the next table:

When you use Items and Resources, system will use Sales Account from General Posting Setup, but if you use G/L Account in the sales line, system will use this G/L Account you typed.

You can notice that we have more line amounts. Number of lines is based on number of period defined in Deferral Template. For each period, we have two lines (positive and negative). We have always first period lines, but other period lines are behind all entries, because they have not the same posting date. Their posting date is based on setup in Deferral Template.

And I’ve forgot one things in the last post. If you want to see all lines using Navigate, you have to delete Posting Date in Navigate page or if you didn’t it, you have to delete Posting Date from filters in General Ledger Entry.

Posting Groups #26 – Deferrals in Purchase

01/02/201601/02/2016 atotovic Microsoft Dynamics NAV chart, Deferrals, Dynamics, entries, GL, Item, Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, NAV, NAV2016, NAVUG, Posting, Posting Group

Last year I had a series of articles about using Posting Groups in Microsoft Dynamics NAV. Now, I want to continue with some small updates.

I already wrote about using Posting Groups in purchasing process, but now I want to add a model when we use Deferrals (a very nice new feature in NAV 2016). In this case, we have some differences compared with a standard posting. System will use some different rules about Posting Groups (you can check standard purchase posting model here). In the following chart, you can understand how system uses Posting Groups when we have deferrals on Purchase document:

When we post document and get purchase posted invoice, we will get the following G/L Entries. You can find completely description of them in the next table:

Events in NAV 2016

28/01/201629/01/2016 atotovic Microsoft Dynamics NAV CRM Online, Dynamics, Eventing, Microsoft, Microsoft Dynamics NAV, NAV, NAV2016, NAVUG, workflow

Eventing is one of the most important new features in NAV 2016. We can use them to design the application to react to specific actions and to enable separating customized functionality from the application business logic. By default, in NAV 2016 system uses Events for workflow and Microsoft Dynamics CRM integration, but we are not limited only on these.

In this article, I want to refer you to many different videos and blogs made by very experienced people:

Mohana’s Dynamics NAV Blog:

Waldo’s Blog:

NAV 2016 Eventing: All published Integration and Business events

Brummel Blog:

NAV 2016 | Hooks vs. Events

Dynamics NAV Team Blog:

Integration Events in Microsoft Dynamics NAV 2016

Magno’s Blog:

VMs in New Azure Portal

16/01/2016 atotovic Azure, Microsoft Dynamics NAV API, Azure, Dynamics, Microsoft, Microsoft Dynamics NAV, NAV, NAVUG, portal, PowerShell, VM

I’ve already wrote about new Microsoft Azure Portal code named Ibiza. When you look this new portal, one of the first news in that now we have two menus for virtual machines:

Virtual Machines
Virtual Machines (classic)

You will see that all virtual machines you already created using old Azure Portal are placed in Virtual Machines (classic). I want to give you a small descriptions about difference between these two options.

The new Azure Resource Manager with a new API doesn’t uses resources as the old API. Because of that, the classic API stack is still operational, but you’ll see those resources showed up as (classic). You have not a reason to convert classic VM to the new VM. You just need to know that you cannot include classic VM in a virtual network deployed with Resource Manager and they don’t have to be included in a virtual network (unless new VMs must be included).

But if you want to migrate classic VM to the newer model, first you have to be sure you can afford a downtime for your VM. If you can afford it, than you can do it using ASM2ARM PowerShell script. You can find all details here.

I hope, I helped you. I have some more information about it and I’ll prepare a real interesting example soon.