A report is defined by specifying the report objects FSG should use to build the report. You can only assign report objects that you have Use privileges to through your definition access sets. The simplest reports are defined by a row set and a standard column set. Optionally, you can specify your own custom column set. Also, you can add a content set, row order, and/or display set to enhance the report or refine the information in the report. You can also specify the budget, encumbrance types, currencies, and constant periods of interest to include on a report.
Once you define and save a report, you can use it any time - to run the report, define a report set, or copy and save it as a new report.
Note: You can also define ad hoc financial reports, as necessary, to meet one-time reporting needs. You create ad hoc reports from the Run Financial Reports window.
Prerequisites
Define a row set.
Optionally, define column sets, row orders, content sets, and display sets.
Navigate to the Define Financial Report window.
Enter a Name, report Title, and Description for your report. The report title is what FSG will print at the top of the report.
(Optional) Select the Enable Security checkbox to apply Definition Access Set security to your financial report definition. Definition Access Sets are an optional security feature that enables you to control access to your General Ledger definitions. For example, you can prevent certain users from viewing, making changes, or using your financial report. If you do not enable security, all users will be able to use, view, and modify your financial report.
If the Assign Access function is available for your responsibility, the Assign Access button is enabled once you check the Enable Security checkbox. Choose the Assign Access button to assign the definition to one or more Definition Access Sets with the desired privileges. For more information, see Definition Access Sets.
If the Assign Access function has been excluded from your responsibility, you will not be able to view the Assign Access button in the financial report window. You can still secure the financial report by checking the Enable Security checkbox, but only Definition Access Sets that are AutoAssigned are automatically assigned to this financial report. See your System Administrator for more information on Function Security.
Enter the Row Set and Column Set to use for the report.
(Optional) Enter the Content Set, Row Order, and/or Display Set to use for the report.
(Optional) Enter Segment Override values for the account segments you want to override. When you enter a segment override value, FSG produces a report for the specific value you specify. For example, assume you have a report definition which produces a combined assets report for four companies. If you modify the report definition to add a segment override for company 02, then FSG will print an assets report for company 02 only.
Note: If a segment you override is subsequently disabled, the Segment Override definition becomes invalid and you must redefine your report.
(Optional) Enter a default Currency for the report. FSG uses this currency only for those rows and columns to which you did not assign a currency when you defined row and column sets.
Note: This must be a monetary currency and cannot be STAT.
(Optional) Select a Rounding Option to use for calculations in the report:
Calculate Then Round: FSG performs calculations before any rounding.
Round Then Calculate: FSG rounds values before they are used in calculations.
(Optional) Select a Level of Detail for the report. There are three options, which correspond to the levels of detail you can assign to rows and columns. If you specify a level of detail for your report, FSG will only print those rows and columns with matching levels of detail.
Note: If you do not enter a level of detail for a report, the system will assume the level of detail is Financial Analyst.
Enter an Output Option for your report:
Text: Produces a report in standard format for printing or viewing online.
Tab-Delimited: Produces a report whose columns are delimited by tabs, making it easier to import the report into a spreadsheet.
Spreadsheet: Produces a report designed specifically for Microsoft Excel and can be used with Applications Desktop Integrator.
XBRL: Generates XBRL output and creates an XRBL instance document. At least one XBRL Taxonomy must be loaded in the system for this option to appear.
XML: Generates an XML output file, which is used as input to BI Publisher so the report formatting of a report template is applied to the FSG report.
If the row or column set has control values assigned, you can assign budgets, encumbrance types, currencies, and constant periods of interest to those values.
Save your work.
Choose Run Report.