Table of Contents

Drill Down on Functions

Right clicking on certain functions will show a Drill Down option at the bottom of the list. This function makes it easy to see detailed information by segment, subsidiary, period, or transaction lines.

The functions that have Drill Down available include...

  • GLAccountBalance
  • GLAccountDebitBalance
  • GLAccountCreditBalance
  • GLAccountSummaryBalance
  • GLItemQuantity
  • StatAccountAmount

Selecting any Drill Down option will result in a new Excel Worksheet being opened in the current workbook that contains the segregated information just within the bounds of the parameters that were filled in for your selected-upon cell's function.

Note

For the Period Drill Down option, Prior Year's Balance will display on the drill down results for Balance Sheet accounts set to YTD. If an account is set to ITD, all periods will be returned as rows back to inception.

Example

Let's say I'm looking at my GL Account Balance total for my Trade Receivables (1110) account under the consolidated subsidiary. I need to review this account total by Subsidiary.

  1. Right click on the amount (cell)
  2. Select Drill Down > Subsidiary
    1. Drill Down Flow
  3. View new worksheet created called "Subsidiary Drilldown" Subsidiary Drilldown

Let's say, looking at this broken out view of the total trade receivables balance for 2024, I want to further investigate the United States Subsidiary this time by location.

  1. Right click on the amount for the United States Subsidiary
  2. Select Drill Down > Location
  3. View the new worksheet created called "Location Drilldown" Location Drilldown

Now that I have the United States Subsidiary for the Trade Receivables Account broken out by location, I want to view the individual transactions that make up Denver.

  1. Right click on the amount for Denver
  2. Select Drill Down > Transaction Lines
  3. View the new worksheet created called "Transaction Lines" Transaction Lines
Note

At the lowest level of Drill Down, Transaction Lines, the user will be able to click the links to view individual transactions directly inside of NetSuite, making this an effective way to troubleshoot any amount issues that may arise.