Drill Down to Journal per Account(s)

Spreadsheet Server allows drilling down to journals from detail account balances, or directly from a GXL formula. If drilling down from detail account balances, the results appear in a single or tabbed panel, based on the option in the user's Spreadsheet Server Settings. When drilling down directly from a GXL formula, results appear in a panel or worksheet, based on the method used to execute the function.

Note: Drill down to journals displays YTD journals if the specified format is LTD. This function is not applicable for Analyst, Data Warehouse, Designer GL, and SAP ledgers. For older versions of Infinium ledgers, if the TXPJNO field does not exist, ensure the exclude option is selected in Application Configurator for the Infinium host configuration.

Drill Down to Journals from a Drill Down Panel

1. From the Account Balances or Expanded by Segment drill down panel, select the desired account(s):
   Drill down to journals from the Expanded by Segment drill down panel does not apply to BPCS 405, Infinium, or Movex ledgers.
• To select a single account: double-click the account. The Journals drill down appears, displaying journals for the selected account.
• To select multiple accounts, press and hold the Ctrl key, as accounts are selected in the grid rows, then right-click and select Journal List for Selected Accounts. The Journals drill down panel appears, displaying journals for the selected accounts.
• To select multiple accounts in a range: select the first account in the range, press and hold the Shift key, select the last account in the range, then right-click and select Journal List for Selected Accounts. The Journals drill down panel appears, displaying journals for the selected accounts.
• To select all accounts in the grid: right-click and select Journal List for All Accounts. The Journals drill down panel appears, displaying journals for the selected accounts.

From the Multiple Account Balances drill down, select the desired account(s):

• To select a single account or period: double-click the desired account, specify the desired column number, then click OK, or, double-click the desired amount. The Journals drill down panel appears, displaying journals for the selected account or period.

Note: To select multiple accounts, see above for basic processing steps.


2. For BPCS 6.02 and 6.04+ users, click the Analysis button to populate the analysis fields in the current panel.

Important: Response time varies based on the size of the journal detail file in the host system.

Drill Down to Journals from a GXL Formula

Select a cell containing a GXL formula, then, from the Spreadsheet Server Ribbon, to:

• Display results in a panel, click Drill Down > GL Journals. The Journals drill down panel appears, displaying journals for all accounts associated with the selected GXL formula (see the above screenshot).
• Push results to a worksheet, click Drill Down > Worksheet> GL Journals. The system pushes the drill down journal results for all accounts associated with the selected GXL formula to a worksheet.