General Ledger > Reports > GL Trial Balance by Group

GL Trial Balance by Group

You use this program to generate a report of ledger account balances and detailed account activity. The report is sequence according to the Group defined against the General ledger codes.

Report Options

Field Description
Reporting currency Indicate the currency in which to generate the report.

This does not apply when generating the report for Statistical account types.

Report type
Option Description
Detail Prints a list of ledger account codes, balances and detailed entries against the account codes for the current year, or any prior year for which detail and summary history is held on file.
Summary

Prints a list of ledger account codes and balances for any single period in the current year or prior year for which summary history is held on file.

Group selection Indicate the ledger group(s) for which to generate the report.
G/L code selection Indicate the ledger codes for which to generate the report.
Year selection
Option Description
Current year Prints the trial balance for the period(s) selected for the current financial year.
Prior year Prints the trial balance for the period(s) selected for a previous year.
Account types

Indicate the account types to include in the report.

If you select the Statistical account type then all other account types are automatically excluded from the report.

Other Options

Field Description
Period selection The Period selection does not apply to a Summary report.
OptionDescription
Current periodGenerates a trial balance for the current period only.
Year to dateGenerates a trial balance for the current ledger year-to-date.
RangeGenerates a trial balance for a range of periods.
Ledger period Indicate the ledger period for which to generate the report. This option only applies when printing a Summary report.
Print interim closing balances

Prints the closing balance for each period within each ledger account.

This does not apply for a Summary report or when printing the report in Detail for the Current period only.

List inactive accounts

Prints accounts where the opening and closing balance is zero for the periods selected.

The detailed report also lists accounts that have no detail transactions in the period(s) selected.

Print summary page for current period

This only applies to the GL Trial Balance report.

Prints an account type breakdown at the end of the report if you are generating the trial balance for the Current period or the current Year-to-date.

The company totals printed on the summary page are always as at the current ledger period.

The forced balance account is excluded from the totals printed on this report and if not zero is indicated on the summary page.

Print report and group summary pages

This only applies to the GL Trial Balance by Group report.

Prints an account type breakdown at the end of each group if you are generating the trial balance for the Current period or the current Year-to-date.

The company totals printed on the summary page are always as at the current ledger period.

The forced balance account is excluded from the totals printed on this report and if not zero is indicated on the summary page.

New page per ledger code Prints each ledger code on a new page. This does not apply when printing a Summary report.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report details

  • Group missing is printed when the GL code is not assigned to any group. No details for the ledger code are printed on the report.

  • Template account types are excluded from this report.

  • PROV indicates that the entry was posted from a Provisional journal.

Notes and warnings

Unable to generate browse for {SYSPRO Table name}

  • This error message is displayed if the e.net Browse does not exist for the table name displayed. Use the e.net Browse Setup program to add the browse for that specific table.