Breadcrumbs

Drilldown for MS Dynamics 365 Business Central

Overview

The Velixo NX Drilldown for Business Central feature allows you to view a summary of underlying data for a value returned by a Velixo function.

This article presents an overview of the Drilldown feature specific to the Business Central integration of Velixo NX. For a general overview of the Drilldown feature, visit the Drilldown reference page.

Example

A simple example will demonstrate how easy it is to create a Drilldown.

Let's consider a simple Trial Balance report. First, locate the TOTAL ASSETS account and click on a cell containing a result of a supported balance function (in this example, BC.TURNOVER):

image-20250818-113429.png

To get a Drilldown for this number, click the Drilldown button on the Velixo NX ribbon and then select Drilldown: 

https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153032606225/original/Jugd5b4kWq8SmtEdsErhDPiHIJMWdVK0eA.png?1730857489

Alternatively, you can right-click on the cell on which you wish to perform a Drilldown and select Velixo -> Drilldown.

https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153072160221/original/_09t-KGVR_MiVybIgwrR65SVCvSmg5iBNg.png?1755524915

This opens a new worksheet, which displays summary information for the data on which the Turnover value is based:

image-20250818-113612.png

The Drilldown worksheet

In a Drilldown worksheet, you can quickly navigate to the reference data (perform a second-level Drilldown):

  • Click any of the links in the Source Cell column to return to the original Velixo function.

  • Click any of the links in the Transactions column...

image-20250818-113732.png

... to view relevant transactions in MS Dynamics 365 Business Central:

image-20250818-113956.png

Supported Velixo NX functions


Financial functions: