Embedded Files
The ways are numerous and in all cases have their pros and cons when it comes to tracking down the balance of an index code. All grant related index balance questions must be referred to the DRSS. For all the rest, one of the following methods should work.
COGNOS (DataMASTER)
The following COGNOS report is one tool at your disposal. This report can be set up to run automatically on a set schedule and be delivered via email.
Report Title = PSU Monthly Activity Report by Multiple Indexes - F0022
Report Location = Production Content --> Finance --> Operating Activity
This report works best on indexes where there are no blanks in the FOAPAL string AND the funds available are budgeted. Some modifications will be needed on indexes that are revenue based such as course fee or designated operating funds. This report is not recommend for the xxxG01 index.
The document attached at the bottom of the page provides visual details on how to find the FOAPAL elements needed to run the report.
ZFGFYESI
This report is in the BANNER FIS Report Menu.
Pros:
- Quick to run.
- Can break out activity codes into separate line items.
Cons:
- CSV output needs quite a bit of tweaking to make it presentable.
- Manual correction of available balances needed for revenue funds. Budget entries on these funds are estimates that must be removed then the opening fund balance needs to be looked up and added in manually.
No way to drill down into details.
Parameters to enter into the report; if nothing is listed for a parameter, then leave it blank:
01 - Fiscal Year Enter last 2 digits of the current fiscal year.
02 - FROM Date Use the begin date of the current fiscal year (July 1st). In BANNER, you can type in the six digits for the date - MMDDYY - and it will format the date correctly for the report parameter.
03 - TO Date Type "T" for today (another BANNER date shortcut) or the end of the current fiscal year (June 30th) using the six digit date - MMDDYY.
07 - Org Code Enter the organization code for your department.
09 - Actv Type "%" which tells BANNER to show all activity codes on a separate line item. If this parameter is left blank, the activity code transactions will roll up into the parent index/fund.
FGIBDSR
This form is in the BANNER General Ledger Menu.
Pros:
- Super speedy.
- Easy to drill down to the individual transaction details.
Cons:
- Activity codes automatically roll up to the parent index/fund and cannot be excluded. However, they can be looked at individually without the parent index/fund information intermingled.
- Payroll information is in summary form only and cannot be drilled down into.
- Net totals at bottom of screen are incorrect for revenue indexes due to the inclusion of "fake" budget and this form does not include the cumulative fund balance.
>> How to run the information.
>> How to drill down into transaction details.
>> How to pull the information out of BANNER and into a spreadsheet.
FGITBSR
This form is in the BANNER General Ledger Menu. Use only for funds that are unique and limited.
- Example of a fund where this screen is really useful: 002205 which houses only Anthropology course fee income and expenses.
- Example of a fund where this screen is completely useless: 001035 which houses ALL E&G funds for CLAS - yep, all 26 departments.
Pros:
- Super speedy.
- Includes prior year funds that carry forward.
- Great for revenue index/funds.
Cons:
- Only useful for limited scope funds as described above.
- Runs by fund, so if the fund has multiple indexes or activity codes then these get lumped together.
- Limited ability to drill down into details ... and what is there is not all that useful, truth be told.
Report abuse