GL account balance inquiry report (RPGLAI) page

Article • 4/27/2026 • 2 min read

Use the GL Account Balances Inquiry Report page to view the MTD and YTD account balances for a GL account in both functional and transactional amount(s).

By default, generic filters are available to generate this report. You can use Advanced Filters to customize or expand your filter criteria.

This report does not include Advanced Filters feature.

To generate GL Account Balance Inquiry Report:

  1. Open the GL Account Balance Inquiry Report (RPGLAI) page.

    a. Select Financial Management> Financial Reports > General Ledger > GL Account Balance Inquiry Report.

    Or

    b. Search for RPGLAI in the Navigation box and then select GL Account Balance Inquiry Report.

    The GL Account Balance Inquiry Report (RPGLAI) page appears.

  2. From the Selection box, select the Account Number.

  3. In the Sort Order list, select how to sort the report.

    The Sort On field is populated based on the order selected in the Sort Order field.

  4. In the Layout list, select the layout in which you want to view the report.

    The Layout field is populated based on the type of report selected in the Selection field.

  5. In the Sort Range area, specify the sort range.

    The Sort On field is populated based on the type of report selected in the Selection field.

    The available sort ranges are:

    • Single- : Select this option to include only one item. Selecting this option enables the From field. Do one of the following:

    a. Type the item reference in the From field.

    b. Click the lookup reference and select the sort of item from the Lookup for From. Select the required sort of item and click Select.

    • Range- : Select this option to include a range of items to sort from. Selecting this option enables the From and To fields. Do one of the following:

    a. Type the first and last values of the range in the From and To fields.

    b. Click the lookup reference (if available) and select the sort of item from the Lookup. Highlight the required sort of item and click Select.

    All- : Select this to include all available items.

  6. In the Other Variables list, type a value for the transactional currency.

  7. On the Toolbar, click Run Report. The Please Select dialog box appears.

    Select Open now to open the report in a new tab or select Notify when Complete to get notification. You can open the downloaded report from My Reports page.
    Related Information ​