FWREXPR is a report that is downloadable into a spreadsheet with details about transactions spent out of a budget. Click here for instructions on how to download this report into Word or Excel. The report will show the document numbers, transaction dates, amounts, and some document text explaining the budgeted amount, expense, reservation or encumbrances. Another useful pdf report for similar data is FWRDETS.
- Type in FWREXPR in the Direct Prompt (Go To ...) field.
- Click the Go button. Click the Next Section icon or just click, with our mouse, into an empty Values line.
- Type in parameter values based on what the Parameter line description is and the Hint Line below the Parameters column. Use the direction arrows (down and up) to navigate from line to line.
When all the Values have been completed, click on the 'Save Parameter Save as' in the lower 'Submission Section' to save this set and then click on the 'Save' button or F10 on a PC keyboard
If you don't need to save the Values, click on the Submit button in the Submission Section and click on the 'Save' button. Most reports do not need a report name. Contact the Training Team if you want to know more about naming your report.
Go to the 'Report Viewer' to view/print your report.
For help with viewing/printing a Banner report from Report Viewer, refer to: Viewing/Printing a Banner Report.
|Line #||Parameter Value & Maximum characters||What to Type/Example|
|Fiscal Year - 2 characters||15|
|02 Required||Fund Code - 6 characters (Roll up OK, no wildcard)||1000|
|03 Optional||Orgn Code - 6 characters (Roll up OK, no wildcard)||A40801|
|04 Required||Acct Code - 6 characters (Roll up OK, no wildcard)||03010 or 03|
|05 Optional||Prog Code - 6 characters (Roll up OK, blank for all)||21|
|06 Optional||Activity Code - Do not use||blank|
|07 Optional||Location Code - Do not use||blank|
|08 Optional||Beginning Date of range within FY - blank for fiscal start||blank|
|09 Optional||Ending Date of range within FY - blank for fiscal end||blank|
|10 Required||Transaction Type - B for Budget, X for expenses, R for Reservations, E for Encumbrance||typically X, R or E|