gl_drillback_screen_mapping custom setting

The gl_drillback_screen_mapping custom setting defines the mapping between standard Financial Reporting reports and the source system.

The gl_drillback_screen_mapping value is an .xml file structure. Each row name matches the unique name of a dashboard used in standard reports. The value property assigns a numeric input that links to the corresponding drillback process and parameters. The value_title property sets the label that you can see in the report options when you right-click a base element in the grid.

Each row of the value represents a screen that supports drillback. The property name defines where the drillback option appears in the report, for example, in a row, value, or report. The property value specifies which drillback process and parameters to use, for example, 1, 2, or 3.

You can change the value_title property. This label appears as a link when users right-click in the data grid.

The gl_drillback_screen_mapping value has these characteristics:

  • Row names match the dashboard unique names of the standard reports.
  • The value property refers to the corresponding number X in the drillbackX_process and drillbackX_parameters custom settings.
  • The value_title property defines the label displayed in the standard Financial Reporting reports.
This is the sample value: 
<Table>
  <Row name="gl_ComparativeFinancialStatement">
    <Property name="value" value="1" />
    <Property name="row" value="2" />
    <Property name="report" value="3" />
	<Property name="value_title" value="Comparative Financial Statement" />
  </Row>
  <Row name="gl_ConsolidatedFinancialStatement">
    <Property name="value" value="1" />
    <Property name="row" value="2" />
    <Property name="report" value="3" />
	<Property name="value_title" value="Consolidated Financial Statement - Balance Sheet" />
  </Row>
  <Row name="gl_ConsolidatedFinancialStatement_IncomeStatement">
    <Property name="value" value="1" />
    <Property name="row" value="2" />
    <Property name="report" value="3" />
	<Property name="value_title" value="Consolidated Financial Statement - Income Statement" />
  </Row>
  <Row name="gl_IncomeStatementBudgetVersusActual">
    <Property name="value" value="1" />
    <Property name="row" value="2" />
    <Property name="report" value="3" />
	<Property name="value_title" value="Income Statement - Budget vs Actual" />
  </Row>
  <Row name="gl_StatementOfCapitalExpenditures">
    <Property name="value" value="1" />
    <Property name="row" value="2" />
    <Property name="report" value="3" />
	<Property name="value_title" value="Statement of Capital Expenditures" />
  </Row>
  <Row name="gl_SummaryTrialBalance">
    <Property name="value" value="1" />
    <Property name="row" value="2" />
    <Property name="report" value="3" />
	<Property name="value_title" value="Summary Trial Balance" />
  </Row>
</Table>