Drill Criteria Sheets

A drill down can be performed by selecting a cell containing a Get Balance formula and clicking the drill down button on the toolbar. However, you may wish to bypass the requirement for a Get Balance formula and simply extract data based on parameters that you set. The Drill Down Criteria Sheet functionality allows you to very quickly extract the detailed balances, line items, and documents that meet certain criteria. This is useful when large numbers of individual balances are required as the values are returned faster than by using many individual Get Balance formulae.

To create a drill criteria sheet navigate to GL Wand | Execute Drilldown | Drill Criteria, and select the drill criteria sheet from the drop-down list. This will create a new drill-down workbook with a criteria form on the first sheet.

Enter the parameters for the data that you wish to extract on the criteria sheet of this new workbook. The criteria are exactly the same as the parameters of the selected balance function and operate in the same manner (required parameters will default in as well).

You can enter values manually by typing them into the field or select them from a list of values where applicable. To use the list of values simply double click the cell or select the applicable cell and click the list of values button on the GL Wand toolbar. The list of values form will open (see the List of Value sections for more details).

Currently, you are able to enter a single value, list of values, a range of values, or a value with wild card criteria for those parameters that support it e.g. GL Account.

Then double click on the Execute Drilldown button to execute the Drill to Next Level, or use the Advanced function in the toolbar to drill straight to the Line Items or Documents.

This workbook operates in exactly the same manner as a normal drill down. See the Drilldowns section for more details.

To create a custom drill-down template see Template Layout.