Skip to main content

JD Edwards Build a Template for GXL

As fields in the Formula Builder > GXL panel vary based on the selected ledger, use the following table to enter unique data unique to JD Edwards ledgers:

Field Description

Configuration

Click the drop-down list, and select the host configuration to be used. The list only displays configurations to which the user is authorized.

Note: If in demo mode, the value is hardcoded to GXL Demo.

Ledger Type

Click the drop-down list, and select the ledger type code containing the balances.

Year

Click the drop-down list, and select the reporting year.

Format

Click the drop-down list and select the time range for which to retrieve data. Valid formats are:

  • PER
  • QTR
  • DQTR
  • YTD
  • LTD
  • RANGE
  • BLTD
  • BLTDAPR
  • BLTDREQ

Period

Click the drop-down list, and select the corresponding period, quarter number, or range of periods (for example, 1.5 for periods 1 through 5) for the specified format.

Currency

Specify a valid currency code. Leave blank to use the base currency assigned in the user's Spreadsheet Server Settings. Enter * to retrieve all currencies.

Weekly

If selected, the formula retrieves weekly balances, rather than period balances.

See Build a Template with Formula Builder for more information.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk