Financial Management
Human Resources
Campus Solutions
Chapter 5
Financial Reports
Updates
Date Action Page(s)
02/14/14 Document created.
02/20/14 Updated directions for accessing reports through Report Manager.
1, 41-48 10/09/14 Updated links. Removed Drilldown section. all
Overview ... 4
1.0 Reconciling the Checkbook ... 5
1.1 What needs to be done? ... 5
1.1.1 Actual transactions on the reports must be reconciled to source documents... 5
1.1.2 Erroneous transactions must be corrected. ... 5
1.1.3 Missing transactions must be researched. ... 5
1.1.4 Fund balances must be reviewed. ... 5
2.0 PC Computer Set-up Prior to Working with Reports ... 6
2.1 PC Set-up (for Windows XP Users) to Open Reports in a New Window ... 6
2.2 PC Macro Security Set-up for Users with Office 2010 ... 7
2.3 PC Macro Security Set-up for Users with Office 2007 ... 9
3.0 Preview of Month-end, Entire Year and Adjusted Year End Report Options at CWU ... 12
3.1 Individual Reports ... 13
3.1.1 Project Activity (Month-end – No Operating Unit) ... 13
3.1.2 Project Activity – Entire Year (no Operating Unit) ... 14
3.1.3 Project Activity with Operating Unit (Month-end) ... 14
3.1.4 Project Activity with Operating Unit – Entire Year ... 15
3.1.5 Project Activity with Student Financials Detail and Operating Unit (Month-end) ... 15
3.1.6 Project Activity with Student Financials Detail and Operating Unit – Entire Year ... 16
3.1.7 Project Summary (Month-end – no Operating Unit) ... 16
3.1.8 Project Summary – Adjusted Year End ... 17
3.1.9 Project Summary with Operating Unit (Month-end) ... 17
3.1.10 Project Balance (Month-end) ... 18
3.1.11 Project Balance – Adjusted Year End ... 18
3.1.12 Project Balance – Year to Date Comparative (Month-end) ... 19
3.2 DEPARTMENTAL SUMMARY BY PROJECT ... 20
3.2.1 Departmental Summary by Project (Month-end)... 20
4.0 Generating a Report ... 21
4.1 Creating a New Run Control ID ... 21
4.1.1 Project Activity (Month-end - No Operating Unit) ... 24
4.1.2 Project Activity – Entire Year (no Operating Unit) ... 25
4.1.3 Project Activity with Operating Unit (Month-end) ... 26
4.1.4 Project Activity with Operating Unit – Entire Year ... 27
4.1.5 Project Activity with Student Financials Detail and Operating Unit (Month-end) ... 28
4.1.6 Project Activity with Student Financials Detail and Operating Unit – Entire Year ... 29
4.1.7 Project Summary (Month-end - no Operating Unit) ... 30
4.1.8 Project Summary – Adjusted Year End ... 31
4.1.9 Project Summary with Operating Unit (Month-end) ... 32
4.1.10 Project Balance (Month-end) ... 33
4.1.13 Departmental Summary by Project (Month-end)... 36
4.2 Accessing an Already Existing Run Control ID ... 36
4.3 Running a Report ... 37
4.3.1 Using Process Monitor to Verify that Your Reports are Finished Processing ... 39
4.3.2 Accessing Your Reports through the Report Manager ... 40
4.3.3 Opening Your Report to View/Print ... 43
4.3.4 Printing Multiple Reports at One Time ... 44
5.0 Working with the Reports ... 49
5.1 Zooming on a Report in Excel 2010 ... 49
5.2 Zooming on a Report in Excel 2007 ... 49
5.3 Expanding/Collapsing Sections of a Report ... 50
5.4 Printing a Report with Gridlines ... 52
5.4.1 Setting up Your Report to Print Gridlines in Office 2010 ... 52
5.4.2 Setting up Your Report to Print Gridlines in Office 2007 ... 53
Overview
The purpose of this document is to describe and illustrate how to use the powerful reporting capabilities within the PeopleSoft Financials system.
Since May 2006, Central Washington University has been using the reports within PeopleSoft to meet your informational needs. This document is meant to help you throughout this change.
After month end closes, official notification will be sent to all FMS users via the FMSUser e-mail listserv when it is time to run the month-end reports for reconciliation. Some of the reports that are available for running include, but are not limited to:
Project Activity
Project Summary
Project Balance
The above reports may be run at any time during the month as well as at the end of the month. A Departmental Summary report may also be run at month end for each Department.
In addition to the month-end reports, there are also year-end reports that may be run after the fiscal year has officially been closed.
Objectives:
By the end of this course, you will be able to:
Generate a report using Specific Criteria
1.0
Reconciling the Checkbook
At this point, it is assumed that all source materials and financial reports are organized as described in the “Suggestions for Getting Organized” section of the Chapter 1 document entitled “Getting Started with FMS.” If not, refer back to that document to establish a method to keep all documents and reports organized to facilitate reconciling the statements (reports) at month end.
It is imperative that project leaders review and reconcile their reports each month to verify the validity of charges made to their department.
The PeopleSoft Financials system has a number of controls to prevent the erroneous posting of a transaction. However, there are circumstances under which a charge could erroneously be posted to the wrong account. When this happens, the only way to detect the error is by reviewing the department’s reports. The reports introduced in this document should assist you in your investigation.
If you have questions regarding discrepancies in your cost center, contact the Accounting Office.
1.1 What needs to be done?
1.1.1 Actual transactions on the reports must be reconciled to source documents.
Take your source documents folder that contains all order forms, invoices, etc. that you have
accumulated that have not yet appeared on the Project Activity Report. Compare these documents with the transactions in the Project Activity Report.
amount the same?
account code correct?
project ID correct?
vendor name change?
1.1.2 Erroneous transactions must be corrected.
All requests for expenditure-related changes are to be sent via email to Josh Ramsey, which will serve as the end user authorization to make any adjustments. The following information needs to be included:
the account and project ID where the item is currently posted
where the item is to be moved to
why it needs to be moved
which report the information is coming from
For Grants: John Ebenal (x1996) wants to be contacted by phone. 1.1.3 Missing transactions must be researched.
If you have incurred an expenditure, and it is not appearing in your financial reports, contact the appropriate office to see wherein lies the problem.
1.1.4 Fund balances must be reviewed.
For revenue-generating funds, balances must be carefully reviewed and corrective action taken if a negative balance is showing.
2.0
PC Computer Set-up Prior to Working
with Reports
Before attempting to retrieve or work with the reports, PC users have a couple of settings to check on their computers. Mac users may skip to section 3.0 as section 2.0 only applies to PC users.
2.1 PC Set-up (for Windows XP Users) to Open Reports
in a New Window
PC users running Windows XP must set their computer to open the reports in a new window.
1. To begin, open up the folder
called . This may be located directly on your desktop or under the menu.
2. Then click on the Tools menu at the top of the screen and choose:
Folder Options…
3. When the Folder Options dialog box appears, click on the |File Types| tab. 4. If you have Microsoft Excel 2007 on your
computer, then scroll until you find
under Registered file types. If you have an earlier version of Microsoft Excel (i.e. Excel 2003), scroll until you find under
Registered file types.
5. Click once on either or to highlight it.
6. Then click the button.
7. When the Edit File Type dialog box appears, check on the following 2 settings:
If the
checkbox is checked, uncheck it.
If the
checkbox is checked, uncheck it. 8. Then click the button.
9. In the Folder Options dialog box, click the button.
Microsoft Excel is now configured to open the Financial Reports in a new window.
2.2 PC Macro Security Set-up for Users with Office 2010
The reports in the Financial Management System make use of macros. If you are a PC user
with Office 2010 on your computer, it is necessary to set the macro security level on your
computer to “Medium” in order for the reports to work properly. If you are a Mac user, this set-up is not necessary.
To set the macro security on your PC computer, first log into Microsoft Excel.
1. From the File menu, choose Options. 8
7
2. When the Excel Options dialog box appears, click on Trust Center. 3.
Then click the button.
8 3
4. When the Trust Center dialog box appears, click on Macro Settings. 5. Then click the radio button to “Enable all macros….”
6. Also check the checkbox to “Trust access to the VBA project object model.” 7. Next click the button at the bottom of the Trust Center dialog box. 8. Finally click the button at the bottom of the Excel Options dialog box.
Your Macro security is now set, and you are ready to work with the Financial Reports.
2.3 PC Macro Security Set-up for Users with Office 2007
The reports in the Financial Management System make use of macros. If you are a PC user
with Office 2007 on your computer, it is necessary to set the macro security level on your
computer to “Enable all macros…” in order for the reports to work properly. If you are a Mac
user, this set-up is not necessary.
To set the macro security on your PC computer, first log into Microsoft Excel. 6
1.
Click the Office Button in the upper left-hand corner. At the bottom of the box that opens, click the Excel Options button.
9. When the Excel Options dialog box appears, click on Trust Center. 10.
Then click the button. 2
11. When the Trust Center dialog box appears, click on Macro Settings. 12. Then click the radio button to “Enable all macros….”
13. Also check the checkbox to “Trust access to the VBA project object model.” 14. Next click the button at the bottom of the Trust Center dialog box. 15. Finally click the button at the bottom of the Excel Options dialog box. Your Macro security is now set, and you are ready to work with the Financial Reports.
4
6
3.0
Preview of Month-end, Entire Year and
Adjusted Year End Report Options at
CWU
The following month-end as well as the entire year reports may be run each month within the PeopleSoft system. The adjusted year-end reports may be run at the close of the fiscal year. The intent of this section is to give you a preview of these reports.
The following types of reports will be reviewed in this section:
Individual Reports - provide a summary by Account for one specific Project ID. 1. Project Activity Reports:
Project Activity (month-end)
Project Activity – Entire Year
Project Activity w-Operating Unit (month-end)
Project Activity Entire Year w-Operating Unit
Project Activity w-Student Financials and Operating Unit (month-end)
Project Activity Entire Year w-Student Financials and Operating Unit
2. Project Summary Reports:
Project Summary (month-end)
Project Summary – Adjusted Year End
Project Summary w-Operating Unit (month-end)
Project Summary w-Loc and Pre-Enc (month-end)
3. Project Balance Reports:
Project Balance (month-end)
Project Balance – Adjusted Year End
Project Balance – Year to Date comparative (month-end)
Departmental Report - provides a summary by Account for multiple Project ID’s.
3.1 Individual Reports
3.1.1 Project Activity (Month-end – No Operating Unit)
The “Project Activity” report is the most detailed of the 3 most common types of month-end reports. Be aware, however, that the Operating Unit (Campus Location) will not display in this report. If you want to be able to view the Operating Unit, then the report that you want to run is the “Project Activity with Operating Unit” report.
3.1.2 Project Activity – Entire Year (no Operating Unit)
The “Project Activity – Entire Year” report provides the same amount of activity detail as the month-end “Project Activity” report. The difference is that the “Project Activity – Entire Year” report covers the time period from the beginning day of the FISCAL YEAR (07/01/xx) to the current date. The “Project Activity – Entire Year” report may be run at any time during the fiscal year (i.e. 07/01/08 through 06/30/09). Keep in mind, however, that the further into the fiscal year you get, the longer it will take for the report to process.
3.1.3 Project Activity with Operating Unit (Month-end)
3.1.4 Project Activity with Operating Unit – Entire Year
The “Project Activity Ent Year w-Oper Unit” report provides the same amount of activity detail as the “Project Activity – Entire Year” report in addition to providing the Operating Unit
(Campus Location) information. The “Project Activity Ent Year w-Oper Unit” report may be run at any time during the fiscal year (i.e. 07/01/08 through 06/30/09). Keep in mind, however, that the further into the fiscal year you get, the longer it will take for the report to process.
3.1.5 Project Activity with Student Financials Detail and Operating Unit (Month-end)
3.1.6 Project Activity with Student Financials Detail and Operating Unit – Entire Year
The “Project Activity Ent Year w-SF and Oper Unit” report provides the same amount of activity detail as the “Project Activity Ent Year w-Oper Unit” report in addition to providing detail about any Student Financials journal that may appear in the report. The additional detail is accessed by clicking on the |SFDetail| tab at the bottom of the report window. The “Project Activity Ent Year w-SF and Oper Unit” report may be run at any time during the fiscal year (i.e. 07/01/08 through 06/30/09). Keep in mind, however, that the further into the fiscal year you get, the longer it will take for the report to process.
3.1.7 Project Summary (Month-end – no Operating Unit)
The month-end “Project Summary” report is consistent with the month-end “Departmental Summary by Project” report except that the “Project Summary” report contains more Account categorizations than the “Departmental Summary by Project” report. The “Project Summary” report may be broken out by period (month) by clicking the button at the top of the YTD column in the report. Refer to section 5.3 of this document for further directions regarding the
3.1.8 Project Summary – Adjusted Year End
The “Project Summary – Adjusted Year End” report provides the same amount of detail as the monthly “Project Summary” report. The difference is that the “Project Summary – Adjusted Year End” report covers the time period from the beginning day of the FISCAL YEAR
(07/01/xx) to the end day of the FISCAL YEAR (06/30/xx+1). The “Project Summary – Adjusted Year End” report may only be run after the fiscal year has officially been closed. Refer to section 6.0 of this document for more information regarding the Adjusted Year End reports.
3.1.9 Project Summary with Operating Unit (Month-end)
This report is consistent with the month-end “Project Summary” report except that the “Project Summary w-Oper Unit” report may be broken out by Operating Unit (Campus Location) by clicking the button at the top of the YTD column in the report. Refer to section 5.3 of this document for further directions regarding the button.
YTD column broken out by
3.1.10 Project Balance (Month-end)
The “Project Balance” report provides you with a Cash Balance as well as a Fund Balance for your project ID number. If you try to run a “Project Balance” report on any Ledger 1 (state funded) project ID numbers, the report will be blank.
3.1.11 Project Balance – Adjusted Year End
The “Project Balance – Adjusted Year End” report provides the same amount of detail as the month-end “Project Balance” report. The difference is that the “Project Balance – Adjusted Year End” report covers the time period from the beginning day of the FISCAL YEAR
(07/01/xx) to the end day of the FISCAL YEAR (06/30/xx+1). The “Project Balance – Adjusted Year End” report may only be run after the fiscal year has officially been closed. Refer to section 6.0 of this document for more information regarding the Adjusted Year End reports. As with the month-end “Project Balance” report, if you try to run the “Project Balance – Adjusted Year End” report on any Ledger 1 (state funded) project ID numbers, the report will be blank. Cash Balance Fund Balance Each of these areas may be expanded to reveal additional detail, if need be.
This column provides data for the current fiscal year through the run date.
3.1.12 Project Balance – Year to Date Comparative (Month-end)
The “Project Balance – Year to Date comparative” report provides you with a Cash Balance as well as a Fund Balance for your project ID number, just as the “Project Balance” report does. The two reports differ in the prior year comparison column. The prior year column will display data through the run date one year ago. For example, if the report was run on 12/31/2010, it would show the current year through 12/31/2010 and the prior year through 12/31/2009 for a “where are we now” vs “where were we last year at this time” type of comparison. If you try to run a “Project Balance – Year to Date comparative” report on any Ledger 1 (state funded) project ID numbers, the report will be blank.
Cash Balance Fund Balance Each of these areas may be expanded to reveal additional detail, if need be.
This column provides data for the current fiscal year through the run date.
3.2 DEPARTMENTAL SUMMARY BY PROJECT
The month-end “DEPARTMENTAL SUMMARY BY PROJECT” report is similar to the month-end Individual Summary report except that it summarizes activity for multiple projects.
3.2.1 Departmental Summary by Project (Month-end)
4.0
Generating a Report
You will have the ability to run most report layouts at any time with specific criteria defined in a PeopleSoft report request.
Each report request is a collection of report-specific information. Follow the directions below to run a report with your own criteria.
If you are a PC user and have not taken care of the computer settings outlined in section 2.0 of this document, you will need to do so before attempting to work with the financial reports.
1. Log into FMS Reports. Navigate to:
Main Menu > Financial Management > CWU Custom Functions > Reports > nVision Reports
On the Find an Existing Value page for nVision Reports, you may access or create a Run Control ID.
To create a new Run Control ID, refer to section 4.1 below.
To access a Run Control ID you previously created, refer to section 4.2 below.
4.1 Creating a New Run Control ID
If you have not already accessed the Find an Existing Value page for nVision Reports, follow the directions in section 4.0 above to do so.
The steps described below are general directions for setting up a Run Control ID. For information regarding the specific criteria to choose on the CW nVision Reports page for a particular kind of report, refer to the sections that follow the steps below, beginning with section
4.1.1.
1. To create a new Run Control ID, click on the |Add a New Value| tab.
2. On the Add a New Value page for nVision Reports, type a name for your Run Control ID. The name you type should contain no spaces (may use the underscore character) and should give an indication of the topic of the report.
3 2
1
delete them or rename them.
3. Click the button.
The CW nVision Reports page will display. It is on this page that you will specify the criteria for the report.
The Report ID, the Sub Report ID and the Through Date fields are all required fields on the
CW nVision Reports page (as is indicated by the * that precedes the names of the fields). The Select On This Report Field and the Report Field Value fields must also be populated before
the report(s) can be run.
4. Click the magnifying glass for the Report ID field. When the Look Up Report ID page opens, you may need to click the button to get the choices to appear. Click on the link for the Report ID of your choice in the Search Results. For most users, this will be one of the first three choices on the page: PROJECT SUMMARY REPORT, PROJECT ACTIVITY
REPORT or PROJECT BALANCE REPORT. After making your choice, you will be returned to
the CW nVision Reports page, and the Report ID field will populate with your choice.
5. Click the magnifying glass for the Sub Report ID field. When the Look Up Sub Report ID page opens, you may need to click the button to get the choices to appear. Click on the link for the Sub Report ID of your choice in the Search Results. See the informational note below.
It is in the Sub Report ID that you specify the particular detail that you want in the type of report you chose for your Report ID. For example, do you want one month of detail, or do you want the entire fiscal year’s detail? Do you want to see the Operating Unit (Campus Location) on the report, or not?
Report ID field will populate with your choice.
6. Click the magnifying glass for the Select On This Report Field field. When the Look Up
Select On This Report Field page opens, you may need to click the button to get the choices to appear. Click on the link for the Chart Field of your choice in the Search Results. You will be returned to the CW nVision Reports page, and the Select On This Report Field field will populate with your choice.
7. Use the Through Date field to specify the end-of-month/end-of-year date through which you wish to view the report. You may either type the date into the Through Date field, or click the
calendar icon to choose the date. See the informational note below.
When filling in the Through Date field, even though you specify a specific date, the report generated will provide all data available for the month/year specified.
8. Type the appropriate information in the Report Field Value field(s). If you are unsure of what to enter, click the magnifying glass for the Report Field Value field. When the Look Up
Report Field Value page opens, you may need to click the button to get the choices to appear. Click on the link for the Report Field Value of your choice in the Search Results. In the screen shot above, “11765500 and “11776100” (project ID numbers) were entered as the
Report Field Values. See the informational note below regarding the addition or deletion of rows in this area, if need be.
If you need additional rows in the Report Field Value area, click the button. If you need to delete a row, click the button in that particular row.
9. If you wish to save the criteria you specified on this page under the Run Control ID you entered, click the button.
10. To add another Run Control ID, click the button. Follow the directions in this section again, beginning with step 2 above.
4.1.1 Project Activity (Month-end - No Operating Unit)
To set up the Run Control for the month-end “Project Activity” report that does not include a column for Operating Unit (Campus Location), choose “PROJECT ACTIVITY REPORT” for the Report ID, “Project
Activity” for the Sub Report ID, “Project” for the Report Field, the Through Date of your choice and then
your Project ID number(s) for the Report Field Value(s). Refer to section 4.1 of this document if you need additional help in setting up the Run Control.
To set up the Run Control for the “Project Activity – Entire Year” report that does not include a column for Operating Unit (Campus Location), choose “PROJECT ACTIVITY REPORT” for the Report ID, “Project
Activity – Entire Year” for the Sub Report ID and “Project” for the Report Field. In the Through Date
field, enter any date that is in the fiscal year for which you want to see activity (i.e. For FY10, enter any date between July 1, 2009, and June 30, 2010). Finally, enter your Project ID number(s) for the Report
Field Value(s). Refer to section 4.1 of this document if you need additional help in setting up the Run
Control.
4.1.3 Project Activity with Operating Unit (Month-end)
To set up the Run Control for the month-end “Project Activity with Operating Unit” report, which includes a column for Operating Unit (Campus Location), choose “PROJECT ACTIVITY REPORT” for the Report
ID, “Project Activity w-Oper Unit” for the Sub Report ID, “Project” for the Report Field, the Through Date
of your choice and then your Project ID number(s) for the Report Field Value(s). Refer to section 4.1 of this document if you need additional help in setting up the Run Control.
4.1.4 Project Activity with Operating Unit – Entire Year
To set up the Run Control for the “Project Activity Entire Year with Operating Unit” report, which includes a column for Operating Unit (Campus Location), choose “PROJECT ACTIVITY REPORT” for the Report
ID, “Project Activity Ent Year w-Oper Unit” for the Sub Report ID and “Project” for the Report Field. In
the Through Date field, enter any date that is in the fiscal year for which you want to see activity (i.e. For FY09, enter any date between July 1, 2008, and June 30, 2009). Finally, enter your Project ID number(s) for the Report Field Value(s). Refer to section 4.1 of this document if you need additional help in setting up the Run Control.
4.1.5 Project Activity with Student Financials Detail and Operating Unit (Month-end)
To set up the Run Control for the month-end “Project Activity with Student Financials Detail and
Operating Unit” report, which includes a column for Operating Unit (Campus Location) as well as a tab at the bottom of the report for Student Financials Detail, choose “PROJECT ACTIVITY REPORT” for the
Report ID, “Project Activity w-SF and Oper Unit” for the Sub Report ID, “Project” for the Report Field,
4.1.6 Project Activity with Student Financials Detail and Operating Unit – Entire Year
To set up the Run Control for the “Project Activity Entire Year with Student Financials Detail and
Operating Unit” report, which includes a column for Operating Unit (Campus Location) as well as a tab at the bottom of the report for Student Financials Detail, choose “PROJECT ACTIVITY REPORT” for the
Report ID, “Project Activity Ent Year w-SF and Oper Unit” for the Sub Report ID and “Project” for the Report Field. In the Through Date field, enter any date that is in the fiscal year for which you want to see
activity (i.e. For FY09, enter any date between July 1, 2008, and June 30, 2009). Finally, enter your
Project ID number(s) for the Report Field Value(s). Refer to section 4.1 of this document if you need
additional help in setting up the Run Control.
4.1.7 Project Summary (Month-end - no Operating Unit)
To set up the Run Control for the month-end “Project Summary” report, which can be expanded to show activity for the past months of the fiscal year, choose “PROJECT SUMMARY REPORT” for the Report
ID, “Project Summary” for the Sub Report ID, “Project” for the Report Field, the Through Date of your
choice and then your Project ID number(s) for the Report Field Value(s). Refer to section 4.1 of this document if you need additional help in setting up the Run Control.
4.1.8 Project Summary – Adjusted Year End
Since the “Project Summary – Adjusted Year End” report can only be run after the fiscal year has closed, the most sensible way to set up the Run Control criteria for the report is to use the Run Control for the month-end “Project Summary” report, adjusting the criteria for the two fields that need to be changed. After you have run the year-end report, simply change the criteria back.
To do this, make sure you have followed the directions for setting up the month-end “Project Summary” report Run Control, as explained in section 4.1.5 above. Bring up that Run Control, referring to section 4.2 of this document, if need be, for help in pulling up a Run Control you had previously set up. The two fields that will need to be changed in the Run Control are the Sub Report ID (choose “Project Summary –
Adjusted Year End” ) and the Through Date (enter the ending date of the fiscal year - 06/30/xx, where xx
is the last two digits of the fiscal year). Changing these two fields will allow you to get the information from the adjustment period to show up on your report. ***Note*** If you enter any other date, the report will
run, but it will include the adjustment period as well as the date range you specified (i.e. Running this report for 7/31/08 would include Period 1 and Period 998, where Period 998 is the adjustment period).
Run the report as you would any other nVision report. For additional information regarding Adjusted Year End reports, refer to section 6.0 of this document.
4.1.9 Project Summary with Operating Unit (Month-end)
To set up the Run Control for the month-end “Project Summary with Operating Unit” report, choose
“PROJECT SUMMARY REPORT” for the Report ID, “Project Summary w-Oper Unit” for the Sub Report
ID, “Project” for the Report Field, the Through Date of your choice and then your Project ID number(s)
for the Report Field Value(s). Refer to section 4.1 of this document if you need additional help in setting up the Run Control.
4.1.10 Project Balance (Month-end)
To set up the Run Control for the month-end “Project Balance” report, choose “PROJECT BALANCE
REPORT” for the Report ID, “Project Balance” for the Sub Report ID, “Project” for the Report Field, the
Through Date of your choice and then your Project ID number(s) for the Report Field Value(s). Refer to
4.1.11 Project Balance – Adjusted Year End
Since the “Project Balance – Adjusted Year End” report can only be run after the fiscal year has closed, the most sensible way to set up the Run Control criteria for the report is to use the Run Control for the month-end “Project Balance Report,” adjusting the criteria for the two fields that need to be changed. After you have run the year-end report, simply change the criteria back.
To do this, make sure you have followed the directions for setting up the month-end “Project Balance Report” Run Control, as explained in section 4.1.8 above. Bring up that Run Control, referring to section
4.2 of this document, if need be, for help in pulling up a Run Control you had previously set up. The two
fields that will need to be changed in the Run Control are the Sub Report ID (choose “Project Balance – Adjusted Year End” ) and the Through Date (enter the ending date of the fiscal year - 06/30/xx, where xx
is the last two digits of the fiscal year). Changing these two fields will allow you to get the information from the adjustment period to show up on your report. ***Note*** If you enter any other date, the report will
run, but it will include the adjustment period as well as the date range you specified (i.e. Running this report for 7/31/08 would include Period 1 and Period 998, where Period 998 is the adjustment period).
Run the report as you would any other nVision report. For additional information regarding Adjusted Year End reports, refer to section 6.0 of this document.
4.1.12 Project Balance – Year to Date Comparative (Month-end)
To set up the Run Control for the month-end “Project Balance – Year to Date Comparative” report,
choose “PROJECT BALANCE REPORT” for the Report ID, “Project Balance – Year to Date comparative” for the Sub Report ID, “Project” for the Report Field, the Through Date of your choice and then your
Project ID number(s) for the Report Field Value(s). Refer to section 4.1 of this document if you need
additional help in setting up the Run Control.
4.1.13 Departmental Summary by Project (Month-end)
To set up the Run Control for the month-end “Departmental Summary by Project” report, choose “DEPT
SUMMARY BY PROJECT” for the Report ID, “Departmental Summary by Project” for the Sub Report ID, “Department Code” for the Report Field, the Through Date of your choice and then your Department ID number for the Report Field Value. Refer to section 4.1 of this document if you need additional help in
setting up the Run Control.
Refer to section 4.3 of this document for instructions on running the report.
4.2 Accessing an Already Existing Run Control ID
If you have not already accessed the Find an Existing Value page for nVision Reports, follow the directions in section 4.0 above to do so.
1. On the Find an Existing Value page for nVision Reports, click the button. 2. When the Search Results appear beneath the button, click on the link for the Run
3. The CW nVision Reports page will appear, and the criteria that you specified for that Run Control ID will populate the fields. You may make changes to any of the fields, if desired, before continuing. At the very least, you will likely want to change the Through Date. Remember that the Report ID, the Sub Report ID and the Through Date fields are all required fields on the CW nVision Reports page (as is indicated by the * that precedes the names of the fields). The Select On This Report Field and the Report Field Value fields must also be populated before the report(s) can be run.
4. To pull up a different Run Control, click the button, which will return you to the
Find an Existing Value page for nVision Reports. Return to the directions at the beginning of
this section above.
To run the report for this Run Control, refer to the directions in section 4.3 below.
4.3 Running a Report
Follow the directions in section 4.1 or 4.2 above to pull up the Run Control criteria for one of your nVision reports.
If you have just run an nVision report and are planning to immediately use the same Run Control to run the report for a different month, it is imperative that you wait until the Process
Monitor page (see section 4.3.1 below) displays “Success” under Run Status for the report
request you just completed. Failure to wait for the “Success” message may result in subsequent report requests displaying data that does not match what you requested.
3
1. Make sure that the
Through Date is
the date you desire before running your reports. 2. On the CW
nVision Reports
page, click the button to continue.
3. Click the button on the message that displays
4. You may notice that the button is now “grayed out.” Your reports are now processing.
If you need to know the minute your reports are finished processing, refer to the directions in section
4.3.1 below.
If you are ready to view your reports, refer to section 4.3.2 below. 3
4
Processing
The directions below assume that you have sent off a request for a report and are looking at the CW
nVision Reports page. If that is not the case, and you need to navigate to the Process Monitor page
manually, the Navigation Path is the following:
Main Menu > Financial Management > PeopleTools > Process Scheduler > Process Monitor
1. To monitor when your reports finish processing, go to the Process Monitor in one of the two ways provided in the directions above (either navigating to the page manually by following the
Navigation Path or through the CW nVision Reports page, as in the screen shot above).
2. If you get the message above, click the button. 2 8
3. On the Process List page, you will see one row of information for each report request that you ran in the Last “X” number of Days.
4. Under the View Process Request For header, you may need to click the button one or more times until the Run Status displays “Success” and the Distribution Status displays “Posted” for your report request.
If you are planning to immediately use the same Run Control to run the report for a different month, it is imperative that you wait until the Process Monitor page displays “Success” under
Run Status for the report request you just completed. Failure to wait for the “Success” message
may result in subsequent report requests displaying data that does not match what you
requested. Click on the Go Back to Nvision Reports link (see screen shot above) to return to the
CW nVision Reports page. Return to the directions in section 4.3 above.
5. If need be, refer to the Run Date/Time column to verify which report request you should be looking at.
6. If you have run a lot of reports, you may want to write down the Instance number (second column under the Process List header) of your report request. ** You may highlight the
Instance number, right click, and copy it. Doing so will help you to quickly locate your reports
through Report Manager after they have finished successfully posting.
7. Once you have verified that your nVision reports have run and posted successfully, you are able to view them. Click on the Go Back to Nvision Reports link (see screen shot above) to return to the CW nVision Reports page…,
8. …where you can then click on the Report Manager link.
4.3.2 Accessing Your Reports through the Report Manager
After running your nVision reports and allowing them time to finish processing and posting, you will want to navigate to the Report Manager page to view the reports. You can navigate to the Report Manager page in one of two ways:
5
4
6
1. If you are currently viewing the CW nVision Reports page, you can easily navigate to the
Report Manager page by clicking on the Report Manager link (see screen shot above).
To navigate to the Report Manager page manually, use the following Navigation Path:
Main Menu > Financial Management > Reporting Tools > Report Manager
2. When the List page of Report Manager appears, click on the |Administration| tab. 1
Tips for Working with the Administration Page of Report Manager:
On the Administration page of Report Manager, you may want to type the 6-digit Instance number (that you wrote down in section 4.3.1 above) into the Instance field (suggested if you have multiple report requests that involve a lot of reports). ** If you highlighted and copied the
Instance number, you may paste it into the Instance field. ** Doing so will allow you to narrow
the report links you see to only those that were generated through the request associated with the Instance number you entered.
1. Click the button.
4. Click on the Details link for the report with which you would like to work. 2. You should see a link to each report generated in your request(s).
3. If you do not, it may be that you generated your report request(s) more than 1 Day ago. If that is the case, you will need to adjust the Last fields accordingly so that the links to your reports display.
2 4
5. When the Report Detail page displays, you have 2 options:
If you simply wish to open the report so you can view/print it, refer to section 4.3.3 below
If, however, you have numerous reports that you are going to want to print, refer to section
4.3.4 below.
4.3.3 Opening Your Report to View/Print
Assuming you have followed the directions in section 4.3.2 above so that you are looking at the Report
Detail page (displays the .xls link for your report under the File List header), continue with the directions below to simply open the report to view/print. If you are not looking at the Report Detail page, follow the directions in section 4.3.2 above first.
1. Under the File
List header of the Report Detail
page, click on the link for the .xls file.
report will be downloaded to your desktop. You will need to “X” out of the Downloads box that
appears and click twice on the report’s icon. If a Microsoft Excel box appears regarding macros, click the button to Enable Macros. Your report document will open in Microsoft Excel.
As with any Microsoft Excel document, you may save or print your report. For specific directions on formatting your report to print the gridlines, refer to the appropriate section of this document (see Table
of Contents). For detailed information about “Working with the Reports,” continue with the appropriate section of this document (see Table of Contents).
2. If a File Download box appears, click to open the file.
3. If you receive a Security Warning regarding Macros, click the button.
Another window containing the report in Excel format will display.
As with any Microsoft Excel document, you may save or print your report. For specific directions on formatting your report to print the gridlines, refer to the appropriate section of this document (see Table
of Contents).
For detailed information about “Working with the Reports,” continue with the appropriate section of this document (see Table of Contents).
4.3.4 Printing Multiple Reports at One Time
Assuming you have followed the directions in section 4.3.2 above so that you are looking at the Report
Detail page (displays the .xls link for your report under the File List header), continue with the directions below to print more than one report at a time. If you are not looking at the Report Detail page, follow the directions in section 4.3.2 above first.
2
1. On the Report Detail page, right click on the .xls link for the report.
2. Choose to “Save Link As…” Please note that you may see the option to “Save Target As…,” which works the same as “Save Link As…”
3. When the Save As box appears, click the dropdown arrow of the Save in field and choose a location to create a new folder on your computer for your reports. In the example above, the N:
2
named Monthly FMS Reports.
5. Click the button to open the new folder.
6. Then click the button to save the report to the folder you created. 7. If a Download complete box pops up, you may want to check the checkbox
to bypass the Download complete box from now on. If not, you will need to click the button to exit the Download complete box.
4
5
6
7
8. To save other reports to the folder you created, click either the or button to return to the Report Manager’s |Administration| tab. Follow the directions above again,
beginning with “Tips for Working with the Administration Page of Report Manager“ in section
4.3.2.
When finished saving all of your reports to the folder you created above, minimize the FMS Reports database and open the folder you created above.
10. Right click one of the reports and choose to “Print.”
11. If you receive one or more Security Warnings about macros, choose to .
12. If you receive the above message about saving changes, click the button of your choice. The message may appear once for each report you sent to the printer.
Your computer should print all of the reports that you highlighted. If it only prints one of the reports, you may need to right click on each report in the folder you created and choose to print.
10
11
5.0
Working with the Reports
To learn about the Zoom feature within a Report, refer to section 5.1 (for Excel 2007) or 5.2 (for Excel 2003) below.
To learn about expanding sections of a Report to view additional detail, refer to section 5.3 below.
5.1 Zooming on a Report in Excel 2010
Once you have opened your report from the Report Manager folder, you can adjust the amount of information displayed on the screen at one time by using the Zoom feature of Excel.
1. Assuming you have your .xlsx report open, click on the |View| tab at the top of your screen. 2.
Click the icon to open the Zoom dialog box to specify the zoom level of your document. 3. In the Zoom box that appears, click the radio button for the percentage Magnification you
want. See the informational note below.
The smaller Magnification you select, the more of the Report you will be able to view on your screen at one time. Keep in mind, however, that the smaller the magnification, the more difficult the screen is to read.
4. Click the button.
5.2 Zooming on a Report in Excel 2007
Once you have opened your report from the Report Manager folder, you can adjust the amount of information displayed on the screen at one time by using the Zoom feature of Excel.
1
2
3
5. Assuming you have your .xlsx report open, click on the |View| tab at the top of your screen. 6.
Click the icon to open the Zoom dialog box to specify the zoom level of your document. 7. In the Zoom box that appears, click the radio button for the
percentage Magnification you want. See the informational note below.
The smaller Magnification you select, the more of the Report you will be able to view on your screen at one time. Keep in mind, however, that the smaller the magnification, the more difficult the screen is to read.
8. Click the button.
5.3 Expanding/Collapsing Sections of a Report
Once you have opened your report, you may be able to get Additional Details or hide details within certain sections of the report.
1 2
3
1. A in the margin at the top or on the left-hand side of the report indicates that that row/column may be expanded to reveal additional details. To expand, click on the button. In the example above, clicking on the button above the YTD column for Actual Activity will reveal details about the amounts listed in that column (outlined above for ease of identifying which column is being referenced).
2. The area outlined in the screen shot above shows the additional details that are revealed after clicking on the button
above the YTD column for Actual Activity.
3. Likewise, any row/column that has a button in the left-hand or top margin of the report may be collapsed, which will hide the details that correspond to that row/column. In the screen shot above, one row may be collapsed, Total Expenses, as well as one column, YTD for Actual Activity.
It is also possible to expand/collapse ALL row or column sections that have a
/ at one time. See information in steps below.
4. To expand all row sections that may be expanded in the above report (Total Assets, Total
Liabilities, Total Fund Balance and Total Expenses, in this case), click the button at the top of the left-hand margin. If there is no button, then click the button.
5. The result will be the same report with the expandable rows (Total Assets, Total Liabilities,
Total Fund Balance and Total Expenses, in this case, as well as Goods & Services, which is
a subset of Expenses) expanded to show the details of those cells.
6. To collapse the expanded rows once again, click the button at the top of the left-hand margin. 7. By the same token, it is possible to expand/collapse ALL columns that have a / at one time
by clicking the or button, respectively, in the top header.
5.4 Printing a Report with Gridlines
If you are planning to print your Excel report, you may wish to have the gridlines print. The set-up below is required if you want the gridlines to print regardless of whether you are using a Mac or a PC.
For directions on printing gridlines in Excel 2010, refer to section 5.4.1 below. For directions on printing gridlines in Excel 2007, refer to section 5.4.2 below.
5.4.1 Setting up Your Report to Print Gridlines in Office 2010
4
5
1. Assuming you have your .xlsx report open, click on the |Page Layout| tab at the top of your screen.
2. Under Gridlines, check the checkbox to Print.
Gridlines will now print on your .xlsx document when you choose to print it.
If you would like gridlines to print on all of your Excel documents, you will need to perform the above set-up with each report as there is no way to default Microsoft Excel to print Gridlines.
5.4.2 Setting up Your Report to Print Gridlines in Office 2007
3. Assuming you have your .xlsx report open, click on the |Page Layout| tab at the top of your screen.
4. Under Gridlines, check the checkbox to Print.
Gridlines will now print on your .xlsx document when you choose to print it.
If you would like gridlines to print on all of your Excel documents, you will need to perform the above set-up with each report as there is no way to default Microsoft Excel to print Gridlines.
6.0
Year-end Reports
In addition to running the month-end reports, some users will need to run Adjusted Year End reports. The reason for this is that the regular month-end reports will not show the data from the adjustment period.
To determine if you need to run the Adjusted Year End reports, first run the following query: CWGL_ADJ_PROJ_BY_FY_B. (For directions on running a query, refer to Chapter 6 entitled “End User Queries”). This query will prompt you to enter the fiscal year (i.e. 2009). When you do so, the query will return a list of Project ID numbers that have posted adjustment activity in the 40000 to 69999 account range. If you find any of your project ID numbers in the list, you will need to run the Adjusted Year End reports. Do so even if the Sum Total Amt column in the query posts as 0.000. If your project ID numbers are not in the list, then you do not need to run any Adjusted Year End reports.
2 1
As is necessary before running the month-end reports, if you are a PC user and have not taken care of the computer settings outlined in section 2.0 of this document, you will need to do so before attempting to retrieve or work with the financial reports.
Be aware that the process for setting up and running year-end reports works the same as the process for setting up and running month-end reports. If you find that you are in need of a refresher, refer to section 4.0 of this document.
1. To work with the “Project Summary - Adjusted Year End” report, refer to section 4.1.8 of this document.
