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.

MadeiraItemAtt1.jpg

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.

MadeiraItemAtt2.jpg

MadeiraItemAtt3.jpg

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.

Advertisements

Create Items with Item Templates in New NAV and Madeira

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.

MadeiraTemplates.jpg

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.

MadeiraSelectTempolate.jpg

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.

MadeiraRibbon.jpg

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

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:

PG_Purch_Deferr.png

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:

Entries_Purch_Deferr.png

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.