View Drilldown Details

The drilldown feature in SourceConnect Management Console displays detailed information for records successfully posted to Central Finance. The drilldown view shows data based on the connection details with the source system without requiring a job run.

Drilldown support is available for EBS, MSFTBC, and D365 source systems. When configuring MAGSW_SOURCE_SYSTEM, ensure that the SOURCE_SYSTEM_ID is set correctly to avoid performance issues. Use the following SOURCE_SYSTEM_ID values for each source system:

Access Drilldown Details

1. In the navigation pane, select the icon, and then select Drilldown. All records loaded to Central Finance from the staging area display.

   

2. Locate the required record by searching for a journal entry or by applying filters. You can save filters to reuse them later or reset them as needed.

   

3. Select the required record to view its details.

Note: If you encounter execution timeout issues when processing large datasets, increase the timeout value using the DrilldownQueryTimeoutInSeconds property in appsettings.

Customize the Drilldown View

You can customize how records display in the drilldown grid:

• Add or remove columns: Use the column chooser to select which columns to display.
• Group columns: Drag column headers to the group panel to organize data by specific fields.
• Save your layout: Save your column configuration, grouping preferences, and filters for future use.

Review Record Details

After selecting a record, review the information in the following tabs:

• Overview: Displays key metrics, document information, and transaction summary with status and variance details.
• Line Items: Shows individual items in the selected record and their details.
• Source vs Target: Provides a comparison of important data points between source and target systems.
• Additional tabs: Depending on the record type (AP, AR, or GL), additional tabs are available.

Customize the Record View

Within each tab, you can:

• Add or remove columns: Use the column chooser to select which columns to display.
• Group columns: Drag column headers to the group panel to organize data by specific fields.
• Refresh data: Select Refresh to view updated information.

Export Drilldown Data

You can export data from both the drilldown grid and individual record screens.

Export from the drilldown grid:

1. In the drilldown grid, select the rows you want to export (up to 500 records).
2. Select Export. An Excel file is generated containing the selected records. Select any journal entry to view its complete details across separate tabs in the workbook.

   

Export from record tabs:

1. Open the required record and navigate to the tab you want to export.
2. To export specific items, select the checkboxes next to the items, and then select the Export selected rows to Excel option under the Export icon.
3. To export all data from the current tab, select the Export all data to Excel option under the Export icon.
4. To export all transaction details across all tabs, use the global export option at the top right of the screen.