Use this screen to print financial statement line detail.
The Financial Statement Detail Report screen consists of three blocks that can be used as follows:
Use the Identification block to enter a parameter ID and description.
Use the Selection Ranges block to specify the ranges that your report will cover.
Use the Options block to specify the level at which you want to roll up the financial statement detail.
You can print this optional report any time after setting up financial statements. You will typically print this report as support for financial statement balances.
|
|
Note: This report provides detailed information about which accounts make up the balances on the overall financial statements. It is useful to print and retain a final version of this report at the end of each accounting period to tie the General Ledger accounts to the resulting financial statements. |
|
|
Note: Only one user at a time can use this screen. |
|
|
Note: You can apply org security to this function. Use this optional feature to grant or remove rights for individual users to view and/or update specific organizations. In order to do so, you must first set up the necessary org security screen. You can then activate org security through the use of the Users (Administration\Maintain\Users) and System Settings (Administration\Configure\System) screens. |
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to specify the ranges that your report will cover.
From this drop-down box, select the grouping for which you want to run the report. Your options are: "Organization," "Ref 1," "Ref 2," "Alternate Reporting," and "Reorganization."
Please note that comparisons are available only when printing for the "Organization."
Enter, or use the drop-down box to select, the range of "Organizations," "Ref No 1s," "Ref No 2s," or "Alternate Reporting" structures that you want to include on the report. The grouping depends on your selection in the Select field.
The system-defined options are "All," "One," "Range," "From Beginning," and "To End."
The value you enter in this field varies depending on the Option you select. If you elect to print for "All" organizations, this field will be inactive.
Enter the starting grouping for the range you want to include on the report.
The value you enter in this field varies depending on the Option you select. If you elect to print for "All" organizations, this field will be inactive.
Enter the ending grouping for the range you want to include on the report.
F/S Code *
This field displays the range option of the F/S Code.
Select the code of the financial statement that you want to print. Lookup contains all of the financial statements that you have set up in the system. A default balance sheet and income statement are provided with the system. The financial statement codes for those statements are "Balsht" and "Incstm."
Please note that the financial statements you select do not need to be the primary statements.
F/S Line Description *
Enter, or use the drop-down box to select, the range of financial statement lines that you want to include on the report. The system-defined options are "All," "One," "Range," "From Beginning," and "To End."
The value you enter in this field varies depending on the Option you select. If you select the "All" or the "From Beginning" option, this field will be inactive. If you select "One" F/S line, select the line description here. If you elect to print a range of F/S lines, select the starting line from Lookup. If you have selected a range beginning from a specific F/S line ("To End"), select that line here.
The value you enter in this field varies depending on the Option you select. If you select the "All," "One," or "To End" options, this field will be inactive. If you elect to print a "Range" of F/S lines, select the ending F/S line from Lookup. If you have selected a range up to a specific F/S line ("From Beginning"), enter that line in this field.
Fiscal Year *
This non-editable field displays a value of "One."
Enter, or use Lookup to select, the fiscal year of the financial statement detail. Only open fiscal years will display.
Accounting Period *
Enter or select the range of periods that you want to include on the report. The system-defined options are "All," "One," "Range," "From Beginning," and "To End."
Enter the starting period number for the range of periods to appear on the report. Once you enter the period number, the starting date will display in the non-editable field to the right.
Enter the ending period number for the range of periods to appear on the report. Once you enter the period number, the ending date will display in the non-editable field to the right.
Use the field in this block to specify the level at which you want to roll up the financial statement detail.
Indicate the level at which you want to roll up the financial statement detail. The reports will be summarized at the level you select for the appropriate grouping.
Select this checkbox to print a comparison column for the financial statement detail report. If you select this checkbox, select the appropriate radio button for the comparison column you want to print.
Your options are Prior Period, Prior Year, and Budget. Note that these comparison columns are available only if you are printing by organization.
Select this checkbox to print inactive accounts on the financial statement detail report.
Unselect this checkbox to prevent inactive accounts from printing on the financial statement detail report.
This checkbox is selected by default.
This screen reads the following tables: FS_SUM (Financial Statement Summary), RPT_FS_COMPARE (Report Financial Statement Compare), and REF_SUM (Reference Summary) tables.
