NAVBI provides a feature to jump to NAV from the drillthrough-list of certain data models:
NAV 2009 RTC or NAV 2013 will open a filtered list for that document.
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…
…it provides links to each record.
As soon as NAVBI is activated in that file…
…the URL-column may be added to any drillthrough. The details-drillthrough may be called from any Pivot-Table of that file:
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:
A click on the URL-column will open the appropriate customer card:
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.