Item Attributes in NAV 2017

How many times you needed some additional attributes on item? And every time you added some new field or something… Now, we will have a small, but smart feature in new NAV2017 – “Item Attributes”. Well, I still cannot say it will be in new NAV for sure, because currently it is a part of Project “Madeira”. But the most of the new features in “Madeira” will be part of NAV2017 and my title is named as you read because of that.

What is Item Attributes? This is something similar to dimensions. We have one additional table with Item Attributes. You can create Attributes as you want. And for each assigned Attribute to Item, you can assign Item Attribute Value (again as you want). You can use a lot of different attributes and everything depends by your needs.

Good thing is when you add your attributes and values to some item, you can see all of them in fact box in the right side of page, on both of them card or list. And even more, you can filter your items based on Item Attributes.

You can choose different attributes and you can use standard filters when you want to use attribute values for filtering (you can easy use “Select More” for this purpose).

All these examples are made on Project “Madeira” and you can do it by yourself using Project “Madeira” demo instance. You can also find more about Item Attributes here.

Create Items with Item Templates in New NAV and Madeira

26/07/2016 atotovic Microsoft Dynamics NAV, SaaS Dynamics, Dynamics 365, Item, Microsoft, Microsoft Dynamics NAV, NAV, NAV Madeira, NAV2017, NAVUG, SaaS, templates

First, this feature is currently published in Project “Madeira” and I’m sure it will be part of NAV 2017, but almost all about NAV 2017 is still by NDA and I cannot write about it.

But this feature is looks fine and I want to share it. When we created new Items we usually used Item Category to preconfigure some fields for item. But now, I think we have a better feature. We can just configure page “Set Up Customer/Vendor/Item Templates” with a lot of data. And that means this feature is not connected only with Items (you notice it right); you can also use this feature as template for other codes.

Now, you can chose one of the templates from list or to create your own template choosing table number to dedicate template to some of the tables. OK, if you want to create Item Template, you will use table 27.

When you open Item template, you can see that now you can configure lot of different fields, as for example:

Base Unit of Measure
Automatic Extended Texts
Type (Inventory or Service)
Price include tax and Price/Profit Calculation with profit and discount groups
Costing Method and Indirect Cost
and Posting groups in Financial Details

But you can do even more, you can open Dimensions command from ribbon and preconfigure dimensions and dimension value and as well as value posting for dimensions (mandatory, same code, no code). And now when you want to create new Item, system will ask you what Item Template you want to use from all enabled templates.

If you want to change something you can later use command “Apply Template” from ribbon to add some template to your item.

If you didn’t use some template or if you changed some details, you can also use command “Save as Template” to save these values as template for some other usage.

Interesting feature and you can use this not only for items. This is more standardized feature in comparison with older versions.

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:

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.

How Deferrals Works in NAV 2016?

09/10/2015 atotovic Microsoft Dynamics NAV Deferrals, GL Account, Item, Microsoft, Microsoft Dynamics NAV, NAV, NAV2016, NAVUG, Resource

I’m sure you already needed it feature and it is possible you already made it as customization in older NAV version (as my company for example). By my opinion it is maybe small, but really necessary feature.

But now we can say, Microsoft is listening us. People from Microsoft really listened us and really made a good job. One of them is using deferrals as new financial feature.

With this new feature, NAV 2016 automatically defers revenues and expenses over a predefined schedule. Finally, we can recognize revenues and expenses in different periods compared with transaction posting period.

It is really easy to use. First we have to set up deferral templates with deferral account, number of period, calculation method, date…

Then, you can configure Default Deferrals Template on G/L Account, Item or Resource (not for Item Charge). In this situation you will use it by default in Purchase Order for example. But if you use e.g. G/L Account without Default Deferrals Template, you can add it on purchase line. You can always see Deferral Schedule from document and change something if you need it.

When you post document, the amount will be posted to the deferral account, and recognized over the defined schedule.

This is very short showing about this awesome feature, but run NAV 2016 and try it. You will see, it is easy and simple for working. Good job Microsoft.