Background: GL Transaction Listing

Use the GL Transaction Listing (GYL) program to print account transactions within a date range. See Road Map for work flow.

This topic has these subtopics:

Organization vs. Organization Group
GL Transaction Listing
History

Organization vs. Organization Group

You can print the report for a specific organization or an organization group. When you print a report for an organization group, it includes a section for each organization in the group.

Note
If you print a report for a consolidation, the report is for that organization only and not for the subsidiaries that consolidate to it. If you want to include the subsidiary organizations, select a consolidation group (for example, **0).

GL Transaction Listing

The GL Transaction Listing shows each entry to GL accounts in account number order for the specified time interval. You can print all transactions or only those transactions within a range of dates that you specify.

The listing includes these fields for each account:

  • GL organization code

  • GL account number

  • GL account description

  • Beginning balance for the account

The listing includes these fields for each transaction

  • Posting date

  • Journal register number

  • Journal source

  • Transaction reference

  • Debit amount and currency

  • Credit amount and currency

If you selected the Print detail for summary transactions Program option, the listing also includes this information:

  • Reference: Order number

  • Description: Customer, invoice, order, tag, line number or other identifier

  • Debit or credit amount

When outputting to a file, the report includes these fields for each transaction:

  • Period/year

  • Posting date

  • The date and time the transaction was updated

  • User ID

  • Journal register number

  • Journal source

  • Journal description

  • Transaction reference
    If the Include expanded descriptions option is selected, additional information is spelled out, such as customer and vendor numbers, names, item descriptions, invoice numbers, etc., depending on the type of transaction and source.

  • Transaction description
    If the Include expanded descriptions option is selected, additional information is spelled out, such as customer and vendor numbers, names, item descriptions, invoice numbers, etc., depending on the type of transaction and source.

  • Debit amount

  • Credit amount

  • Currency (if the multiple currencies feature is active)

These total print for each account:

  • Period activity: Total and currency, debits and currency, credits and currency

  • Total activity: Total and currency, debits and currency, credits and currency

  • Ending balance

These totals print of each organization:

  • Organization control totals: Total debits and credits

These totals print for the listing:

  • Grand control totals: Debits and credits

History

You can include transactions for closed periods only if you selected the YTD transaction history? option in the System Options Maintenance (XM) program (General Ledger Options).