Related topics

General Ledger Reports

Using the G/L Source Journals Report

Source journals list the details of posted transactions for the source codes that you included in the source-journal definition, and in the order you specify at print time.

You can specify the source codes that display in a report in the source journal profile, and you specify the following items when you print the source journal:

  • The sorting order of the report (by account number, account segment, account group, or account sorted group).
  • The ranges of account numbers, segment codes, account groups, or account sorted groups.
  • The ranges of fiscal periods, references, dates, posting sequences, and batch numbers.

In other words, the journal profile specifies the type of transaction, but you refine the detail selection at print time. The result is a very flexible report for tracing all kinds of transactions, originating in any of the subledgers.

Source journals can include up to 50 source codes for each journal. If you have less than 50 source codes in your ledger, you could print all transactions posted on a particular date or with a particular reference code.

Information on the report

  • The name of the journal. (Journals are identified by name.)
  • The ranges you specified for each column of the report.
  • Details listed in the order indicated by the columns.
  • The total debits and credits of all details printed.
  • Optional fields posted with transaction details, if you choose to include them.

Before using this report

  • Post current batches.
  • Define source journals in the Source Journal Profiles window.

Printing source journals

You can customize a source journal at print time by choosing:

  • The sorting order of the report. (By account number, segment, or account group.)
  • Account, segment, account group, or account optional field ranges.
  • Fiscal period, reference, transaction date, posting sequence, and batch number ranges.

To print the report

  1. Select Reports > Payroll > General Ledger Reports > Source Journals.
  2. On the Journal tab, select a journal in the Profile field. The journals include:
    • A/R Clearing Journals
    • Bank Reconciliation Report
    • GL Journal Entries
    • Invoice Journal
    • Purchase and Receipts Journal
    • Reallocation Journal
    • Transaction Journal
  3. Click the Browse button to select a report format in the Use Report field.
  4. On the Account tab:
    1. Specify whether to sort the report by Account Number, by Segment, or by Account Group.
    2. Specify the range.
    3. Select Select Account Groups By Sort Code Range (optional) and then select the range.
    4. Select Include Trans. Optional Fields to print optional fields that were posted with transaction details.
    5. Use the Finder to select the range of Segment Names.
    6. If you use optional fields, enter a range of account optional fields to be included in the report.

      Note: The Account Group option in the Sort By section changes to Account Sorted Group when you select this option.

  5. On the Ranges tab of the window, specify ranges of fiscal periods, references, dates, posting sequences, batch numbers.

    Note: You must enter 000000 in the Batch Number From field when you print entries for consolidated accounts/transactions.

  6. Click Print.