Oregon University System

Oregon University System Logo

OUS

 

88.00 Commonly Used Banner Forms & Reports

88.00 Commonly Used Banner Forms & Reports

Banner Input Forms:

FAAINVD Invoice/Credit Memo Cancel Form
FAAINVE Invoice/Credit Memo Form
FGAENCB Encumbrance/Reservations Maintenance Form
FGAJVCD Journal Voucher Entry Form
FOADOCU Document by User
Used to query by originating user ID (inputter) all documents that are completed, approved, incomplete, or cancelled.

This screen is helpful when the inputter wants to make a correction to a completed document prior to it routing for FIS approval. The inputter can use this screen to deny (disapprove) a completed (but not approved) document so that corrections can be made.

FOATEXT General Text Entry Form
FOAUAPP User Approval Form
Remove name displayed to view all documents in all queues
FPAPDEL Purchase Order Cancel Form
FPAPURR Purchase Order Form
GJAPCTL Process Submission Control Form
Used to run reports or processes

Banner Query Forms:

FAIINVL Invoice/Credit Memo List Form
(Open, Paid, Suspense, or Hold)
FAICHKH Check Payment History Form
Shows status of check (e.g., check date and date cashed for final reconciliation).
FAIVNDH Vendor Detail History Form
More specific information can be obtained by querying on elements in the lower block.
FFIMAST Fixed Asset Master Query Form
FFIFALV Fixed Asset List Form
FGIDOCR Document Retrieval Inquiry Form
Query on posted documents with option of seeing FGQDOCP document postings (accounting detail information)
FGIENCB Encumbrance List Form
FGIENCD Detail Encumbrance Activity Form
FGIGLAC General Ledger Activity Form
FGIJSUM Journal Voucher Summary Form
FGIJVCD List of Suspended Journal Vouchers Form
FGIOENC Organizational Encumbrance List Form
FGITRND Detail Transaction Activity Form
FHIJSUM Journal Voucher Summary Form
FOIAPHT Approval History Form
Query by document code to display originating user and approver.
FOIAPPH Document Approval History Form
Query by document code to display originating user and approver.
FOIDOCH Document History Form
Query by document number (invoice, purchase order, check, or asset tag) to show status (incomplete, complete, approved)
Shows other documents tied to the payment (e.g., invoice, PO, check, and asset tag)
FPIOPOB Open Purchase Orders by Buyer Form
FPIOPOF Open Purchase Orders by FOAPAL Form
FPIOPOV Purchase Orders by Vendor Form
FPIPORS Purchase Order Suspense List Form
FPIPURR Purchase Order Inquiry Form
FTIIDEN Entity/Name/ID Search Form
FWIBDST Organization Budget Status Form
FWIBSUM Organization Budget Summary Form
FWIFOAN Employee Within FOAP
Used to query personal services expenses for a specified fiscal period (sorted by employee or account code) NOTE: Be sure to complete the parameter for the Index or Organization Code to query only your department's budget status.
FWITXID Name/Tax ID Search
GWIJOBR Banner Job Submission Results

Banner Reports:

FARINVA Invoice Activity Report
Print detail and summary invoice activity for a specified period of time.
CAUTION: Remember to enter 05 option of Vendor ID to avoid getting ALL vendors activity within a given time period.
FGRACCI Account Index Report
Sort by Fund, Organization, or Index
FGRBDSH Budget Status Report
NOTE: Be sure to complete the parameter for the Index or Organization Code to only print your department's budget status
FGRJVLR Journal Voucher Listing
FGRODTH Organization Detail History
NOTE: Be sure to complete the parameter for the Index or Organization Code (from and to) to print only your department's budget status
FGROPNE Open Encumbrances Report
Shows encumbrances for POs and Encumbrances
FGRORGH Organization Hierarchy Report
Leave the Organization parameter blank for a report of the entire organization hierarchy
FPROPNP Open Purchase Orders Report
Open purchase orders as of a given date and purchase order (optional default is all) and vendor (optional default is all)
FPRPURA Purchase Order Activity Report
Provides the user the ability to print detail and summary purchase order activity information for a specified period of time, vendor, or user.
FWAPORD Purchase Order Print
Print purchase order by PO number, current or original status, or buyer code. Note, it must be a completed and approved purchase order to print.
FWRFAIA Non-Expendable Inventory Annual Report
NOTE: Be sure to complete the parameter(s) for the Organization Code to print only your department's list of inventoried item(s)
FWRFAIP Non-Expendable Inventory Investment In Plant Report
(Sort by Location or Organization)
FWRFOAP Payroll Detail by Organization
Used to show all personal expenses (salaries, wages, overtime, OPE, etc.) for employees paid by index.
  • This report can be generated for a specified fiscal period or the entire fiscal year (if the fiscal period field is left blank).

Note: Be sure to complete the parameter for Index to print only your department's salaries

FWRIJVR Incomplete Journal Voucher Report
FWRODTH Transaction Detail History
Similar to FGRODTH, with the following differences:
  • It can be generated across the fiscal year
  • It includes ALL transactions before and after a change that occur in the defaults of the index
  • The output can be in the form of a printed report or downloaded into a spreadsheet
  • It does not have the budgetary error inherent in FGRODTH

Be sure to complete the parameter for the Index or Organization Code (from and to) to print only your department's transaction detail.

FWRVHST Single Vendor History Report
Print detail and summary invoice activity for a specified period of time.
FWRVNDA Vendor Payment History By Acct
Prints list of payments made during a time period specified for an index or a fund.