G/L Acct Trans Consolidated Query (GL45)

Additional Information
iTopia Quick Link

TIP: This program has access to the iTopia Quick Link feature. For more information, click here.

The GL45 Display Account Transactions program lists transaction details and Account balances by GL Account. GL45 displays the following information:

  • The Account balances - opening balance, YTD balance and net transactions total.

  • Details of the transactions posted to the Account for the date range entered.

  • Transactions from all sources or only those for a specific Source Code, for example AR, AP, IN, etc.

The following list defines every field on GL45:

  • In the Selection section:

    • Account - enter or select from the query the GL Account to be displayed. GL Accounts are maintained in Maintain Chart of Accounts (GL01).

      Once the Account is entered, the Account Description automatically displays to the right of this field.

    • In the Dates section:

      • Starting - enter or select from the query the Starting date for the transaction display. Only transactions from this date forward are displayed. This is an optional field; if you leave this field blank, the display starts with the first transaction record on file for this Account.

      • Ending - enter or select from the query the Ending date for the transaction display. Only transactions up to this date are displayed. This is an optional field; if you leave this field blank, the display ends with the last transaction record on file for this account.

    • In the Source Code section, enter or select from the query a GL Source Code. This is an optional field and allows you to view transactions from a specific Source Code only. The default value (**) displays transactions from all Source Codes.

  • In the Balances section:

    • Opening - the opening balance for the GL Account selected is always equal to the ending balance for the last closed period.

    • YTD - displays the account balance as of the entered Ending Date. This value is calculated as the net of the Opening Balance and the Transactions total.

      Caution: If any transactions have been skipped because they are outside of the Start/End date range, then this value will NOT represent the true YTD balance of the account. To calculate the true YTD balance as of a specified Ending Date, do not enter a Start Date.

    • Transactions - displays the net value of transactions listed for the GL Account between the Starting and Ending dates entered.

  • Transaction List Box - displays the details or transactions for the GL Accounts that fall between the Starting and Ending Dates specified for the Source Code entered. The following information displays in the list box for each transaction:

    • Date
    • SC (Source Code)
    • Trans # (Transaction Number)
    • Detail
    • Folio
    • Debit/Credit

The following table outlines the functionality of each button in GL45:

Button Label Icon Functionality
Display Details Display Details Click Display Details to view the transaction details for the GL Account entered.
Print Print Opens the PointForce iTopia G/L Account Transaction Query (ibis_glcf) for the GL account currently open in GL45. You can print the data from this view or you can export the data to an excel spread sheet.