List Accounts for a GXL Formula

This feature allows for listing account numbers to be used in the calculation of a GXL formula.

Note: This option is not applicable to Designer GL ledgers.

1. Select the desired cell containing the GXL formula, right-click, and select Spreadsheet Server > List Accounts. The List Accounts window appears.

2. Review the accounts listed in the grid to ensure the formula is retrieving the appropriate accounts.
3. To modify the list of accounts being displayed in the List Accounts window, alter the value in the Filter field, and click the List Accounts button.

Note: Modifying the filter does not change the account segment values in the spreadsheet cell being referenced by the GXL formula.

See List Accounts, General Grid Features, andCopy or Export Records for more information.