Banner Forms/Reports

Banner Forms/ReportsQuick Help GuideDivision of FinancePhone: 208-885-2719Updated: August 201612Division of FinancePhone: 208-885-27191

Finance Forms/Screens2NotesFAIINVLInvoice/CreditMemo ListProvides a list of open invoices/creditmemos.FAIINVEInvoice/CreditMemo QueryAllows the user to view on-line invoices. Information is limited, user may needto refer to FOIDOCH.FAIOINFOpen InvoicesAllows user to view open invoices bybudget or FOAPAL.FAIVHISVendor HistoryProvides a summary listing of total invoice payments by vendor per year.FAIVNDHVendor Detail/HistoryAllows the user to view all invoices paidto a vendor.FGAJVCDJournal VoucherEntryForm used to create a financial document into Banner.FGIBAVLBudgetAvailabilityAllows the user to view available budgetedfunds. Includes all posted and non-postedtransactions. On sponsored programs budgetsdoes NOT include overhead on unposteditems.FGIBDSTBudget StatusAllows the user to view posted transactions expensed or credited to an organization. Can drill down to see transactionlevel detail via the options menu.FGIDOCRDocumentRetrievalAllows the user to view posted documents.FGIENCDDetailEncumbranceActivityAllows the user to view posted detailedtransaction activity for an ides a list of all outstanding encumbrances for a specified organization.FGITBALTrial BalanceAllows the user to query account balances fora fund. First page shows assets, liabilities,control accounts and current account balances.Hit F7 to enter a query, then type 4%, and hitF8. This will show your actual fund balance(expenses revenue /- transfers – encumbrances /- beginning fund balance). Can drilldown to see transaction level detail via theoptions menu.FGITBSRBalanceSummary FormAllows the user to see fund balance(balance does not include encumbrances). Can view total activity for a specificaccount (mainly use account codes thatbegin with the number 4 )11

Notes10FOADOCUDocumentDisapprovalForm:Allows the “originator” to disapprove adocument before it goes through the nextapproval queue.FOAAINPDocumentApproval FormAllows the user to locate a document inthe approval process and identify whothe next approver is.FOIAPHTApprovalHistory FormDisplays the document approval historyand status of a specific document.FOIAPPHDocumentApprovalHistoryDisplays the approval or disapproval adocument has received.FOIDOCHDocumentHistory FormAllows the user to view the status ofPurchasing/Accts Payable transactionsand ties associated documents together.FPACHARChange OrderFormAllows you to enter a change order for apurchase order.FPAEOCDEncumbranceOpen/CloseFormAllows user to close an existing purchase order encumbrance.FPAPDELPurchase/Blanket OrderCancelAllows you to cancel a DepartmentalPurchase Order that has been completedand posted.FPAPURRPurchase OrderEntry FormAllows you to enter a DepartmentalPurchase Order into Banner.FPARDELRequisitionCancel FormAllows you to cancel a Requisition thathas been completed and posted, but nopurchase order issued yet.FPAREQNRequisitionEntry FormAllows you to enter a Requisition intoBanner.FPIOPOFPurchase Ordersby FOAPALProvides a list of Purchase Orders bybudget or FOAPAL.FPIOPOVPurchase Ordersby VendorProvides a list of Purchase Orders byVendor.FPIPURRPurchase/Blanket/ChangeOrder QueryAllows a user to view a purchase orderor change order, no matter what status itis in.FPIREQNRequisitionQueryAllows a user to view a requisition, nomatter what status it is in.FTVORGNOrganizationCode ValidationFormAllows a user to query on all budgetsnumbers (active or inactive), that havebeen set up for their area.3

Finance Forms/Screens ContinuedFWAIDENIdentificationFormShows you addresses, telephone, email,etc if not marked private.FWAUSORReport UserQuery FormShows what budgets will print in certainreports.FWIBAKOOutstandingDocuments NotPostedAllows you to see documents for a budget that are incomplete or in approvalsthat affect budget availability.FWIQBUDBudgets inApproval QueueShows you what budgets and documenttypes go through your approval queue.FWIROLLRoll-Up orMid-level QueryShows what budgets fall under a particular Roll-up or Mid-level.FWIVENDVendorMaintenanceAllows the user to determine if W-9 ison the system and find specific addressesfor a vendor.NotesFinance Reports4FGRGLTAGeneral LedgerDetailTransactionsShows detailed transactions withinthe General Ledger.FGRIDOCIncompleteDocumentListingLists incomplete documents for a specified user ID.FGRORGHOrganizationHierarchy ReportShows your midlevel, roll-up codeand budget numbers that fall under aspecific roll-up code (3 digit number). This helps to determine ifbudgets are in the correct area.FWRBDRVBudget RevenueComparisonFor UA, UB, UC funds only; comparesthe adjusted budget with revenue.FWRDOARDetail by Org orActivity ReportShows beginning adjusted budgetedamounts, expenses and/or incomefor a specific period, encumbrancesand a cumulative balance by primary expense code; may also beprinted by expense class code oractivity code.9

Human Resources Forms/ScreensNBAJOBSAllows the user to check the status ofan employee.Finance Reports ContinuedFWRDSTRStatement ofChangesThis report shows by org range; thebeginning fund balance; YTD income;YTD expenditures; YTD transfers;current encumbrances; and the endingfund balance. Mostly used for incomegenerating accounts with a single budget to fund relationship.FWRITEMItemizationReportList of itemized expenditures and payroll by person for specific date range.Was originally created for grants, butyou can now use any budget. Allowsyou to narrow down your start and enddate by actual days instead of periods(ie: 01 July, 02 August, etc.)NBAPBUDPosition BudgetShows permanent budgeted amountsand labor distribution.NBAPOSNPositionDefinitionShows title number, page grade, personcurrently in that position.NBIPINCPositionIncumbent ListShows all individuals who have beenappointed to that PCN.NOAAPSMElectronicApprovalSummaryPersonnel action (EPAF) approvalform.NHIDISTLaborDistribution DataInquiryShow individual expenditures by earncode and ows all outstanding encumbrances forspecified budgets.NHIEDSTEmployeeDistributionInquiryAllows you see payments made for aspecific period.FWRPBSRBudget nel action (EPAF) approvalform.NOAEPAFElectronicPersonnel ActionFormAllows you to create an EPAF for anIndividual.Report shows by organization, midlevel and fund type; the current adjustedbudgeted amounts by primary expense;their associated expenditures for theselected period; the associated cumulative expenditures year –to-date; thecurrent encumbrances; and the availablebalance.FWRJVPRNTRPCLSPosition ClassRulesTitle (class code) query form.Print JournalVoucherAllows you to print a completed journalvoucher; does not have to be posted.FWRTPECNWRVACTVacant PositionReportShows positions in your Midlevelor Department that are currently vacantOperatingBudget/PrimaryExpense ClassShows original budgets by primaryexpense as entered into Banner for thebudget setting process.NWRDERPDepartmentalEmployeesReportShows various employee informationincluding, job titles, pay rates,employee class, leave balances, etc.GUAPMNUPersonal MenuAllows you to input Banner forms andreports for direct access.PEAEMPLEmployee History Shows hire dates, leave balances andFormother pertinent information.FOATEXTGeneral TextEntryAllows you to add text to a Bannerdocument.FOAUAPPUser ApprovalPEAFACDFacultyInformation FormShows rank and effective dates of faculty.Allows user to access approval queue toapprove documents.FOAPOXTText EntryPEIJTOTJob Year To DateTotalsShows you the gross earnings by person for a calendar year.Allows user to add text to a PurchaseOrder or Requisition after it has posted.NWRSERPPay Event List:Shows list of payments made to thatindividual.SalaryEncumbranceReportThis report displays YTD salaries paid,encumbered salary amounts and totalannual salary that will be paid for thefiscal year and pay period entered.PHILIST8Employee JobsGeneral5

Office of Sponsored Programs ContinuedPayroll Reports ContinuedFRAGRNTGrantMaintenanceShows all of the basic grant/contractinformation, including PI, sponsor,responsible department, etc.NWRPYSVSalary SavingsReportPWRGREMReport ofEmployees Paidfrom GrantShows employees assigned to a budgetfor a specific fiscal year and whetherthey are active or terminatedShows, by org., the estimated currentfiscal year salary residuals at a point-intime. Has detail about year-to-date andestimated expenditures, by person.NWRTBSRBudgeted SalaryReportShows, by budget, PCN, name, title,classification, FTE %, annual salary,and percentage of salary for that budgetfor full time, board appointed positions.PWRDISTPayrollDistributionDetail withAdjustmentsThis report will display earnings codes,payroll salary amounts, and fringebenefit expenses by employee for thedate range and Midlevel or DepartmentCode entered.PWRLEAVLeave TakenThis report will display annual, sickand comp time amounts earned andtaken for the date range specified.PWRWTESWeb Time EntrySummary ReportAllows you to see the historyor status of a time sheet. Useslegal paper, or do a “no print”to view all columns.PWRWTESWeb Time EntrySummary ReportAllows you to see the historyor status of a time sheet. Useslegal paper, or do a “no print”to view all columns.FRIGITDGrant Inception to Shows information on all posted budgetDateand expense transactions from theinception of the award. May beNarrowed down by the time periodFRIGTRDGrant TransactionDetailShows detailed information on transacttions. Available through the optionsmenu of FRIGITD.FWRSUMRGrant SummaryReportSummarizes information by grant inception to date through specified enddate. Allows for multiple selections orselection by sponsor ID. Included %time remaining and % funding remaining.FWRBRTERoll-up CodeSummary ReportShows a summary of the roll-up information contained in FWRSUMR. Goodfor checking that spending is occurringat a reasonable rate.Payroll Reports6FWRPEDRPersonnelExpenditureReportShows, by org and pay period,the personnel expenditures, by person.It includes salaries, irregular help,overtime and fringe benefits. (Mustuse legal paper.)NWREMPSEmployee orSupervisorReportAllows you to see who supervisors areby employee, department or mid-level.NWREMPTEmployeeTerminationReportLists by organization roll-up, 01 suffixemployees who do not have EPAFtermination dates. Report shows terminations after specified date on parameter 1.NWRPREXPersonnelExpendituresShows, by budget, and date as specified, name, hourly rate, and amountpaid in each expense account code thatis applicable (ie: E4105). Lists totalwages and fringes paid.7

Form used to create a financial docu-ment into Banner. FGIBAVL Budget Allows the user to view available budgeted . Hit F7 to enter a query, then type 4%, and hit F8. This will show your actual fund balance . Hierarchy Report Shows your mi