GL Financial Reporting

General Ledger > Financial Reporting > GL Financial Reporting

GL Financial Reporting

You use this program to print financial reports that were created using the GL Define Financial Reports program.

Up to 100 report codes can be assigned to a list that will be processed consecutively when you start processing.

Reports created using the GL Define Financial Reports program can be run in SYSPRO Reporting Services (SRS) - refer to GL Financial Report Writer reports in SRS for additional information.

GL Print Financial Reports

Field

Description

Report code

You use this field to enter the code of the report you want to add to the list of reports to process.


	If you are using VALnnn variables to transfer values from one report to another, then the report which calculates the value must precede the report that uses it.

Add

Select this to add a report to the list of reports to process.

Remove

Select this to remove the highlighted report from the list of reports to process.

This function is only enabled after you have added at least one report to the list.

Report code

This indicates the code of the report added to the list.

Title

This indicates the title defined against the report code.

Output file

This indicates the out put file defined for XML report types.

XML document

This indicates the name defined for the XML document for XML type reports.

Continue

You use this function to indicate the level of detail you want to print on the highlighted financial report and to specify a list of companies for which you want to produce the report.

Select this to exit the program without processing any financial reports.

Reporting Options

You use the Continue function to indicate the level of detail you want to print on the financial reports as well as specify a list of companies for which you want to produce the selected financial reports.

Field

Description

Options

Print totals only

Select this if you want to print only the totals generated by each report you selected to print.

Print zero value lines

This option is disabled if you selected the option: Print totals only.

Select this if you want to print lines containing zero values on the report.

Clear variables between reports

The option is only enabled if more than one report code was selected for processing.

Reporting currency

This field is only displayed if you have created alternative currency ledgers (GL Alternative Currency Setup).

The field defaults to the local currency defined against the company (Company Setup) but you can select to print the financial reports in any of the alternate currencies defined.

Companies selected

The company or companies for which you want to run the report(s) are displayed.

Select Companies

This function enables you to specify a list of companies for which you want to produce the selected financial reports.

This enables you to consolidate the ledgers of up to 36 companies.

If you want to consolidate multiple companies' results in one set of financial reports, then you must ensure that each of the separate company's accounts is stored in the same physical repository.

You do this by logging into the company from which the consolidated reports are to be run (i.e. the holding or sharing company), and selecting the Merge Live Ledger to Current File option from the GL Copy, Merge and Delete program, for each of the companies you want to include in the consolidation.

When the Merge process is completed you must ensure that the same company id code is displayed for all companies at the Shared companies - Ledger file company field (Company Setup).

Once you have grouped the companies in the same physical file, then the Report Options you defined using the GL Define Financial Reports program dictate which companies are available for selection.

You must set the following options to be the same for all of the entered companies:

number of accounting periods in a year (Company Setup)
ledger file company id (Company Setup)

Comp

This indicates the company code available for selection.

Name

This indicates the company name for the company code.

Select All

Select this to include all companies listed in the report.

Unselect All

Select this to exclude all companies listed from the report.

Select this to save the company selections.

Cancel

Select this to return to the previous screen.

Start Processing

This function enables you to start printing the financial reports in the order in which they were entered on the previous screen.

If you selected to execute a XML report from the GL Define Financial Reports program, you are given the option of viewing the report in SYSPRO's XML Report Viewer (see GL XML Report Viewer).

However, this option is not available if you selected to generate the report from the GL Financial Reporting program. The reason is that the GL Financial Reporting program is designed to execute multiple reports consecutively. Therefore, a report can depend on the previous report for input values, prompts, etc.

Cancel

Select this to return to the previous screen.

Notes and warnings

Program access

You cannot run reports to which you are denied access - see Report Options.
You must enter the correct password before being able to run a report against which a password is defined - see Report Options.