slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Financial Information System Running Reports in FIS PowerPoint Presentation
Download Presentation
Financial Information System Running Reports in FIS

Loading in 2 Seconds...

play fullscreen
1 / 27

Financial Information System Running Reports in FIS - PowerPoint PPT Presentation


  • 121 Views
  • Uploaded on

Financial Information System Running Reports in FIS. financial information system running reports in FIS. Overview. Locating the report you wish to run. Changing your task view to access end-user reports. Selecting the proper report to run. Submitting your report to run.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Financial Information System Running Reports in FIS' - vesta


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Financial Information System

Running Reports in FIS

slide2

financial information system

running reports in FIS

Overview

  • Locating the report you wish to run.
    • Changing your task view to access end-user reports.
    • Selecting the proper report to run.
  • Submitting your report to run.
    • Step-by-step instructions.
    • Run time decisions: data selection and processing options.
  • Outputting your report.
    • Managing your job queue.
    • Accessing .pdf and .csv files to view, analyze and print your report.
slide3

financial information system

running reports in FIS

Section 1 – Locating the Report

  • Where do I find the end-user reports on FIS?
  • Which reports are available for me to run?
  • Which report should I run to get the information I need?

This section will provide answers to the following

questions…

slide4

financial information system

running reports in FIS

The End-User Reports Task View

  • End-user reports are located in the “End-User Reports” task view.
  • Select the appropriate task view from the dropdown list provided.

Click the arrow

to reveal the

dropdown list.

Then select the

“End-User Reports”

task view from

the dropdown list

provided.

slide5

financial information system

running reports in FIS

End-User Reports

  • The following screen print displays the reports available to all end users…
slide6

financial information system

running reports in FIS

Which report should you run?

  • The following chart explains the output each of the end-user reports will generate…
slide7

financial information system

running reports in FIS

The Budget Comparison Report

slide8

financial information system

running reports in FIS

The Trust Summary Report

slide9

financial information system

running reports in FIS

The General Ledger Detail Report

slide10

financial information system

running reports in FIS

The Trial Balance by Business Unit Report

slide11

financial information system

running reports in FIS

The Trial Balance by Object Account Report

slide12

financial information system

running reports in FIS

Section 2 – Submitting Reports to Run

  • Data Selection
  • Processing Options
  • Output Options

This section provides step-by-step instructions for

running reports by examining the following run-time

options…

slide13

financial information system

running reports in FIS

Data Selection

  • Data selection allows you to define the criteria by which records are included in your report.
  • Reports requiring or permitting data selection will prompt you with the following graphic.
  • Check the appropriate box for data selection and then submit your report.
slide14

financial information system

running reports in FIS

Making your Data Selection

  • Operator
    • Where is the default value for the first set of criteria.
    • For subsequent statements And and Or become the available values in this column.
  • Left Operand
    • Provides a list of fields to perform data selection against.
    • For example: Company; Business Unit; Object Account; etc…
  • Comparison
    • Provides a list of comparison operators use to perform the data selection.
    • For example: is equal to; is greater than; is greater than or equal to; is not equal to, etc…
  • Right Operand
    • Identifies the selection criteria limiting the report data.
    • Most often this will be a “Literal” constant.
slide15

financial information system

running reports in FIS

Literal Selection (Single Value)

  • Single Value
    • Enter a single value, and then click OK.
    • For example, you might enter business unit “19250”.
slide16

financial information system

running reports in FIS

Literal Selection (Range of Values)

  • Range of Values
    • Enter a range of values, and then click OK.
    • For example, you might include all object accounts from “5000” to “9999”.
    • Only is equal to and is not equal to are valid logical comparison operators when using a range of values.
slide17

financial information system

running reports in FIS

Literal Selection (List of Values)

  • List of Values
    • Type each value in the field, and then press Enter or click the Add button.
    • Repeat the above process until your list of values is complete
    • For example, you might include a list of ledger types “AA, BA & PA”.
    • You can delete a value from the list by choosing the value and then clicking the Delete button.
    • Only is equal to and is not equal to are valid logical operators when using a list of values.
slide18

financial information system

running reports in FIS

Processing Options

  • Options available to further specify your report details at run time.
  • Selections may be different for each report.
  • Blank selections default as quoted.
  • Typically includes a period or date selection.
slide19

financial information system

running reports in FIS

Entering a Date

  • Enter a two digit year representing the start of the fiscal year.

For example: use 03 for the 2003/04 fiscal year.

  • The University of Windsor uses an April 30th fiscal year-end.

Choose the appropriate period number from the chart below.

slide20

financial information system

running reports in FIS

Output Specifications

slide21

financial information system

running reports in FIS

Section 3 – Report Output

  • Navigate the View Job Status application.
  • View or print your report from a .pdf (Portable Document Format) file.
  • Edit or analyze your report from a .csv (Comma Separated Values) file.
  • Manage your job queue.

In this section we will manage report output by

learning to…

slide22

financial information system

running reports in FIS

View Job Status

  • After a report has been submitted, the output can be obtained from the View Job Status application.

Click here

slide23
Selecting View Job Status will launch the Work with Servers application.

Use the following steps to select the finance server (finesrv):

financial information system

running reports in FIS

Choosing the “finesrv” Server

1. Click Find

2. Click the check

box next to

“finesrv”

3. Click Select

slide24

financial information system

running reports in FIS

Managing your Submitted Jobs

  • Submitted reports will appear in your finesrv job queue as depicted above.
  • Submitted reports may have the following status:
  • Clicking Find will refresh this screen (similar to “F5” on the old system).
  • Reports require a “Done” status before they can be accessed.
slide25

financial information system

running reports in FIS

Viewing Reports from a .pdf File

  • Use the following steps to view a report in Adobe Acrobat Reader:

1. Click the check box next to the report you wish to view.

2. Click the Row button to reveal a drop

down menu.

3. Select View PDF from the drop down menu.

4. Adobe Acrobat Reader will automatically

open to display your report.

slide26

financial information system

running reports in FIS

Editing Reports from a .csv File

.csv must have been selected from the output specs

to allow you to export a .csv file to Microsoft Excel.

  • Use the following steps to export your .csv file to Microsoft Excel for editing/analysis:

1. Click the check box next to the report you wish to edit.

2. Click the Row button to reveal a drop

down menu.

3. Select View CSV from the drop down menu.

4. Microsoft Excel will automatically open

to display your report.

slide27

financial information system

running reports in FIS

Managing your Job Queue

  • Be sure to keep your job queue neat and tidy!!!
  • Use the following steps to remove reports from your queue:

1. Click the check box next to the report(s) you wish to delete.

2. Click the Delete button

to remove the selected

report(s) from your job queue.

3. Click OK in the pop up window

to confirm that you wish to delete

the selected reports.