Skip to the content


Clever Filters you never knew existed!

Many of you are aware that on your Microsoft 安博电竞 ® NAV role centre you have boxes for “My Customers”, “My Items” and “My Vendors” but did you know that NAV stores the information so you can filter them in other parts of NAV?

You can see on this role centre that there is a box with “My Customers”.

My Customer Role Centre Microsoft 安博电竞 NAV

This list is specific to the user, who can add and remove the customers that they deal with on a regular basis. You can now run a report (the example being Customer/Item Sales) and filter using the %MYCUSTOMERS%.

Customer Item Sales Microsoft 安博电竞 NAV

You can see below the report has only run the customers from my list.

Customer Sales Report 安博电竞 NAV

Now this isn’t restricted to reports. It can also use on a list screen to quickly view your customers.

Customer List Microsoft 安博电竞 NAV

You can now be really clever and click “Show as Chart” in the ribbon and select the measurements and dimensions you wish to see. It has kept the filter of %MYCUSTOMERS% and therefore will only show results based on them. You can then save the chart and add it to the role centre, the example below shows the value of outstanding orders from “My Customers”.

Microsoft 安博电竞 NAV Role Centre Customer Chart

Now there are other filters that work in a similar way.

%MYITEMS% - shows the items you add to the “My Items” list on the role centre.
%MYVENDORS% - shows the vendors you add to the “My Vendors” list on the role centre.

The following % filters are useful for administrators who want to create a chart on everyone’s role centre which returns a view specific to individuals when they run NAV.

%USER% - returns the user ID of the current user.
%COMPANY% - returns the name of the current company.

I hope you have found this useful. We run a range of training courses for 安博电竞 NAV so if you would like to learn more please see our training page .

Tom Hogben

Tom has an extensive background in customer service and management. Having joined DC in November 2014 as the Marketing Manager, he soon increased his responsibilities to working with our customers more directly. 

Partner with the Experts

With over 300 years of combined experience in Microsoft business solutions, our team will help to get you up and running, as well as building a partnership that keeps you supported, all from our UK offices. 

From functionality and licensing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.

飞鱼电竞押注网站 28加拿大记录手机版数据 江湖电竞最新版比赛(江湖电竞投注app网站) 金沙电竞app pc加拿大28计划最稳胆码授权平台 街霸5(上海)查询APP v8.6