Jack Henry Build a Template for GXL

Use the GXL formula to retrieve account balances for a specific format/reporting period. The following is an overview for the GXL formula for Jack Henry ledgers:

Field	Description
Data Type	Click the drop-down list, and select the data type for which to retrieve data: Silverlake valid values are: `ACTUAL` `AGGREGATE` `AVERAGE` `BUDGETA` `BUDGETB` `CURBAL` `YESBAL` CIF 20/20 valid values are: `ACTUAL` `AGGREGATE` `BUDGETA` `BUDGETB` `CBAL` `YESBAL`
Time Span	Click the drop-down list, and select the time span for which to retrieve data: Silverlake valid values are: `CURRENT` `PRIOR1` `PRIOR2` `FUTURE` CIF 20/20 valid values are: `CURRENT` and `PRIOR1`.
Year	Click the drop-down list, and select the reporting year. This field is for informational purposes only.
Format	Click the drop-down list, and select the time range for which to retrieve data. Valid formats are: `PER` `QTR` `DQTR` `YTD` `LTD` R`ANGE`
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.
Level	Click the drop-down list, and select the account posting level. `0` indicates detail level account, `1`-`8` indicates roll up level account, and blank includes all account levels.

See Build a Template with Formula Builder for more information.

Was this article helpful?

We're sorry to hear that.

Click Here to Provide Feedback.

Powered by Zendesk