Skip to main content

Designer GL Ledger Specifics

Use the following table to enter data in the Spreadsheet Server Settings > Ledger Specifics >Designer GL panel, or to access other functions:

Field Description

Designer General Ledger Options:

 

File Name

Specify the Designer GL file name. May use alphanumeric or underscore characters.

Connection Name

Click the drop-down list, and select the connection name. Right-click and select Refresh to refresh the data.

Key 1 Caption

Specify the caption for Key 1.

Key 1 Data Validation

Specify the values to be included in the Key 1 drop-down list.

Key 2 Caption

Specify the caption for Key 2.

Key 2 Data Validation

Specify the values to be included in the Key 2 drop-down list.

QuickText

Specify the button label to appear in the Spreadsheet Server Ribbon > Build a Template > General Ledger menu, to identify the ledger for building a GXL formula.

Tool Tip

Specify the tool tip to display for the associated QuickText item.

SAP: Secondary Database Connection

For SAP Designer GLs only, if desired, specify the name of the secondary database connection to be used for processing.

SQL TRIM Supported

If selected, the TRIM function used in SQL to remove a specified prefix or suffix from a string is supported.

Preload HSegments

If selected, HSegment values are preloaded into the cache when Spreadsheet Server is started. If not selected, the hierarchy option in the Locate Segment function is disabled, as there are no values to display.

Reset Connections on Clear Cache & Recalculate

If selected, the system closes and reopens connections when the Clear Cache & Recalculate function is processed, in an effort to improve performance. This option should only be selected in specific scenarios. Please contact insightsoftware prior to selecting this option.
Button Description

Set Default Designer GL

Opens Windows Explorer, allowing the user to browse to, and, select or set the default Designer GL without having to enter a password.

Load Default GL Definition

Loads the default Designer GL data in the panel. This function is password protected.

Browse for GL Definition

Opens Windows Explorer, allowing the user to browse to and select a Designer GL definition. This function is password protected.

Refresh Acct Key Sec Cache

Refreshes the account segment security cache, to process any changes made to ad hoc files.

Save

Saves all changes to the Designer GL definition.

Note: These options are used to maintain Designer GL definitions. These panels are password protected. Contact insightsoftware for more information.

See Spreadsheet Server Settings for more information.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk