Display GL Transactions for an Account

Use the GL Activity Inquiry (GTL) program to display GL transactions for an account. See Background and Road Map for more information.

  1. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

GL org code

Required
2 alphanumeric

Select the code for the GL organization.

GL account no

Required
10 alphanumeric

Enter the GL account number or click the Lookup icon and use the standard lookup options to select the account from a list.

Note
To display or print information for a range of accounts, use the GL Transaction Listing (GYL) program.

Start date

Required
10 date

Accept the displayed date, select a different date, or enter a date shortcut. Look ahead to step 3 to change the default start date for subsequent runs of GTL.

End date

Required
10 date

Accept the login date, select a different date, or enter a date shortcut. Look ahead to step 3 to change the default end date for subsequent runs of GTL.

The program displays these header fields:

Field Name

Displays

Account

The GL organization code and account number you selected, the account's description, and the currency code for this account

Account type

The type of account

Start date

The start date you selected

End date

The end date you selected

Beginning balance

The beginning balance for the account based on the date you selected for the Start date field

Debits

Total of the debit transactions for the period selected

Credits

Total of the displayed credit transactions for the period selected

Net activity

Net activity during the period (debits minus credits)

Ending balance

The ending balance for the account based on the date you selected for the End date field

These detail fields are listed:

Field Name

Displays

Period

GL accounting period in which the transaction was posted

Post date

The date transaction posted

Reference

A reference for the transaction

Description

Descriptive information about transaction

Debits

The amount debited

Credits

The amount credited

Summary

The activity and ending balance in each GL accounting period

Reg

The register number for the transaction

Src

The journal source

User

The user who posted the transaction

Entered at

The time and date the transaction was updated

Source desc

The description of the journal source

Additional desc

More descriptive information about transaction if a second description was specified (populated only if it is a general journal; i.e., source is GJ0, GJG or GJQ)

  1. Choose the appropriate options:

To

Do This

Review your options for this program

Click Prog opts. See step 3.

Print the transaction listing

Click Print. See Print an Inquiry.

Display each period's total, net activity, and ending balance, the total for all periods selected, and the ending balance for this GL account number

Click Totals. Click Totals again to return to the detail display.

Display detail for the selected transaction

Click Detail. The program that displays depends on the journal source (see Background for more information). If the transaction selected is a summary posting, the journal is displayed.

Click OK to return to this program.

Display the journal for the selected transaction

Click Journal. See Display an Interface Journal. Click OK to return to this program.

Display the custom fields your company uses

Click User. A green check mark on the button indicates that user fields have been entered for the displayed account. User fields can only be maintained in GL Account Maintenance.

Note
This button displays only if you have set up user fields for General Ledger Master (GLMAST) file in User Fields Maintenance (XMO).

Specify a different account and/or date range

Click OK. See step 1.

Exit and return to the menu

Click Exit.

  1. Click Prog opts to review your options. To change them:

    1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.

    2. Click the Program tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Print GYL listing

Optional

Select if you want to print the GL Transaction Listing when you click the Print button. Leave blank if you output to match the inquiry.

Default start date

Required
10 date

Accept the displayed date, select a different date, or enter a date shortcut.

Important!
If you change the date, be sure to click Save and exit GTL. The new default start date will be used for subsequent runs of GTL.

Default end date

Required
10 date

Accept the login date, select a different date, or enter a date shortcut.

Important!
If you change the date, be sure to click Save and exit GTL. The new default end date will be used for subsequent runs of GTL.

    1. Click Save to save these options for future use.

    2. Click Refresh to display current options.

    3. Click OK to apply these options or click Cancel to exit without applying them.