With FWRDETS, you can run a budget detail report listing all expenditures for a specified period of time for a given department budget (FOAP). The report can be run for one department Org. code and one account number at a time (for example: C30301 & 03010), or for a roll up Org. code and a roll up account number (for example: C303 & 03). You can also sort this report by transaction date or FOAP. The completed report shows document numbers, descriptions, amounts, FOAPs, and totals (on the last page).
When using this report to determine the amount of money that has been expended from your budget between specific dates, please keep in mind that FWRDETS will use the "transaction date" (the date in which the money was first encumbered) as the basis of its reporting and not the date the transaction was eventually taken out of "Year to Date" activity.
- Type in FWRDETS in the Direct Prompt and press Enter
- Click the Go button and then Next Section 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 Block' 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 (No wildcard %, no rollup)||1000|
|03 Required||Orgn Code - 6 characters (No wildcard %, rollup allowed)||A4 or A408 or A40801|
|04 Required||Account Code - 6 characters (No wildcard %, rollup allowed)||03|
|05 Optional||Prog Code - 6 characters (no wildcard %, roll up allowed)||21|
|06 Required||Beginning Date of range within FY (DD-MON-YYYY)||01-JUL-2014|
|07 Required||Ending Date of range within FY - (DD-MON-YYYY)||30-JUN-2015|
|08 Required||Sort Order by D for Date or F for FOAP||D or F|