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.

 

  1. Type in FWRDETS in the Direct Prompt and press Enter
  2. Click the Go button and then Next Section  or just click, with our mouse, into an empty Values line.
  3. 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.
  4. 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.

  5. 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.

  6.  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 charactersWhat to Type/Example

01 Required

Fiscal Year - 2 characters15
02 RequiredFund Code - 6 characters (No wildcard %, no rollup)1000
03 RequiredOrgn Code - 6 characters (No wildcard %, rollup allowed)A4 or A408 or A40801
04 RequiredAccount Code - 6 characters (No wildcard %, rollup allowed)03
05 OptionalProg Code - 6 characters (no wildcard %, roll up allowed)21
06 RequiredBeginning Date of range within FY (DD-MON-YYYY)01-JUL-2014
07 RequiredEnding Date of range within FY - (DD-MON-YYYY)30-JUN-2015
08 RequiredSort Order by D for Date or F for FOAPD or F