Microsoft Dynamics NAV 2013 R2 Tips and Tricks

Microsoft Dynamics NAV 2013 R2 offers great functionality that can help to make the users life better. This article outlines some simple tips and tricks that will improve your productivity in your everyday use of Microsoft Dynamics NAV.

1)     Sort by Columns

It is now possible to sort by any columns displayed on a page by clicking on the column header. It is also possible to sort by multiple columns by holding the SHIFT button while clicking on the column headers.

matt 010414 pic1









Even the sub-pages (e.g. sales lines) can be sorted. This can be useful when you’ve got an order with hundreds of lines.

mat 010414 pic2

2)      Sub-Page Filter

In the previous Microsoft Dynamics NAV versions, only the headers could be filtered. Microsoft Dynamics NAV 2013 R2 offers you the ability to filter the sub-pages as well.

Clicking on the filter button on the sub-page opens a new window where you can select the filters you want to apply to the sub-page.

matt 010414 pic3















3)      Copy/Paste Rows

Dynamics NAV 2013 R2 now enables you to copy and paste entire rows.

This could be useful on a general journal where you need to have the same lines but with different dimensions.

Simply select the lines you want to copy, right click and select “Copy Rows”.

matt 010414 pic4

Then, right click and select “Paste Rows”.

Once the lines are pasted, you can change the dimension on each new line.

matt 010414 pic5

4)      Select All

Another functionality is the ability to click on the top left corner of a list to select all the lines. Like you would do it in Excel. This is really useful when you need to delete a journal with a lot of lines.

matt 010414 pic6

By Mathieu Kalck, Dynamics NAV Consultant @ EBS.  For more information on Microsoft Dynamics NAV 2013 R2 call EBS on 1300 303 973 or email

Subscribe to the EBS monthly enewsletter to get the latest Microsoft Dynamics NAV, Arrow Financials news and more.  EBS enews.

Evolution Business Systems (EBS) specialises in business management solutions that give you the freedom to focus on your business. Melbourne based EBS does this by automating your core business processes and integrating your specialist business applications to deliver the right financial management solution. With deep expertise in leading financial applications including Microsoft Dynamics NAV and Arrow Financials, EBS works beside clients to ensure their software solves problems rather than creating more. EBS has a detailed implementation strategy that is tailored to customers in terms of timelines, requirements, risks and responsibilities. While it does not sell or support hardware or site network environments, EBS informally partners with selected specialists in these areas to provide clients with a “total solution”.

Contact EBS to find out how we can help you achieve your business goals.  Call EBS on 1300 303 973, email or visit our website to read more.