← All posts

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

New in NAVBI: jump from any pivot table straight to the matching record in NAV — not only from prepared drillthrough lists.

Archive post from 2014. It describes Dynamics NAV and the Microsoft BI tools of that time; Dynamics 365 Business Central and today’s Power BI differ in places.

NAVBI provides a feature to jump to NAV from the drillthrough-list of certain data models:

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

NAV 2009 RTC or NAV 2013 will open a filtered list for that document.

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

We extended this feature in our current NAVBI-release to allow links to any NAV-Page. We are using NAV 2013 R2’s GETURL-function to give Power Pivot the information about the link to NAV. How does it work?

NAV 2013 R2 introduced a new function GETURL. When added to any page such as the customer list page…

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

…it provides links to each record.

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

In any Power Pivot file that was created for that OData-Source (see examples here and here) we just need to import the OData-Feed of that page:

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

As soon as NAVBI is activated in that file…

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

…the URL-column may be added to any drillthrough. The details-drillthrough may be called from any Pivot-Table of that file:

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

Calling the details-function from the context menu will open a window with all details records – in my case of all transactions of customers with Country Region Code DE since the drillthrough was initiated from the amount for DE-customers:

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

A click on the URL-column will open the appropriate customer card:

New feature of NAVBI - jump into NAV 2013 R2 from any Pivot-table

Depending on the business question, a link back to the item card, vendor, sales order or any other NAV-page would be possible. It would just be necessary to add the URL-column to the pages that are used as OData-Sources.

Next postHow to create reports in Dynamics NAV across companies?

Questions on this topic?

Get in touch — we are happy to share what we know, beyond the blog too.

Get in touch