Use this screen to create the report tables necessary to print financial statements with comparative information. Comparative column options currently include prior period, prior year, and budget information. This information is gathered and stored in a common report table generated by this utility.
Please note that when you execute this utility, it updates only rows in the table for the fiscal year and period selected. For example, assume the table contains comparative data from January 1, 2002 through March 31, 2005. You can choose to update the table from January 1 through March 31, 2005. Only those rows are updated.
Because the table contains budget information for the budget revision(s) you select, you must verify that all rows in the report table contain budget information for the same budget revision. If the utility has been run for a different budget revision, inconsistencies will occur when the budget information is printed.
For example, the table may contain budget amounts for periods 1 and 2 updated with budget revision number 1. You then execute the utility in period 3 using budget revision number 2, and print an income statement with budgeted amounts for periods 1-3. The amounts reflected in your budget columns are a combination of budgeted amounts from revision 1 and 2, and do not provide you with useful comparative data.
You must execute this utility before printing financial statements. If you print financial statements without comparison columns, this utility is optional.
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.
Accounting Period
Enter, or use the drop-down box to select, the range of periods to update. The system-defined options are: "All," "One," "Range," "From Beginning," and "To End."
This range should be consistent with the periods to be printed on the financial statements.
For example, if you want an income statement to reflect data from periods 1-3 of 2005, run the utility for that range.
Please note that if the F/S code that you have selected is for a balance sheet, you are required to enter a value of "One" as your Option.
Enter, or use Lookup to select, the fiscal year you want to update. The fiscal year you enter should be consistent with the year to be included on the financial statements.
Enter, or use Lookup to select, the starting period you want to update. The starting period you enter here should be consistent with the range of periods to be included on the financial statements.
If you elected to print for "All" periods, this field will be inactive.
This non-editable field displays the ending date.
Enter, or use Lookup to select, the ending period you want to update. The ending period you enter here should be consistent with the range of periods to be included on the financial statements.
If you elected to print for "All" periods, this field will be inactive.
This non-editable field displays the ending date.
Budget Revision
This non-editable field defaults to "One."
Enter, or use Lookup to select, the budget revision with which you want to update the report tables.
Create General Ledger Report Tables
After selecting the Action button, select this icon on the toolbar to activate the process of creating the report tables.
This screen updates the RPT_FS_COMPARE (Report Financial Statement Compare) table.