FWRODTA or FWRPDTA

The FWRODTA and FWRPDTA reports break down the expense transactions based on the Fund, Organization, Account and Program codes. These reports show Transaction Dates, Document numbers, Descriptions, Account Codes, the amount Budgeted, Individual Transactions, and Encumbrances, Reservations and Commitments.

Procedures:

  1. In Banner, search for FWRPDTA or FWRODTA. This will auto-fill the process field.
  2. Click the Go button.
  3. With your mouse, click into the first field under the "Values" heading and begin entering Values based on the Parameters listed.
  4. Only follow the recommendations listed below when entering Values. Some hint line notes are not Optional.



FWRODTA

Follow these recommendations;

* Even though the Hint line specifies Optional for lines 03 through 08 and 15, 16, 18 and 19, these cannot be left blank.

#Parameters

Opt/Required

Values

01Fiscal YearR2 digit Fiscal Year (ex: 20)
02Chart of AccountsR1
03From ORGANIZATION Code*REnter the Org Code (ex: B40239)
04To ORGANIZATION Code*RIf you are running a report for just one Org code, type the same Org code as Line 03.
05From FUND Code*REnter the Fund Code
06To FUND Code*RIf you are running a report for just one Fund code, type the same Fund code as Line 05.
07From ACCOUNT Code*REnter the Account Code
08To ACCOUNT Code*RIf you are running a report for just one Account code, type the same Account code as Line 07.
09From PROGRAM CodeOEnter the Program Code
10To PROGRAM CodeOIf you are running a report for just one Program code, type the same Program code as Line 09.
11From Activity CodeOLeave Blank - PCC doesn't use Activity Codes
12To Activity CodeOLeave Blank - PCC doesn't use Activity Codes
13From Location CodeOLeave Blank - PCC doesn't use Location Codes
14To Location CodeOLeave Blank - PCC doesn't use Location Codes
15From Date*R1st day of Fiscal Year (ex: 01-JUL-2019)
16To Date*RTODAYS DATE - Do not use last day of fiscal year
17Include Accrual for Last PrdOLeave this Blank
18Print Organization TotalsORecommended - Enter Y for yes
19Commitment TypeORecommended - B for both

3. To save these Parameters, click the box in the Submission Section next to "Save Parameter Set as

There's typically no need to name the report. However, if you need to Save your Reports with Names, refer to the additional resource documentation available.
If you are not saving the Parameter Set, just click on the Submit button.

4. Click the Save button or F10 on a Windows keyboard.

5. Go to the Report Viewer and log in with your Banner user name (no password or Report Name required) and click on the Submit button.

6. The recommended format for most reports is LC - click on the blue dot underneath the format heading.


FWRPDTA

Follow these recommendations;

* Even though the Hint line specifies Optional for lines 03 through 08 and 15, 16, 18 and 19, these cannot be left blank.

#Parameters

Opt/Required

Values

01Fiscal YearR2 digit Fiscal Year
02Chart of AccountsR1
03From Organization Code*REnter the Org Code
04To Organization Code*RIf you are running a report for just one Org code, type the same Org code as Line 03.
05From Fund Code*REnter the Fund Code
06To Fund Code*RIf you are running a report for just one Fund code, type the same Fund code as Line 05.
07From Program Code*REnter the Program Code
08To Program Code*RIf you are running a report for just one Program code, type the same Program code as Line 07.
09From Activity CodeOLeave Blank - PCC doesn't use Activity Codes
10To Activity CodeOLeave Blank - PCC doesn't use Activity Codes
11From Location CodeOLeave Blank - PCC doesn't use Location Codes
12To Location CodeOLeave Blank - PCC doesn't use Location Codes
13From Account CodeOLeave Blank for all
14To Account CodeOLeave Blank for all
15From Date*R1st day of Fiscal Year (01-JUL-2019)
16To Date*RTODAYS DATE - Do not use last day of fiscal yr
17Include Accrual for Last PrdOLeave Blank
18Print Organization TotalsORecommended - Enter Y for yes
19Commitment TypeORecommended - B for both

3. To save these Parameters, click the box in the Submission Section next to "Save Parameter Set as

There's typically no need to name the report. However, if you need to Save your Reports with Names, refer to the additional resource documentation available.
If you are not saving the Parameter Set, just click on the Submit button.

4. Click the Save button or F10 on a Windows keyboard.

5. Go to the Report Viewer and log in with your Banner user name (no password or Report Name required) and click on the Submit button.

6. The recommended format for most reports is LC - click on the blue dot underneath the format heading.