Printing the G/L Source Journals Report

Sage 300 ERP

Home > Printing Reports > General Ledger Reports > Source Journals Report

Printing 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.

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.
  • Select printing destinations and, if necessary, turn on and connect the printer.

  • Post current batches.
  • Define source journals on the G/L Source Journal Profiles screen.

To print the Source Journals report:

  1. Open General Ledger > G/L Reports >  Source Journals.

  2. On the Journal tab:

    1. In the Profile field, select the type of journal to print.
    2. In the Use Report field, type a report format or use the Browse button to select it. More...

      If your General Ledger is multicurrency, you can select one of three formats:

      • GLSJ01F (for printing functional-currency only onto letter-size paper)
      • GLSJ01S (for printing both source- and functional-currency reports onto legal-size paper)
      • GLSJ1SA (for printing both source- and functional-currency reports onto letter-size or A4 paper)

      There are two ways to select a format:

      • Type one of these format file names into the Use Report field,
      • Select a currency option from the Currency list. The Use Report field automatically shows the file name of the report format.

      Note: You can select one of the report formats that are shipped with General Ledger, or you can choose a custom format that your company has created.

    3. If your General Ledger is multicurrency, in the Currency field, select Functional or Source and Functional.

      The Reporting option is available only in multicurrency ledgers if the euro is your functional currency and you specified a reporting currency.

      Note: The Reporting option uses the letter-size report format (GLSJ01F) and prints debit and credit amounts from the reporting fiscal set.

  3. On the Account tab:

    1. Specify whether to sort the report by Account Number, by Segment, or by Account Group.
    2. Specify a range of account numbers or segment codes.
    3. If you want to select accounts by a range of sort codes, select Select Account Groups By Sort Code Range, and then specify the range.

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

    4. If you want to include optional field information that was posted with transaction details, select Include Trans. Optional Fields.
    5. In the segment table, specify the segment names and ranges of segment codes by which to select accounts.
    6. in the account optional fields table, enter a range of account optional fields by which to select accounts, or leave the table blank. (The table appears only if you use Transaction Analysis and Optional Field Creator.)
  4. On the Ranges tab, specify ranges of fiscal periods, references, dates, posting sequences, batch numbers, (and source currencies, for a multicurrency ledger).

    Important! If you print entries for consolidated transactions, you must enter 000000 in the Batch Number From field.

  5. Click Print.

Related Topics