FOAPAL Reports

Running WEB Reports

If you cannot scroll through pages/down the page of a WEB report, you may need to run the report in a different browser. IT Services recommends using Chrome. More information about supported browsers is available in the IT Knowledge Base.

Instructions for logging in to reports and exporting data is available on the Running Web & Crystal Reports page.
Crystal Reports software is not required to run the web report templates.


FOAPAL Report Templates

Fund Information WEB Report

File Fund Information CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays all non financial information relating to a Fund. You can only query one Fund at a time. Use the Organization Fund Information or Organization Grant Information Reports to retrieve all Funds/Grants within a Org.

Report Help:
Fund Information [.pdf]

Prompting Query Fields:
- Fund code

View Information [for Crystal Report]
View: FG.Statement.Heading
View Help: Statement Heading [.pdf]

Organization Fund Information WEB Report

File Organization Fund Information CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Displays all non-financial information for all funds (including Grants) within an Organization code. Any Fund with the same default Org code will be displayed.

Report Help:
Organization Fund Information [.pdf]

Prompting Query Fields:
- Org Code

View Information [for Crystal Report]
View: FG.Statement.Heading
View Help: Statement Heading [.pdf]

FOAPAL Verification WEB Report

File FOAPAL Verification CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Designed as a look up report for FOAPAL code validation. Will display all matches for the code entered for any part of the FOAPAL string. Ideal for use by service departments that generate feed files to Financial Services.

Report Help:
FOAPAL Code Verification [.pdf]

Prompting Query Fields:
- FOAPAL code

View Information [for Crystal Report]
View: FG.Foapal.Code.Translation
View Help: FOAPAL Code Translation [.pdf]

Fund Listing by Department Org Code WEB Report

File Fund Listing by Department Org Code CRYSTAL Report

Description, Prompting Query Fields, Help Documentation

Last modified:
2007-01-31

Description:
Lists all funds (including funds linked to Grants) under a specific Department Organization Code. Grouped by Fund Financial Manager’s McGill ID.

Report Help:
Fund Listing by Department Organization [.pdf]

Prompting Query Fields:
- Dept. Org code

View Information [for Crystal Report]
View: FG.Fund.Profile
View Help: Fund Profile [.pdf]