Print Financial Reports

Use the Financial Reports Print (GP) program to print financial reports. Each report uses a format set up in the Financial Reports Format Maintenance (GFM) program and a header set up in the Financial Reports Header Maintenance (GHH) program. See Background, Financial Report Examples, and Road Map for more information.

Notes

If no rounding default is set at the report level, rounding is to hundreds.
Some options are mutually exclusive—only one should be selected. See Background for more information.

Set your options:
1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries.
2. Click the Selection tab to select the report number or range that you want to print. If you select a specific organization or organization group, you override the Org or org group field for the report numbers in the Financial Reports Header Maintenance (GHH) program.

OR

Click List to enter report numbers that are not in a range or to print reports in a different sequence. See Create a List of Financial Reports to Print.

1. Click the Program tab to set these program specific options:

Field Name	Type / Max Length	Action / Description
Enter a date to find starting period	Optional	Enter or select the date in the starting period you want to report, enter a date shortcut or leave blank for the current period. For example, if your fiscal calendar corresponds to a calendar year and you enter March 23, 2020, the starting period is 03/2020.
Enter a date to find ending period	Optional	Enter or select the date in the ending period you want to report, enter a date shortcut or leave blank for the current period. For example, if your fiscal calendar corresponds to a calendar year and you enter April 15, 2020, the ending period is 04/2020.
Enter report type override	Optional 1 alphanumeric	Enter the report type to use for this printing or leave blank to use the report type assigned to the selected report numbers in the Financial Reports Header Maintenance (GHH) program. You can use this option to temporarily change the type of a report. This means that if you normally print a type L report (P & L: Actual to Budget), you can enter type K to change the format to P & L: Actual to Last Year without changing the Report type field in Financial Reports Header Maintenance program. Type U (user-defined) cannot be specified as the report type override.

1. Click the Program2 tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Print only period-end reports?

Optional

Select to print all reports that have the Period end? field selected in the Financial Reports Header Maintenance (GHH) program or leave blank to not print them.

Print which type of report

Optional
1 alphanumeric

Select the report type you want to print:

Report Description	Single Period	Multi-Period
Balance Sheet	A
P & L: Actual to Last Year	B	K
P & L: Actual to Budget	C	L
P & L with Percentage Calculation	D	M
Statement of Change	E	N
Activity Report	F
Trial Balance	G
Budget Planner	H
P & L: Last Year to Actual to Budget	I	J
History Report		O
Operating Report		P
Rolling Forecast		R
User-Defined	U

Use the Financial Reports Header Maintenance (GHH) program to assign a report type to each report header.

Note
Entry of a report type overrides the selection for report number. All reports with the specified report type are printed.

Select for worksheet format?

Optional

Select to print in worksheet format or leave blank to print in pro forma format.

Worksheets contain formatting detail, all accounts, and accumulators.

Exclude zero amounts?

Optional

Select to omit accounts that have no data (all columns are zero) or leave blank to include them.

Enter heading for this date range

Conditional/Optional
15 alphanumeric

For report types F, J, K, L, M, and N, enter a heading that describes the date range for this report; for example, Period-to-Date or Quarter-to-Date.

Enter budget source code

Conditional/Optional
4 alphanumeric

For report types C, H, I, J, and L, enter a budget source code set in the GL Budget Maintenance (GBM) program to use an alternate budget or leave blank to use default budget data from that program.

Change negative sign?

Optional

Select to place the negative sign before the number or leave blank leave the negative sign after the number.

Some spreadsheet programs and other 3rd- party software expect negative (-) signs before the number. If you want to do further calculations on the data after it is exported, you can select this option to move the sign from after the number (Qantel standard) to before the number.

See Background for more information on the negative sign and commas.

Select report group

Optional
6 alphanumeric

Enter a report group or click the Lookup icon and use the standard lookup options to select the report group from a list.

Convert currency?

Conditional/Optional

If the multi-currency feature is active, select to convert different currencies to one currency or leave blank not to do this.

You can print financial reports in a single currency (conversion) or print reports in the currency of each account (no conversion).

If you do not select this option, you should evaluate only individual account values because totals (of multiple, unlike currencies) may be meaningless.

Convert to which currency

Conditional
2 alphanumeric

If you selected the Convert currency? option, select the currency to convert to.

The default is the company's base currency code, but you can print the report in any other currency for which you have established appropriate exchange rates.

Select currency exchange date

Conditional
10 date

If you selected the Convert currency? option, select the date to use for the currency exchange rate or enter a date shortcut.

The report uses the exchange rate in effect on this date.

Choose the appropriate options:

To	Do This
Review the report on the screen before printing	Click View.
Print the report	Click Print. Note The report prints immediately if the option Allow device override? in the Date-Output Device Maintenance (ZE) program is not selected. If this option is selected, the program prompts Output device. Accept the default device that displays, which is specified in the Date-Output Device Maintenance program, or enter the name of a different device.
Save these options for future use	Click Save.
Redisplay selected options	Click Refresh. The selected organization/org group description and the calendar date that corresponds to entered date shortcuts are displayed.
Enter report numbers that are not in a range or to print reports in a different sequence.	Click List. See Create a List of Financial Reports to Print.
Exit the program	Click Exit.