Click to show/hide contact information.

Loading...

FIS User Manual

​​​

‭(Hidden)‬ Summary Link Web Part

Expand or contract all step headings
printer
printer
increase font size Decrease Font Size
 
 
 
 magnifying glassDelete Circle
Getting Started With FIS Banner
Workstation Configuration
Getting to Know FIS Banner
Accounting Information Structure and FOAPAL Codes
Reviewing Budget Status
Approving Documents
Purchase Orders
Receiving and Returning Goods
Change Orders
Invoices
Journal Vouchers
Research Accounting
Reporting
Glossary of FIS Terms
Appendix A: Vendor Databases
Appendix B: Transfer of Funds, Transfer of Expense, Associated Rule Codes
Appendix C: Recharge and System Generated Rule Codes and Contacts
Appendix D: UCOP CCoA Attributes in FIS Banner
  • Getting an Account

    Who needs an account?
    Staff, faculty and temporary staff who have a business need to query, process, review and/or approve financial transactions.

    An employee may obtain one of the following types of FIS accounts:

    • Inquiry only (Query) user
    • Transaction preparer (Purchase order, invoice, journal entry, etc.)
    • Transaction approver

    For more information on account roles and responsibilities, please see the Separation of Duties guide.

    New Account Requirements
    You must complete the appropriate training and submit FIS account forms to obtain an FIS account:

    Training
    FIS Banner account access requires training which is offered free of charge to UCSC staff. Specific training will depend on the access being requested. Please visit FIS Training for information on required classes and registration.

    Authorization
    Each division and/or unit has one or more management staff with delegated authority to authorize creation or modification of FIS Banner accounts. This delegation is based on campus roll-up Organization Codes. The FIS Access Authorizer for a division/unit must sign all FIS Access Authorization forms for that division/unit. In their absence, the Senior Officer for the unit/division may sign. FIS Access Authorizers can be found on the FIS Access Authorizers page.

    FIS Account Forms
    Two forms are needed to request a new FIS Banner account.

    You will be notified via email upon receipt of your approved form. Information about required training or other actions, and/or login information will be included if your account is ready.

    Modifying an Existing Account
    Please complete the FIS Access Request form and obtain appropriate signature authorizations. You will be notified via email when the request has been implemented.

    Central Offices and Other Special FIS Access Requests
    FIS Security administration maintains special authorization forms for central offices including Accounting, Purchasing, Budget Analysis and Planning, Student Business Services and those offices with unique access needs. Please contact fis_probs@ucsc.edu for assistance.

    Closing Accounts
    To inactivate your own or another’s account because they are leaving their position, please notify ITS Support Center via the ITS Request system. They can also be contacted by phone, 459-4357, or emailing help@ucsc.edu. They will notify all business systems to close accounts as directed.

    Policy References
    Please visit IT policies and guidelines for policy references.

    ​​​​
    Back to Top
  • Where To Get Help

    The FIS Help Team is a first point of contact for user questions regarding FIS Banner. Contact us at: fis_probs@ucsc.edu for help with:

    • Accessing FIS Banner
    • Navigating within the system
    • System error messages
    • Updating access
    • Printing and Reports

    FIS Help is staffed Monday – Friday, 8 am – 5 pm.
    FIS Help is not available on university holidays or closure days. Inquiries when the office is closed will receive a response the following business day.

    For assistance with FIS training, please visit the FIS Training page.


    Back to Top
  • Off-Campus Access

    ​Accessing FIS from an off-campus location (e.g. telecommuting) requires a connection to UCSC's VPN.

    Campus VPN must be connected prior to launching FIS.

    1. Download/install VPN client. (Instructions at http://its.ucsc.edu/vpn/installation.html.)
    2. Launch VPN client called Cisco AnyConnect.
      • PC location: Start Menu\Programs\Cisco\Cisco AnyConnect Secure Mobility Client
      • Mac location: In Applications\Cisco AnyConnect Secure Mobility Client
    3. Login to VPN client. Enter server name: vpn.ucsc.edu then click 'Connect'. Enter your CruzID Gold credentials then click OK. Once VPN is successfully connected, you will be able to launch FIS.

    Additional information about using Campus VPN may be found at http://its.ucsc.edu/vpn/. Campus VPN support is provided by ITS.


    Back to Top
  • Introduction to FIS Banner

    What is FIS Banner?

    The FIS Banner Financial Information System (FIS Banner) is a financial data management and reporting system. Using fund accounting, the University tracks monies it receives from various sources (state, federal, students, public, etc.) and accounts for how those monies are spent. FIS Banner takes advantage of the latest technologies in retrieving, managing, and reporting data.

    FIS Banner offers:

    • Access to the central FIS Banner system via the internet for the most up-to-date financial information
    • On-line data entry capabilities between departments and FIS Banner
    • On-line approvals of transactions
    • Ongoing posting of transactions: this means your financial status is up-to-date whenever you check it
    • Access to transaction detail as well as summary information
    • Availability of financial data in an electronic medium that will allow greater ease in using critical information for strategic planning

    The FIS Banner system contains several modules. They are General Ledger, Finance Operations, Stores Inventory, Purchasing and Procurement, Accounts Payable, Fixed Assets, and Research Accounting. Each of these modules acts as a totally integrated sub-system of FIS Banner, ensuring the compatibility of the system.

    Each Banner module provides both printed reports and the ability to view detail and summary information on-line. This gives you the ability both to enter information on-line and to inquire about transactions on-line.

    One of the major benefits of FIS Banner is that it interfaces with several other University systems, including the Payroll/Personnel System, the Academic Information System, the Budget System, and the Office of the President. Since FIS Banner is able to interface with such a wide variety of systems, the University is able to utilize and disperse accounting information throughout the campus.

    This manual is designed to augment but not replace FIS Banner User Training, which provides UCSC faculty and staff with access to the Financial Information System. The manual alone is not sufficient for learning the FIS Banner system. New FIS Banner users must complete the User Training before being granted system access. Please see the FIS Training web page for information about registering for User Training.

    Overview of the FIS Database

    FIS stands for UC Santa Cruz’s Financial Information System. FIS is made up of several software components: the database management system, the database, and the application program.

    The database management system (DBMS) serves as the foundation for FIS. It is software that sorts, updates, adds, and deletes data. In FIS, we use a database management system called Oracle, which is a product of Oracle Corporation.

    A database is a collection of information that is stored in a logical, consistent order so that it is easy to locate and retrieve. The FIS database stores information in tables that are made up of columns and rows. Each column is a field and the column heading is the field name, which is usually descriptive of the data contained in that column. Each row is a record that contains the information for each entry in the table.

    For example, the information from an address book might be stored in a table where each person is listed in a row. The pieces of information related to a person are stored in fields called Name, Address, City, State, ZIP, and Phone.

    The application program, Banner, is the software that you use when you interact with the FIS database. It was developed by Systems and Computer Technology (SCT) and is now managed by Ellucian. All of the on-line pages that you work with are parts of the Banner application, and it is the Banner software that enables UCSC financial staff to create reports for your unit.


    Back to Top
  • Getting Set Up

    Workstation Campus VPN

    Your computer workstation must be connected to Campus VPN prior to launching FIS.

    Visit the Off-Campus Access section for information on setting up Campus VPN.

    Use the Chrome Browser

    Chrome is the recommended browser for Macs and PC. Do not use IE, Edge or Firefox.

    Getting An Account

    You must have a valid FIS account to access FIS Banner

    Visit the Getting Started section for information on required forms for staff, faculty and temporary staffing appointment FIS accounts.


    Back to Top
  • Logging on to FIS Banner

    How To Log On To FIS Banner

    1. Go to https://financial.ucsc.edu/Pages/Launch_FIS.aspx​ and click on the 'Launch FIS' button (the Chrome browser is recommended for Macs and PCs).

      View Image



    2. ​You will be prompted to enter your CruzID Gold and MFA (Multi-Factor Authentication) credentials. After entering your credentials, the Banner Welcome Page will display: 

      View Image



    3. Follow steps below to access Banner pages.

    Accessing Banner Pages

    1. Type or search for a Page name in the Search field, then key [enter].

    2. You will be brought to your page, where you can perform work (query, run reports, input documents, etc.).

    3. To access a different page, key [ctrl-Q] or click on X to exit and return to the Welcome page and enter your new page name.

    4. When you are done with your FIS Banner session, click on the Sign Out button, then close your browser window.​


    Welcome Page Overview​​​​​​


    View Image



    ​​
    ​​​ ​
    ​​​​​​​
    Back to Top
  • Banner Page Favorites Menu

    How To Create a Personal Favorites Page Menu on the Banner Welcome Page

    Banner page names are, well, not exactly intuitive (FZRPTJV anyone?). Fortunately you can create a Personal Menu of your favorite Banner pages to access them via the FAVORITES folder:​

    1. Enter your page name into the Welcome Search window.
    2. The page name and title will appear, and to the right you will see a white star.
    3. Click on the star and it will turn blue. 

    4. View Image



    5. The page will now be stored in your Favorites folder (star icon in left sidebar menu).

    6. View Image



    7. To remove a page from Favorites, click on the star to turn it from blue to white.

    Back to Top
  • Banner Messaging/Disapproval Notifications

    Banner Messaging/Disapproval Notifications GUAMESG

    Banner Messaging/Disapproval Notifications notifies users when their documents (invoices, journal vouchers, purchase orders and change orders) have been disapproved. GUAMESG is intended for Banner users who input documents into Banner that require approval from another Banner user.

    1. When you log in to FIS Banner, if you have any messages, a number will appear on your user icon in the Menu sidebar:

    2. Click on the user icon, then click Check Banner Messages to view your messages. GUAMESG General Message page will open and display your message(s).

      View Image




    3. After viewing your message(s), click the Delete button or key Shift F6 from the record you wish to delete. You must also save before you exit for the messages to be completely deleted. To save, key F10 or click on the Save icon in the lower right corner.​
    ​​​​​​​​​
    Back to Top
  • Navigation Within FIS Banner

    Navigation is accomplished using the mouse (buttons, icons or menu items) the keyboard (keyboard shortcut keystrokes), or a combination of the two. Basic Banner navigation by function is summarized in the following table:

    View Image


    Navigation methods within FIS Banner are described in more detail:

    Search Field
    After successfully logging into FIS Banner, the Search field appears in the Welcome page. You can enter the seven-letter FIS Banner page code name in the Search field and press [enter] to jump directly to that page.

    Banner Tip
    The Search field can predict page names after typing the first three letters of a page. For instance, if you type 'FOI', Banner will generate a list of all pages that begin with FOI (FOIDOCH, FOIAPHT, etc.). Also, if you don't recall the code but remember a word in the Page title, you can type that into the Search field and Banner will list all pages containing that word in the title. For example, when you type 'Journal', Banner displays a list of pages with Journal in the title, like FZAJVCD-Journal Voucher Entry. 

    Section to Section Navigation Methods
    From within a page, to navigate from section to section, use the [alt pagedown] Next Section and [alt pageup] Previous Section keystrokes, or click on the Next Section or Previous Section buttons on the bottom left of the page.

    Field to Field Navigation Methods
    To navigate from field to field, use the <TAB> Next Field and <shift TAB> Previous Field keys. 

    Record to Record Navigation Methods
    To navigate from record to record, use the [up arrow] Previous Record and [down arrow] Next Record keys.

    Tabbed Page Navigation Methods
    Certain pages display information in tabs, e.g. FTMVEND and FRAGRNT. To navigate from tab to tab use the mouse or key [alt page up] Previous Section and [altpage down] Next Section keys, or click on the Next Section or Previous Section buttons on the bottom left of the page.​

    Page to Page Navigation Methods
    FIS Banner allows navigation between pages without exiting the current page you are working in. Instead of going back to the Banner Welcome page every time you need to switch to a different page, do the following:

    1. Key [ctrl-shift-Y] or click on the Magnifying Glass icon in the Menu sidebar on the left side of the page. A search window will appear. Type in or search for the page name you want to navigate to, press Enter, and the page will display. Once you are done with the page, key [control q] Exit or click on the X in the upper left corner of the page, and you will be brought back to your original page.

    Related Menu
    The Related menu contains a drop-down menu list of common functions, including many that can be used for navigation. You can access the Related Menu by clicking on the Related button located in the upper right corner of a page, or by keying [alt-shift-R].​

    Tools Menu
    The Tools menu contains contains additional common functions used to navigate within pages. You can access the Tools Menu by clicking on the Tools button located in the upper right corner of a page, or by keying [alt-shift-T].​

    Start Over
    The Start Over button clears the page you are currently in and returns it to it's initial status. This is useful when you are using a page for iterative searches (multiple journal voucher documents, organization codes, etc.). You can also key [F5] to start over a page.​​​

    Navigation Quick Reference
    The following is a quick reference for Banner navigation methods:


    View Image



    ​​ ​​​ ​ ​​​​​​​
    Back to Top
  • Page Naming Conventions

    ​All FIS Banner Finance pages have seven-letter code names which use the following convention: abcdddd. You can learn the ownership, type, and use of most pages, such as the purchase order inquiry page, FPIRURR, by learning the meaning of each character in its name.

    • The first letter refers to the system
    • The second letter is a code for the module
    • The third letter is a code for the page type
    • The last four letters are unique abbreviations of the page name

    FIS Banner page code names serve as important navigation tools, providing shortcuts as you move from one page to another.

    • a = Single character code identifying the system
      • A = Alumni/Development
      • F = Finance
      • G = General
      • N = Position Control
      • P = Human Resource
      • R = Financial Aid
      • S = Student
      • T = Accounts Receivable
    • b = Single character code identifying the Finance module
      • A = Accounts Payable
      • B = Budget Development
      • C = Cost Accounting
      • F = Fixed Assets
      • G = General Ledger
      • O = Overall
      • P = Purchasing
      • T = Table
      • U = Utility
      • W, X, Y and Z are used across all Finance modules.
    • c = Single character code identifying the type of page
      • A = Application (query and modification)
      • I = Inquiry
      • M = Maintenance
      • Q = Query (when called from another form)
      • R = Rule
      • V = Validation
    • dddd = Unique four character page name
      For example, FPIPURR is a page in the Finance Purchasing module and is used to query a purchase order.
      • F = Finance
      • P = Purchasing
      • I = Inquiry
      • PURR = Purchase Order (meow)

    Back to Top
  • Data Entry Methods

    Text Entry
    Text entry is the most common method of entering data into FIS Banner page fields.

    Check Boxes

    Check boxes are used for fields that can be toggled on and off. They represent a yes/no or selected/deselected condition.
    In some cases, check boxes indicate that action has been taken or that requirements meet specific rules set up in FIS Banner. Such check boxes are indicators only and cannot be edited.

    Radio Groups

    A radio group is a group of two or more radio buttons each representing a choice. Only one button can be selected in a group of buttons.

    Drop-Down Lists

    Drop-down lists are fields that allow the user to select one of several pre-determined responses. To activate a drop-down list by mouse, place your cursor over the small arrow, click on the arrow, and then click on your choice. To activate a drop-down list by keystroke, tab to the list, then arrow up or down until you get to your choice.

    Current Date
    In most date fields, entering a single, non-numeric character followed by Enter or Tab will display the current date. Just remember T for Today.


    Back to Top
  • Data Entry Standards

    ​Data entry standa​rds have been adopted to facilitate effective management of shared institutional data. Use these standards when searching for a vendor name to ensure success in finding the right name. The official name of the company/individual will be entered in the Last Name field only once — there should only be one ID number for each organization.
    Restricted characters: The following characters must not be used in vendor names:
    @   #   $   %   *   “   :   ;
    Note: The Standards for vendor names are very specific and are intended to be consistent throughout all data forms.

    Organization Name Standards

    The Non-Person (Organization) Name field is a 60-character, free text field.

    1. Organization names should be entered as received from the company or using the “official” corporate name.
    2. Use of Abbreviations: When space limitations require the use of abbreviations, the words at the end of the line should be abbreviated first (work right to left). When abbreviations are necessary, use the following (unless an organization provides information regarding their preferences):
      Assn Association
      Assoc Associate
      Assocs Associates
      Co Company
      Conslt Consulting
      Conslts Consultants
      Corp Corporation
      Dept Department
      Eng Engineering
      Fdn Foundation
      Inc Incorporated
      Intl International
      Ltd Limited
      Mfg Manufacturing
      Publ Publishers
      Soc Society
      St Saint
      Univ University
    3. Initials and Person Names: When an organization name is the name of a person, enter periods after each initial and no space between double initials.
      Example: F.G. Brehmer Foundation
      Names should be entered with spaces between the words:
      Example: David & Gloria Morris Foundation
    4. Acronyms: Acronyms and universally accepted abbreviations should not use periods.
      Example: ABC, NYS Department of Energy
    5. “The” as First Word: Avoid using “The” as the first word in the name (because of sorting).
      Example: The Bagelry becomes Bagelry
    6. Use of Commas: Commas should not be used between corporate identifiers:
      Example: Elevator Service Company, Inc. becomes Elevator Service Company Inc
    7. Use of Connective Words: Enter words like and, in, of, for, the etc. in lower case except if they are the first word of the organization name. The use of “and” or “&” should be determined by company preference.
      Example: C & N Tractors, Ed and Dick’s Floral Design
    8. Use of Hyphens and Slashes: Do not enter spaces on either side of hyphens or slashes.
      Example: K-Bach, Citicorp/Citibank
    9. Universities: Enter University and College names as received/preferred by the institution.
      Examples: University of California Santa Cruz
       State University of New York, Binghamton

    Person Name Standards

    The Person Name fields consist of First Name or Initial, Middle Initial, and Last Name.

    1. Enter names as received from the constituent. Constituent names will be sorted by the last name. Data associated with names will be entered as received from constituents.
    2. Last Name: The last name can be one word (Ruiz) or two words separated by a hyphen (Ruiz-Delaney).
    3. First Name: Enter the formal name in the first name field.
    4. Middle: Enter the middle name or middle initial in this field.
    5. Suffixes: Enter the following suffixes as part of the last name field: Jr., Sr., I, II, III, IV, V.

    Vendor Name Examples

    First Middle Last Guideline
    Bob Smith Capitalize first letter of each word
    Bobby Joe Smith Enter two word first names in first name field
    B.​ Joe Smith Enter single character first name with period, preferred name in middle name field
    Donna Louise Campos Use full middle name if appropriate and preferred
    Donna L. Campos Enter a period after a middle initial unless the constituent has requested otherwise
    Tracy West Goldman Enter the name as you receive it from the constituent (i.e., use space between words if they do
    ​Larry Carl Long-Reed Omit spaces before and after hyphens
    Larry Carl O’Leary Omit spaces before and after apostrophes
    Larry Carl O’Leary III Enter suffixes as part of the last name field

    Commodity Abbreviations For Vendors

    • bldg: building
    • equip: equipment
    • lab: laboratory
    • maint: maintenance
    • misc: miscellaneous
    • svcs: services

    Back to Top
  • Query (Filter) Techniques

    You may query (aka filter) within FIS Banner pages when seeking specific information already entered in the database. Some pages open in filter mode and display the message “Enter query” in the status line. Other pages require you to perform a filter operation and enter filter criteria to obtain the information you require from the FIS Banner database.


    How to Filter

    1. Go to the page you want to query.
    2. If the page opens in filter mode, go to Step 3. To enter filter mode, either type [F7] or click the Filter button.
    3. Once the page is in filter mode, enter your search criteria.
      • You can filter on any field where you can place the cursor.
      • Use the Oracle wildcards (_ or %) as you enter your search parameters.
    4. Once you have entered your criteria, type [F8] or click the Go button. The page will search the FIS Banner database. All records matching the filter are displayed.
    5. When a usable list of records displays, place the cursor in the selected record. To return to the originating form with a selection, type [alt S] or click the Select button.

    Using Wildcards in a Search 

    To aid in filtering, FIS Banner allows two wildcard characters. Both stand for any alpha-numeric character. They are “_” representing only one character and “%” representing any number of characters.

    To get these results: Enter this criteria:
    All entries that contain ma %ma%
    All entries that begin with ma ma%
    All entries that have ma as the final two characters %ma
    All entries that have m as the second character _m%

    Banner Tip
    Wildcards can be used many times in one search. Remember the search is case sensitive, meaning that upper and lower case must match exactly.

    Basic Filter and Advanced Filter 

    When filtering, pages will open up in Basic Filter mode, however Banner also offers Advanced Filter mode, which allows use of detailed search criteria, including date ranges, “Contains…” criteria, “Starts with…” criteria, and so on. To enable Advanced Filter, click on the Advanced Filter button to the right of the Basic Filter button.

    Basic Filter


    View Image


    Advanced Filter


    View Image



    ​​​​
    Back to Top
  • Reviewing Document History FOIDOCH

    FOIDOCH: Document History

    ​The complete history of acquisitions documents (purchase orders, invoices, checks and inventorial documents) is available on FIS Banner from the FOIDOCH page. This page displays the document numbers for all documents linked by an original transaction. For example, from FOIDOCH you can trace how a purchase order turned into an invoice, which was then paid by check. FOIDOCH also shows document status (e.g. Check: Cancelled, Purchase Order: Complete, Invoice: Approved, etc.).

    1. Type FOIDOCH in the Banner Welcome page.
    2. You will see the cursor in the DOCUMENT TYPE field. Enter the DOCUMENT TYPE code:
      • REQ Requisition
      • PO Purchase Order
      • ISS Issues
      • INV Invoicev
      • CHK Check Disbursement
      • RTN Returns
      • RCV Receiving Documents
      • FAS Asset Tag
      • FAA Asset Adjustment
      • (BID is currently unused by UCSC.)

      View Image



    3. In the DOCUMENT CODE field, enter the document number. If uncertain, type [F9] List Field Values to search. For instructions on searching, see Query Techniques.
    4. Type [alt pagedown] Next Block to transfer to the block indicated by your document type selection (step 2). The screen will fill with the document numbers related to the document you entered in the DOCUMENT CODE field. The one-character field to the right of each related document number contains the status code. Click on View Status Indicators in the Tools Menu to review the status codes, as shown in the figure below. All documents except Returns will have a status indicator if they have been completed. Returns have no status code, so the code field will always be blank in the Return box. An Asset Tag status indicator is shown for a permanently-tagged item only. To return to FOIDOCH from the Status Indicator window, click on the Cancel button at the bottom of the list of Status Indicators.
    5. To view the details of your document, go to Related Menu and select Query Document [BY TYPE].



      Note: If any other documents are linked to the query document, the system will also display their document numbers.
      Note: If the STATUS BOX to the right of your document number is blank, the document has not been completed. (Doc type "Return" is the only exception.)
    6. To enter a new query, key F5 or click on the Start Over button. Then repeat steps 2-5.
    ​​​
    Back to Top
  • Navigation Table (by function)
    Navigation in FIS Banner is performed by using screen icons (mousing) or keyboard shortcuts. The Navigation table below lists common FIS Banner navigation functions and the screen icon or keyboard button needed to perform the function.

    FIS Banner Navigation by Function Table


    View Image



    ​​ ​​
    Back to Top
  • Notifications

    Banner Notifications

    Banner typically displays notifications in the upper right corner of the page:




    Most notifications can be closed by pressing the Tab key or clicking on the notification message. Some notifications must be acknowledged by clicking Yes, No, Cancel or OK. Send email to fis_probs@ucsc.edu if you encounter issues or have questions about notifications.


    ​​
    Back to Top
  • Introduction

    This section describes several important structures that provide the foundation upon which the University’s Financial Information System (FIS) is built.
    This section provides information about:

    Background

    FIS Banner was developed as a financial data management and reporting system. Using fund accounting, the University tracks monies it receives from various sources (state, federal, students, public, etc.) and accounts for how those monies are used.
    The FIS system contains several modules to record the inflow and outflow of money. They are the General Ledger, Operating Ledger, Stores Inventory, Purchasing and Procurement, Accounts Payable, and Fixed Assets.
    Each of these modules operates as a totally integrated sub-system of FIS, ensuring the compatibility of all the modules. This compatibility eliminates problems that are found in independently developed software systems common at other universities.
    Each module provides both printed reports and the ability to view detail and summary information on-line. This ability both to enter information on-line and to inquire about transactions on-line is a valuable feature of FIS.

    FIS Interfaces

    One of the major benefits of the FIS system is that it interfaces with several other University systems. These systems include the Payroll/Personnel System, the Academic Information System (AIS), the Budget System (FMW), departmental recharge systems and the Office of the President. Since FIS is able to interface with such a wide variety of systems, the University is able to utilize and disperse accounting information throughout the campus.


    Back to Top
  • The General Ledger and The Operating Ledger

    ​FIS Banner produces two Ledger Reports: the General Ledger and the Operating Ledger. Below is a brief description of each.

    The General Ledger

    The General Ledger provides information on balance sheet accounts. This ledger is broken into four main sections: Assets, Liabilities, Fund Balance, and Control Accounts. Since most units do not receive the General Ledger, this manual does not focus on it. If you have questions regarding the General Ledger, please contact the Accounting Office.


    The Operating Ledger

    The Operating Ledger provides the status of financial, budgetary, summary encumbrance activity and balances for the operating accounts of organizations at UCSC. This ledger is broken into three main sections: Revenue, Expenditures and Transfers.

    The FIS Operating Ledger can be compared to a monthly bank statement. Each month you receive your FIS Operating Ledger showing your account’s activity during the month. As you review your ledger, consider whether the transactions reported are reasonable and consistent with your unit’s budget and expenditure plan.

    For procedures on using FIS Banner to review your Operating Ledger, see Reviewing Budget Status.


    Back to Top
  • Chart of Accounts Code Hierarchy

    ​The Chart of Accounts

    The FIS Banner Chart of Accounts (COA) is the list of codes used for classifying, recording, and reporting financial information. A chart of accounts can be as simple as a list of the categories of expenditures and income in the ledger of a small business. The code elements of the FIS Banner Chart of Accounts at UCSC are the basis for the classification, recording, and reporting of ALL types of financial information for the entire campus. Chart of Accounts codes appear on most reports, forms, and on-line screens of FIS Banner.

    The Chart of Accounts is a systematic classification of the university’s assets, liabilities, fund balances, revenues, and expenditures. It is designed to be compatible with the university’s organizational structure and the form and content of its financial reports.

    The COA is also a tool that provides departments and other campus entities with a means of organizing and collecting data needed to run their units. Portions of the chart are based on categories used within the UC system and utilize codes used by the UC Office of the President. Other portions of the chart are “user defined.” For example, Fund is based on the fund accounting system used within UC, while many organization and account codes and all activity codes are largely determined by users.

    When using code elements of the chart, it is important to use individual categories in a manner that is consistent with their intended use. For example, use account code 000060-Computer supplies (not software) to record expenditures for computer supplies only, and use account code 000071-Computer Software Licenses for software expenditures​.

    While the overall structure of the Chart of Accounts is difficult to change, individual categories may be changed as needed by users. When a unit determines a change is necessary, the change will need to be coordinated with the Accounting Office and/or Budget and Planning Analysis Office.

    The chart codes used to specify and report transactions are: Fund, Organization, Account, Program, Activity and Location. These codes are used together to describe each campus entity. Fund, Organization, Account, and Program are required in order to record transactions in the Operating Ledger; Activity and Location are optional. All together, they are referred to as the FOAPAL.

    Hierarchical Structures

    Five of the chart codes discussed above are structured in hierarchies (Fund, Organization, Account, Program and Location). A hierarchy is a way of organizing information in a “pyramid” - where each step of the pyramid is subordinate to the one above it. The following example demonstrates a simplified Organization code hierarchy. This is one of the five codes with hierarchical structures in FIS. The example begins with the highest level being the Total UCSC Campus. The next level is the Academic Units followed by the Social Sciences. The hierarchy becomes more detailed, splitting into different departments - Politics, Economics, and Psychology.

    Example of a Hierarchy



    The example above demonstrates the levels of hierarchy that would be used to produce a report for the Division of Social Sciences. The shaded areas are subordinate levels to the Division of Social Sciences level within the hierarchy and would be included in the report.

    As mentioned previously, five of the chart codes use hierarchical structures to organize data.

    The following diagram demonstrates the similarities and differences among the hierarchical structures of the five chart codes. Each example represents a small portion of the entire hierarchy for each code. For simplicity, only the Code levels for codes are shown. In both the Fund and Account code hierarchies, there are also two Type levels for codes, Level 1 and Level 2, which are not shown.

     Hierarchy diagram for Fund, Org and Account

    A Sample Organization Hierarchy

    The following example will provide more detail on an Organization code hierarchy (if you need detailed descriptions of any of the FOAPAL codes and what they mean, see  “FOAPAL Codes Described” later in this section). A hierarchy starts at a very broad level and becomes more specific with each additional level. Below is a diagram of an organization hierarchy for the Economics Department.

    You will notice the first (highest and broadest) level of organization is the Total UCSC Campus. The campus is divided into academic units and other types of units (not shown). The academic units are made up of divisions; one of these is the Division of Social Sciences. It, in turn, is made up of departments, such as the Economics department. This means that all the accounting information that has to do with the lower levels [from the basic organizations of the Economics department (level 5) to Social Sciences (level 3)] can be “rolled up” or summarized into one comprehensive report for the Dean of Social Sciences.

     

    The hierarchical method of structuring data makes it possible to design a report at Level 1, which summarizes information for the entire UCSC campus, or a report at level 2, which reflects the account information for the Academic Divisions that would include the Social Sciences and the Economics department. With hierarchical level reporting, the FIS system can be used to produce a number of reports at any level in the hierarchy. The ledger reports use hierarchical structures to summarize data.

    Continuing with the Economics department example, we are going to examine a complete Organization code hierarchy. Below level four are a number of units in the Economics department. Level five breaks the Economics Department into various subsets, which allows the Economics Department more flexibility in sorting and separating budgetary and financial information.

     

    An organization hierarchy with five levels is shown above. The value used to code transactions and enter them into the system is always the code for the lowest level of its hierarchy. This lowest level of the hierarchy is known as the Data Entry Level. All higher levels are known as Predecessor Levels. The predecessor levels are used to group data for reports. The Data Entry Level can also be used for detailed reports that are specific to that level.

    An example would be if the Division of Social Sciences requested a report on all activities within that division. The predecessor level the division would request would be Level 3 (#114). This report would include detail on not only the Economics department, but all other departments and activities that were listed below “Division of Social Sciences” in the Organizational hierarchy.

    All values above a data entry level are referred to as “predecessor levels” or “roll-ups”; these levels are used only to group data on reports. Organization codes are always numeric.

     


    Back to Top
  • FOAPAL Codes Described

    ​This section describes the FOAPAL codes in the order in which they appear: Fund, Organization, Account, Program, Activity, and Location. All chart codes are assigned by the Budget and Planning Analysis Office in accordance with University of California rules and regulations, with the exception of Fund codes, Revenue codes, Transaction Code Accounts and Balance Sheet Accounts, which will be assigned by the Accounting Office. The combination of Fund, Organization, Account and Program codes are required on expenditure, revenue, and transfer transactions. Balance sheet transactions (in the General Ledger) require fund code and account code only.
    The following diagram shows FIS Banner chart of account codes with examples. A description of each code follows the chart.

    ​ ​

    Fund Codes

    Fund is an up to five character code describing the source of funding for a transaction. Fund is defined in a five level hierarchy. Fund corresponds to the coding structure of the Office of the President.

     

    The lowest level is the data entry level of the fund hierarchy. This is the fund number that is used to code transactions.

    Data Entry Level Fund Codes

    Following is the framework used in assigning data entry level fund codes:

    Current Funds:

    • 04100-09599 Endowments, Principal Approps., and University Opportunity Funds
    • 18000-19999 State of California
    • 19900-19999 University General Funds (State)
    • 20000-20399 Student Tuition and Fees
    • 20600-20999 Local Government
    • 21000-33999 Federal Government
    • 34100-39799 Endowment Income
    • 39800-59999 Private Gifts, Grants and Contracts
    • 60000-62999 Sales and Services of Educ. Activities
    • 63000-63999 Teaching Hospitals
    • 64000-65999 Sales and Services of Educ. Activities
    • 66000-66099 Service Enterprises
    • 66100-69999 Other Sources
    • 70000-74999 Auxiliary Enterprises
    • 75000-75999 Reserves - Current
    • 76000-76999 Reserves for Renewal and Replacement
    • 80000-88999 Federal Government
    • 00001-00299 Agency Funds
    • 00300-01999 Plant Funds
    • 02200-03999 Loan Funds

    Organization Codes

    Organization is a numeric code describing the department or office of the University. Organization codes are arranged in hierarchies of up to five levels. Level one is a one character code, level two is a two character code, level three is a three character code, and level four is a four character code. Data entry is at level five and is a 6 character code. For a full discussion of a sample Organization code hierarchy, see Hierarchical Structures

    Account Codes

    Account is a six character code that describes the basic accounting classifications. There are seven account types:

    General Ledger (Balance Sheet)

    1. Asset
    2. Liability
    3. System Control
    4. Fund Balance

    Operating Ledger

    1. Revenue (Income)
    2. Expenditures
    3. Transfer

    Account codes are organized in a hierarchy within each account type. The highest level, Type Level 1, is used as a sort criteria in Operating Ledger reports. Every transaction requires an account code.

     

    Accounts - Balance Sheet (General Ledger)

    For balance sheet account transactions, an account code and fund code are required. Balance sheet accounts include assets, liabilities, clearing accounts, fund balance, and General Ledger system control accounts. Data entry level balance sheet account codes begin with the number 1 for assets, liabilities, clearing, and fund balance accounts, and either the number 3 or the number 4 for system control accounts.

    Accounts - Revenue (Operating Ledger)

    Revenue accounts are operating accounts used with the Fund, Organization, and Program codes to identify revenue (income) transactions. Revenue codes begin with the alpha character R.
    For extramural funds there is a revenue account for each major fund category, such as Federal Grant Revenue, Federal Contract Revenue and Private Gifts/Grants Revenue, as well as for each major agency. Use of the fund code with these revenue accounts provides an accounting by specific fund source.

    Accounts - Expenditure (Operating Ledger)

    Expenditure accounts are operating accounts used with Fund, Organization, and Program codes to identify expenditures. These are the accounts used for the day-to-day purchasing transactions of most units. The basic structure is shown in the following illustration. Any data entry level expenditure account can be used for budgetary or financial transactions. The only exceptions are certain expenditure accounts reserved for budgetary transactions. Budgetary account codes begin with the alpha character “B.”

     

    Accounts - Transfers (Operating Ledger)

    Transfer codes are operating accounts and are used to designate financial additions to, deductions from or transfers between fund balances. Fund balance transactions are coded by the Accounting Office.

    Program Codes

    Program is an up to six character code representing the functions of the University. The Program codes will usually consist of the first two digits of the Organization codes that are used at the Data Entry Level. The functions they represent are: instruction, research (including research grants), public service, academic support, student services, institutional support, operation and maintenance of plant, student financial aid, auxiliary enterprises, budgetary provisions, agency accounts, and construction in progress. There is at least one program code associated with each organization code.

     

    Activity Codes

    Activity is reserved for departmental use. Activities may be established by units for cost-centering purposes. The first two characters of the activity code will be alphabetical, and will be assigned by the Budget and Planning Analysis Office. Activity is not hierarchical.

    Location Codes

    Location codes are not used at UCSC.


    Back to Top
  • Establishing Agency Account/Fund Codes

    ​Agency accounts are established by the University for non-University entities. When a unit accepts funds for the operation of activities sponsored by a non-University entity, the funds are not considered tax-deductible donations because, in most cases, control over the funds remains in the hands of the sponsoring entity. Even though the sponsored activities may relate closely to University activities and provide services or benefits to the University community, the receipt and disbursement of funds coming from the sponsoring entities are not reported as University income and expenditures.

    Areas of Responsibility

    Business Officers/Unit Managers are responsible for adhering to Agency Account Policy and Procedures.
    The Accounting Office is responsible for reviewing unit requests for new agency accounts and assigning and setting up new accounts. The source of these guidelines is the Campus Policy on Agency Accounts.

    Campus Units Other than the Conference Office

    Send a request to (or call) the Extramural Funds Supervisor in the Accounting Office and provide the following information:

    • Campus unit sponsoring the agency activity and unit organization code
    • Index code to be used if applicable
    • Individuals authorized to input and approve transactions against agency fund
    • Name of the agency
    • Description and purpose of the activities to take place
    • Functions to be performed by the campus unit sponsoring the agency activity
    • Fund - Organization - Program code to charge any deficit balances remaining in the agency fund upon completion of agency activities

    The Extramural Funds Supervisor

    • Reviews the information
    • Assigns and sets up the appropriate agency fund code
    • Provides the new agency fund code to the unit
    • Forwards fund information to the Budget and Planning Analysis Office

    Budget Analysis and Planning

    Sets up requested agency Organization code.

    The Conference Office

    The Conference office will be assigned a range of fund codes that they will use to set up new conference (agency) activity. The campus Conference Office will provide the Extramural Funds Supervisor with the following items:

    • Fund code to be used for the new agency activity and title
    • Index code to be used and the Fund - Organization - Program code combination
    • List of individuals with input and approval authorization
    • Fund - Organization - Program code to charge any deficit balances remaining in the agency fund upon completion of agency activities

    Back to Top
  • Establishing Activity Codes

    ​Activity codes assist departmental units by allowing them to gather financial data by activities (e.g., project, principal investigator, cost center, etc.).

    Because commonly-used activity codes have the capability of collecting data across funds, organizations, and/or programs, causing a potential for duplication and corruption of data, unique activity codes must be established for each of the campus’ over 140 organizational units. To preserve that uniqueness, at least at the campus level, the first two characters of all departmental activity codes will consist of a Budget and Planning Analysis assigned and mandatory two-character Unit Alpha Code. The units themselves may assign up to a total of four of the remaining characters. These four characters may be structured or unstructured, depending on unit preference.

    A Few Precautions

    The full use of activity codes to collect or to separate financial information within your organizational unit may require additional effort on your part.

    The collection of financial data by any activity code requires that all data-enterable information related to that “collection center” include the pertinent activity code.

    Conversely, if relative information is entered without an activity code, that information will not be included on activity code reports. Therefore, consistent input is key to the effective collection of activity code data.

    How to Establish Activity Codes

    1. Type FTMACTV in the Banner Welcome page.
    2. When FTMACTV opens, it is running in filter-only mode. Type [control-q] or click the small black x in the upper right corner to exit filter mode.
    3. Click the Insert button. A blank record will display.
    4. In the CHART OF ACCOUNTS field, enter the COA code (currently X). Required.
    5. <TAB> to ACTIVE STATUS field (checkbox). Leave box checked.
    6. <TAB> to ACTIVITY. Required. Type in your assigned two-character unit alpha code, followed by up to four alpha-numeric characters of your choice.
    7. <TAB> to TITLE. Required. Enter the name of the activity.
    8. <TAB> to EFFECTIVE DATE field. Today’s date defaults. IMPORTANT - Backdate this date to 7/1 of the current fiscal year. For example, when creating an Activity Code in FY23, backdate the Effective Date to 7/1/2022, the first day of FY23. If you enter a future date, this activity code will not be able to be used until that future date.

      IMPORTANT NOTE FOR UCPATH
      For Activity Codes that will be used in conjunction with UCPath, consider the date you will need the Activity Code to be effective for Funding Entry. It is recommended that the Activity Code be backdated upon creation in FIS Banner to 7/1 of the current fiscal year, so that the associated Funding Entry can be made effective as of that date​.​

    9. <TAB> to TERM field. Optional. You may specify an end date for the activity code by entering a future date in this field. However, this field should only be used if you are certain that you do not want this activity code to be used beyond this date. Usually this field will be left blank.
    10. If you are establishing a single activity code and wish to end the session, key F10 or click the Save button to commit your record. If you wish to establish another activity code, type <down arrow> Next Record or click in the Chart of Accounts field in the next record, then continue from Step 3 (above).

    How to Query/Verify Activity Codes

    1. Type FTMACTV in the Banner Welcome page.​
    2. When FTMACTV opens, it is in Filter mode.
    3. <TAB> to ACTIVITY and type in your activity code. If you need to find the activity code, type [F9] List of Values.
    4. Click the Go button or key return.
      If the activity code exists, the remaining information on the screen will fill in, reflecting previously-entered data.
    5. If you wish to end the session, type [control-q]. If you wish to query another activity code, click the Filter button to return to filter  mode, then continue from Step 2 (above).

    Changing an Existing Activity Code

    Because FIS Banner tracks activity code history, activity codes entered in the system cannot be changed. If the code was entered incorrectly, you must copy the activity code record and then change it.

    1. Type FTMACTV in the Banner Welcome page.​​
    2. Filter for the activity code you need to change. (Filter instructions are listed above.)
    3. With your cursor anywhere in the record for the activity code you need to change, click the Copy button. This creates an exact copy of the activity code in the record below the original activity code record.
    4. Change the activity code record as appropriate, including the effective date.
    5. Type [F10] or click the Save button to commit your activity code record.

    Important: When you filter for activity codes, codes that have been changed will be listed multiple times. You can choose any one of the records listed with the same code and FIS Banner will default to the newest activity code record. That is, if you changed an incorrect description and then later choose the old record from the list, FIS Banner will default to the activity code with the correct description. FIS Banner adds an activity code to the list each time you make a change.

    Making an Activity Code Inactive

    Caution: Before inactivating an Activity Code, make sure it does not have any existing budget, financial or encumbrance balances. If you are unsure about your activity code's balance status, send an email to fis_probs@ucsc.edu.

    If you want to use the activity code in question during the next fiscal year, you will only want to make it inactive for now. People will still see the activity code when they List [F9], but they will not be able to successfully use the code.

    1. Filter for the activity code you want to make inactive (instructions are listed above.)
    2. With your cursor anywhere in the record for the activity code you need to change, click the Copy button. This creates an exact copy of the activity code in the record below the original activity code record.
    3. Uncheck the ACTIVE STATUS checkbox.
    4. Change the EFFECTIVE DATE to today if you want to inactivate it immediately, or to a future date if you want it to become inactive in the future.
    5. Type [F10] to commit your activity code record.

    Terminating an Activity Code

    Caution: Before terminating an Activity Code, make sure it does not have any existing budget, financial or encumbrance balances. If you are unsure about your activity code's balance status, send an email to fis_probs@ucsc.edu.

    If you want to terminate an activity code from the system, you can supply a termination date in the TERM field. This will NOT delete the activity code from the List of Values [F9], but you will be unable to use the code.

    1. Filter for the activity code you want to make inactive (instructions are listed above.)
    2. With your cursor anywhere in the record for the activity code you need to change, click the Copy button. This creates an exact copy of the activity code in the record below the original activity code record.​
    3. Change the EFFECTIVE DATE: to today if you want to terminate it immediately, or to a future date if you want it to be terminated in the future.​
    4. Enter a termination date in the TERMINATION DATE: field. This date must be equeal to or greater than the EFFECTIVE DATE.
    5. Type [F10] to commit your activity code record​. 

    FZRACTV Activity Code Report

    There is a report called FZRACTV that you can run using your unit or department's two-character Unit Alpha Code for Activity Codes. The report shows Code, Code description, active status, effective date, and a history of changes to the Activity Codes and the Users who made the changes. To run the report:

    1. Type FZRACTV in the Banner Welcome page.​​
    2. Type [alt-pagedown] to the Printer block and enter your desired printer name​. 
    3. Type [alt-pagedown] to Parameter Values, arrow down to Activity_Code_Prefix, tab to Values and enter your two-character alpha code. You can also change the parameter for Active_Only if desired. 
    4. Type [alt-pagedown] to the Submission block and type [F10]. Your report will print to the printer code specified.​

    If you do not want to print a physical copy of the report, you can use the DATABASE printing method.

    Note: you can only enter one prefix code at a time. If you need reports for multiple different prefix codes, you'll need to run the report separately for each code.

    IMPORTANT: Do not run the report without an Activity_Code_Prefix parameter, otherwise you will print a list of every UCSC activity code (of which there are more than 60,000!).
    ​​​
    Back to Top
  • Document Level versus Commodity Level Accounting

    ​In FIS Banner, Requisitions, Purchase Orders, Invoices, and Journal Vouchers are called documents.

    Document Level Accounting

    Document level accounting allows you to use one or more funding sources to pay for the commodities on a requisition by a percentage (or other distribution) of the total.

    Example:

    • 1st Commodity (plus)
    • 2nd Commodity (plus)
    • 3rd Commodity ( = total charge)
    • paid by:
    • 1st FOAPAL (100%)
    • or
    • 1st FOAPAL (75%) and 2nd FOAPAL (25%)
    • or
    • 1st FOAPAL ($partial amount) and 2nd FOAPAL ($balance)

    Commodity Level Accounting

    Commodity level accounting allows you to assign one or more FOAPALs to each specific commodity. In this case, you would remove the checkmark from the DOC Level Accounting field in your document. This activates commodity level accounting.

    Commodity level accounting must be used when you order inventorial items.
    Commodity level accounting would be used, for instance, to purchase inventorial equipment and components for existing equipment on one document.

    Example:

    • 1st Commodity paid by 1st FOAPAL (100%)
    • 2nd Commodity paid by 2nd FOAPAL (100%)
    • 3rd Commodity paid by 2nd FOAPAL (50%) and by 3rd FOAPAL (50%)

    Back to Top
  • Introduction

    ​The Operating Ledger is a report your unit will use to review financial activity on your account and to check the status of your budget. Financial Managers will use the Operating Ledger as an accountability tool for ensuring the accuracy of the budget and financial information for each of the units served by the Division. But in order to understand the Operating Ledger, you need to understand the system that produces it. For further information, read “Accounting Information Structure and FOAPAL Codes.”

    Important: Financial Managers will need to review the Operating Ledger carefully; it is their most important tool in maintaining accountability for the accurate input of budget and financial transactions for the units they serve.

    To review additional information on a transaction in FIS Banner, use a query form such as the Detail Transaction Activity Form (FGITRND). You should also review the status of your budget to ensure that you are not overdrawn. Finally, Financial Managers should perform random audits of detailed transactions to ensure that all backup materials are in order, and that data has been entered into the FIS correctly.

    The Operating Ledger is a monthly report containing detailed information about transactions posted during the month. It reports on revenue, expenditure, and transfer account activity for all campus organizational units. A separate ledger is prepared for each unit. Within that ledger are reports for each organization/program/fund combination. There are two sections to the report: Current Month Transactions and the Account Summary. Not included in this report are transactions posted to general ledger accounts (shown on the separate General Ledger).

    The following FIS Banner forms and their uses are explained in this section:


    Back to Top
  • Checking Organization Budget Status FGIBDST

    FGIBDST

    FGIBDST Organization Budget Status Form. FGIBDST provides a summary of all activity for an FOP (FUND ORG PROGRAM), excluding items which have been neither approved nor posted. Using FGIBDST, queries can be further defined by ACCOUNT or ACTIVITY.

    Note: FGIBDST does not reflect incomplete, unapproved or unposted transactions.

    1. Type FGIBDST in the Banner Welcome page.
    2. CHART and FISCAL YEAR fields will default. <TAB> through both fields.

      View Image



    3. At UCSC, the INDEX field is only used by Central Offices for certain transactions.
    4. Leave the THRU FISCAL PERIOD field blank to see all activity for the fiscal year, or specify a fiscal period (01-12) to see activity through that time period.
    5. <TAB> to QUERY SPECIFIC ACCOUNT checkbox. Box can be left unchecked for a relative account listing (i.e., the system will produce a list of all accounts greater than the account code entered into the ACCOUNT field), or can be checked [spacebar] to limit the query to specific account detail.
    6. INCLUDE REVENUE ACCOUNTS. Leave checkbox blank unless your unit has income from revenue type accounts and you wish these totals to be included in the detail below. Check the field [spacebar] to include revenue accounts.
    7. <TAB> to COMMIT TYPE. Leave “Both” (the default).
    8. <TAB> to ORGANIZATION. Provide your Organization code.
    9. <TAB> to FUND. Provide your Fund Code.
    10. <TAB> to PROGRAM. Provide Program Code.
    11. <TAB> to ACCOUNT. Leave blank to query all accounts. Otherwise, enter specific account code.
    12. <TAB> to ACCOUNT TYPE. Leave blank to query all account types, or indicate account type code to limit query to a specific Level 2 account type (e.g., ‘71’ Non-Capital Expenditures). See table below for a list of Level 2 account types.
      Level 2 Acct Type ​ Acct Type Title​
      71​ ​Non-Capital Expenditures
      ​72 ​Capital Expenditures
      ​73 ​Indirect Costs (Contract & Grant O/H)
      ​79 ​CIP Expenditures
      ​61 ​Salaries & Wages
      ​66 ​Retirement & Employee Benefits
      ​51 ​Tuition & Fees
      ​52 ​State Government
      53 ​Local Government
      54 ​Federal Government
      55 ​Private Gifts, Grants, & Contracts
      ​56 ​Sales & Services of Educational Act
      57 ​Service Enterprises
      ​58 ​Other Services
      59 ​Sales & Services of Auxiliary Ent
    13. <TAB> to ACTIVITY. Leave blank to query on all activity codes (includes transactions with or without activity codes attached), or enter an activity code to limit the query.
    14. <TAB> to LOCATION. The Location Code field is only used by Plant Accounting and Physical Planning & Construction in conjunction with Plant Funds to denote the building for which the corresponding transaction is being posted. All other divisions should always leave this field blank.
    15. Type [alt pagedown] Next Block.

      View Image



    16. The page displays the budget status for the FOAPAL combination you have entered. To view additional budget lines, scroll up and down using the vertical scroll bar, [page up] and [pagedown] keys, or <up arrow> <down arrow> arrow keys.
    17. You may jump to FGIBSUM Organization Budget Summar via Related Menu. (see below for instructions).
    18. To start a new query, click the Start Over button.
    19. Type [control q] to exit FGIBDST.

    Jumping to Other Forms from FGIBDST

    After you have input your query information in FGIBDST, and typed [alt pagedown] Next Block, you can choose to access other pages which summarize or expand the same data in different ways:

    • To view Transaction Detail, key [F3] or select FGITRND from the Related Menu.
    • To view Organization Budget Summary, key Shift+[F2] or select FGIBSUM from the Related Menu.
    • To view Organizational Encumbrance List, key [F4] or select FGIOENC from the Related Menu.​​
    • Format Display Preferences provides users with the ability to make format choices, as shown in the screenshot below.

    ​​​​​
    Back to Top
  • Detail Transaction Activity FGITRND

    ​FGITRND

    The FGITRND Detail Transaction Activity form provides a detailed list of all transactions associated with specific FOAPAL values. You can use the form to search for transaction detail for Fiscal Year, Fund, Organization, Account and Activity codes, and Posting (Month) Period. The form can be used as a Stand-Alone form (entered directly from the Go To... field of the Banner Menu Form), or it can be called from within the FGIBDST Organization Budget Status form.

    FGITRND Stand-Alone

    1. Type FGITRND in the Banner Welcome page.
    2. Cursor appears in the COA field. Accept default value X.
    3. <TAB> to Fiscal Year field. Current FY will default. Change if required.
    4. <TAB> to INDEX. Leave blank.
    5. <TAB> to FUND. If desired, enter a Fund code or type [F9] List Field Values to lookup and retrieve a specific Fund code.
    6. <TAB> to ORGANIZATION. If desired, enter an Organization code or type [F9] List Field Values to lookup and retrieve a specific Org code.
    7. <TAB> to ACCOUNT. If desired, enter an Account code or type [F9] List Field Values to lookup and retrieve a specific account code.
    8. <TAB> to PROGRAM. Leave blank.
    9. <TAB> to ACTIVITY. Field is optional. If desired, enter an Activity code or type [F9] List Field Values to lookup and retrieve a specific Activity code.
    10. <TAB> to LOCATION. Leave blank.
    11. <TAB> to POSTING PERIOD. If desired, enter a specific two digit Posting Period code (01=July, 02=Aug ... 11=Nov, 12=Dec). This will limit your detail results to transactions for a specific month.
    12. <TAB> to QUERY TYPE. R or S will default. Do not change.
    13. <TAB> to COMMIT TYPE. Leave blank.
    14. Type [alt pagedown] Next Block to go to the Transaction Detail block. The Transaction Detail Block will appear in filter mode with no visible detail.
    15. Type [F8] Execute Query. Transaction Detail for the specific codes entered will appear.

      View Image



    16. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction detail records. Use the <TAB> key to navigate through a specific record for more detail.
    17. To view the originating document of a specific record, clicking on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Related Menu. After the originating document opens, use [alt pagedown] Next Block and <down arrow> Next Record to navigate within the form. Type [control q] when you are ready to return to FGITRND.
    18. To start a new query, click the Start Over button.
    19. Type [control q] to exit FGITRND and return to the Banner Welcome page.

    FGITRND Viewed From FGIBDST

    You can access FGITRND from within FGIBDST to view specific transaction details in FGIBDST’s Adjusted Budget, YTD Activity and Commitments columns. You can also view all combined (Budget+YTD+Commitments) detail.

    Adjusted Budget Transaction Detail:

    1. Navigate to the lower block of FGIBDST by typing [alt pagedown] Next Block. The cursor will appear in the Account field of the first row.
    2. Use the arrow keys <up arrow> <down arrow> to navigate to a specific Account (e.g. 000010 - Supplies-Other, 000030 - Office Supplies, etc.).
    3. <TAB> to the Adjusted Budget field.

      View Image



    4. Key [F3]. FIS Banner will display the FGITRND screen with specific Budget Transactions for your Fiscal Year, Fund, Organization, Account and Activity Code settings from FGIBDST.
      Note: If your Adjusted Budget field is zero (0.00), FGITRND will display a Hint Text message "Query caused no records to be retrieved."

    5. View Image



    6. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction Detail records. Use the <TAB> key to navigate through a specific record for more detail.​
    7. To view the originating document of a specific record, click on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Related Menu, or type [F3]. After the originating document opens, use [alt pagedown] Next Block and <down arrow> Next Record to navigate within the page.

      View Image



    8. Type [control q]  when you are ready to return to FGITRND.
    9. Type [control q] to exit FGITRND and return to FGIBDST.

    YTD Activity Transaction Detail:

    1. Navigate to the lower block of FGIBDST by typing [alt pagedown] Next Block. The cursor will appear in the Account field of the first row.
    2. Use the arrow keys <up arrow> <down arrow> to navigate to a specific Account (e.g. 000010 - Supplies-Other, 000030 - Office Supplies, etc.).
    3. <TAB> to the YTD Activity field.

      View Image



    4. Key [F3]. FIS Banner will display the FGITRND screen with specific YTD Transactions for your Fiscal Year, Fund, Organization, Account and Activity Code settings from FGIBDST.
      Note: If your YTD Activity field is zero (0.00), FGITRND will display a Hint Text message "Query caused no records to be retrieved."

      View Image



    5. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction Detail records. Use the <TAB> key to navigate through a specific record for more detail.
    6. To view the originating document of a specific record, click on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Related Menu, or type [F3]. After the originating document opens, use [alt pagedown] Next Block and <down arrow> Next Record to navigate within the page.

      View Image



    7. Type [control q] when you are ready to return to FGITRND.
    8. Type [control q] to exit FGITRND and return to FGIBDST.

    Commitments Transaction Detail:

    1. Navigate to the lower block of FGIBDST by typing [alt pagedown] Next Block. The cursor will appear in the Account field of the first row.
    2. Use the arrow keys <up arrow> <down arrow> to navigate to a specific Account (e.g. 000010 - Supplies-Other, 000030 - Office Supplies, etc.).
    3. <TAB> to the Commitments field.

      View Image



    4. Key [F3]. FIS Banner will display the FGITRND screen with specific Commitments for your Fiscal Year, Fund, Organization, Account and Activity Code settings from FGIBDST.
      Note: If your Commitments field is zero (0.00), FGITRND will display a Hint Text message "Query caused no records to be retrieved."

      View Image



    5. Use the arrow keys <up arrow> <down arrow> or the scroll bar to navigate through the Transaction Detail records. Use the <TAB> key to navigate through a specific record for more detail.
    6. To view the originating document of a specific record, click on the Account code of the desired document (under Account on the left side of the screen), then select Query Document [By Type] from the Related Menu, or type [F3]. After the originating document opens, use [alt pagedown] Next Block and <down arrow> Next Record to navigate within the page.

      View Image



    7. Type [control q] when you are ready to return to FGITRND.
    8. Type [control q] to exit FGITRND and return to FGIBDST.

    ​​
    Back to Top
  • Organization Budget Summary FGIBSUM

    FGIBSUM

    While using FGIBDST (see Checking Organization Budget Status), you can view the total of all FOP activity summarized in four account code categories (Revenue, Labor, Direct Expenditures, and Transfers) via FGIBSUM.

    1. From the lower block of FGIBDST, choose FGIBSUM (Budget Summary Information) ​from the Related Menu.

      View Image



    2. Leave the THRU FISCAL PERIOD field blank to see all activity for the fiscal year, or specify a fiscal period (01-12) to see activity through that time period.
    3. After you have reviewed the budget summary, type [control q] to return to FGIBDST.
    ​​
    Back to Top
  • Organizational Encumbrance List FGIOENC and Detail Encumbrance Activity FGIENCD

    FGIOENC and FGIENCD

    While using FGIBDST (see Checking Organization Budget Status), you can view a list of all encumbrances for a fund/org combination via FGIOENC. To view encumbrance activity in even greater detail, you can jump from FGIOENC to FGIENCD.

    1. From the lower block of FGIBDST, choose FGIOENC (Organizational Encumbrance List) from the Related Menu.

      View Image



    2. You may scroll through the transactions using the vertical scrollbar, [page up] and [page down] keys, or <up arrow> <down arrow> arrow keys.
    3. To get to FGIENCD (Detail Encumbrance Activity), choose FGIENCD from the Related Menu.

      View Image



    4.  Type [control q] to return to FGIOENC (Organizational Encumbrance List).
    5. Type [control q]​ return to FGIBDST.
    ​​
    Back to Top
  • Querying Executive Summary Information FGIBDSR

    FGIBDSR

    FGIBDSR looks identical to FGIBDST, but functions in a different way. In FGIBDST, information could only be queried based on data enterable FOP (Fund Org Program) codes. If you need to query on a high-level summary code, such as an Org code for an entire school or college, you must use FGIBDSR. When you query on non-data enterable codes, you cannot view transaction detail, because that detail is linked to the data enterable code, not the summary code.

    1. Type FGIBDSR in the Banner Welcome page..

      View Image



    2. CHART and FISCAL YEAR fields will default. <TAB> through both fields.
    3. <TAB> through INDEX. At UCSC, the INDEX field is only used by Central Offices for certain transactions.
    4. Leave the THRU FISCAL PERIOD field blank to see all activity for the fiscal year, or specify a fiscal period (01-12) to see activity through that period.
    5. <TAB> to QUERY SPECIFIC ACCOUNT checkbox. Box can be left unchecked for a relative account listing (i.e., the system will produce a list of all accounts greater than the account code entered into the ACCOUNT field), or can be checked [spacebar] to limit the query to specific account detail.
    6. INCLUDE REVENUE ACCOUNTS. Leave checkbox blank unless your unit has income from revenue type accounts and you wish these totals to be included in the detail below.
    7. <TAB> to COMMIT TYPE. Leave “Both” (the default).
    8. <TAB> to ORGANIZATION. Provide your Organization code, if desired.
    9. <TAB> to FUND. Enter Fund code for query, if desired.
    10. <TAB> to PROGRAM. Enter Program code for query, if desired.
    11. <TAB> to ACCOUNT. Leave blank to query all accounts. Otherwise, specify specific account code.
    12. <TAB> to ACCOUNT TYPE. Leave blank to query all account types, or indicate account type code to limit query to a specific Level 2 account type (e.g., ‘71’ Non-Capital Expenditures). See table below for a list of Level 2 account types.
      Level 2 Acct Type ​ Acct Type Title​
      71​ ​Non-Capital Expenditures
      ​72 ​Capital Expenditures
      73 ​Indirect Costs (Contract & Grant O/H)
      ​79 ​CIP Expenditures
      ​61 ​Salaries & Wages
      66 ​Retirement & Employee Benefits
      51 ​Tuition & Fees
      52 ​State Government
      53 ​Local Government
      54 ​Federal Government
      55 ​Private Gifts, Grants, & Contracts
      ​56 ​Sales & Services of Educational Act
      57 ​Service Enterprises
      ​58 ​Other Services
      59 ​Sales & Services of Auxiliary Ent 
    13. <TAB> to ACTIVITY. Leave blank to query on all activity codes (includes transactions with or without activity codes attached), or enter specific code to limit query.
    14. <TAB> to LOCATION. The Location Code field is only used by Plant Accounting and Physical Planning & Construction in conjunction with Plant Funds to denote the building for which the corresponding transaction is being posted. All other users should always leave this field blank.
    15. Type [alt pagedown] Next Block.
    16. The page displays the budget status for the FOAPAL combination you have entered. To view additional budget lines, scroll up and down using the vertical scroll bar, [page up] and [page down] keys, or <up arrow> <down arrow> arrow keys.
    17. If you have queried on data enterable codes, you may jump to FGITRND (see below for instructions). If you have queried on non-data enterable codes, (e.g. Org 2681) you cannot jump to FGITRND.
    18. To start a new query, click the Start Over button.
    19. Type [control q] to exit FGIBDSR.

    Jumping from FGIBDSR to FGITRND Detail Transaction Activity

    While using FGIBDSR (see above), you can view detail transaction activity via FGITRND. You can view transactions which make up any amount in FGIBDSR’s Adj Budget, YTD Activity or Commitment columns
    Note: When you query on non-data enterable codes, you cannot view transaction detail, because that detail is linked to the data enterable code, not the summary code.

    1. In the lower block of FGIBDSR, in any of the three columns (Adj Budget, YTD Activity, Commitment), click on the amount for which you need further detail.
    2. Select FGITRND (Transaction Detail Information) from the Related Menu.
    3. You may scroll through the transactions using the vertical scrollbar, [page up] and [page down] keys, or <up arrow> <down arrow> arrow keys. Additional fields in each record can be accessed by using the horizontal scrollbar.
    4. Type [control q]​ to return to FGIBDSR.
    ​​​​
    Back to Top
  • Known Issues - FGIBDST - Organization Budget Status

    FGIBDST-Organization Budget Status

    Drilling down from FGIBDST to FGITRND may display incorrect transactions: When drilling down to FGITRND from the FGIBDST detail block, sometimes transactions that are not related to the filter criteria will display. This normally happens when navigating directly to FGIBDST after performing queries in FGITBSR.

    Workaround

    Exit FGITRND, click the Start Over button in FGIBDST and key [alt pagedown]. Then select FGITRND from the Related Menu, and FGITRND will display correct results. 


    Back to Top
  • Approving Documents: POs, Change Orders, Invoices and Credit Memos – FOIAINP & FOAUAPP

    ​You can use the pages described below to complete the approval process for documents like Purchase Orders, Change Orders, Invoices or Credit Memos.

    The first time you sign onto FIS Banner each day and go to any page, if you have any documents in your approval queue, the system will automatically go to FOIAINP Approvals Notification. This only happens the first time you sign on. If you choose not to enter the approval page at that time, FIS Banner will not prompt you to enter it again until you exit FIS Banner and sign on again. You can enter User Approval (FOAUAPP) any time from the Banner Welcome page.

    View Image



    1. From FOIAINP, select User Approval (FOAUAPP) from the Related Menu. FIS Banner will route you to FOAUAPP.
    2. <TAB> Next Field to the DOCUMENT field and enter the document number if you want to approve a specific document and already have the document number. Leave blank to see all documents.
    3. <TAB> Next Field to the NEXT APPROVER field. The unchecked box defaults to view all documents in your queue and in queues below yours where others have the authority to approve the transaction. Check the box to view only documents where you are the next approver.
    4. Type [alt pagedown] Next Block. Documents that need your approval will display a “Y” in the NEXT APPROVER field, indicating you are the next approver for this document. You can approve other transactions, but it is not necessary at this time, since they are also in another person’s queue to approve (the other person will have a “Y”).
      You will only receive FOIAINP Approvals Notification Form when you log into FIS Banner if you have transactions in your queue marked with a “Y”. Multiple users sharing the same queue can have the “Y” and approve the document.

      View Image



    5. To view document detail in FOAUAPP, click on the Detail button. Depending on the type of document you select, Banner takes you to FOQPACT Purchase Order Approval, FOQJVCD​ Journal Voucher Approval, or FOQINVA Invoice/ Credit Memo Approval where you can view FOAPAL information. Use the arrow keys to scroll through commodity or FOAPAL records when there are multiple records.
    6. To view the entire document that you need to approve, select Query Document from the Related Menu, and Banner will take you to the query page for that type of document and fill in the document number. For example, if you are approving a purchase order, the system will default to FPIPURR. For an invoice or credit memo, the system will default to FAIINVE. 
    7. To view the Commodity detail, select View Commodities (FOICOMM) from the Related Menu.
    8. Accounting information may be viewed from FOICOMM by selecting Accounting Information (FOIACCT for POs, FAININV for invoices) from the Related Menu. Remember that you can use the arrow keys to scroll through commodity or FOAPAL records when you have multiple records.
    9. Type [control q] to return to the approval detail page.
    10. Type [control q] to return to FOAUAPP User Approval. Prior to approval, if you wish to view the document queue, click on the Queue button. The system will go to FOAAINP Document Approval and FIS Banner will fill in the document number. Type [alt pagedown] Next Block to view information for this document. The left side is queue information and the right side provides names of approvers in that queue.

      View Image



    11. If you wish to approve the document at this time, in FOAAINP click on the Approve button to approve or click on the Disapprove button to disapprove. Making the approval here or in FOAUAPP performs the same function. 

    12. If you disapprove a document, the Banner Messaging System GUAMESG will automatically send a message to the Banner user who completed the document notifying them that the document has been disapproved. Approvers who disapprove a document can override the default disapproval message with their own personal message:

      View Image

      ​​​

      The user whose document was disapproved will received the personal message:​

      View Image



      ​See Banner Messaging GUAMESG for more information.

    13. Type [control q] when all approvals are complete to return to the Banner Welcome page.
    ​​​​​​​​​​
    Back to Top
  • Querying Approval History FOIAPHT

    ​FOIAPHT Approval History allows the user to query approval history by Document Code, Document Type, Change Sequence, Queue ID, Queue Level, Approver’s ID, or Approve Date. 

    1. Type FOIAPHT in the Banner Welcome page.​
    2. Enter information into Queue ID, Approver’s ID, Date, etc. as needed.
    3. Enter [F8] or click the Go button to display data. Your result will display any documents containing your search criteria.

      View Image



    4. Type [control q] to return to the Banner Welcome page.​


    ​​
    Back to Top
  • Document Self Denial / Query by User FOADOCU

    ​FOADOCU Document by User enables the user to display a list of documents originated by a specific user, and to "DENY" approval for a document, returning it to "incomplete" status. Use this feature to re-open documents and correct or delete them, instead of waiting for an approver to disapprove them. (Users can only deny their own documents.)

    TO DENY A DOCUMENT

    1. Type FOADOCU in the Banner Welcome page.
    2. Tab to the Document field and enter the number of the document you want to review. COA and Fiscal Year will default. If you don't know the document number, you can enter Document Type, Status and Activity Date range to narrow your search.
    3. Key [alt pagedown] Next Block to display data. Note that the page may take some time to load data. Be patient!
    4. Select the document to deny and click on the Deny Document Icon. A message "Document XXXXXXXX has been denied." appears in the Status/Hint Text field.
    5. Type [control q] Exit Screen to return to the Banner Welcome page.

      View Image


    TO QUERY DOCUMENTS BY USER

    1. Type FOADOCU in the Banner Welcome page.​​ In the ORIGINAL USER ID field, your ID will default.
    2. <TAB> to COA. X defaults as the value for the Chart of Accounts field.
    3. <TAB> to FISCAL YEAR. The current fiscal year defaults.
    4. <TAB> to TYPE. Enter PO, INV, ENC, JV or leave blank to see all documents.
    5. <TAB> to DOCUMENT. Enter the document number, or partial number using wildcards (%), or leave blank for all (example: P000%).
    6. <TAB> to STATUS. Select using the pull-down menu, or leave blank to see all.
    7. <TAB> to ACTIVITY DATE FROM and TO fields. Provide lower and/or upper bounds of date range of interest, or leave blank to see all.
    8. Key [alt pagedown] Next Block to display data.
    9. Select Approval History [FOIAPHT] from the Related Menu.
    10. Select Document History [FOIDOCH] from the Related Menu to see the history for a particular document.
    11. Type [control q] to return to the Banner Welcome page.

    Back to Top
  • Creating a Purchase Order FPAPURR (Part 1)

    Note: Certain users (primarily from the Purchasing Department) will use FPAPURR after completing the process of assigning requisition line items to purchase order numbers using FPAPOAS, primarily for Blanket and Subaward purchase orders.

    Banner Tip: Purchase order numbers are of the form Pxxxxxxx where P is the only letter. Often a leading zero can be mistaken for an o. Beware!

    Document Information

    1. Type FPAPURR in the Banner Welcome page.
    2. In FPAPURR, you will see the cursor in PURCHASE ORDER field. To begin a new PO, type <return> and NEXT will default. If you are working on an incomplete PO#, enter the PO# and skip to step 3.
    3. Type [alt pagedown] Next Block to the Document Information block. The BLANKET ORDER field is not used and should remain blank.
    4. The cursor will appear in the ORDER TYPE field, and defaults to Regular. Do not change the default value.
      IMPORTANT: The DOCUMENT LEVEL ACCOUNTING checkbox in the upper right corner of the page should be left alone until you reach Commodity / Accounting Step 7 below.

      View Image



    5. <TAB> to ORDER DATE. Defaults to current date, but date may be overridden (dd-mmm-yyyy).
    6. <TAB> to TRANSACTION DATE. Defaults to current date, but date may be overridden (dd-mmm-yyyy).
    7. <TAB> to DELIVERY DATE. Enter a date at least one day greater than TRANSACTION DATE (dd-mmm-yyyy).
    8. <TAB> to COMMENTS. May be entered directly. The 30 character comments field contains information to assist the buyer.
    9. <TAB> to BUYER. Enter your Buyer Code . Click on Filter or use [F9] List function to locate a buyer code and assign PO to a buyer.
    10. Type [alt pagedown] Next Block to go to the Purchase Order Entry: Requester/Delivery Information block.

    Requester/Delivery Information

    1. You will see the cursor in the REQUESTER field. This will default from your Banner userid. (Alternately, you can enter the name of the person requesting the purchase, if different than default. You will then need to enter the alternate requester's Org, Email, Phone and Fax information by tabbing to each field. See below for specific steps.)
    2. <TAB> to CHART OF ACCOUNTS (COA). This field will default to COA# X. Do NOT change or delete this value.

      View Image



    3. <TAB> to ORGANIZATION. Enter Organization# if different than default. If unknown, query the organization file: Click on the Search icon or type [F9] List Field Values and retrieve your Organization#.
    4. <TAB> to EMAIL. Enter requester’s email address if different than default. Optional field.
    5. <TAB> to PHONE. Enter requester’s phone number if different than default. Optional field.
    6. <TAB> to FAX. Enter requester’s fax number if different than default. Optional field.
    7. <TAB> to SHIP TO. “Ship To” address and phone information defaults from requisition. Enter a different Ship-To Code, as appropriate, or query for one by clicking on the Search icon or typing [F9] List of Values and following the filter process. PO needs to reference the address where the vendor will ship the merchandise. Whatever is in this field will print on the PO, beginning with the 1st address line, with a total of five lines, including the ATTENTION TO field contents.
    8. <TAB> to ATTENTION TO. Defaults from Ship-To Code. If no default, enter name of contact person for delivery. Required field. This field typically prints on the PO. Enter a [.] if no printout is desired.
    9. Type [alt pagedown] Next Block to go to the Purchase Order Entry: Vendor Information block.
    ​​​
    Back to Top
  • Creating a Purchase Order FPAPURR (Part 2)

    Vendor

    1. You will see the cursor in the VENDOR field. This field will be blank. You MUST enter a vendor to continue with the PO. Either enter Vendor ID# or query the vendor file: Type [F9] List of Values and retrieve your vendor.
    2. Once a vendor has been chosen, the address will default. Check the address for accuracy. The Address Type field's Search icon may be used if a different address is needed. Clicking the Search icon or typing [F9] List of Values takes users to the Address Information Query Form: FOQADDR. Double click on the Address Type field of the address needed to return to FPAPURR.
    3. <TAB> to Contact field. If no default value, enter the name of a vendor contact person. Optional field. The contact name will print on the PO if space allows (a total of 5 lines print on the PO.)
    4. <TAB> to Email. Enter email information associated with contact person. Optional field.
    5. <TAB> to DISCOUNT CODE. Accept default or click on Filter or use [F9] List function to choose a different code.
    6. Cursor appears in FOB CODE field. FOBs alert A/P to freight invoices. Change the code as needed. You can use [F9] List or click on the FOB search icon to see possible codes.
    7. <TAB> to TAX GROUP. Will default to CRUZ tax rate. If changed, all commodities will have changed tax rates. (If this field value is changed after commodities are entered, you must tab through the commodity fields to update the tax code and tax amounts.)
    8. <TAB> past Disbursing Agent checkbox.
    9. <TAB> to CLASS CODE. This is an optional field.
    10. <TAB> to CARRIER. This is an optional field.
    11. <TAB> to Currency. This is an optional field.​

      View Image



    Text Entry: FOAPOXT

    Use Document text to add your name, department, contact information and additional information, including clauses, schedules, delivery contact information, etc. to your Purchase Order.

    1. From FPAPURR, select Document Text [FOAPOXT] from the Related Menu. The system will go to FOAPOXT: Procurement Text Entry Form. Document text entered here will print before the first line item of your requisition.
      Tip: All lines in the FOAPOXT text screen must have line numbers. If you want blank lines, you must enter line numbers for them. Type <TAB> Next Field until you get to the LINE field and enter a sequential line number.

      View Image



    2. Entering Text: Begin typing your message. Use <down arrow> Next Record or click on subsequent lines to add more text. (Navigation and editing with the mouse behave much like they do in word processing programs, except that no wrapping occurs. Users may click directly in the field where they wish to enter data.)
    3. You can insert lines of text between existing lines by entering the text, tabbing to the line field, and entering a number that places the text where you want it sequentially relative to the line numbers already defined. To insert a blank line, arrow down to a new line, tab to the LINE field and enter a number that places your blank line in the position you desire relative to the already-defined line numbers. To change the order of lines of text, tab to the line field and change the number of the line so it will be in the desired sequence. Type [F10] Save or click on the Save icon to save your text.
    4. To add a clause that is modifiable, key [F5] or click on the Start Over button. The cursor will appear in the CLAUSE field. Type [F9] List Field Values and choose appropriate clauses as needed. Type [F6] Insert Record to add the clause to your document text. Then modify the clause as needed.
    5. To insert a non-modifiable clause that will appear on the printed PO but will not appear in FOAPOXT, <TAB> Next Field to the CLAUSE field and type [F9] List Field Values and choose appropriate clauses as needed. Type [alt s] to add the clause to your document text.
      Note: If there are clauses that you use regularly and want to have available to you in Banner, contact Purchasing and they can create them for you.
    6. Each time you add text and click the Save button, the record count in the status line gets updated. From FOAPOXT, to delete a line of text you have saved but no longer want, click the Delete button while the cursor is in that line of text. When you exit via [control q], Banner asks if you want to save the changes you have made. Click on Yes to save and return to FPAPURR. Banner places a check in the Document Text field (in the top right corner).
    7. From FPAPURR, you can review your Purchase Order text by selecting Document Text [FOAPOXT] from the Related Menu. Type [control q] to exit FOAPOXT and return to FPAPURR.
    8. Type [alt page down] Next Block to go to the Purchase Order Entry: Commodity/Accounting block.

    Back to Top
  • Creating a Purchase Order FPAPURR (Part 3)

    Commodity/Accounting

    1. Cursor appears in COMMODITY field. Leave blank if not using a UCSC-defined commodity. If using UCSC-defined commodity, enter Commodity Code (use [F9] List of Values to see possible codes).
    2. <TAB> to the DESCRIPTION field. If a Commodity Code was used, associated description will default.This description can be over-written. If no default entry, enter a detailed description of item, starting with a descriptive noun. You may include catalog #. Use at most 50 characters. Additional information may be added as Line Item Text (see Step 11 below.)
    3. <TAB> to U/M. Enter Unit of Measure code. Type [F9] List of Values to look up and retrieve your unit of measure.
    4. <TAB> to TAX GROUP. Defaults to CRUZ tax rate. Overwrite as necessary. To search, click on the Filter icon or enter F9. Highlight your selection and click OK or double-click on your selection.
    5. <TAB> to QUANTITY. Enter number of items desired. The QUANTITY field is not available on standing orders.
    6. <TAB> to UNIT PRICE. Enter price per unit. Decimal only required for cents.

      View Image



    7. DOCUMENT LEVEL ACCOUNTING box, located in upper right portion of Commodity Block, is checked as default. To create a COMMODITY LEVEL PURCHASE ORDER, uncheck this box, which will assign accounting records to specific commodities.
    8. <TAB> to ADDITIONAL. Enter any additional charges. Zero defaults if you add no amount here.
    9. To add text about a commodity (aka item), select Item Text [FOAPOXT] from the Related Menu. The system will go to FOAPOXT: Procurement Text Entry. If you are ordering inventorial equipment, this is where you can add more detail to your commodity description.
      After adding text, click on the Save icon. System will send message “Transaction complete — record added and saved.” (For text entry directions, see Text Entry: FOAPOXT, step 16 i-vi.) Type [control q] Exit Screen to exit FOAPOXT and return to FPAPURR. The system will check the Item Text checkbox for this commodity.
      Note: Commodities Text is unused, so ignore the Commodity Text option.
    10. To add additional commodities, type [down arrow] Next Record to move to an another commodity record and repeat steps 1 through 11 above. The ITEM field specifies how many commodities are on this PO, and specifies which commodity you are currently viewing.
    11. Type [alt page down] Next Block to go to the Accounting block (FOAPAL).

    Accounting Block

    Important: If the Suspense field is checked by Banner, check your information for accuracy. You may select View Items in Suspense from the Related menu to find out what part of the PO caused the suspense condition. Tab through the fields of that item or FOAPAL sequentially and Banner will typically reset the suspense flag.

    1. Cursor appears in the COA field. Accept default.
    2. <TAB>. Fiscal Year Code FY will default, and cursor will move to INDEX. Leave blank.
    3. <TAB> to FUND. Enter a Fund code or type [F9] List Field Values to lookup and retrieve your Fund code.
    4. <TAB> to ORGN. Defaults from header block. (Can be over-written with different org codes.)
    5. <TAB> to ACCT. Enter an account code or type [F9] List Field Values to lookup and retrieve your account code.
    6. <TAB> to PROG. Defaults from the Organization Code.
    7. <TAB> to ACTV. Field is optional. If desired, enter activity code or type [F9] List Field Values to lookup and retrieve your activity code.
    8. <TAB> to LOCN. The Location Code field is only used by Plant Accounting and Physical Planning & Construction in conjunction with Plant Funds to denote the building for which the corresponding transaction is being posted. All other users should always leave this field blank.
    9. <TAB> to PROJ. This field is currently not used at UCSC. Leave blank.
    10. <TAB> to EXTENDED field (%). Leave blank for 100% of the amount to be applied to this FOAPAL. If you provide more than one FOAPAL, you must specify the division that is appropriate by specifying either percentages or dollar amounts.
      To specify percentages, click on the EXTENDED (%) checkbox.
      To specify dollar amounts, leave the EXTENDED (%) box unchecked.
      Remember, when DOCUMENT LEVEL ACCOUNTING is checked, the distribution you supply applies to all commodities combined.
    11. <TAB> to USD AMOUNT. (NOTE: If EXTENDED (%) is checked, cursor will automatically move to USD AMOUNT field.) Fill in either a percentage (if you checked the EXTENDED (%) checkbox in step 10), or else enter the dollar amount to be associated with this FOAPAL.
    12. If the PO is to be split over 2 or more FOAPALs, type <down arrow> to move to next ACCOUNTING DATA record. Proceed with steps 1-11 above.
      Note: If the cost of the commodities is shared among multiple FOAPALs, then Banner checks the Distribute checkbox located in the Commodity block after the FOAPALs are entered.
    13. If you change the $ amount(s) for commodities after you have entered your commodities and FOAPALs, the default is for Banner to distribute the new $ amounts as defined when the FOAPALs were entered.
      To manually distribute changes in the $ amounts for commodities, uncheck the Distribute option by clicking on the Distribute checkbox. Then go to the FOAPAL block and make changes to the amount(s) as appropriate. The REMAINING COMMODITY AMOUNT field in the FOAPAL block specifies the $ amount that needs to be distributed.
      Tip: Tax will be calculated on every account sequence by the percentage specified. (Banner calculates the percentages if you specify amounts.)
      Note: From anywhere in the accounting data block (FOAPAL), you can review a summary screen of the account sequences by selecting Review Accounting Information (FOICACT) from the Related menu. System will jump to FOICACT: Commodities and Accounting for Review Query Form. After you complete your review, type [control q] to exit FOICACT and return to FPAPURR.
    14. Once you have completed your accounting distribution, type [alt page down] Next Block to move to the Balancing/Completion block.

    Balancing/Completion

    1. Click on the Complete button if your Purchase Order Form is complete and you want it to go to posting/approvals. Otherwise, click on the In Process button to save your changes. The form will roll back to the FPAPURR entry page, permitting you to open an existing In Process Purchase Order or to create a new PO if desired, by following steps beginning with Document Information Step 2 above.
    2. Type [control q] to exit FPAPURR and return to the Banner Welcome page. 

      View Image



    Back to Top
  • Copying a Purchase Order

    Important: The PO to be copied must be completed and posted.

    1. Type FPAPURR in the Banner Welcome page.​
    2. You will see the cursor in the PURCHASE ORDER field. <TAB> to the Copy icon. The word NEXT will default into the Purchase Order field.
    3. Click on the Copy icon or press your Space Bar. A Copy dialog will appear. Enter the Purchase Order Number for the PO to be copied. <TAB> and the vendor info defaults from the PO specified. Click on OK.

      View Image



    4. Banner will assign a PO number and will copy the data from the PO you specified. You may then edit the fields as you would for any new purchase order.

    Back to Top
  • Canceling a Purchase Order FPAPDEL

    ​Use this process to cancel a Purchase Order that has been created, completed, and approved.
    Note: Cancelation differs from deletion. A canceled PO remains as a permanent record in the FIS database. However, you can delete any PO BEFORE it is completed by typing [shift F6] Delete Record twice. A deleted PO is completely removed from the FIS database.
    Important: You cannot cancel a purchase order that has an activity associated with it, such as a Change Order, Receiver, or Payment. You must cancel Change Orders before canceling Purchase Orders. Activity associated with a document can be viewed using FOIDOCH. See Reviewing Document History .

    1. Type FPAPDEL in the Banner Welcome page.
    2. You will see the cursor in the Purchase Order field. Enter the purchase order number that you need to cancel.
    3. Type [alt page down] Next Block to view vendor information and dollar amounts for the PO.

      View Image



    4. Type [alt page down] Next Block, select Access Cancel Date from the Related Menu and click on the Cancel Date tab. The Cancel Date will default to today’s date.

      View Image



    5. Accept the Cancel Date, or change if necessary. Reason code is not required. If you wish to add additional text to the Purchase Order's existing document text to explain the cancellation, select Document Text [FOAPOXT] from the Related Menu. After entering text, click on the Save icon to save your text. Type [control q]​ to​ exit FOAPOXT and return to FPAPDEL.
    6. To process the cancellation, click on the Make Cancellation Permanent button, or Right Click - Process Cancellation.
    7. Type [control q] to return to the Banner Welcome page.

    Back to Top
  • Querying Purchase Orders FPIPURR

    Use this process to query a completed and approved purchase order, and any change orders that have been processed:

    1. Type FPIPURR in the Banner Welcome page.​
    2. You will see the cursor in the Purchase Order field. Enter the purchase order number (including the P).
    3. <TAB> to CHANGE SEQUENCE NUMBER field. If you are querying a purchase order that has no change orders against it, leave this field blank. If you wish to view the resultant purchase order including any change orders against it, leave this field blank. If you wish to view only those changes made on a particular change order, enter the sequence number of the change order (i.e. 1). This will select only those items which have been changed on change order #1, and the TOTAL AMOUNT field will reflect the net amount of the change (which may be negative if the commodity amount was decreased), not the entire purchase order total. If you have entered changes to a purchase order, but would like to see the original purchase order only, type 0 in this field.
    4. Type [alt pagedown] Next Block to view the purchase order Document Information. Note that completion and approval status are reflected here.
    5. If the DOCUMENT TEXT checkbox contains a check, you can review your Purchase Order text by selecting Document Text [FOAPOXT] from the Related Menu. To exit FOAPOXT and return to FPIPURR, type [control q]. 

      View Image



    6. Type [alt pagedown] Next Block to view Requester/Delivery data.

      View Image



    7. Type [alt pagedown] Next Block to view Vendor data.

      View Image



    8. Type [alt pagedown] Next Block to view Commodity/Accounting data. Commodity level funding is active if the Document Accounting checkbox is blank. See Document Level versus Commodity Level Accounting. For commodity level funding, if the Item Count total is greater than 1, you can use the arrow keys to view accounting records for each commodity.

      View Image



    9. If the ITEM TEXT checkbox contains a check, you can review your Item text by selecting ItemText [FOAPOXT] from the Related Menu. To exit FOAPOXT and return to FPIPURR, type [control q].
    10. After viewing commodities, type [alt pagedown] Next Block to view Accounting Data. If the FOAPAL count is greater than 1, you can use the arrow keys to view each additional accounting record.
    11. From the FOAPAL block, to view accounting records by commodity, select Review Accounting Information [FOICACT] from the Related Menu. After you complete your review, type [control q] to return to FPIPURR.​
    12. Type [alt pagedown] Next Block to return to FPIPURR’s Document Information screen. Type [control q] ​to exit FPIPURR and return to the Banner Welcome page.​​​

    ​​​


    Back to Top
  • Locating Open Purchase Orders FPIOPOF, FPIOPOV, FPIOPOB

    ​Purchase Order numbers can be found using three filter pages in Banner:

    • FPIOPOF – Open Purchase Orders By FOAPAL
    • FPIOPOV – Open Purchase Orders By Vendor
    • FPIOPOB– Open Purchase Orders By Buyer

    An open purchase order is a PO which has not been liquidated by an invoice.

    FPIOPOF
    Open Purchase Orders By FOAPAL

    1. Type FPIOPOF in the Banner Welcome page.
    2. You will see the cursor in the INDEX field. <TAB> Next Field to the FUND field and enter your Fund code. To filter for Fund codes, type [F9] List.
    3. Add any other search limitations such as ORGN, ACCT, PROG, or ACTIVITY by typing <TAB> Next Field to the appropriate field and entering the code.
    4. Type [alt page down] Next Block.
    5. You may scroll through the records by using <up arrow>/<down arrow> up/down arrow keys.
    6. If you want to see a summary of all commodities for a particular PO, select View Commodities [FOICOMM] from the Related Menu. The system will go to FOICOMM: View Commodities page.
    7. To return from FOICOMM to FPIOPOF, type [control q].
    8. To filter again, click on the Start Over button.
    9. Type [control q] to​ exit​ FPIOPOF and return to the Banner Welcome page.

      View Image



    FPIOPOV
    Open Purchase Orders By Vendor

    1. Type FPIOPOV in the Banner Welcome page.
    2. You will see the cursor in the VENDOR Field. Enter vendor code. To filter for vendor codes, type [F9] List of Values.
    3. <TAB> to the Status buttons. PO STATUS defaults to Open. Change if necessary.
    4. <TAB> to Fiscal Year field. Current Fiscal Year will default.
    5. <TAB> to COA field. Default value X will appear. Do not change this value.
    6. <TAB> to Organization field. LEAVE THIS FIELD BLANK. You currently cannot search for open POs by Organization Code in FPIOPOV.
    7. Type [alt pagedown] Next Block. Your query results, if any, will appear.

      View Image



      NOTE: Occasionally, querying a heavily-used vendor (Apple Computer, Fisher Scientific, etc) in FPIOPOV will cause the page to work incorrectly. A message may appear:

      FRM-40106: No navigable items in destination block.

      If you encounter this situation in FPIOPOV, do the following:
      1. Click OK on the "FRM-40106: No navigable items" window.
      2. After the window closes, several buttons will appear on a blank screen. Do not click on any of the buttons.
      3. Click on the Start Over button icon.
      4. Re-run your original query per steps 2-7 above.
        Typically, re-running FPIOPOV after encountering this error will produce successful query results.
    8. You may scroll through the records by using <up arrow>/<down arrow> up/down arrow keys.
    9. If you want to see the detail for a particular PO, type [F9] List Values. The system will jump to FPIPURR. In FPIPURR, type [alt page down] Next Block to view info about the PO.
    10. To return from FPIPURR to FPIOPOV, type [control q] .
    11. If you want to see commodity information from the selected PO, select View Commodities [FOICOMM] from the Related Menu. The system will go to FOICOMM: View Commodities.
    12. To return from FOICOMM to FPIOPOV, type [control q].
    13. From FPIOPOV, to enter a new filter, click on the Start Over button.
      NOTE: The COA value X is not maintained when you start over after a previous filter. You must re-enter the COA value after every start over. If you try to filter without the COA value X, your filter will result in no records returned.
    14. Type [control q] to exit FPIOPOV and return to the Banner Welcome page.

    FPIOPOB
    Open Purchase Orders By Buyer and Status

    1. Type FPIOPOB in the Banner Welcome page.​
    2. You will see the cursor in the BUYER Field. Enter Buyer code. [F9] List Field Values is available.
    3. Type [alt pagedown] Next Block.
    4. You may scroll through the records by using <up arrow>/<down arrow> up/down arrow keys or page up/page down, or you may perform a search for a specific PO.
    5. If you want to see the detail for a particular PO, type [F9] List Values or select Query Purchase Order Information [FPIPURR] from the Related Menu. The system will jump to FPIPURR. In FPIPURR, type [alt pagedown] Next Record to view info about the PO.
    6. To return from FPIPURR to FPIOPOB, type [control q].
    7. If you want to see commodity information from the selected PO, select View Commodities [FOICOMM] from the Related Menu. The system will go to FOICOMM: View Commodities.
    8. To return from FOICOMM to FPIOPOB, type [control q].
    9. From FPIOPOB, to enter a new PO query, click on the Start Over button and repeat the above steps.​
    10. Type [control q] to exit FPIOPOB and return to the Banner Welcome page.

      View Image




    Back to Top
  • Printing a Purchase Order FPAPORD

    Note: Certain users (primarily from the Purchasing Department) will use FPAPORD to print specific purchase orders or change orders directly from Banner FIS. All other POs will be printed directly from the CruzBuy system.

    1. Type FPAPORD in the Banner Welcome page. Banner will route you to GJAPCTL Process Parameter Entry Form where you can specify what PO you want to print. GJAPCTL is sometimes referred to as the job submission form.
    2. You will see the cursor in the PROCESS field. FPAPORD defaults.
    3. Type [alt pagedown] Next Block. You will see the cursor in the PRINTER field. You can type [F9] List of Values to access your office's printer code, or you may type your printer code directly. You can have your printer code default into GJAPCTL, FPAPORD, or any other Job Submission form by sending an email request to fis_probs@ucsc.edu.
    4. Once you select the printer, the SPECIAL PRINT field defaults to purchorder. Do not change. The Lines and Submit Time fields should remain blank.
    5. Type [alt pagedown] Next Block to specify your Parameter Values. Cursor will first appear in Number Field 01. Do not change or delete.
    6. <TAB> Next Field to the VALUES field and type the number of the purchase order you want to print.
    7. Type <down arrow> Next Record, to the Buyer Code block and then go to the VALUES field for Buyers. Always specify the buyer code associated with the PO you want to print.
    8. Type <down arrow> Next Record to go to the STATUS field. Accept the default of C to print the current purchase order. Alternatively, you can specify O (the letter) to print a copy of the original purchase order when you have created change orders against a purchase.
    9. Type <down arrow> Next Record to go to the Purchase Order Print Option field. Accept the default of B to print the current purchase order.
    10. Type <down arrow> Next Record to go to the Include E-Procurement POs? field. Accept the default of Y to print the current purchase order.
    11. Type [alt pagedown] Next Block to the Submission Block. Defaults to Submit. Type [F10] Commit or click the Save button to submit your job to the specified printer.
    12. When you have printed all jobs you need to print at this time, type [control q]​ to return to the Banner Welcome page.

      View Image



      Note: If your PO is not completed or approved, you will see a DRAFT watermark superimposed across each page. If your PO is closed, you will see a CLOSED watermark superimposed across each page.




    Back to Top
  • Receiving Goods FPARCVD

    Use the process described below to receive and receipt materials purchased.

    1. The recipient confirms that the delivery address is correct.
    2. The recipient verifies that the number of items delivered is the same number of items as listed on the carrier’s paperwork.
      • If there is visible damage on a package
        Either refuse delivery of the package or note the condition of the package in writing on the carrier’s paperwork.
    3. The recipient signs the carrier’s delivery paperwork.
    4. Remove the packing slip and verify that the package contents match the packing list.
      • If items are damaged inside a damaged package
        Note damage on the packing list, notify the carrier of damaged goods, and request an inspection report. Save all packing materials and boxes.
        Note: For damaged goods: An inspector will check packaging, write a report, and recommend reimbursement of costs if it is clear that the carrier is at fault. The carrier may choose not to send out an inspector, but will obtain information on the cost of the damaged goods and issue a refund check for the cost of the goods.
      • If items are damaged inside an intact package
        If packing list has already been entered on-line, contact your buyer and inform her/him of the damage, otherwise, note the damaged items on the packing list. The buyer contacts the vendor and makes arrangements to return item(s) and/or receive replacement item(s).
    5. Sign and date the packing list acknowledging receipt of items.

    Receiving Items On-Line FPARCVD

    1. Type FPARCVD in the Banner Welcome page.
    2. You will see the cursor in the RECEIVER DOCUMENT CODE field. Type 'NEXT' in the field, or to resume work on an uncompleted receiver, enter the receiver number.
    3. Type [alt pagedown] Next Block to go to the Receiving Header block. You will see the cursor in the RECEIVING METHOD field. This field describes the method by which the goods came to campus, e.g. U.S. Mail, FEDEX, UPS, etc. Either type the appropriate code or type [F9] List (see Query Techniques)and select a receiving method. This field is optional.
    4. <TAB> Next Field to the CARRIER field. Enter your carrier code (e.g. @00000029 for Air-Sea Forwarders.) Either type the appropriate code, click on the arrow icon, or type [F9] List. This field is optional
    5. <TAB> Next Field to DATE RECEIVED field. Today’s date will default.
    6. To enter header text, select View Receiving Text [FOATEXT] from the Related Menu. The system will go to FOATEXT General Text Entry. Include your name, phone #, and any text messages. Refer to Text Entry: FOATEXT to view detailed instructions for entering text in Banner. After entering text in FOATEXT, type [F10] Save. Then type [control q] to return to FPARCVD.
    7. Type [alt pagedown] Next Block to go to the Packing Slip block.
    8. You MUST enter the Packing Slip number in the PACKING SLIP field.
    9. <TAB> Next Field to BILL OF LADING field and enter a number, if desired. This field is optional.
    10. Type [alt pagedown] Next Block to the Purchase Order block to add the PO number.

      View Image



    11. After the PO number is added, BUYER and VENDOR field values will be added from the PO.
    12. If you need to review PO information, key [shift-F2], and the system will go to FPIPURR Purchase/Blanket/Change Order Query, where you can peruse the information on your PO.  Type [control q] to return to FPARCVD Receiving Goods.
    13. You can select ALL PO items by opening the Tools Menu and selecting Receive All Purchase Order Items.
      Or
      You can select SPECIFIC Purchase Order items by opening the Tools Menu and selecting Select Purchase Order Items [FPCRCVP]. The system will jump to FPCRCVP Receiving Goods PO Item Selection. You can select all items on the PO by typing [spacebar] or clicking in the Receive All field. Alternatively, type [alt pagedown] Next Block and then choose individual item(s) being received by typing [spacebar] or clicking in the ADD ITEM field for that commodity. Type [control q] Exit to return to FPARCVD. You will be prompted to save your changes.

      View Image



    14. Back in FPARCVD, type [alt pagedown] Next Block to the Commodity block.
    15. <TAB> Next Field through fields to the QUANTITY RECEIVED CURRENT field and enter the quantity received.

      View Image



    16. Type [alt pagedown] Next Block and click on the Complete button to complete the document.

    If a damaged item(s) was received

    Important: Only use this procedure to reject an item at the time of receipt.

    1. Begin with steps 1-14 above.
    2. To reject a damaged item at the time of delivery, include the damaged item(s) in the QUANTITY RECEIVED CURRENT field. Then, in the QUANTITY REJECTED field, enter the number of items that were damaged. This will ensure that the invoice for the damaged items will not be paid.
    3. Click on the Receiving Text option and enter your notes about the damaged item being received, explaining why it is being rejected.
    4. Use the arrow keys to move through records, to record every line item being rejected.
    5. Type [alt pagedown] Next Block and click on the Complete button to complete the document.

    Receiving Inventorial Items

    1. Either confirm that the serial number on the equipment matches the packing list serial number or add the equipment serial number to the packing list.
    2. Record the PO number from the packing list or address label.
    3. Forward the packing list to the Department/Division.
    4. Complete the procedure for Receiving Items On-Line, FPARCVD, above, with the following addition: while in the Receiving header block, go to the Related Menu and click on View Receiving Text [FOATEXT] and enter the serial number for each inventorial item being received.
      Note: Complete a Property Tag Follow-up Form and mail to Equipment Administration. Tags will then be mailed to the person specified on the form.

    To correct a Receiver completed in error
    Important: Receivers may not be cancelled or deleted once they are completed. You will need to adjust items by creating a new receiver.
    Complete steps 1-11 of Receiving Items On-Line FPARCVD above. Then continue with the steps described below.

    1. Choose to ADJUST ITEMS by either clicking on the field with the mouse or by typing [spacebar] while in the field.
    2. You can select ALL PO items by opening the Tools Menu and selecting Receive All Purchase Order Items.
      Or
      You can select SPECIFIC Purchase Order items by opening the Tools Menu and selecting Select Purchase Order Items [FPCRCVP]. The system will jump to FPCRCVP Receiving Goods PO Item Selection. You can select all items on the PO by typing [spacebar] or clicking in the Receive All field. Alternatively, type [alt pagedown] Next Block and then choose individual item(s) being received by typing [spacebar] or clicking in the ADD ITEM field for that commodity. Type [control q] Exit to return toFPARCVD. You will be prompted to save your changes.
    3. Type [alt pagedown] Next Block to the Commodity block.
    4. <TAB> Next Field through fields to the QUANTITY RECEIVED ADJUSTMENT field and enter a negative adjustment to reduce the quantity received to date.
    5. Type [alt pagedown] Next Block and click on the Complete button to complete the document.
    ​​​
    Back to Top
  • Returning Goods FPARTRN

    Use the process described below to return goods that are damaged or incorrect or that have been ordered in error, to the vendor.

    • The buyer contacts the vendor to arrange for the return of goods and to obtain a Return Authorization number.
    • The buyer, or another designated person in the Department/Division, completes a shipping memo that specifies either the shipping address for the return or states that the item is to be held for pickup. Refer to the Return Authorization number on the shipping memo.
      Important: If the item is to be shipped back to the vendor, it must be properly packaged. Include a copy of the shipping memo.
      Important: If the item you are returning has been invoiced, the invoice must be cancelled prior to completing the return. Alternatively, a credit memo can be issued.
    • If your unit handles their own shipping, arrange for the item and the shipping memo to get to the proper location.
      OR
    • When the vendor’s designated carrier picks up the item, obtain the driver’s signature on your copy of the shipping memo to document the transaction.

    1. Type FPARTRN in the Banner Welcome page.
    2. Type NEXT in the RETURN CODE field and type <TAB> Next Field.
    3. Enter your Purchase Order Number in the PURCHASE ORDER CODE field.
    4. Type [alt pagedown] Next Block. VENDOR information defaults from PO. You may only change the address if the address you are using exists in the Banner address table for this vendor. You use this form to document the return. It is NOT a shipping document, so the address need not accurately reflect the vendor’s address for the return shipment.
    5. Cursor is in the CARRIER field. This is an optional field. You may enter the name of the carrier who will be performing the shipment. You can use [F9] List function to access FTVCARR Carrier List Form and type [F10] Save when you find your carrier in the list.
    6. <TAB> through the ADDRESS TYPE and SEQUENCE NUMBER fields.
    7. If you are shipping the item(s) back via common carrier, <TAB> Next Field to BILL OF LADING field and enter your Bill of Lading number. Otherwise leave this optional field empty.

      View Image



    8. To enter header text, select [FOATEXT] from the Related Menu. The system will go to FOATEXT General Text Entry. Include your name, phone #, and any text messages. Refer to Text Entry: FOATEXT to view detailed instructions for entering text in Banner. After entering text in FOATEXT, type [F10] Save. Then type [control q] to return to FPARTRN.​
    9. To go to the Commodity Block, open the Tools Menu and select Returned Goods Information.
    10. Enter the PO Line Item Number in ITEM field, then <TAB> Next Field. The description will default from the PO, as will the quantity that has been received, rejected, or returned to date.
    11. <TAB> Next Field to the REASON field. Type [F9] List to lookup and retrieve your Reason Code. Highlight the correct Reason Code and click OK or hit the Return key.
    12. Enter the QUANTITY RETURNED.
    13. If you are returning more than one commodity, use the arrow down key to a new record to enter the next line item number.

      View Image



    14. Type [F10] Save. A 'Saved Successfully' notification will appear. Make note of the Return Code document number, which can be reviewed in FOIDOCH as Doc Type RTN. Type [control q] to complete the Return transaction and return to the Banner Welcome page.

    Back to Top
  • Receiver Queries FPIRCVD

    ​You can query on FPIRCVD Receiving Goods Query Form. The information you have provided on the FPARTRN Return Goods/Receiving Adjustment Form will be reflected in the counts provided.

    1. Type FPIRCVD in the Banner Welcome page.​ Enter your RECEIVER DOCUMENT CODE and type [alt pagedown] Next Block to view your receiver data. If you see a 'Y' in the Text Exists box of the Receiver Information or Packing Slip block, do the following to view the text:
      Go to the Related Menu and select Receiver Text [FOATEXT] or Packing Slip Text [FOATEXT].

      View Image



    2. To view Commodity Information, type [alt pagedown] twice, or open the Tools Menu and select Commodity Information.​
    3. Here you can view what commodities have been received, returned or rejected. If there are multiple commodities, use the scroll bar or the down arrow to view them.

      View Image



    4. Type [control q] to return to the Banner Welcome page.

    Back to Top
  • Canceling FPARTRN (Returned Goods Form)

    ​Use the process described below to cancel Returned Goods Forms that have been created in error:

    If you accidentally create extra Return Goods Forms you can delete the record and start again.

    1. Type FOIDOCH in the Banner Welcome page.​
    2. You will see the cursor in the DOCUMENT TYPE field. Enter PO for purchase order.
    3. <TAB> to the DOCUMENT CODE field and enter the PO number.
    4. Type [alt pagedown] Next Block. Documents associated with the PO you specify will be listed. Record the Returns Code (typically T000...').

      View Image



      Note: To review information on the original receiver, highlight the Receiving Documents record and select Query Document [BY TYPE] from the Related Menu. Receiver information [FPIRCVD] will display. See Receiver Queries.
    5. After viewing the PO History in FOIDOCH, type [control q] to return to the Banner Welcome page.
    6. Type FPARTRN in the Banner Welcome page.
    7. In FPARTRN you will see the cursor in the RETURN CODE field. Enter the Return Code you recorded in step 4. Key <TAB> and the purchase order number will be filled in by Banner.
    8. Type [alt pagedown] Next Block.
    9. Type [alt pagedown] Next Block again. The Returned Goods section will display.
    10. Type [shift F6] twice to delete all the information in the records you wish to delete. Type [F10] Save. A notification will display indicating the number of records deleted.
    11. You can repeat the process with any other Returned Goods records that you want to cancel by repeating the steps defined above.
    12. Type [control q] to return to the Banner Welcome page.

    Back to Top
  • Processing a Change Order FPACHAR (Part 1)

    Use this process to change a completed and approved purchase order — adding items, deleting items, or changing the line item cost, description, or quantity:

    Note: All Change Order Requests must originate via the CruzBuy system, regardless of PO origin (exceptions include departments currently not using CruzBuy).

    1. Type FPAPCHAR in the Banner Welcome page.​
    2. Enter the number of the purchase order you need to change.
    3. <TAB> Next Field to CHANGE SEQUENCE NUMBER field and enter NEXT. If you have already started a change order, and it has not been completed, you will need to enter that sequence number. NEXT will only work when you are starting a new change order and all earlier change orders for this PO have already been completed, approved and posted.
    4. Type [alt pagedown] Next Block.
    5. In FPACHAR, in the Change Order: Document Information block, you can change any information except the Purchase Order Type (Regular or Standing).
      Note: Origin field will say EPROCUREMENT for POs initiated via CruzBuy and Banner for POs initiared in FIS Banner. The Reference Number field only populates for CruzBuy POs and shows the draft CruzBuy PO number before it validates in FIS Banner.

      View Image



    6. Type [alt pagedown] Next Block to navigate to the Requester/Delivery Information screen. Change field values as needed.

      View Image



    7. When any changes have been completed, type [alt pagedown] Next Block to go to Change Order: Vendor.
    8. You can change any information except the vendor name. <TAB> Next Field to navigate through the Vendor Information, changing field values as needed.

      View Image



    9. When any changes have been completed, type [alt pagedown] Next Block and the system takes you to Purchase Order Item Selection Form: FPQCHAP, where current line items for the PO are listed.

      View Image



    10. In FPQCHAP, the cursor is in the CHANGE ALL field. Type space bar or click on the field to choose to change all PO items for this change order.

      Important: Only choose CHANGE ALL the first time in FPQCHAP for a specific change order. If you need to return to FPQCHAP to select additional items, do not activate the CHANGE ALL field. Type [alt pagedown] Next Block and add individual items to the change order, as described in step 10 below.

    11. To change only selected PO items on this change order, type [alt pagedown] Next Block and <TAB> to the ADD field and select the specific line items to be changed by typing <SPACEBAR> or clicking with the mouse. To navigate between records use the arrow keys.
    12. Type [F10] Save to save your changes.
    13. Type [control q] Exit Screen to return to FPACHAR. You may be asked if you want to save your changes. Click on yes. You may receive a message stating how many records have been saved.
    14. Back in FPACHAR, if you need to select additional commodity items from the PO for your change order, select Change Order Item Selection [FPQCHAP] from the Related Menu, where remaining line items (if any) for the PO are listed. Select items as described in steps 10-12 above.

      Important: Do not use the CHANGE ALL option on a second pass in FPQCHAP. Type [alt pagedown] Next Block and <TAB> to the Add field for the specific line item to be added to the change order.

    15. Back in FPACHAR in the Change Order: Commodity/Accounting block, <TAB> Next Field to navigate through the Commodity Information, changing field values as appropriate. For POs with multiple commodities, use the arrow keys to navigate through the records, making your changes. You may add and edit Line Item text by selecting Item Text [FOAPOXT] from the Related Menu for any commodity.

      View Image



    16. When any changes, additions and deletions have been made to the commodities, type [alt pagedown] Next Block to go to Change Order: Commodity/Accounting [FOAPAL]. Banner will automatically make changes to the Accounting sequences as specified in the percentage split on the original purchase order. Even if amounts were entered as dollar amounts, Banner will calculate the percentages for each accounting sequence and make changes accordingly.
    17. For Commodity Level Accounting (all CruzBuy orders are Commodity Level) the commodity whose accounting info is being shown is highlighted. To access the accounting records for subsequent commodities, type [alt pageup] and then use the arrow keys to move between commodities. Then type [alt pagedown] to view adjusted FOAPAL amounts.
    18. If new commodities were added in the Commodity block, type [alt pagedown] Next Block from the new commodity record to go to the FOAPAL block and enter corresponding accounting information.
    19. Type [alt pagedown] Next Block to advance to the Balancing/Completion page.
    20. To review the Change Order Accounting Distribution, select Commodity/Accounting Information from the Related Menu, then type [alt pagedown] to go to the FOAPAL section. Select Review Accounting Information [FOICACT] from the Related Menu. The system will jump to FOICACT Commodities and Accounting for Review Query Form. FOICACT is an inquiry-only page. You cannot make changes from here. If the original PO was created using document level accounting, this page will display “document accounting distribution” in the commodity field. If it was created using commodity level accounting, you will see the item number displayed along with the description of the item whose account sequences you are viewing.​View each commodity accounting sequence using the arrow keys to navigate between records. The Accounting Data List block of FOICACT is a view of the first nine accounting sequences. Use the arrow key to navigate to additional accounting sequences. Remember if commodity level accounting was used, there will be an accounting block for each commodity item. Type [control q] to exit FOICACT to the Accounting block of FPACHAR.
    21. If you are finished with your changes, click on the Complete icon. Click 'Yes' when you are prompted to save your changes.​
      Important: the 'Save changes' dialog box must be acknowledged immediately after it appears, otherwise the Banner approval process can be impacted. Send email to fis_probs@ucsc.edu for questions.​
    22. This completes the change order. Alternatively, if you wish to exit and return to your change order later, click on the In Process icon.
    23. Upon successful completion, the message “Document XXXXXXX sequence X completed and forwarded to the Approval process” will appear in the status bar at the bottom of the Banner screen.

    Back to Top
  • Processing a Change Order FPACHAR (Part 2)

    Changing an Existing Account Sequence

    ​Note: Complete the Change Order as described in Processing a Change Order, with the following steps included:

    1. You can NOT change field values for an existing FOAPAL. That is, you cannot enter values into existing accounting sequence fields. To change any field of an existing sequence, you must change the dollar value to zero, and replace it with a new accounting sequence. In the Change Order Accounting Block of FPACHAR, use the arrow keys to navigate to the existing account sequence you need to change. Navigate to the extended amount field and enter a 0.00 value. <TAB> Next Field to zero out the accounting column. This accounting sequence (FOAPAL) will continue to show.
    2. Type [F6] Insert Record to insert blank accounting sequence so you can enter your replacement FOAPAL.
    3. <TAB> Next Field to the EXTENDED field. Provide either a percentage distribution or the dollar amount.
      To provide a percentage, type <SPACEBAR> or click in the percent field and <TAB> to the EXTENDED USD field and enter the appropriate percentage.
      To provide the dollar amount to be charged to this accounting sequence, leave the % (Percent) field blank and <TAB> to the EXTENDED USD field and enter the dollar amount.

    Back to Top
  • Processing a Change Order FPACHAR (Part 3)

    Changing Accounting Distributions

    Note: Use this process when multiple FOAPALs are being charged. Either distribute $ amounts by percentage or byentering dollar amounts directly. Complete the Change Order as described in Processing a Change Order, through Step 17. Then follow the steps below to change accounting distributions.

    1. By percentage: In FPACHAR, in the Commodity/Accounting screen, in the FOAPAL block, to change an item’s percentages, check the % field by clicking with the mouse, or typing <SPACEBAR> while the cursor is in the percent field. <TAB> and then enter the new percentage amount in whole numbers (example: 80 for 80 percent and 20 for 20 percent).
      By $ amount: In FPACHAR, in the Commodity/Accounting screen, in the FOAPAL block, to manually change dollar amounts, make your calculations carefully, taking into consideration that sales tax is calculated on the extended amount. With the percentage checkbox blank, enter your amounts in the AMOUNT field (labelled USD). Navigate through accounting sequences (FOAPALs) using the arrow keys.
    2. To return to the commodity block from the accounting data block, type [alt pageup] Previous Block. To complete the change order type [alt pagedown] Next Block to go to Balancing/Completion.
      Tip: If you are working with commodity level accounting, in the Commodity block, use your arrow key to go to the next commodity, then type [alt pagedown] Next Block to go to that commodity’s accounting data block.

    Adding a Commodity Item

    Note: Use this process to add a new commodity item to a purchase order. Complete the Change Order as described in Processing a Change Order, through Step 12. Then follow the steps below to add commodities.

    1. From FPACHAR Commodity/Accounting block, with your cursor in the COMMODITY field, type down arrow <down arrow> to move to a blank record and then enter your new commodity.
    2. Enter Line Item text as needed by selecting Item Text [FOAPOXT] from the Related Menu.
    3. If you are using Document Level Accounting, the dollar amount will be distributed automatically by the percentage specified. If you are using commodity level accounting, type [alt pagedown] Next Block and enter the accounting sequences and amount distribution for that commodity.

    Zeroing Out a Commodity Item

    Note: Use this process to zero out an existing commodity item from a purchase order. Complete the Change Order as described in Processing a Change Order, through Step 8. Then follow the steps below to delete commodities.

    1. From FPQCHAP, add the commodity to the change order form by navigating to the PO Commodity Info Block and checking the item(s) to be deleted. To return to FPACHAR from FPQCHAP, type [control q].
    2. From the Change Order Commodity Block, <TAB> Next Field to the TAX GROUP field and enter [NOTX] to ensure that any tax amount that had been applied gets reset to zero.
    3. <TAB> Next Field to the UNIT PRICE field and enter a 0.00 value. This will zero out all the extended costs. The item still exists, but has a zero dollar amount. Banner will automatically deduct the dollar amounts from the accounting sequences.
      Note: It may be necessary to enter [alt pagedown] Next Block to cycle through each block in FPACHAR before you see the results of your changes in the Commodity of Accounting blocks. Banner may distribute the change in dollar amounts. Sometimes, however, the system will provide the following message in the status bar: “Amounts for commodity items cannot be distributed automatically. Distribute manually.”
    4. Any dollar amounts needing to be distributed will be shown in the REMAINING COMMODITY AMOUNT field. <TAB> to the Extended amount fields and make the changes.

    Back to Top
  • Querying Change Orders FPIPURR

    ​Use this process to query a completed and approved purchase order, and any change orders that have been processed:

    1. Type FPIPURR in the Banner Welcome page.
    2. You will see the cursor in the Purchase Order field. Enter the purchase order number (including the P).
    3. <TAB> to CHANGE SEQUENCE NUMBER field. If you are querying a purchase order that has no change orders against it, leave this field blank. If you wish to view the resultant purchase order including any change orders against it, leave this field blank. If you wish to view only those changes made on a particular change order, enter the sequence number of the change order (i.e. 1). This will select only those items which have been changed on change order #1, and the TOTAL AMOUNT field will reflect the net amount of the change (which may be negative if the commodity amount was decreased), not the entire purchase order total. If you have entered changes to a purchase order, but would like to see the original purchase order only, type 0 in this field.
    4. Type [alt pagedown] Next Block to view the purchase order Document Information. Note that completion and approval status are reflected here.
    5. If the DOCUMENT TEXT checkbox contains a check, you can review your Purchase Order text by selecting Document Text [FOAPOXT] from the Related Menu. To exit FOAPOXT and return to FPIPURR, type [control q].

      View Image



    6. Type [alt pagedown] Next Block to view Requester/Delivery data

      View Image



    7. Type [alt pagedown] Next Block to view Vendor data.

      View Image



    8. Type [alt pagedown] Next Block to view Commodity/Accounting data. Commodity level funding is active if the Document Accounting checkbox is blank. See Document Level versus Commodity Level Accounting. For commodity level funding, if the Item Count total is greater than 1, you can use the arrow keys to view accounting records for each commodity.

      View Image



    9. If the ITEM TEXT checkbox contains a check, you can review your Item text by selecting ItemText [FOAPOXT] from the Related Menu. To exit FOAPOXT and return to FPIPURR, type [control q].
    10. After viewing commodities, type [alt pagedown] Next Block to view Accounting Data. If the FOAPAL count is greater than 1, you can use the arrow keys to view each additional accounting record.
    11. From the FOAPAL block, to view accounting records by commodity, select Review Accounting Information [FOICACT] from the Related Menu. After you complete your review, type [control q] to return to FPIPURR.
    12. Type [alt pagedown] Next Block to return to FPIPURR’s Document Information screen. Type [control q] ​to exit FPIPURR and return to the Banner Welcome page.​​

    Back to Top
  • Canceling a Change Order FPACDEL

    ​Use this process to cancel a Change Order that has been created, completed, and approved.

    Note: Cancelation differs from deletion. A canceled Change Order remains as a permanent record in the FIS database. However, you can delete any Change Order BEFORE it is completed by typing [shift F6] Delete Record twice. A deleted Change Order is completely removed from the FIS database.

    Important: To delete an incomplete change order, type [shift F6] Delete Record twice from the TRANSACTION DATE field. The system will notify you that the change order has been deleted.

    1. Type FPACDEL in the Banner Welcome page.​.
    2. You will see the cursor in the PURCHASE ORDER field. Enter the Purchase Order number you need to cancel.

      View Image



    3. <TAB> Next Field to CHANGE SEQUENCE NUMBER field and enter the change order sequence number you need to cancel.
    4. Type [alt pagedown] Next Block to view data about the PO you specified.
    5. Select Access Cancel Date from the Related Menu. Cancel date will default to today’s date.

      View Image



    6. Select Process Cancellation from the Related Menu to make the cancellation at all levels permanent. Status bar information at bottom of page will reflect records saved information.
      Note: UCSC currently does NOT require a Reason Code for cancellations, so please ignore this field. Use Document Text [FOAPOXT] if you need to document the reasons for your Change Order cancellation.
      Important: You MUST cancel the latest completed, approved, and posted Change Order first. You must delete Change Orders before deleting Purchase Orders. If there has been any activity, such as Receiving or Invoices, against the Change Order, you will NOT be able to cancel your Change Order. Instead, you will need to process an additional Change Order to make any necessary modifications.

    Back to Top
  • Printing a Change Order FPACORD

    1. Type FPACORD in the Banner Welcome page. Banner will route you to GJAPCTL Process Parameter Entry Form where you can specify what Change Order you want to print. GJAPCTL is sometimes referred to as the job submission form.​
    2. You will see the cursor in the PROCESS field. FPACORD defaults.
    3. Type [alt pagedown] Next Block. You will see the cursor in the PRINTER field. You can type [F9] List (see Query Techniques) to access your office's printer code, or you may type your printer code directly. You can have your printer code default into GJAPCTL, FPACORD, or any other Job Submission form by sending an email request to fis_probs@ucsc.edu.
    4. Once you select the printer, the SPECIAL PRINT field defaults to purchorder. Do not change. The Lines and Submit Time fields should remain blank.
    5. Type [alt pagedown] Next Block to specify your change order parameters. Cursor will first appear in Number Field 01. Do not change or delete.
    6. <TAB> Next Field to Parameter Values and type the purchase order number whose change order you want to print. Be careful to enter your PO number with a capital letter (usually P, B, or S).
    7. Type <down arrow> Next Record, to the CHANGE ORDER SEQUENCE field. You can either enter a change order sequence or leave the field blank to print all change order sequences for the purchase order number you specified.
    8. Type <down arrow> Next Record, to the Purchase Order Type field. Value defaults to A for all. You may enter either R for regular, or S for standing, alternatively.
    9. Type <down arrow> Next Record to go to the Include E-Procurement POs? field. Accept the default of N to print the current purchase order.
    10. Type [alt pagedown] Next Block to the Submission Block. Defaults to Submit. Type [F10] Commit or click the Save button to submit your job to the specified printer.
    11. When you have printed all jobs you need to print at this time, type [control q]​ to return to the Banner Welcome page.


    Back to Top
  • Direct Payments General Policy Requirements

    ​Please refer to UCSC Financial Affair's Payment and Reimbursement Guide for information about Direct Payment Policy Requirements.


    Back to Top
  • Direct Pay Invoice FYAINVE

    ​A Direct Payment is used when a purchase order is not required.

    Note: Enter direct payments using FYAINVE. See Direct Payments – One-Time Vendors FYAINVE for one-time-vendor specific information.

    1. Type FYAINVE in the Banner Welcome page.
    2. You will see the cursor in DOCUMENT # field. <TAB> Next Field and NEXT will appearin the Document field, indicating that Banner will automatically assign an invoice number in a future step.
    3. <TAB> Next Field to MULTIPLE field. Click or type <spacebar> to choose to pay multiple vendor invoices to the same vendor on the same Banner invoice document. See Multiple Invoice below for more information on processing multiple invoices from the same vendor on a single Direct Payment document.
    4. <TAB> Next Field. The field value defaults to Direct Pay.
    5. <TAB> Next Field to the VENDOR field. Enter the vendor number. If your vendor’s number is unknown, type [F9] List Field Values and retrieve your vendor.
    6. Type [alt pagedown] Next Block or click the Go button to navigate to the Invoice/Credit Memo Header section.

      View Image



    7. Today’s date defaults in the INVOICE DATE field and in the TRANSACTION DATE field. Enter the invoice date that appears on the vendor’s invoice, and adust the transaction date from the default date to a different date as necessary.
    8. <TAB> Next Field to the DOCUMENT LEVEL ACCTG field. Leave checked for Document Level Accounting. For Commodity Level Accounting uncheck by clicking on the field. See Document Level versus Commodity Level Accounting for information. Document Level Accounting enables you to assign account distributions to an invoice document in total.
      Use Commodity Level Accounting to assign account distributions to individual commodities, if necessary.
    9. <TAB> Next Field to the CHECK VENDOR field. Leave blank unless payee is different than invoice vendor. (This is used when the payment is for travel made on behalf of the traveler.)
    10. <TAB> Next Field to the ADDRESS CODE field. Accept default value.
    11. <TAB> Next Field to the SEQUENCE # field. Accept default value or type [F9] List Field Values and choose the appropriate address sequence number.
    12. <TAB> Next Field to the DISCOUNT CODE field. Value defaults for vendor chosen. You can type [F9] List Field Values and change the discount code if necessary.
    13. <TAB> Next Field to the PAYMENT DUE field. This field value determines when the check is printed. It is very important to enter a date that allows for early payment discount. Set the payment due date at least five days prior to the actual date that payment is due to the vendor.
    14. <TAB> Next Field to the BANK CODE field. OR defaults for Office of Record.
    15. <TAB> Next Field to the VENDOR INV # field and enter the number from the vendor’s invoice or the account number with month and year (35 characters maximum). This field prints on the remittance advice of the check. Vendor should be able to identify payment from this entry.
    16. <TAB> Next Field past the ACH Transaction field to the 1099 TAX ID field. If data defaults, verify that it is correct. Enter Tax ID number if invoice is for services and is tax reportable. When a 1099 Tax ID is entered, the 1099 VENDOR field defaults to checked, and an Additional Information block will be shown later (see step 22 below.)
    17. <TAB> Next Field to the CREDIT MEMO field. Leave blank unless your document is a credit.
    18. <TAB> Next Field through the AP REVIEW field. Review the 204 ON FILE field value and contact AP if the field value is N but the pay type requires a 204 on file.
    19. View the UCSC EMPLOYEE field. If field value is Y, review for a possible Conflict of Interest.
    20. Select Document Text [FOAPOXT] from the Related Menu to enter document text in FOAPOXT. Document text must be added before completion of the invoice. Include your name, unit or department and phone number, for example jsmith/opers/95678. Include a full description of the charge, as well as instructions for check distribution. See Text Entry: FOAPOXT if you need detailed instructions for entering text and clauses. Click on the Save icon and then type [control q] to return to FYAINVE.
    21. If a single check per invoice (order) is required, select View Document Indicators from the Tools Menu. Click on the GROUPING arrow and select (1) Invoice per Check to select one check and then click on the Close button. (M) allows one check to pay multiple invoices; (1) requires a separate check to pay only this invoice.

      View Image



    22. Type [alt pagedown] Next Block. If the vendor has a 1099 Tax ID number (see step 16 above) Banner will transfer to the Additional Information block of FYAINVE. ​You can also select Header Additional Information from the Tools Menu.
    23. The cursor will be in the Commodity field. <TAB> to the Commodity Description field, and enter a description (limit 50 characters).
    24. <TAB> through the TAX GROUP field. Value defaults to CRUZ. Change to NOTX (no tax) for reimbursements or services as necessary.
    25. <TAB> through the CURRENCY field.
    26. <TAB> through the DISBURSING AGENT field.
    27. <TAB> to the INCOME TYPE field. When the 1099 field is checked, Banner expects an income type to be provided. Type [F9] List and choose the appropriate value. NC, for nonemployee compensation is commonly used.
    28. Leave Carrier Route, Delivery Point and Correction Digit fields blank. Then click on the Close button.

      View Image



    29. Type [alt pagedown] Next Block to transfer to the Commodity Info - Direct Pay/General Encumbrance block of FYAINVE.
    30. Write down your Banner document number.
    31. <TAB> Next Field to the COMMODITY DESCRIPTION field and enter commodity description. Note: This does not print on the check.
    32. <TAB> through the TAX GROUP field. Value defaults to CRUZ. You may change this as needed.
    33. <TAB> through the REVERSE CALC field.
    34. In the APPROVED AMOUNT field enter the total $ amount for the commodity.
    35. <TAB> Next Field to the ADDITIONAL field and enter the appropriate amount.
    36. <TAB> Next Field and the appropriate tax amount defaults.

      View Image



    37. If you are entering more than one commodity, use the arrow keys to go to the next record. Repeat steps 31-36 for each commodity.
    38. Type [alt pagedown] Next Block to go to the Invoice Accounting Distribution section.
    39. Enter your FOAPAL in the appropriate fields.
    40. BANK field value will default to value entered in step 15 (header information.)
    41. <TAB> Next Field through INCOME TYPE field. Defaults from value entered in step 27.
    42. In the APPROVED % field, enter a P if you want to charge a percentage of the total to the entered FOAPAL. Then enter the percentage in the AMOUNT field. Alternatively, if you want payment made against only one FOAPAL, <TAB> through the % field and amounts will default.
    43. If you are charging multiple FOAPALS, enter the percentage or amount in the APPROVED AMOUNT field. Use the arrow down key to go to the next blank accounting sequence field, and insert the next FOAPAL and percentage or amount (repeat steps 41-44).
    44. <TAB> Next Field through NSF OVERRIDE field.
    45. Use the Arrow Down key [down arrow] as needed to enter additional accounting sequences.
    46. Type [alt pagedown] Next Block to go to the Balancing/Completion section.
    47. Click on the Complete button if your invoice is complete and you want it to go to posting/approvals. Otherwise, click on the In Process button to save your changes. The page will roll back to the FYAINVE entry page, permitting you to open an existing In Process invoice or to create a new invoice if desired.
    48. If accounting errors exist, select Accounting Information from the Related Menu to go to the Accounting block to review and/or adjust entries. After corrections, repeat steps 48-49.
    49. Record the Banner Invoice Number on the appropriate form and retain all the backup documentation, including the original invoice.

      View Image



      Special Case - Closed Accounting Periods: The accounting periods are closed at 5pm on the seventh working day of every month. All documents not approved must be disapproved and reset to incomplete status. This allows the transaction date to be changed to the current open period. After this date is changed, <TAB> through the fields and complete the document.

    Multiple Invoices - Direct Pay

    Use this process to pay MULTIPLE invoices from the same vendor on a single Direct Payment invoice document (Idoc).

    1. Type FYAINVE in the Banner Welcome page.​​
    2. You will see the cursor in DOCUMENT # field. Defaults to NEXT, so Banner will automatically assign an invoice number.
    3. <TAB> Next Field to MULTIPLE field. Click or type <spacebar> to choose to pay multiple vendor invoices to the same vendor on the same Banner invoice document.
    4. <TAB> Next Field to MULTIPLE field. Click or type <spacebar> to choose to pay multiple vendor invoices to the same vendor on the same Banner invoice document.

      View Image



    5. Process via Steps 7-21, exclusing step 15 at the beginning of this section, then continue to Step 5 below. Note that "MULTIPLE" will default into the Vendor Invoice field.

      View Image



    6. Type [alt pagedown] Next Block to transfer to the FACICON Vendor Invoice Consolidation.
    7. The cursor will appear in the VENDOR INVOICE field. Enter the number from the vendor’s first invoice you wish to group with other invoices (35​ characters maximum). This field prints on the remittance advice of the check. Vendor should be able to identify payment from this entry.
    8. <TAB> Next Field to the VENDOR INVOICE DATE. Value defaults to current date. You may change this as needed via DD-MON-YYYY format.
    9. Type [alt pagedown] Next Block to the FACICON Commodity section. Cursor appears in Commodity field.
    10. <TAB> Next Field to the DESCRIPTION field and enter commodity description. Note: This does not print on the check.
    11. <TAB> Next Field to the APPROVED AMOUNT field and enter the total $ amount for the commodity.
    12. <TAB> Next Field to the ADDITIONAL field and enter the appropriate amount.
    13. <TAB> Next Field to the TAX GROUP field. Value defaults to CRUZ. You may change this as needed.

      View Image



    14. If you are entering more than one commodity, use the [down arrow] Next Record key to go to the next record. Repeat steps 9-12 above for each commodity.
    15. To enter additional vendor invoices, type [alt pageup] Previous Block. Key [down arrow] Next Record, and repeat steps 6-13 above for each invoice.
    16. When all invoices and associated amounts have been entered into the FACICON Vendor Invoice Consolidation blocks, type [alt pagedown] Next Block to transfer to the Invoice Accounting Distribution section. Process to completion via Steps 40-50.
    ​​​​
    Back to Top
  • Direct Payments – One-Time Vendors FYAINVE

    ​A Direct Payment is used when a purchase order is not required.
    Complete the Direct Pay Invoice FYAINVE, with the following changes for one-time vendors:

    • A one-time vendor name must be manually entered into FYAINVE. When entering an individual’s name manually, enter “Last Name, First Name.”
    • Manually enter a one-time vendor’s complete remittance address, including the full zip code. Note: The NATION field remains blank for USA addresses.
      Note: A one-time vendor cannot be a 1099 vendor.
    • DISCOUNT CODE field must be filled in. Use code '30'. There are no default values for one-time vendors.

    View Image




    Back to Top
  • Regular Invoice FYAINVE

    ​Use a Regular Invoice when you reference a purchase order created previously through the Purchase Order Form (FPAPURR) or via CruzBuy.

    1. Type FYAINVE in the Banner Welcome page.
    2. You will see the cursor in DOCUMENT # field. Defaults to NEXT, so Banner will automatically assign an invoice number. To continue work on an in-process invoice, enter the Invoice Number.
    3. <TAB> Next Field to MULTIPLE field. Leave this field blank. The Vendor Invoice Consolidation feature can NOT be used on Regular Invoice documents.
    4. <TAB> Next Field. The field value defaults to Direct Pay. Use the Arrow Down key [down arrow] to select Regular from the drop-down list.
    5. <TAB> Next Field to the PURCHASE ORDER field. Enter the PO number or type [F9] List Field Values (see Query Techniques) and retrieve your PO number. Vendor information defaults from the PO.
    6. To select individual items on the PO, <TAB> Next Field to the SELECT PO ITEMS field. Type Y to select purchase order items for this invoice.

      View Image



    7. To select all items on the PO, <TAB> Next Field through the SELECT PO ITEMS field to the INVOICE ALL field.Type Y to select all open items on the referenced purchase order. Type [alt pagedown] Next Block. Skip to step 11.
    8. Type [alt pagedown] Next Block to transfer to the Invoice/Credit Memo PO Selection Form FAQINVP.
    9. In FAQINVP type [alt pagedown] Next Block and <TAB> Next Field to the ADD field and select item(s) for the invoice. Key spacebar to enter a checkmark on the ADD field. Move among additional commodity records using the arrow keys.

      View Image



    10. Type F10 or click on the Save button to save your commodity items. Type [control q] to return to FYAINVE. A record will be committed for each commodity item you chose to add from the PO.
    11. Today’s date defaults in the INVOICE DATE field and in the TRANSACTION DATE field. Enter the invoice date that appears on the vendor’s invoice.
    12. <TAB> Next Field to the CHECK VENDOR field. Leave blank unless payee is different than invoice vendor. (This is used when the payment is made to the invoice vendor on behalf of the payee.)
    13. <TAB> Next Field to the ADDRESS CODE field. Accept default value.
    14. <TAB> Next Field to the SEQUENCE # field. Accept default value or type [F9] List Field Values and choose the appropriate address sequence number.
    15. <TAB> Next Field to the DISCOUNT CODE field. Value defaults for vendor chosen. You can type [F9] List Field Values and change the discount code.
    16. <TAB> Next Field to the PAYMENT DUE field. A date defaults. This field value determines when the check is printed. It is very important to enter a date that allows for early payment discount. Set the payment due date at least five days prior to the actual date that payment is due to the vendor.
    17. <TAB> Next Field through the BANK field.
    18. <TAB> Next Field to the VENDOR INVOICE field and enter the number from the vendor’s invoice or the account number with month and year (35 characters maximum). This field prints on the remittance advice of the check. Vendor should be able to identify payment from this entry.
    19. <TAB> Next Field to the 1099 TAX ID field. Data defaults for 1099 reportable payments. Verify that it is correct. Enter Tax ID number if invoice is for services and is tax reportable. When a 1099 Tax ID is entered, the 1099 VENDOR field defaults to checked, and an Additional Information block will be shown when you type [alt pagedown] Next Block to go to the Commodity Information block. (See step 27.)
    20. If a 1099 tax ID field value is present, the 1099 VENDOR field is checked by Banner.
    21. <TAB> Next Field to the CREDIT MEMO field. Leave blank unless your document is a Credit Memo.
    22. <TAB> Next Field through the AP REVIEW field. Review the 204 ON FILE field value and contact AP if the field value is N but the pay type requires a 204 on file.
      Note: If the AP Review flag is checked, contact AP to provide required information. The following dialog will appear if you choose the completion icon.



    23. View the UCSC EMPLOYEE field. If field value is Y, review for a possible Conflict of Interest.
    24. Select Document Text [FOAPOXT] from the Related Menu and enter document text in FOAPOXT. Document text must be added before completion of the invoice. Include your name, unit and phone number for this transaction (for example jsmith/fast/95678). Include a full description of the charge, as well as instructions for check distribution. See Text Entry: FOAPOXT if you need detailed instructions for entering text and clauses. Type F10 or click on the Save button to save your text. Then type [control q] return to FYAINVE.

      View Image



    25. If a single check per invoice (order) is required, select View Document Indicators from the Tools Menu. Click on the GROUPING arrow and select (1) Invoice per Check to select one check and then click on the Close button. (M) allows one check to pay multiple invoices; (1) requires a separate check to pay only this invoice.

      View Image



    26. Type [alt pagedown] Next Block to transfer to the Commodity Information - Regular block of FYAINVE.
    27. Write down your Banner document number.
    28. If a 1099 Tax ID number is present in the header block, an Additional Information FYAINVE block will appear, as shown below. If no 1099 Tax ID number has been entered, type [alt pagedown] Next Block and skip to step to step 33.
    29. <TAB> through the TAX GROUP field. Typical default value is CRUZ.
    30. <TAB> through the CURRENCY and DISBURSING AGENT fields.
    31. Enter an INCOME TYPE. Typical value is NC for nonemployee compensation.
    32. Leave Carrier Route, Delivery Point and Correction Digit fields blank.
    33. Click on the CLOSE button to return to the header block. Type [alt pagedown] Next Block to go to the Commodity Information Block.

      View Image



    34. <TAB> Next Field through the COMMODITY and U/M fields. Commodity information defaults from the PO.
    35. <TAB> Next Field through the ADD COMMODITY field.
    36. <TAB> through the TAX GROUP field. Value defaults to value specified on PO. You may change this as needed.
    37. <TAB> through the QUANTITY ACCEPTED field.
    38. In the INVOICED and APPROVED fields, the total quantity not already paid defaults. Accept or change to reflect actual invoice payment. (These two field values are typically the same.)
    39. <TAB> Next Field to the ADDITIONAL field and enter the appropriate amount.
    40. <TAB> Next Field and the appropriate tax amount defaults.
    41. <TAB> through the OVERRIDE TOLERANCE field.
    42. <TAB> Next Field to the FINAL PAYMENT field and enter an F if this is the final payment. Otherwise leave blank.
      Note: Setting the Final Payment Indicator will close out the commodity item. Be sure that there are no outstanding invoices against a commodity item before setting Final Payment Indicator.

      View Image



    43. If you are entering more than one commodity, use the arrow keys to go to the next record. Repeat steps 28-41 for each commodity.
    44. If you need to reallocate accounting amounts manually, uncheck the ACCESS COMPLETION field. If the ACCESS COMPLETION field is checked, then Banner will take you directly to the Balancing/Completion block when you type [alt pagedown] Next Block. FOAPAL information defaults from the PO.
      Note: Accounting method on an invoice must remain the same method that was specified for the PO. For example, if the PO accounting is Document Level Accounting then the invoice must also be Document Level Accounting.
    45. In the APPROVED % field, enter a P if you want to charge a percentage of the total to the entered FOAPAL. Then enter the percentage in the AMOUNT field. Alternatively, if you want payment made against only one FOAPAL, <TAB> through the % field and amounts will default.
    46. If you are charging multiple FOAPALS, enter the percentage or amount in the APPROVED AMOUNT field. Use the Arrow Down key [down arrow] to go to the next accounting sequence field, and insert the next percentage or amount.
    47. <TAB> Next Field through NSF OVERRIDE field.

      View Image



    48. Type [alt pagedown] Next Block to go to the Balancing/Completion block.
    49. Click on the Complete button if your invoice is complete and you want it to go to posting/approvals. Otherwise, click on the In Process button to save your changes. The form will roll back to the FYAINVE entry page, permitting you to open an existing In Process invoice or to create a new invoice if desired.
    50. If accounting errors exist, select Accounting Information from the Related Menu to review and/or adjust entries. After corrections, repeat steps 45-47.
    51. Record the Banner Invoice Number on the appropriate form and retain all the backup documentation, including the original invoice.

      View Image



    Special Case - Closed Accounting Periods: The accounting periods are closed at 5pm on the seventh working day of every month. All documents not approved must be disapproved and reset to incomplete status. This allows the transaction date to be changed to the current open period. After this date is changed, <TAB> through the fields and complete the document.

    ​​​​​
    Back to Top
  • Credit Memo Guidelines

    Credit Memo Guidelines

    ​Use credit memos to enter credits against closed purchase orders or other previously-paid transactions.
    Use FAIVNDH Vendor Detail History to find document numbers, invoice numbers, check numbers, payment dates, holds, and other information about specific vendors.

    Credit Memos vs Refund Checks

    • When dealing with a vendor who is used infrequently by UCSC attempt to get a refund check from the vendor. Credit Memos cannot be applied in the system until the next time the vendor invoices UCSC for an amount in excess of the credit memo, using the same remit address. Note: Unapplied Credit Memos are periodically reviewed, canceled and charged back to the FOAPAL.
    • Refund checks may be deposited through the Cashier’s Office directly to the appropriate FOAPAL using the SC27 deposit form available from the book store. Vendor refund checks should be made payable to UC Regents.
    • Frequent UCSC vendors may issue Credit Memos instead of refund checks. If you are not sure how often a vendor is used, you can check vendor history using FAIVNDH. See Vendor Detail History Form FAIVNDH below. It need not be your unit that will buy from this vendor again as long as it is reasonable to expect that the University will be making another payment to this vendor in the near future, so the credit may be applied.
    • If a refund check is received after entering a Credit Memo, cancel the Credit Memo to avoid a duplicate credit. If the Credit Memo is already applied to a new payment, contact AP.
    • Credit Memos against closed POs are received by AP and reviewed for vendor activity, remittance address and bank code. AP will provide a routing slip with instructions and the Credit Memo to the Service Center originating the PO. FASTr will process the Credit Memo per the routing slip and then return the original Credit Memo and routing slip noting the Banner document number to AP (the office of record for PO related payments).

    Creating Credit Memos FYAINVE

    Create a Credit Memo by following the steps for Direct Pay Invoice FYAINVE, with the following change:

    • In the header block, click on the CREDIT MEMO field to create a credit memo.
      Important: Credit Memo must be selected before going to the commodity block. This is the only field that designates a credit memo. You will not see negative numbers in the approved amount on a credit memo.
    • Add and complete a “DOOR” clause for this transaction in text on-line. Include the original payment check number that applies to the credit memo, as well the Unit name, contact and phone number for this transaction. See Text Entry: FOAPOXT if you need detailed instructions for entering text and clauses. Click on the Save Icon and then type [control q] Exit Screen, click on the Exit icon or Right Click - Exit to return to FYAINVE.
    • Enter the PO number in the vendor invoice number field followed by a forward slash followed by the credit memo number. (For example: P41807/009000). If the vendor’s invoice and credit memo numbers are identical, enter “CM” after the credit memo number (P41807/009000CM).
      Important: Do not enter the credit as a negative number.
      Note: The approved amount will not show as a negative number in a Credit Memo. It WILL show as a negative number on unit ledgers and in invoice history (FAIVNDH).
    • After you have processed the credit memo on-line, note the Banner document number and due date for the Credit Memo.

    Back to Top
  • Vendor Payment History FAIVNDH

    Vendor Detail History FAIVNDH

    1. Type FAIVNDH in the Banner Welcome page.​
    2. Enter the vendor number in the Vendor field. To query for vendor codes, type [F9] List (see FTIIDEN).
    3. <TAB> to Fiscal Year field. Current Fiscal Year will default. You may change if desired.
    4. If you wish to constrain your query to a specific From: and To: date range, do the following:
      • <TAB> to Invoice Date From: field, and enter your lower bound date, in format DD-MON-YYYY (e.g. 15-SEP-2007).
      • <TAB> to Invoice Date To: field, and enter your upper bound date, in format DD-MON-YYYY (e.g. 15-DEC-2007).
        Tip: Click on the Calendar icon to display a month-format calendar to assist in selecting date ranges.
        Once your date is selected, click OK, and your date will be returned to the Date field in the proper format.
        Note: When entering a date range for FIVNDH, the Fiscal Year field value will blank out.
        If you don't need to constrain your date range, skip to Step 5.
    5. Type [alt pagedown] Next Block. Your query results, if any, will appear.

      View Image



    6. Once results have displayed, you can look at Invoice and Check information in detail:
      • For Invoice Detail, place the cursor in the Vendor Invoice field and select View Invoice Information [FAIINVE] from the Related Menu.
      • For Check Detail, place the cursor in the Check Number field and key F3. The check Payment History form FAICHKH will display. Type [alt pagedown] Next Block for check detail. Type [control q] to exit FAICHKH and return to FAIVNDH.
        Note: check number will display for canceled checks for invoices with an Open/Paid indicator of "O".
        The Cancel indicator can be used to determine invoice status as follows:
        1. Open invoices with Cancel indicator of "N" have payables re-established.
          Canceled check number will display until replacement check is issued for re-established invoice.
        2. Open invoices with Cancel indicator of "Y" do not have payables re-established.
          Canceled check number will permanently display.​
    7. Type [control q] to exit FAIVNDH and return to the Banner Welcome page.
    ​​​
    Back to Top
  • Placing & Releasing Invoice / Credit Memo Holds FAAPAYC

    ​Use this process to place on hold or release from hold any invoice or credit memo that has been created, completed, or approved:

    1. Type FAAPAYC in the Banner Welcome page.​​
      Important: The hold must be placed in the Invoice Information block. DO NOT USE the Commodity Information block.
    2. You will see the cursor in the DOCUMENT # field. Enter the document number and <TAB>. You can type [F9] List Field Values (see Query Techniques) and retrieve the document number that you need to hold.
    3. Type [alt pagedown] Next Block to go to the next block.
    4. <TAB> to the HOLD field or click on it to place the document on hold; to release the document from hold, delete the check by clicking on the field. Type [F10] or click on the Save button to commit the modified hold status.
    5. Type [control q] to return to the Banner Welcome page. You will be asked if you want to save your changes.

    Important: Record the reason for placing a hold on the vendor invoice.

    Develop a method of tracking documents placed on hold. The hold must be removed before a payment will be processed.

    If the invoice will not be paid, cancel the invoice using FAAINVD. See Cancelling an Invoice or Credit Memo FAAINVD.

    Do not place an invoice or credit memo on hold using the Invoice /Credit Commodity Data block. The commodity hold also places the whole document on hold but it is not easily viewed or modified when using FAAPAYC.

    View Image




    Back to Top
  • Canceling an Invoice or Credit Memo FAAINVD

    Use this process to cancel an invoice or credit memo that has been created, completed and approved.

    Note: You can delete any document before it is completed by typing [shift F6] Delete Record twice while in the Header Data Block.

    Call Accounts Payable for assistance to cancel a prior year invoice in a new fiscal year. Control accounts and fund balances may become out of balance.

    You cannot cancel an invoice or credit memo:

    • with an associated activity, such as a Payment, or
    • before it has been approved
      (An error message displays and the cancel transaction is not posted. Have the invoice disapproved then type [shift F6] Delete Record twice while in the Header Data Block.)
    1. Type FAAINVD in the Banner Welcome page.​​​
    2. You will see the cursor in the DOCUMENT # field. Enter the document number and <TAB>. You can type [F9] List Field Values (see Query Techniques) and retrieve the document number that you need to cancel.
    3. Type [alt pagedown] Next Block.
    4. Verify the vendor name, vendor number and amount.

      View Image



    5. Select Access Cancel Date from the Related Menu. The Cancel Date field will default to today’s date. Do not change the cancellation date.

      View Image



    6. Click on the Make Cancellation Permanent icon to make the cancellation at all levels permanent. A status bar message will acknowledge that the transaction has been posted.
    7. Type [control q] to return to the Banner Welcome page.
    ​​
    Back to Top
  • Open Invoice / Credit Memo List FAIINVL

    ​Use FAIINVL Open Invoice/Credit Memo List Form to check your open invoices and credit memos. FAIINVL provides a summary of all open invoices and credit memos, including incomplete, unapproved or unpaid transactions.

    1. Type FAAINVL in the Banner Welcome page.​
    2. The form will default with the OPEN radio button checked. You may check another setting (PAID, SUSPENSE or HOLD) if required. Type [alt pagedown] Next Block. The page will display all Open Invoices and Credit Memo. To search for a specific document, type [F9] List Field Values (see Query Techniques)
    3. From the INVOICE NUMBER field, select the invoice of interest using arrow keys or the mouse. Select Document Query [FAIINVE] from the Related Menu. Type [control q] to return to FAIINVL.
      Note: The PURCHASE ORDER/ENCUMBRANCE field allows a query for additional information. Type [F9] List Field Values and the system jumps to FPIPURR Purchase/Blanket/Change Order Query Form.

      View Image



    4. Type [control q] to return to the Banner Welcome page.

    Back to Top
  • Known Issues - Receiver Required Inappropriately

    Invoice under $10,000 requiring a Receiver.

    Occasionally, a trigger gets set on an invoice under $10,000 causing a receiver to be required when it shouldn’t be. This can happen if the invoice total was originally over $10K and the amount was reduced to less than $10K. It also sometimes occurs when the previously entered invoice over $10K.


    Work Around

    Delete the invoice and start a new one with a new invoice number (don’t try to reuse the old document number).

     


    Back to Top
  • Known Issues - Invoice Cancellation FAIINVD

    Invoice Cancellation FAIINVD

    There is a known issue when FOADOCU-Document by User and FAIINVD-Invoice Cancellation​ are used at any point during the same Banner session. If you log on to Banner, do normal Banner work, then go to FOADOCU at any point and deny a document, then go to FAAINVD within the same session to cancel an invoice, the invoice will not cancel as expected. Instead, the invoice will post a second time, resulting in the FIS financial ledger being out of balance and requiring extensive analysis and technical work to correct.​

    Work Around

    Whenever you use FOADOCU, immediately log out of your session AFTER your FOADOCU work is completed, then re-open a new session.

    IMPORTANT

    If you believe you may have used FAIINVD and FOADOCU within the same Banner session, please contact the FIS Office immediately at fis_probs@ucsc.edu.

     ​

    ​​​
    Back to Top
  • Known Issues - Invoice Tax Adjustment

    Invoice Tax Adjustment FYAINVE

    If you process Regular (PO) invoices against a PO with two or more line items and the final line item is set to No Tax, you will not be able to adjust tax via the Commodity Taxes Distribution function unless you use a temporary work-around.

    Background

    A defect has been discovered in FYAINVE w​hen using the Commodity Taxes Distribution function to adjust tax distribution. When processing a Regular Invoice against a PO that has at least one taxable item and a final non-taxable item, if you use the Commodity Taxes Distribution function (Tools Menu/Tax Distribution Information in FYAINVE Commodity Section), you cannot save a Tax Override, instead the Commodity Taxes Distribution window remains unchanged:



    Compare with pre-defect behavior, where you could enter an Override value into the Tax Override field, key Tab, and the page will prompt you to Save your changes:





    In addition, if you first navigate through the Commodity field then call the Commodity Taxes Distribution window, you will see warning messages, and the Commodity Taxes Distribution window will have no values in the Details section:



    If you attempt to enter an adjustment amount in the Tax Override field when the Detail section is empty, your session will spin and require you to restart your Banner session after a 15 minute wait.

    Work Around

    We have identified a temporary work-around when tax needs to be overridden for a PO that has the final item set to non-taxable:

    1) Go to Commodity Information section and navigate to the last (non-taxable) item.



    2) Set the Tax Group from No Tax to Tax (e.g. from NOTX to CRUZ)



    3) Navigate back up to the Taxable Item that needs adjustment. You should now be able to Select Tax Distribution Information from the Tools Menu, enter a value into the Tax Override field, then press the tab key. The Commodity Taxes Distribution window will disappear, and you will be prompted to save changes. Your tax adjustment will then be saved.

    4) Press “Close”, and navigate back to the last (previously non-taxable) item, and set the Item back to Not Taxable.



    ​​ ​​​​
    Back to Top
  • Known Issues - Clearing Cash Advance

    Clearing Cash Advances

    At UCSC, Cash Advances (usually for travel) are cleared with a direct pay invoice, using two accounting distributions (FOAPALs), that offset each other, making the net value of the invoice equal to zero. FIS does not allow entry of a direct pay invoice with a zero net balance, so a workaround is necessary.

    Work Around

    Prepare Direct Pay invoice in FYAINVE as normal through Commodity Info - Direct Pay/General Encumbrance block. Then complete the following steps:

    1. Type [alt pagedown] Next Block to go to the Invoice Accounting Distribution block.
    2. Enter your DEBIT FOAPAL (the foapal the cash advance is being charged to) in the FUND, ORGANIZATION, ACCOUNT, and ACTIVITY CODE fields as necessary.
    3. <TAB> Next Field through LOCN, BANK, INCOME TYPE: and % fields to ACCOUNTING/APPROVED: field. Field will be blank.
    4. <TAB> Next Field so that cursor moves from ACCOUNTING/APPROVED field to the second % field. All fields in the Accounting column will populate with '.00'
    5. Key F10-Save, or click on the Save button. Cursor will appear in the COA field.
    6. <TAB> Next Field through FUND, ORGANIZATION, ACCOUNT, ACTIVITY CODE, LOCN, BANK, INCOME TYPE: and % field to ACCOUNTING/APPROVED: field.
    7. Replace the existing '.00' value with the amount to be debited (e.g. 5.00), then <TAB> Next Field.
    8. Key F10 or click on the Save button.
    9. Key Arrow Down to next record.
    10. Enter index code (e.g. 112150) and then tab through LOCN, BANK, INCOME TYPE: and % field to ACCOUNTING/APPROVED: field.
    11. <TAB> Next Field so that cursor moves from ACCOUNTING/APPROVED field to the second % field. All fields in the Accounting column will populate with '.00'
    12. Key F10 or click on the Save button. Cursor will appear in the COA field.
    13. <TAB> Next Field through FUND, ORGANIZATION, ACCOUNT, ACTIVITY CODE, LOCN, BANK, INCOME TYPE: and % field to ACCOUNTING/APPROVED: field.
    14. Replace the existing '.00' value with the amount to be credited (e.g. -5.00), then <TAB> Next Field.
    15. <TAB> Next Field to COA field.
    16. Key F10 or click on the Save button.​
    17. Select Review Accounting Information [FOICACT] from the Related Menu. Confirm accounting data is balanced, then exit FOICACT.Key F10 or click on the Save button.
    18. Type [alt pagedown] Next Block to go to the Balancing/Completion block, complete or keep in process as necessary.

     


    Back to Top
  • Known Issues - Vendor Address Error

    Vendor Address Error

    If the vendor address used on a Purchase Order has been inactivated since the PO was completed, FIS will display an error message: 

    T​he Address Type and Sequence Number combination is invalid or inactive.

    Work Around

    Click OK. The error message may reappear several times; continue to click OK until it does not reappear. The inactive address will clear from the form, and the cursor will be in either the Address Code or Sequence Number field (depending on which field caused the error message to occur)

    Click on the Search Arrow next to the box your cursor is in and it will take you to the Address Query screen SOQADDR.

    Arrow down to the address to be used for payment remittance. Click on the Select button on the bottom right corner of your page to return the address to FYAINVE.

    Complete the document as usual.

     


    Back to Top
  • Known Issues - Multiple Invoice Consolidation (VIC)

    Multiple Vendor Invoice Consolidation (VIC) feature

    The FIS Banner Multiple Vendor Invoice Consolidation feature is used to pay MULTIPLE invoices from the same vendor on a single Direct Payment invoice document. It should only be used on direct pay invoices with Document Level Accounting.


    Work Around

    Do not use the Multiple Invoice feature on Purchase Order payments.

     


    Back to Top
  • Known Issues - Wrong or Missing Vendor Displayed When Entering Text

    Wrong or Missing Vendor Info Displayed when Entering Invoice Text

    When entering or viewing text on invoices for One Time Vendor payments, the Vendor information in the header of the text form (FOAPOXT) will either be blank, or will contain the Vendor info from the previous invoice paid. This is a display error only; the text is associated with the correct vendor and invoice.


    Work Around

    None; display error only.

     


    Back to Top
  • Known Issues - General Encumbrance Invoice Final Payment Indicator Error

    General Encumbrance Invoice Final Payment Indicator Error

    When a General Encumbrance payment is made immediately after a Direct Pay payment without leaving FYAINVE, the Final Payment Indicator field in the Commodity block is un-usable (Status Line Message reads 'FRM-40200: Field is protected against update.').

    Work Around

    Navigate to the General Encumbrance header block and shift-delete (key Shift-F6 twice) the payment document. Exit from FYAINVE back to the General Menu, re-enter FYAINVE and enter payment information. This time the Final Payment Indicator will be usable.

     


    Back to Top
  • Creating a Journal Voucher FZAJVCD (Part 1)

    ​Use the UCSC Journal Voucher Entry page to enter a Transfer of Expense, a Transfer of Funds, or a Balance Sheet Journal.
    Important: Use only one journal type (rule code) in one Journal Voucher. See Appendix B: Transaction Rule Codes, as needed, for journal type specifics.

    UCSC Journal Voucher Entry

    1. Type FZAJVCD in the Banner Welcome page.

      View Image



    2. You will see the cursor in the DOCUMENT NUMBER field. NEXT defaults. Type [alt pagedown] Next Block.
    3. OR, to continue work on an incomplete existing journal voucher, enter the journal voucher number. You can click on the Search Icon or type [F9] List from the DOCUMENT field and the system will go to FZIJVCD List of Suspended Journal Vouchers and show a list of incomplete and/or unapproved journal vouchers, which you can query. See Query Techniques for details. The queryable fields are Document, Amount, Transaction Date, User ID and Rule Code. Key [alt S] to bring an incomplete Journal Voucher number back to FZAJVCD.​ 
    4. Note: When using FZIJVCD as a Stand-Alone (entered directly from the Search field of the Banner Welcome page), your query results are read-only.

      View Image



    5. For new JVs, the TRANSACTION DATE field value defaults to today’s date. To change the date, enter the desired date. For existing JVs, previously-entered date shows.
      Note: TRANSACTION DATE defines the financial period in which the journal voucher will be posted. You must enter a date in an open period. Each month is closed at 7pm on the 7th working day after the end of that month.
    6. From FZAJVCD, <TAB> to the DOCUMENT TOTAL field and enter the total of all debits and credits for this JV. Do NOT include +/- or $ signs.
    7. Document Text: FOATEXT
      Document Text is required for completion of all JVs. Select Document Text [FOATEXT] from the Related Menu. The system will go to FOATEXT: General Text Entry Form. Up to 9,999 lines of 50 characters each are available.
      Note: Banner assigns a JXXXXXXX document number when you go to FOATEXT.
      Important: Include answers to the questions who, what, and why in this text field. Include name, unit, and phone number of document preparer. See TOE/TOF Quick Reference Cheat Sheet for specific Document text requirements for different journal types.

      View Image



      1. Entering Text: Begin typing your message. Use <down arrow> Next Record or click on subsequent lines to add more text. (Navigation and editing with the mouse behave much like they do in word processing programs, except that no wrapping occurs. Users may click directly in the field where they wish to enter data.)
      2. You can insert lines of text between existing lines by entering the text, tabbing to the line field, and entering a number that places the text where you want it sequentially relative to the line numbers already defined. To insert a blank line, arrow down to a new line, tab to the LINE field and enter a number that places your blank line in the position you desire relative to the already-defined line numbers. To change the order of lines of text, tab to the line field and change the number of the line so it will be in the desired sequence. Type [F10] or click on the Save button to save your text.
      3. To add a Banner Clause, key [F7] or click on the Start Over button. The cursor will appear in the CLAUSE field.Type [F9] List Field Values and choose appropriate clauses as needed. Type [F6] Insert Record to add the clause to your document text. Then modify the clause as needed.
      4. Each time you add text and save, the record count in the status line gets updated.
      5. From FOATEXT, to delete a line of text you have saved but no longer want, type [shift F6] Delete Record while the cursor is in that line of text.
      6. When you type [control q], Banner asks if you want to save the changes you have made. Click on Yes to save and return to FZAJVCD. Banner places a check in the Document Text Exists field in the Journal Voucher Document header block.
      7. Back in FZAJVCD, type [alt pagedown] Next Block to go to the Transaction Detail Block.​
    ​​​​​
    Back to Top
  • Creating a Journal Voucher FZAJVCD (Part 2)

    1. You will see the cursor in the SEQUENCE field. Leave blank for system default sequence numbers.
    2. <TAB> to the JOURNAL TYPE field. Enter the appropriate rule code. (You could type [F9] List Field Values to choose from the possible codes, but that will give you hundreds of choices.) Enter one listed in the following table.
      Table 3: Rule Codes for JVs
      Rule CodeDescription
      Transfer of Expense (TOE)
      Rule Codes ​ ​
      XTOENon-Payroll Expense Transfers
      XECG​Contract and Grants and Special State Appropriation Transfers
      XEPTConstruction in Progress/Plant Expense Transfers
      XEQTInventorial Equipment Expense Transfers
      XPRAPayroll Expense Transfers
      Transfer of Funds (TOF)
      Rule Codes
      XTOF​Temporary Budget Adjustments
      XDCG​Contract and Grants and Special State Budget Transfers
      Balance Sheet Journal
      Rule Code
      XJVBBalance Sheet Account Transfers
      ​Sales Tax Entry Rule Code​XTAX​Invoice Payment Sales Tax Accrual
      ​XPTXProCard Sales tax Accrual
    3. After entering a Rule Code, the cursor will automatically move to the COA (Chart of Accounts) field. X defaults as the value for the COA field. <TAB> twice to get to the FUND field. (The INDEX field is currently unused, except for Balance Sheet Accounts. For Balance Sheet Accounts, enter the appropriate Index code and <TAB> to the FUND field.)
    4. Enter a Fund code or type [F9] List Field Values from the FUND code field to find your Fund code. (Know your Fund code before you initiate a journal voucher.)
    5. <TAB> to the ORGN field and enter your Organization code.
      Note: Prog (Program) Code field will automatically populate with two-digit value defaulted from ORGN code. This field is NOT updatable in FZAJVCD.
    6. <TAB> to the ACCT field and enter your Account code.
    7. <TAB> to the ACTV field. This field is optional. If desired, enter your Activity code.
    8. <TAB> to the LOCN field. The Location Code field is only used by Plant Accounting and Physical Planning & Construction in conjunction with Plant Funds to denote the building for which the corresponding transaction is being posted. Service Center users should always leave this field blank.
    9. <TAB> to the AMOUNT field and enter the amount of your transaction. Do NOT include +/- or $ signs.
    10. <TAB> to the SIGN field. Enter a C for Credit or a D for Debit for TOEs or a plus (+) or minus (-) for TOFs, as appropriate.
      Note: A Debit is an increase to an expense account or a decrease to a revenue account. A Credit is a decrease to an expense account or an increase to a revenue account. For XTOF, XDCG, and XJVB see the rule code descriptions for further details.

      View Image



    11. You will see the cursor in the DESCRIPTION field. This field is mandatory and may contain up to 35 characters. Describe the transaction here. The contents of this field appear on queries and reports. Refer to TOE/TOF Quick Reference Cheat Sheet for description requirements.
    12. <TAB> to the DOCUMENT REFERENCE field and enter the text. This field is mandatory and may contain up to 35​ characters. Appropriate entries for this field depend on the rule code selected. Refer to TOE/TOF Quick Reference Cheat Sheet for document reference requirements.
    13. To add additional entries of the same journal type (rule code) type [down arrow] Next Record and repeat Steps 1 through 12 above.
      Tip: [F3] Duplicate Field copies a specific field from the previous sequence entry in this Journal Voucher.
      Important: If you type [down arrow] Next Record, from your last completed record, a new record is created. If you do NOT want this record, immediately type [up arrow] Previous Record before you enter any field values. You can delete an unwanted, completed (Postable) record by typing [shift F6] Delete Record from within the unwanted record.
      [F4] Duplicate Record will duplicate the entire previous record, not just an individual field.
      Note: Each time you enter a value in a field, the system will edit your entry. If there are errors, the Red Warning message in the upper right corner of your screen will provide an explanation of the error.
      Tip: Select Access Transaction Summary Info [FGIJSUM] from the Related Menu to view a summary of your JV entries on FGIJSUM Journal Voucher Summary Form. You will see a summary of entries by FOAPAL, along with a status indicator for each. To return to FZAJVCD, type [control q].

      View Image



      Note: To print your journal voucher, see Printing Journal Vouchers.
    14. After you have entered all records for this journal voucher, type [alt pagedown] Next Block to go to the Completion Block.

    Completion

    1. Remember to record the Journal Voucher document number and then click on the Complete button to complete your journal voucher. The system performs a final edit to check your total relative to the sum of your debits and credits. If your form is correct you will see the message “Document JXXXXXXX completed and forwarded to the Approval process”.
      Note: If your entry fails the edit for reconciling debits, credits, and the document total, the system will provide an error message window detailing the specific error(s) that need to be fixed.

      View Image



    2. If you choose to leave the JV uncompleted, type [control q] Exit to return to the Banner Welcome page. Remember to record the document number of your JV so you can return and complete it later.
    ​​
    Back to Top
  • Creating a Journal Voucher FZAJVCD (Part 3)

    Deleting Incomplete, Unapproved Journals

    You can delete a journal voucher before it is completed by typing [shift F6] Delete Record twice while in the Journal Voucher Document Header Block.
    Note: Completed but unapproved journals must be disapproved by an approver before they can be deleted via Delete Record process. See Approving Journal Vouchers for more information.
    A completed and approved journal cannot be deleted, and can only be corrected via another journal that reverses the original journal. See Reverse JV (step 5 in Copying section below) for more information.

    Copying Completed and Approved Journal Vouchers

    FIS Banner now allows specific journal voucher to be copied and/or reversed. You can use this feature to reverse incorrect journals or copy frequently-used journal data.
    Caution: Your FIS Rule Code (table, above) permissions apply to any copied journal you create. You will not be able to complete a copied journal containing a Rule Code that you have not been granted specific access to in your account set-up. Each copied journal voucher accounting line containing a Rule Code you do not have permission to use will display 'E' status. Do not copy journal vouchers containing rule codes you do not have permission to access.

    1. Type FZAJVCD in the Banner Welcome page.​
    2. You will see the cursor in the DOCUMENT NUMBER field. Leave 'NEXT' as default value, and click on the Copy icon.
    3. A Copy dialog box will appear:

      Image

      Enter a Journal Voucher number in the Copy From Document Number field. You can click on the Search Icon or type [F9] List from the Copy From Document Number field and the system will go to FGQDOCN List of Transaction History Documents and permit a query on all completed, approved journal vouchers. The queryable fields are Document Code, Document Type (use JV), Submission Number, Commit Type, and Description.
      You can also query in Transaction Date and Activity Date, but you MUST enter a specific date (e.g. 11-FEB-2008) with no wildcard characters (for example, don't use %FEB%2008%). See Query Techniques for details.
      Caution: Queries in FGQDOCN can take several minutes to complete. To speed up your query, use wild cards and enter as much specific information as possible, i.e. Document Code = J0214%, Document Type = JV. Always include Submission Number (value = 0) and Commit Type (value = U). Transaction Date and Activity Date must be entered with a specific date (e.g. 11-FEB-2008) with no wildcard characters.
    4. Transaction Date will default to current date. Change date as needed for month-end reconciliation.
    5. Check Reverse JV to create a journal that reverses all accounting sequence on the "Copy From" journal. Credit accounting sequences on the "Copy From" journal will automatically be entered as debit sequences on the "Copy To" journal. Debit accounting sequences on the "Copy From" journal will automatically be entered as credit sequences on the "Copy To" journal.
    6. Check Copy Text to copy the original text in the "Copy From" journal into the new "Copy To" journal. Important: You will need to update this text to reflect the reasons why you are copying or reversing your original journal.
    7. Click OK, then process your journal starting with Step 3 above- UCSC Journal Voucher Entry Form, making all necessary changes to document text, document total, and accounting information as needed.
      Important: Banner does not record the Document Number of the Journal Voucher number that was copied. For reference, you should note in Document text (FOATEXT) the document number of the Journal Voucher that was copied or reversed. You may insert existing modifiable clauses JVCOPY and JVREV. See Document Text: FOATEXT, for information about inserting clauses in FOATEXT.
    ​​
    Back to Top
  • Locating Incomplete Journal Vouchers FZIJVCD

    ​Use FZIJVCD List of Suspended Journal Vouchers Form as a Stand-Alone form to locate an incomplete or unapproved journal voucher. You can also access FZIJVCD from the FZAJVCD Journal Voucher Entry Form.

    1. Type FZIJVCD in the Banner Welcome page.
      Tip: If you are locating a document so you can work on it, enter [F9] List from the DOCUMENT field in FZAJVCD.
    2. You will see the cursor in the DOCUMENT field. Incomplete journal vouchers are listed. Due to the number of outstanding documents you may choose to query for your journal voucher. Refer to Query Techniques for detailed instructions. The queryable fields are Document, Amount, Transaction Date, User ID and Rule Code. For an example, see FZIJVCD Form.
      Tip: When querying the Transaction Date field in FZIJVCD List of Suspended Journal Vouchers Form, ALWAYS include a wildcard at the end to obtain correct results (the field in Banner includes a time stamp that you do not see). For example, query on Transaction Date by providing a field value of 19-FEB-2008% and then typing [F8] Execute Query. Use the arrow keys to move among the returned JVs.
      Note: When using FZIJVCD as a Stand-Alone form, your query results are read-only. When accessed from FZAJVCD, FZIJVCD query results with I (Incomplete) Status Indicator may be selected and brought into the FZAJVCD Document Number field for processing to completion. Key [Alt S] Select to bring an incomplete JV number back to the FZAJVCD form.
    3. Type [control q] Exit to return to the Banner Welcome page.

    Back to Top
  • Journal Voucher Summary FGIJSUM

    ​Use the Journal Voucher Summary Form as an aid in balancing an incomplete journal voucher and to view how FOAPAL elements, dollar amounts and indicator signs were keyed before completion.

    1. While in the Transaction Detail screen of the Journal Voucher page FZAJVCD, go to the Related Menu and select Access Transaction Summary Info (FGIJSUM).
    2. You will see the page populated with your journal voucher sequences. Use the Page Down & Page Up keys to navigate the rows, and your mouse to select a specific row.
    3. Type [control q] to return to FZAJVCD.
    4. NOTE: FGIJSUM can be used as a stand-alone page accessed directly from the Banner Welcome page.

      View Image




    Back to Top
  • Approving Journal Vouchers FOQJVCD


    ​You can use the pages described below to complete the approval process for documents:

    The first time you sign onto FIS Banner each day and go to any page, if you have any documents in your approval queue, the system will automatically go to FOIAINP Approvals Notification. This only happens the first time you sign on. If you choose not to enter the approval form at that time, FIS Banner will not prompt you to enter it again until you exit FIS Banner and sign on again. You can enter User Approval (FOAUAPP) any time from the Search field on the Banner Welcome page.

    1. From FOIAINP, select User Approval (FOAUAPP) from the Related Menu. FIS Banner will route you to FOAUAPP.

      View Image



    2. Alternatively, if you want to approve a specific document and have the document number available, .<TAB> Next Field to the DOCUMENT field and enter the document number. Otherwise, leave blank to see all documents.
    3. In the NEXT APPROVER field, the unchecked box defaults to view all documents in your queue and in queues below yours where others have the authority to approve the transaction. Check the box to view only documents where you are the next approver, then type [alt pagedown] Next Block. Documents that need your approval will display a “Y” in the NEXT APPROVER field, indicating you are the next approver for this document. You can approve other transactions, but it is not necessary at this time, since they are also in another person’s queue to approve (the other person will have a “Y”). 
    4. You will only receive FOIAINP Approvals Notification when you log into FIS Banner if you have transactions in your queue marked with a “Y”. Multiple users sharing the same queue can have the “Y” and approve the document.
    5. To view document detail in FOAUAPP, click on the Detail icon. FIS Banner takes you to FOQJVCD Journal Voucher Approval Form, where you can view FOAPAL information. Use the arrow keys to scroll through FOAPAL records when there are multiple records.

      View Image



    6. To view Journal Voucher text, select Text Information (FOATEXT) from the Related Menu.
      Important: The text should at least contain answers to the questions who, what, and why.
    7. Type [control q] to return to the approval detail page.
    8. Type [control q] to return to FOAUAPP User Approval. Prior to approval, if you wish to view the document queue, <TAB> to the Queue icon and hit <return>, or click on the Queue icon. The system will go to FOAAINP Document Approval and FIS Banner will fill in the document number. Type [alt pagedown] Next Block to view information for this document. The left side is queue information and the right side provides names of approvers in that queue.

      View Image



    9. If you wish to approve the document at this time, in FOAAINP click on the Approve icon to approve or click on the Disapprove icon to disapprove. Making the approval here or in FOAUAPP performs the same function. 

    10. If you disapprove a document, the Banner Messaging System GUAMESG will automatically send a message to the Banner user who completed the document notifying them that the document has been disapproved. Approvers who disapprove a document can override the default disapproval message with their own personal message:

      View Image

      ​​​

      The user whose document was disapproved will received the personal message:​

      View Image



      ​See Banner Messaging GUAMESG for more information.

    11. Type [control q] when all approvals are complete to return to the Banner Welcome page.
    ​​​​​​​​​​
    Back to Top
  • Journal Voucher Retrieval FGIDOCR

    ​Use a Document Retrieval Form for on-line review of posted journal vouchers. FGIDOCR shows description details.

    1. Type FGIDOCR in the Banner Welcome page.​
    2. You will see the cursor in the DOCUMENT field. Enter the journal voucher document number and type [F9] List and the system will go to FGQDOCN List of Transaction History Documents below and permit a query on all completed, approved journal vouchers. The queryable fields are Document Code, Document Type (use JV), Submission Number, Commit Type, and Description.
      You can also query in Transaction Date and Activity Date, but you MUST enter a specific date (e.g. 11-FEB-2008) with no wildcard characters (for example, don't use %FEB%2008%). See Query Techniques for details.
      Caution: Queries in FGQDOCN can take several minutes to complete. To speed up your query, use wild cards and enter as much specific information as possible, i.e. Document Code = J0214%, Document Type = JV. Always include Submission Number (value = 0) and Commit Type (value = U). Transaction Date and Activity Date must be entered with a specific date (e.g. 11-FEB-2008) with no wildcard characters.
    3. Type [altpagedown] Next Block to see the Detail Information for your document.

      View Image



    4. If the Text Exists field is a “Y” in the Header Information block, users can select Document Text [FOATEXT] from the Related Menu to view text for the JV. System will take you to FOATEXT. Type [control q] to return to FGIDOCR Document Retrieval.

      View Image



    5. Select Access Document Postings [FGQDOCP] from the Related Menu to access FGQDOCP Document Postings Form to see details of Banner posting activities for that record.

      View Image



    6. From FGQDOCP, type [control q] to return to FGIDOCR.
    7. To view another document, from FGIDOCR click on the Start Over button or key F5. Then repeat steps 2-6 above.
    8. Type [control q] to return to the Banner Welcome page when you finish viewing posted JVs.
    ​​​
    Back to Top
  • Printing Journal Vouchers FZRPTJV

    ​Use a Process Parameter Entry Form to print any journal vouchers (incomplete or completed, posted or unposted).

    1. Type FZRPTJV in the Banner Welcome page.​​
    2. You will see the cursor in the PROCESS field of GJAPCTL Process Submission Control Form. FZRPTJV defaults as the process name.
    3. Type [alt pagedown] Next Block. You will see the cursor in the PRINTER field. You can type [F9] List Field Values to access your department's printer code, or you may type your printer code directly. If your printer is not on the list of valid printers, or if you would like to set a default printer code to appear in the PRINTER field whenever you print a journal (or any other process submission such as FPAPORD, FPACORD, FZRPOEL, etc.), please send an email request to fis_probs@ucsc.edu.
    4. You may leave blank the SPECIAL PRINT, LINES and SUBMIT TIME fields. Values for some fields may default based on your printer choice.
    5. Type [alt pagedown] Next Block to specify your Parameter Values.
    6. <TAB> next field to the VALUES field and type the number of the journal voucher you want to print.
    7. Type [alt pagedown] Next Block to the Submission Block. Defaults to Submit. Type [F10] or click on Save to submit your job to the specified printer.

      View Image



    8. Type [control q] to return to the Banner Welcome page when you have printed all the journal vouchers you need to print at this time.
    ​​
    Back to Top
  • Viewing the Open Encumbrance Report FZRPOEL

    The FZRPOEL Open Encumbrance Report is available from Infoview.


    Back to Top
  • Selecting Encumbrances for Liquidation

    What to Consider when Selecting Purchase Orders for an Encumbrance Liquidation Journal

    Important: Select purchase orders for which no further activity is anticipated. Choose carefully; once an encumbrance is fully liquidated, further activity is prohibited. As encumbrances are liquidated, the associated purchase order will be affected as shown in the chart below. (The purchase order item, or the entire purchase order will be closed depending on whether the purchase order was created using document or commodity level accounting).
    After running the Open Encumbrance Report, there are some important factors to consider before closing a purchase order encumbrance.

    Purchase orders should not be selected for encumbrance liquidation if any of the following conditions exist:

    • A credit memo is anticipated. Review any returned goods activity which could indicate future receipt of a credit memo.
    • Shipping charges are anticipated. Review the FOB terms of the purchase order, it may indicate future receipt of a shipping charge. Check FOIDOCH; freight charges may have been invoiced.
    • The PO is an active Blanket purchase order.
    • The PO is an active Not-to-Exceed purchase order.

    How Liquidating Encumbrances Affects Purchase Orders

    Important: Once a purchase order is closed, further activity is prohibited.

    Liquidation’s Effects on POs (Commodity Level Accounting)

    Commodity Level Accounting Effect on Purchase Order Effect on further activity
    Liquidating all Accounting Sequences​ Entire PO (all Items) Closed No further activity allowed
    Liquidating some but not all Accounting Sequences for one item (This process is NOT RECOMMENDED) PO Item will not be closed All items will allow activity BUT, PO’s / INV’s will be OUT OF BALANCE. Change order must correct.
    Liquidating all Accounting Sequences for a commodity item​ Only the item for which encumbrance is being liquidated will be closed. All other items remain open No further activity on closed item. Other items will allow activity

    Liquidation’s Effects on POs (Document Level Accounting)

    Document Level Accounting Effect on Purchase Order Effect on further activity
    Liquidating all Accounting Sequences Entire PO (all Items) Closed No further activity allowed
    Liquidating some but not all Accounting Sequences (This process is NOT RECOMMENDED) PO Items will not be closed All items will allow activity, but accounting sequence which was liquidated will no longer show on change orders or invoices. AND, PO’s / INV’s will be OUT OF BALANCE.
    Change order must correct.

    Back to Top
  • Creating a PO Encumbrance Liquidation Journal Voucher FZAJVEL

    ​Use the UCSC Encumbrance Liquidation Entry Form to enter a Purchase Order encumbrance liquidation.

    Encumbrance Liquidation Entry Form

    1. Type FZAJVEL in the Banner Welcome page.​
    2. You will see the cursor in the DOCUMENT NUMBER field. NEXT defaults. Type [alt page down] Next Block.
      OR, to continue work on an incomplete existing journal voucher, enter the journal voucher number. You can click on the Search Icon or type [F9] List from the DOCUMENT field and the system will go to FZIJVCD List of Suspended Journal Vouchers and show a list of incomplete and/or unapproved journal vouchers, which you can query. See Query Techniques for details. The queryable fields are Document, Amount, Transaction Date, User ID and Rule Code. Key [alt S] to bring an incomplete Journal Voucher number back to FZAJVEL.
      Note: When querying the TRANSACTION DATE field in the UCSC Pending Journal Vouchers Form, FZIJVCD, ALWAYS include a wildcard at the end to obtain correct results (the field in Banner includes a time stamp that you do not see). For example, query on Transaction Date by providing a field value of 19-FEB-2008% and then typing [F8] Execute Query. Key [alt S] to return the desired journal to FZAJVEL.
    3. For new JVs, the TRANSACTION DATE field value defaults to today’s date. To change the date, enter the desired date. For existing JVs, previously-entered date shows.
      Note: TRANSACTION DATE defines the financial period in which the journal voucher will be posted. You must enter a date in an open period. Each month is closed at 7pm on the 7th working day after the end of that month.

      View Image



    4. <TAB> to the DOCUMENT TOTAL field and enter a total that represents the number of transactions on this JV. Each line item transaction is entered as $1.00, NOT the actual encumbrance amount being liquidated. Therefore, the document total is equal to the number of line item transactions.
    5. Document Text is required for completion of all JVs. Select Document Text [FOATEXT] from the Related Menu. The system will go to FOATEXT: General Text Entry Form. Up to 9,999 lines of 50 characters each are available.
      Note: Banner assigns a JXXXXXXX document number when you go to FOATEXT.
      Important: Include answers to the questions who, what, and why in this text field. Include name, unit, and phone number of document preparer. See TOE/TOF Quick Reference Cheat Sheet for specific Document text requirements for different journal types.
    6. Begin typing your message. Use <Down Arrow> Next Record to add more lines (up to 9,999 lines of 50 characters each are available.)
    7. You can insert lines of text between existing lines by entering the text, tabbing to the LINE field, and entering a number that places the text where you want it sequentially relative to the line numbers already defined.
    8. To change the order of lines of text, <TAB> to the LINE field and change the line number so it will be in the desired sequence.
    9. To delete a line of text you no longer want type [shift F4] Clear Record.
      Tip: You can navigate to the end of a line in the Text field using the End key.
    10. After adding your text, type [F10] Save or click on Save button to save your text. The status bar will reflect the number of records saved (each line is a separate record). To return to FZAJVEL type [control q].

      View Image



    11. Back in FZAJVEL, type [alt pagedown] Next Block to go to the Transaction Detail Block.

    Transaction Detail Block

    1. You will see the cursor in the SEQUENCE field. <TAB> Next Field and the appropriate value defaults. (This is the sequence number for this liquidation transaction.) <TAB> Next Field to the Journal Type field. X032 defaults and can only be changed to Z032 for Central Office liquidations. You cannot override the X032 or Z032 rule codes and use FZAJVEL for any other type of transaction.<TAB> Next Field to get to the COA field.
    2. You will see the cursor in the COA field. “X” defaults as the value for the Chart of Accounts field. <TAB> twice to get to the FUND field.
    3. Enter the Fund code from the Open Encumbrance report.
    4. <TAB> to the ORGN field and enter the Organization code from the Open Encumbrance report.
    5. <TAB> to the ACCT field and enter Account code from the Open Encumbrance report.
    6. Cursor will automatically move to the PROG field after entering 6-digit Org code. PROG Program Code value will default from value entered into ORGN field. Do not change this code.
    7. <TAB> to the ACTV field and enter Activity code if this code appears on the Open Encumbrance report for this item.
    8. <TAB> to the LOCN field and enter Location code if this code appears on the Open Encumbrance report for this item. (Note: LOCN field is rarely used at UCSC.)
    9. Banner automatically defaults $1.00 in the AMOUNT field.
    10. Banner will automatically default + in the SIGN field.
      Note: The rule code will liquidate the total encumbrance for the PO item and sequence number that you input. The rule code will process a total liquidation even though the FZAJVEL form indicates an amount of $1.00 and a transaction sign of +.
    11. You will see the cursor in the DESCRIPTION field. A description of “PO Encb Liquidation” will automatically default. This field is mandatory and may contain up to 35 characters. You can modify or override the description that defaults into this field if you want a different description.
    12. <TAB> to the ENCUMBRANCE NUMBER field. Enter the Purchase Order number in the ENCUMBRANCE NUMBER field.
    13. <TAB> to the ITEM NUMBER field. Enter the Item number to be liquidated from the PO.
    14. <TAB> to the SEQUENCE field. Enter the Sequence number in the SEQUENCE field. (This is the sequence number of the item on the PO.)
      Note: The entries to ENCUMBRANCE/ITEM/SEQUENCE must exactly match the data from your Open Encumbrance report.
    15. Banner will automatically default T (for Total) in the ACTION field, and U (for uncommitted) in the COMMIT TYPE field.
    16. <TAB> to the DOCUMENT REFERENCE field. Banner will automatically default the PO number you entered into the ENCUMBRANCE NUMBER field. Do not change this value.

      View Image



    17. To add additional entries type [down arrow] Next Record and repeat Steps 1 through 15 above.
    18. If the data entered for the record has errors, an Edit Error Messages screen will provide feedback. Click on the Close button in the lower right corner of the screen to return to the Transaction Block and correct your entries.
    19. To add additional entries of the same journal type (rule code) type [down arrow] Next Record and repeat Steps 1 through 12 above.
      [F3] Duplicate Field
      copies a specific field from the previous sequence entry in this Journal Voucher.
      [F4] Duplicate Record will duplicate the entire previous record, not just an individual field.
      Important: If you type [down arrow] Next Record, from your last completed record, a new record is created. If you do NOT want this record, immediately type [up arrow] Previous Record before you enter any field values.
      You can delete an unwanted, completed (Postable) record by typing [shift F6] Delete Record from within the unwanted record.

    20. After you have entered all records for this journal voucher, type [alt pagedown] Next Block to go to the COMPLETION Block. An additional edit will be performed. Any errors will be displayed. If errors are displayed, click on the "Close" button. After resolving any errors, navigate to the Completion block again.
    21. Click on the Complete button to process the JV you just created, or click on the In Process button to delay processing.
    22. Type [control q] to return to the Banner Welcome page.

    Important: Do not leave the JV uncompleted. Encumbrance liquidation journals should be done immediately after printing the Open Encumbrance Report. The encumbrance liquidation journal will not post if payment activity has occurred between the time the report is printed and the time the journal is completed, and the payment activity completely liquidates the encumbrance. Banner will allow you to complete the journal without an error message; however, the posting process will reject the journal by resetting its status to incomplete, even if it has already been completed and approved. It is advisable to query UCSC Pending Journal Vouchers Form FZIJVCD after completing an encumbrance liquidation journal (allow some time for posting to occur). Querying FZIJVCD, or running the Open Encumbrance report again are the only ways of identifying Encumbrance Liquidation Journals that did not go through posting and were reset to incomplete.
    FPPPOBC
    Please be aware that the FAST office initiates a production process FPPPOBC (Purchase Order Batch Close) each month to automatically liquidate purchase order line items that have had no activity for at least 120 days with a balance of less than $10.00. This process only impacts purchase orders that begin with a “P”.​ FPPPOBC journals are identified in FGIENCD as document type POBC. Contact FAST at aphelp@ucsc.edu for questions.


    Back to Top
  • Key Tip: UCPath Transactions

    Journal Transaction Description Changes
    JOURNAL PREFIX FIS JOURNAL TRANSACTION DESCRIPTION EXPLANATION
    LD Check Date MM/DD/YYYY

    Expense-RPNI Assessments
    Payroll Expense

    UCRP Supp Assessment Interest Expense
    LW W/S Salary Offset

    W/S Benefit Offset
    Work-Study Salary Expense Offset

    Work-Study Benefit Expense Offset
    LB Benefit Pool Offset Benefit Pool Offset for Vacation Accrued/Taken
    UCPath Account Codes
    ACCOUNT TITLE
    P68530 GAEL/ Employee Support
    P68933 Terminal Vacation Paid
    P68850 Composite Benefit Rate (CBR)
    P01960
    P11960
    P21960
    Compensatory Time Accrued
    ​ ​​​

    Back to Top
  • Establishing Grants

    Establishing Grants in Banner is a function of the Extramural Funds Office [EMF] of Financial Affairs.
    The main forms for creating and maintaining grants in Banner are:


    Back to Top
  • Grant Maintenance FRAGRNT

    FRAGRNT is used to create and maintain grant records. A grant must be created in FRAGRNT before it can be associated with a fund code in the FTMFUND page. Note that only the Main and Personnel tabs in FRAGRNT are required.

    Banner Tip: Press F2 to bring up a list of the tabs allowing use of the Up and Down arrows keys [this works only for forms with tabs].

    • View Image


      Grant details found on the FRAGRNT Main tab:

      • Responsible Organization: Not currently used.
      • Long Title: 256 character grant title/description.
      • Title: When first creating a grant, the first 35 characters of the Long Title will display in the Title field. You may change the text in this field if you want. The title in this field is carried forward to FTMFUND and FRMFUND forms.
      • Requires Effort Certification: Not used. Checked or unchecked has no impact. Effort Certification is currently an external system.
      • Agency: The Banner ID and name of sponsor who awarded the grant funding. For EMF maintenance: click on arrow or press F9 to query on existing agencies. New agencies are added via form FTMAGCY – Agency Code Maintenance.
      • Principal Investigator ID: The Banner ID and name of the primary researcher conducting and managing the project. For EMF maintenance: FIS recommends PI data be entered on the Personnel tab which allows more flexibility in querying for persons. See Personnel section below.
      • Project Start Date & Project End Date: The dates from which costs can be incurred to the date the project is complete and all costs charged. For EMF maintenance: These dates will populate the Budget Period Dates in FRMFUND when creating a new FRMFUND record.

      Banner Tip: Double-click in most date fields to bring up a calendar. Double-click on a day in a calendar to populate the date field.

      • Proposal: Not used in Banner.
      • Termination Date: Date the grant ended. Must be equal to or greater than the Project End Date.
      • Expenditure End Date: Currently not used.
      • Status: Either active [A] or inactive [I].
      • Pass Through Indicator: Currently not used.
      • Alternate Description: Optional 35 character field for comments appended to Status indicator. Status history can be viewed in form FRIGRST [Grant Status History].
      • Status Date: Last date the grant record was updated.

      Banner Tip: In most date fields, entering a single, non-numeric character followed by Enter or Tab will display the current date. Just remember T for Today.

      • Current, Cumulative & Maximum Amounts: Optional fields indicating the amount of the most recent increment of funding, the amount awarded to date and the maximum funding the sponsoring agency will award for the grant.
      • Total Recipient Share & Related Grant: Not used.
      • Grant Type: Refers to applicable OMB circular for federal funds.
      • Category: This field is not used. See Sub Category.
      • Sub Category: Four character code identifying the project sponsor. For EMF Maintenance: Click on the arrow or press F9 to select the appropriate Sub Category [note the 2-character Category is also listed]. New Sub-Category codes are maintained only by FIS.
      • CFDA Number: Code identifying the federal program in the Catalog of Federal Domestic Assistance. For EMF Maintenance: Click on the arrow or press F9 to select the appropriate CFDA code. Use FRVCFDA – Catalog of Domestic Assistance Codes form to create new CFDA codes.
      • Sponsor ID: 30 character free form field for the reference number of the sponsoring agency.

      The Personnel tab is used to maintain and view persons associated with the grant. Only the ID, Indicator, Chart of Accounts and Organization fields are currently used.

      • View Image


        Personnel details found on the FRAGRNT Personnel tab:

        • ID: The Banner ID number for the person. For example, @00084434. For EMF Maintenance: Click on the arrow, then select Person Search Form-FOIIDEN to find and select the correct Person and Banner ID.

        • View Image


          See Query Techniques to help with queries when using FOIIDEN.

          • View Image



            • Indicator: The Indicator code identifying a person’s grant role.
            Grant Role Indicator
            Number
            Description
            Principal Investigator 001 - PI conducts and manages a sponsored project.
            - Identified by Office of Sponsored Projects [OSP].
            - The default person to certify effort in Effort Reporting System [ERS].
            - Required for effort reporting.
            - Banner does not allow multiple 001’s.
            - Is never assigned an org.
            Grant Accountant 002 - Provides support to Campus Business Offices.
            - Identified by EMF.
            - Optional.
            - There should only be one 002 indicator per grant record.
            - Is never assigned an org.
            Co-PI 003 - Shares sponsored project management with PI.
            - Identified by OSP.
            - Required only if called out by OSP.
            - Banner accepts multiple 003’s.
            - Never use org.
            Report Certifier 301-310 - Person(s) designated by PI to certify effort on sponsored project.
            - Identified by Campus Business Offices.
            - Required only if called out by ERS [they provide specific instructions].
            - Banner accepts multiple Report Certifier roles. But the combination of ID and Indicator must be distinct.
            - Org always required.

    Back to Top
  • Fund Code Maintenance FTMFUND

    This section is about fund records as they pertain specifically to grants.

    FTMFUND is used to create and maintain fund records. A grant must be created in FRAGRNT before it can be associated with a fund code in FTMFUND.

    Banner Tip: Use the Fund field for queries to ensure accurate query returns.

    • View Image



      • Active Status: The default is checked to indicate the record is active. Unchecked indicates the record is inactive.

      Banner Tip: Using the space bar on a check box is the same as clicking with the mouse.

      • Grant: The Grant code created in FRAGRNT. The FRAGRNT title field will display. When the title in FRAGRNT is changed, the grant title in FTMFUND is automatically updated.
      • Last Activity Date: System generated date representing the last date the fund record was updated.
      • Proposal: Not used.
      • Fund: The Fund code must always be the same as the Grant code. A mismatch will cause posting and reporting errors.
      • Title: 35 character title.
      • Effective Date: The date the fund record goes into effect.

        IMPORTANT NOTE FOR UCPATH
        For Fund Codes that will be used in conjunction with UCPath, consider the date you will need the Fund Code to be effective for Funding Entry. If needed, the Fund Code can be backdated upon creation in Banner so that the associated Funding Entry can be made effective as of that date.​

      • Termination Date: The fiscal year end-date of the retention period for a closed fund.
      • Next Change Date: System generated date of the next record’s effective date. When blank, it means this is the record currently in effect.

      Banner Tip: In most date fields, entering a single, non-numeric character followed by Enter or Tab will display the current date. Just remember T for Today.

      • Expenditure End Date: Not Used.
      • Data Entry: When checked, the fund record can be used for data entry purposes.
      • Grant Requires Effort Certification & Fund Requires Effort Allocation: Not used. Checked or unchecked has no impact.
      • Fund Type: Identifies the type of fund [state agencies, federal funds, etc].
      • Predecessor Fund: Identifies the category within the fund type [National Science Foundation, ARRA Contracts, etc].
      • Financial Manager: Not Used.
      • Unbilled AR Account: Account code used for revenue recognition in the General Ledger [rule code GRAR – Accrued Accounts Receivable].
      • Revenue Account: Account code used for revenue recognition in the Operating Ledger [rule code GRRV – Accrued Revenue].
      • Bank and Cash Receipt Bank Code: Not used.
      • Capitalization Fund Indicator: Used by the Fixed Assets module.
      • Capitalization Equity Account and Capitalization Fund: Not used.
      • Multiple Fund Balance Indicator: Directs the system to the appropriate Fund Processing Balance Accounts that will be affected during Year End Processes and Concurrent Year Processing.
      • Restriction Indicator: Defaults to Unrestricted.

    Back to Top
  • Fund Local Attribute Maintenance FZMFUND

    FZMFUND is used to create and maintain fund attributes for UCOP, UCSC and UCPath. A fund must be created in FTMFUND before a record can be created in FZMFUND.​

    • View Image



      • UCOP Attributes: Attributes are required from all campuses and are based on the UCOP Fund Group Code. See UCOP’s Appendix C for details.
      • UCPath Attributes:
        • UCPath Everify Ind: Used when a fund requires e-verify processing in UCPath, set by EMF during fund attribute setup.
        • UCPath Budget Offset Org: Update only as directed by Budget Analysis and Planning.
        • UCPath Fed Recharge Ind: Update only as directed by Budget Analysis and Planning.
      • UCSC Attributes:
        • Budget Roll Update is used by the FIS office for fiscal close processes.
        • Federal Financial Report (FFR) is used by EMF for specific federal fund designation.
        • Grant Billing fields are updated by EMF as required.
        • BAP Use: Budget Analysis and Planning will update as needed.
      • CCOA Attributes:
        • UCOP has implemented a financial system which requires campuses to use a Common Chart of Accounts (CCOA) format. At UCSC, we are translating our Chart of Accounts elements through a series of attributes entered into FIS Banner, and transmitting to UCOP for processing. For additional information about entering CCoA Fund Attributes, see Appendix D of the FIS User Manual.
    ​​​
    Back to Top
  • Research Accounting Fund Maintenance FRMFUND

    FRMFUND is used to associate cost codes for grants. A grant must be created in FRAGRNT and a fund must be created in FTMFUND before you can create a FRMFUND record.

    • View Image



      • Fund: Fund code and title as created in FTMFUND.
      • Grant: Grant code and title as created in FGAGRNT. When the short title in FRAGRNT is changed, the grant title in FRMFUND is automatically updated.
      • Effective Date: The date the record is effective. This should be the same as the FTMFUND effective date [when EMF creates a new record].
      • Termination Date: The date the record is no longer usable.
      • Budget Period Dates: Upon creating a new record, these dates default from FRAGRNT.
      • Encumber Multi Year Labor & Indirect Cost Encumbering: Not used.
      • Indirect Cost Basis: Represents a list of accounts used in indirect cost calculation. These codes are maintained by EMF in form FTMBASI – Basis Definition Code Maintenance.
      • Indirect Cost Rate Code: Rate of indirect cost. These codes are maintained by EMF in form FTMINDR.
      • Indirect Cost Charge Account Code: Determines what account code to charge for indirect cost. This is maintained by EMF in form FTMINDA – Indirect Cost Charge Code Maintenance.
      • Indirect Cost Distribute to Code: Tells Banner how to distribute indirect cost. Maintained by EMF in form FTMINDD – Indirect Costs Distribution Maintenance.
      • Cost Share fields: Not used.
      • Billed Accounts Receivable: Used for the Billed A/R account column in report FZXEMAR [EMF Unbilled & Receivables Ext].
      • Cash Receipt Bank Code: Not used.
      • Revenue Account & Unbilled Accounts Receivable: Default values from FTMFUND.
      • Retainage fields: Not used.

    Back to Top
  • Fund Code Edits Report FZRFUND

    FZRFUND helps identify specific errors in grant and fund records. Used by FIS and EMF.

    1. In the Banner Welcome page, type FZRFUND.
    2. Perform alt + pg down until you are in the Parameter Values box. The As of Date should default to today. If not, remember T for today.
    3. Perform alt + pg down to navigate to the Submission block. Press F10 to submit your report.

    For sustainability purposes, FIS recommends using the DATABASE method for running this report to prevent using paper. See Reporting (Part 4) for specific directions.

    FZRFUND will identify:

    • Missing FZMFUND records.
    • Missing Fund Group Code.
    • FTMFUND records where the Multiple Fund Balance Indicator is other than the default.
    • FTMFUND records where the Grant code and the Fund code do no match.
    • Missing pred funds.
    • FTMFUND records with future effective dates.

     

    Back to Top
  • Grant Queries

    Back to Top
  • Grant Agency Inquiry FRIASTG

    Use FRIASTG to display all grants associated with a single agency. Enter the Banner ID in the header then perform control + pg down.


    Back to Top
  • Grant Personnel Inquiry FRIPSTG

    Use FRIASTG to display all grants associated to a single person. Enter the Banner ID in the header then perform control + pg down. This can be queried for any person having a grant role [001, 002, 003 301-310].


    Back to Top
  • Grant Inception to Date FRIGITD

    Use the Grant Inception to Date Form to retrieve grant budget and expenditure information. This is a query only form. Grant financial information can either be viewed in total, or for a specific span of time.

    1. In the Welcome to Banner page, type FRIGITD. Type <return>.
    2. You will see the cursor in the Grant field. Enter the grant code (the grant code is identical to the fund code). The Grant is a required field to use this form.
    3. To view all information for a specific grant, leave the remaining fields of header block blank.
    4. Type [alt + page down] to display Inception to Date information in the detail block. The Date From and Date To fields specify the pertinent dates for the data being displayed. The Type column displays the kind of account code charged:
      • E for Expense
      • L for Labor
      • R for Revenue
      • T for Transfer

      • View Image



        • The default is to display data beginning from the project start date to today. You may view data for a different period. Click on the Start Over button. Tab to the Date From field and enter the beginning month/year then ending month/year in the Date To field as desired. Type [alt + page down] to display Inception to Date information for this period.
        • You may further specify data to be viewed for a grant by entering codes in the Header Block fields provided:
          • Index: Not currently used.
          • Fund: Enter a fund code. Fund codes are the same as the grant code. Alternatively, this can be left blank since the Grant Code field is required.
          • Organization: Enter an organization code if you would like a specific view. Leave blank and all orgs used on grant will be included.
          • Program: Enter a program code in this field to query a specific program. Leave blank to include all program codes.
          • Activity: Enter an activity code to query a specific activity. Leave blank to include all activity codes.
          • Account Type or Account: Enter an account type or account to view specific expenditure and budget information. Leave blank to include all.
            Note: You may query either account type OR account code, but NOT both.
          • Date From and Date To: These fields default starting with the project start date to today. Change dates as needed.
          • Include Revenue: Check the Include Revenue box to see revenue in your query.
          • Account Summary: Select Level1 or Level2 Acct Types from the drop down list to display query results by level 1 or level 2 account types. Selecting Budget Pool displays query results by Budget Pool accounts [similar to what is viewed in FIS report, FZRSITD]. See example below for query by Budget Pool with revenue included. The Include Revenue check box works in tandem with these Account Summary selections.
          • Exclude Indirect Costs: Check this box to exclude indirect costs [expenses and budget].
          • Fund Summary: Currently not used.
          • By Sponsor Account: Currently not used.

        • View Image


          Transaction Detail Information

          From the detail block, detailed transaction information can be viewed by selecting Grant Detail Information [FRIGTRD] from the Related Menu. After reviewing, type [control q] to return to FRIGITD. Note: if your query was by Budget Pool from the Account Summary drop down list, the Related Menu selection will read Grant Transactions by Pool [FRIGTRD].

          View Image



    Back to Top
  • Grant Transaction Detail Form FRIGTRD

    Use the Grant Transaction Detail Form to retrieve detail grant budget and expenditure information. This is a query form only. Grant financial information can either be viewed in total, or for a specific span of time [by changing the Date From and Date To fields].

    1. Enter grant code in the Grant field. Type <return or tab>. This is a required field. Note that the Date From and Date To fields populate.
    2. Perform alt + page down to navigate to the detail block. Press F8 to perform query. Query results are ordered by Account, Organization and descending Activity Date.

      View Image



    3. You may further specify data to be viewed for a grant by entering codes in the Header Block fields provided:
      • Index: Not currently used.
      • Fund: Enter a fund code. Fund codes are the same as the grant code. Alternatively, this can be left blank since the Grant Code field is required.
      • Organization: Enter an organization code if you would like a specific view. Leave blank and all orgs used on grant will be included.
      • Account: Enter an account code to view specific expenditure and budget information. Leave blank to include all. Note: You may query on a specific budget pool account by first checking the Pool box, then entering the pool account code. See example below displaying budget and expense query results for pool account CG6000.
      • Program: Enter a program code in this field to query a specific program. Leave blank to include all program codes.
      • Activity: Enter an activity code to query a specific activity. Leave blank to include all activity codes.
      • Location: Not currently used.
      • Commit: Not currently used.
      • Year and Period: For Grant Year queries – not used by UCSC.
      • Date From and Date To: These fields default starting with the project start date to today. Change dates as needed.

        View Image



    4. To execute another query, click on the Start Over button to return to the header block. Then, enter query criteria.
    ​​
    Back to Top
  • Reporting (Part 1)

    FIS Banner Reporting

    This section contains information about reports produced by FIS Banner. Please note that you can also access certain financial reports from UCSC's Infoview system. Be aware that Infoview data is refreshed nightly, and will not show real-time changes to FIS. For instance, a journal transaction which posts at 3pm will not appear in Infoview until the following morning, prior to the start of the business day (7:30am). For more information, visit Data Management Services at https://datamgmt.ucsc.edu/infoview/index.html.

    Overview

    FIS offers three methods for retrieving data from Banner. Depending on your specific reporting needs, you can:

    • Get a report from your printer. This is done by accessing the Process Submission Control Form (GJAPCTL) where you enter parameters to specify output (See the Reports Listing at the end of this section for a list of the most commonly used printed reports).
    • Have a PDF report delivered to your desktop. (Not all reports are PDF capable. See the Reports Listing at the end of this section for reports available in PDF).
    • Download query into Excel. You can query in a FIS form, such as FGITRND, and download query results into an Excel file on your desktop. (Not all forms are enabled for this function. See the Reports Listing at the end of this section for forms enabled for exporting to Excel).

    The following explains how to get a report using these various delivery methods, and how to prepare your desktop for PDF/Excel files. At the end of this section is a list of reports with their descriptions and delivery methods (Printer, PDF, or Excel) for a specific report.

    Banner Tip: You may return to a recently used form by selecting it from the File menu, where up to ten form names are displayed.

    Printing Reports Directly to Your Printer

    Important: Before printing from FIS, your printer must be registered with ITS and configured properly.
    Click here to learn more about ITS support for printer setup.
    Printing reports from FIS is handled by the Job Submission process, which enables you to execute a report without having to exit the Banner application. Job Submission is carried out by form GJAPCTL (Process Submission Control Form). To print a report:

    1. In the Go to... field on the Banner Menu Form, type GJAPCTL <return>.
      Tip: You can save a few keystrokes by typing in the report name, instead of the form name, in the Go To…. field (then press Enter).
    2. In the Process field, enter the name of the report you want to print.. See the Reports Listing at the end of this section for a list of the most commonly used printed reports.
    3. Type [alt pagedown] Next Block to the Printer Control block. Enter the Printer Code of the printer you want to send the report to in the Printer field (press F9 List of Values or click on the Search icon to see a list of printer codes).
    4. Type [alt pagedown] Next Block to the Parameter Values block. Enter the appropriate parameters in the Values column. Use caution with Optional parameters. This may result in long printed reports with unwanted data.
    5. Type [alt pagedown] Next Block to the Submission block. Click on ‘Save Parameter Set’ (this is optional) to save the values you just entered for the next time you want to print the same report.
    6. Type [F10] to Commit your entered values. Your report will not be submitted for output until you commit it.

    View Image


    The ‘Log File’ information displayed as a green notification message indicates your print job has successfully been submitted to the FIS print server, which sends the print job to your printer. Most printouts will appear on your printer almost immediately.




    ​​​
    Back to Top
  • Reporting (Part 2)

    Exporting Data from FIS to Excel

    You can download data from some (but not all) FIS pages and export that data to Excel. For example, you could query on ledger activity for a specific FOAPAL in FGITRND. Then, download the displayed results of the query to an Excel spreadsheet. This feature is called Export.

    To download data from a Banner page into Excel:

    1. From the Banner Welcome page, enter the name of the Banner page you wish to extract data from (e.g. FGITRND, FGIBDST, etc.) then key <return>.
    2. Perform your page query. 
    3. Once query results are displayed, go to Tools > Export, or key Shift-F1.

      View Image



    4. Depending on your browser’s settings, you may see a File Download box (similar to those below) and you may be prompted to Open or Save the downloaded file.

      View Image



    5. Immediately save the file.

      View Image




    Back to Top
  • Reporting (Part 3)

    Database Export Process

    Banner 9 allows users to ‘print’ certain reports such as FABMATC, and FZRPTJV directly to their desktop via the Database Export method, without sending them to a local printer.​

    1. Run the report as usual, using DATABASE in the Printer field.

    2. Upon Save, note log file number in message:

    3. Go to > Related > Review Output. The GJIREVO screen will appear. Click on the '...' to the right of the File Name field.  



      The Available Files window will display. Select the file having .lis in the file name, by double-clicking on the file name or clicking OK.



    4. The report should now display within the GJIREVO window. Scroll to view the report contents.

    5. To extract the report to your desktop, to save as a Word or Excel doc, click F10-Save or go to Tools > Options > Show Document, then select ‘Save File’ when this box pops up:

    6. Click OK when this box appears:

    7. The report will be available for viewing at the bottom of the browser window:

    8. Once the file is opened on the desktop, you can save it in Excel format or print to PDF.
    ​​​​​​​
    Back to Top
  • Reporting (Part 4)

    Reports Listing

    If you are in a Central Office and/or have access to special FIS reports that you do not see on this list, or have questions, please contact fis_probs@ucsc.edu.

    Form or Report Name​ Title Description​ Delivery Method​ Instructions​
    FGRACTH​ Account Hierarchy REPORT Prints a list of Account Codes, and their roll-up codes. Printer or Database Submit print job via GJAPCTL.
    Note: Most users like this for Non-inventorial expense accounts (Account Type 71).
    FGRFNDH​ Fund Hierarchy REPORT Prints a list of funds and their hierarchy in order of fund type. Printer or Database Submit print job via GJAPCTL.
    ​FGRGLTA General Ledger Detail Transaction REPORT Prints General Ledger accounts activity by fund. Printer or Database Submit print job via GJAPCTL.
    FGRORGH Organization Hierarchy REPORT Prints a list of Org codes and their roll-ups. Printer or Database Submit print job via GJAPCTL.
    Tip: Use Level 3 or Level 4 org to prevent printing entire list of UCSC orgs.
    FPAPORD Purchase Order PRINT This will print a specific Purchase Order which has been approved. Printer Submit print job via GJAPCTL.
    FZRACTV Activity Codes by Prefix REPORT Lists Activity Codes; includes selection by Activity Code prefix Printer or Database Submit print job via GJAPCTL.
    FZRPTJV Journal Voucher Print REPORT This reports prints details of a selected Journal Voucher Printer or Database Submit print job using GJAPCTL.
    FZRYE127B Balance Sheet Summary Prints Expenditure information for a selected Chart, Fiscal Year, and Period Printer or Database Submit print job using GJAPCTL
    FZRYE127E Expenditure Summary Prints Revenue information for a selected Chart, Fiscal Year, and Period Printer or Database Submit print job using GJAPCTL
    FZRYE127R Revenue Summary Year end budget status by Fund/Org for specific Fund Type and/or Budget Roll Indicator Printer or Database Submit print job using GJAPCTL
    FABMATC Receiving Matching Process Matches Invoices being paid versus items received when Receiving is being used. Displays results in form of report Printer or Database Submit print job using GJAPCTL
    FAIVNDH Vendor Detail History PAGE This form lists invoices, credit memos, and check numbers for a specific vendor. Can query by single Fiscal Year, or Fiscal Year can be blank for all FYs. Excel Query in page, then Export (F1) to Excel.
    Caution: if FY left blank, query can take several minutes.
    FGIBDSR​ Executive Summary PAGE This form performs budget queries using roll-up FOAPALs. Excel Query in page, then Export (F1) to Excel. 
    FGIBDST Organization Budget Status PAGE  This form does Budget queries for specific FOAPALs. Excel Query in page, then Export (F1) to Excel. 
    FGIDOCR Document Retrieval Inquiry PAGE This form is used to view posted journals (and other posted documents). Excel Query in page, then Export (F1) to Excel. 
    FGIENCD Detail Encumbrance Activity PAGE This form shows activity against each accounting sequence for an individual encumbrance. Excel Query in page, then Export (F1) to Excel. 
    Important: To download activity, navigate to that block first.
    FGIGLAC General Ledger Activity PAGE This form shows detailed transaction activity for General Ledger accounts by account number. Excel Query in page, then Export (F1) to Excel. 
    FGIJSUM Journal Voucher Summary PAGE This form provides shows journal voucher transactions that are not yet posted. Excel Query in page, then Export (F1) to Excel. 
    FGITBSR Trial Balance Summary PAGE This form enables you to query on specific funds and General Ledger accounts. Excel Query in page, then Export (F1) to Excel. 
    FGITRND​ Detail Transaction Activity PAGE This form enables you to query for detail on specific funds and Operating Ledger accounts. Excel Query in page, then Export (F1) to Excel. 
    FOAPOXT Procurement Text Entry PAGE Text form used for Purchase Orders and Invoices. Excel Query in page, then Export (F1) to Excel. ​
    FOATEXT​ General Text Entry PAGE Text form used for Journal Vouchers. Excel Query in page, then Export (F1) to Excel. 
    FPIOPOB​ Open Purchase Orders by Buyer PAGE This form displays a list of Open Purchase Orders by Buyer. Excel Query in page, then Export (F1) to Excel. 
    FPIOPOV Purchase Orders by Vendor PAGE This form displays a list of Open, Closed, Cancelled, or Incomplete Purchase Orders by Vendor. Excel Query in page, then Export (F1) to Excel. 
    FPIPOHD​ Purchase Order Validation PAGE This form provides a list for all Purchase Orders. Excel Query in page, then Export (F1) to Excel. 
    Note: Speed up queries in this form by entering criteria, such as PO Date.
    FRIGITD​ Grant Inception to Date Summary PAGE This form displays inception to date activity summary by Account Type or Account Code Excel Query in page, then Export (F1) to Excel. ​
    FRIGTRD Grant Transaction Detail PAGE This form displays inception to date activity detail. Excel Query in page, then Export (F1) to Excel. 
    FYILTRP UCSC Trip Number List PAGE This form lists Trip Number data for Open and/or Closed trips. Excel Query in page, then Export (F1) to Excel. 
    FZIABAL​ Budget Availability Status PAGE This form displays Available Budget, YTD Expenditures, Open Encumbrances and Available Balance by Pool Account when querying by Org. Excel Query in page, then Export (F1) to Excel. 
    FZIAGLC AIS-General Ledger Interface PAGE This form shows details for the AIS-FIS interface postings. Excel Query in page, then Export (F1) to Excel. 
    FZIDOCR Completed Document Retrieval PAGE This form is used to see FOAPALs of posted documents, in list format. Excel Query in page, then Export (F1) to Excel. 
    FZIJVCD UCSC Pending Journal Vouchers PAGE This form lists pending Journal Voucher. Excel Query in page, then Export (F1) to Excel. ​
    TIP: Query by USERID to find your pending JVs.
    ​​
    Back to Top
  • Glossary Of Terms

    Accountability: To be answerable for the results of an assigned action. Accountability is associated with delegated authority and is distinct from responsibility. A supervisor can assign responsibility but cannot give away his/her accountability; the manager is ultimately accountable.

    Account: A category of an expense, revenue, asset, liability, or equity for which transactions are recorded separately.

    Account Code: A six digit alpha-numeric code that classifies assets, liabilities, fund balances and system control for the General Ledger and revenue, expenditures and transfers for the Operating Ledger. Account codes are organized in a hierarchy for each account type.

    Acquisition: Acquisition refers to all processes involved in requisitioning, ordering, transporting, handling and paying for goods and services.

    Activity Code: An up to six character alpha-numeric code used to record cost center or other unit-defined data in the Chart of Accounts. Each unit has a unique two-letter prefix to begin their desired activity codes, which are assigned by Budget and Planning Analysis. Unlike all other FOAPAL elements, activity codes are not hierarchical. Activity codes are optional.

    Amendment: See Change Order.

    Approve: To sanction or officially confirm that a transaction is appropriate. Approving is the technical step done by the transaction processor after they have received appropriate authorization. The approver checks that the authorization is valid, funds are available and being used for an appropriate item, policies are followed, etc. One can only approve with authorization. The authorization and approval processes imply a separation of duties.

    Asset: Resources owned by the University.

    Authorize: To agree to the commitment of funds for a specified use; authorization can only be given by a person who is responsible for the funds in question. Note that FIS Banner uses the term “approve” when referring to the authorization of encumbrances.

    Audit: An official investigation that puts pieces of information together to see the whole, conducted or overseen by internal or external auditors.

    Authorize: Official decision to confirm that a transaction may occur. To authorize is to give permission to take an action. The action is then forwarded for processing and approval. Authorization is the precondition to approval, and is part of the initiation of a process. One may authorize without approval, assuming they have delegated authority. One may NOT approve without authorization.

    Auto Help: The help line that appears below all Banner forms prompting action. Such as “Enter document number; use NEXT or leave blank to generate number.” The message displayed is for the field in which the cursor is located and changes as the cursor moves from field to field.

    Balance Sheet: General Ledger Accounts used to identify assets, liabilities, system control and fund balances.

    Banner: See FIS Banner.

    Blanket PO: A type of purchase order for goods or services that extends over the period of the fiscal year. Permits the payment of multiple invoices that all utilize a consistent unit of measure and unit price. Funds are encumbered for the total amount indicated.

    Block: The information displayed in a Banner form is grouped into blocks. A block is a subset of related information fields utilized for data input or query. Each block has a block name and is separated by a solid horizontal line.

    Budget Period: The period (month or year) used in posting budgetary transactions. At UCSC budgets are annual, so Period 1 refers to the current fiscal year.

    Business Officer: The individual who has primary responsibility for overseeing the organizational unit’s budget and financial status. This individual may be a senior administrative official, a management services officer, a department manager, etc.

    Buyer: A professional buying specialist in Central Purchasing or the department or unit staff responsible for coordinating the requests for acquisitions of goods and services.

    CAAN: Capital Asset Account Number, also known as building code. Used to designate location of inventorial equipment. In Banner, the CAAN is used in the location code field for certain transactions. See Location Code.

    Change Order: A document that changes a completed and approved purchase order.

    Chart of Accounts: The overall structure into which all FOAPALs are organized. At UCSC, there is one chart of accounts (COA) named “X”; this defaults into all transaction and query forms and cannot be changed.

    Commodity: Something that is bought or sold. Any movable or tangible object that is produced or used as the subject of barter or sale.

    Commit: [F10] The Banner command that saves changes in the current transaction to the database.

    Component: Item with a cost of $1500.00 or more that permanently increases the value of a specific (as identified by property number) University owned unit of inventorial equipment, is not complete in itself, and thus is not separately inventoried.

    Control: Action(s) taken to mitigate risk in the achievement of a business objective.

    Control Account: A summary account used in posting to the general ledger. Activity that occurs at the operating ledger level (such as revenue, expenditures and transfers) are summarized in various control accounts for display and reporting within the general ledger. These entries are generated automatically by the posting process; and keep the general and operating ledgers in balance with each other.

    Cost Center: A method of isolating costs of a particular project, activity, or function identified by the campus unit or a contract or grant.

    Count Query Hits: [Shift F2]: In a query screen this keystroke combination counts the number of records retrieved by your query. The count appears in the lower left corner of your screen.

    Cumulative: Balances or balance forward figures for activities within the current year-to-date.

    Data: Information that has been entered in FIS, everything from transaction records to vendor addresses to FOAPALs.

    Database (DB): A series or group of tables or files that organize and standardize information in logical ways. A simple example is an address book. Each person’s address listing is a like a record in a database.

    Data Entry Level: The lowest level in the Chart of Accounts code hierarchy, and the level you work in to code transactions and input data. Sometimes referred to as Recording Level.

    Data Integrity: The principle that all administrative data is correct, timely, complete, and in compliance with policies (e.g. Federal, State, University, etc.) Data has integrity when it accurately reflects the state of the object it is supposed to describe.

    Description Field: A field on the Banner form that describes the current transaction.

    Document Number: A unique eight-digit system assigned number that identifies each document.

    Doc. Reference Code: A six character code used on journal vouchers to identify the type of transfer being performed, or to reference a previous document whose postings are being corrected.

    Drill Down: Process of navigating from one form to another advancing to the next level of detailed information. Each subsequent “drill down” takes you to a lower level of detail.

    EIMR: Equipment Inventory Modification Request. Sent to Equipment Administration to notify them of fabrications, equipment loans, losses, thefts, transfers or other transactions, and to request authorization to dispose of equipment.

    Encumbrance: A commitment of funds to purchase goods or services.

    Encumbrance Ledger: Describes encumbrances (liens) in detail and provides encumbrance balances. Form FGIENCD is used to query this ledger.

    Exit With Value: [Shift F3] During a query this keystroke combination imports data from the highlighted field to the field from which the query was initiated.

    Expenditures: The outflow of cash or other resources or the incurring of debt for goods or services used by the University.

    Expenditure Account: Account codes used to identify the type of expenditure, including codes for salaries, benefits, equipment, etc.

    Expert Mode: Mode that allows you to navigate directly to a desired form. Simply enter the name of the form at the Enter Selection ==> prompt on any FIS Banner menu. You will be brought directly to that form.

    Field: The lowest level of detail in a database. A field displays a specific data element. On FIS forms, fields are usually displayed as individual boxes that either contain information, require data input or are left blank. The auto help line’s message will prompt you for information regarding the field your cursor is in and changes as you move from field to field.

    Financial Transaction: Transactions in the ledger representing either realized revenue, costs incurred for goods and services, or transfers of funds and expenditures.

    FIS: FIS Banner’s Financial Information System. The finance module UCSC uses to capture and record Financial and Acquisition information.

    FIS Banner: The name of Systems and Computer Technology (SCT) Sungard Corporation's suite of higher education information products. UCSC uses the financial module called Financial Information System (FIS).

    Fiscal Year: The University’s operating year for reporting activity, e.g. July 1 to June 30.

    FOAPAL: Acronym for the Chart of Account elements; Fund, Organization, Account, Program, Activity, Location. The accounting structure attached to each financial transaction.

    Form: The screen or series of screens that perform a function in the FIS system, which are comprised of blocks and fields. Input or update forms are used for data entry and query, while query forms are used only to query the system for information.

    Fund: Each self-balancing revenue source and associated expenditures are assigned a separate and unique fund number. Fund numbers are assigned from “fund groups” which indicate the kind of funding source involved i.e. General funds, Student fees, Private gifts, etc.

    Fund Accounting: Principles and practices developed for not-for-profit organizations that enable them to account properly for the diversity of resources that they receive and use. Fund accounting enables the University to identify and track a variety of resources, such as state and general funds, student fees, donations and contract and grants. It also enable the University to track expenditures by their use, by campus unit and by the funding source.

    Fund Balance Account: A General Ledger account used to record the fund balance at the beginning of a fiscal year. During the fiscal closing process, the current year’s transactions for revenue, expenditures and transfers are closed into this account in order to arrive at a new beginning balance for the next fiscal year.

    General Ledger (GL): Contains the financial data on assets, liabilities, fund balances and control accounts (the balance sheet).

    Hierarchy: A pyramid structure used in the Chart of Accounts that describes the ordering of codes into levels. The hierarchy of codes facilitates both detail and summary reporting. FIS takes data input at a detail level and rolls it up to higher levels of administration. This means you can obtain accounting reports at various levels, or you can combine various levels for a comprehensive or summary report for divisional use.

    Implied Approval: The singular approval of a transaction up to a set dollar amount. While document inputters may have implied approval up to $500.00, department or units may set approval limits for all document types - requiring multiple approvals as they deem necessary.

    Indirect Costs: Governmentally-approved rates calculated and applied to direct charges on research funds.

    Installment Purchase: Contract executed by the University and another party containing all terms and conditions for acquisition of property by means of scheduled installment payments of specified amounts of money during the life of the contract. Title of the equipment passes to the University at the end of the term of the contract.

    Inventorial Equipment: Non expendable personal property that has an acquisition cost of $1500 or more, is free standing and complete in itself, and has a normal life expectancy of two years or more. If title vests with the federal government it is called government property.

    I.T.: Information Technology.

    Journal Voucher (JV): The FIS document used to process entries into the ledgers transferring funds, revenue and expenses from one FOAPAL to another.

    Lease: A non-cancelable contract between the University and a supplier that contains the essential terms and conditions for the use (not purchase) of property in exchange for scheduled payments of a specific amount over a specified term. Title of the equipment remains with the supplier.

    Lease With Purchase Option: A lease that includes an option to purchase the equipment for a specified amount upon termination of the lease. If this option is exercised, title then transfers to the University. This is NOT the same type of contract as a Lease-Purchase (Installment Purchase).

    Ledger: One of three (Operating, Encumbrance, and General) repositories containing campus financial, budgetary, and lien activity. The Operating Ledger shows transactions involving Revenues, Expenditures, and Transfers. The General Ledger reports the balance sheet accounts.

    Liability: Debts or obligations owed by the University to creditors.

    Liability Account: General Ledger account used to denote the amounts owed by the University (payables, deposits, deferred income, etc.).

    Lien: See Encumbrance.

    List of Values: [F9]: A query function; it displays a list of the values (data) that are available for entry in the field where your cursor is. The values come from the appropriate validation table in the FIS database.

    Location Code: For Plant Accounting and Physical Plant use only. The location code field in conjunction with plant funds is used to denote the building for which the corresponding transaction is being posted. department or unit users should always leave the field blank.

    Navigation: How you get around in FIS Banner menus and forms. See Navigation Within FIS Banner for details.

    Net: The sum of revenue less expenditures less outgoing transfers.

    Normal Balance: The method used in FIS to determine the sign (-) of a transaction. Every account code is set with a normal balance equal to a debit or a credit.

    Office of Record: The department or unit or Central Office that originates an online transaction is the Office of Record for that transaction and appropriate backup documentation. The Office of Record is responsible for the maintenance, retention and retrieval of said documents.

    OPAL: See Operating Ledger.

    Operating Ledger: Reports the activities within an organization. Provides a detailed account of revenue, expenditures and transfers to every unit each month.

    Operating Unit: See Organizational Unit.

    Oracle: The Relational Database Management System (RDBMS) developed and copyrighted by the Oracle Corporation, and used by FIS Banner.

    Oracle Error: Banner has an enormous amount of error checking built in to help ensure that faulty data does not enter the database. However, if an erroneous action is performed which was not anticipated by the system, an Oracle error may occur. If the error message is not self explanatory, it should be reported to the FIS Team by sending e-mail to: fis_probs@ucsc.edu.

    Organization Code: Six-character code that identifies a campus or budgetary unit.

    Organizational Unit: Any operating unit that has a budget and is responsible for its financial performance. The term can apply to a division, department, unit, etc. The term operating unit is used interchangeably with organizational unit.

    PPS: Payroll/Personnel System. The system for entering hires, processing changes in payroll and benefits information, and recording payroll and personnel adjustment transactions.

    Plant Asset: The recorded value of real estate, buildings, fixed equipment, general improvements, infrastructure, equipment, library collections, and special collections (art, museum and scientific) acquired by purchase, gift, construction or exchange.

    Policy: A statement that outlines expectations, standards and requirements for prudent management. Policies are long-lasting statements of goals and principles and are distinct from procedures that include more detail about how to carry out a policy.

    Pool Budget Accounts: An account that allows monitoring and movement of budget at a higher level than the data enterable account codes. Pool budget accounts exist for payroll salaries, benefits, supplies and expense, equipment, and recharges. Data enterable account codes are linked to the appropriate Pool Budget Account for rollup reporting.

    Predecessor Level: Refers to a Chart of Accounts code (Fund, Organization, Account, Program or Location) that is used to summarize or sort information for a report -sometimes referred to as a “roll-up” level or reporting level. Predecessor level codes are never used to input data or code transactions.

    Preliminary Requisition: Form that provides documentation of authorization of funds for the acquisition of goods and services specified in detail by line item, including the identification of hazardous materials.

    Procedure: A certain way of getting something done; an established series of steps. Procedures are the steps that are used to achieve a principle or objective or to carry out a policy.

    Process: A series of steps or tasks that lead to a goal, product or service.

    Program Code: The program code is always the first two digits of the organization code and denotes the type of activity or function of the organization. The program code automatically defaults when an organization code is entered.

    Purchase Order (PO): Banner document used to initiate the purchase of goods and services. Vendors, prices, terms and conditions of the order are specified here.

    Query: [F7] to enter, [F8] to execute: Querying is the means of looking up information by having Banner retrieve and display the information on the screen (form). It is an information retrieval function that can be performed in any field that draws data from a validation table.

    Receiver: The FIS Banner Receiving Goods form, FPARCVD.

    Recharge: The assessment and collection by one University/department of a charge for goods or services, based on an identifiable unit of measure, furnished to another University/department. The recharge form is the means used to process said charges.

    Record: A specific subset of information within a form. Each transaction is stored in Banner as a record. Each record contains all the component information for the blocks and/or fields within the respective form. For example, on a journal voucher each sequence is a record.

    Recording Level: See Data Entry Level.

    Responsibility: To be entrusted with or assigned a duty or charge. In many instances responsibility is assumed, appropriate with one’s duties. Responsibility is distinct from accountability.

    Requisition (Req): The request form you use to initiate the purchasing process (FPAREQN).

    Revenues: Inflow of cash and other items of value received for goods sold or services rendered.

    Risk: Refers to any undesirable result such as inaccuracy, incompleteness, or non-compliance as well as the risk of fraud.

    Rollback: This function clears the form, returning cursor to first field so you may begin a new query or document.

    Roll up: Summary of data from lower levels in the Chart of Accounts hierarchy. Data from any group of elements in lowers levels can be “rolled up” or summarized for a report at a higher predecessor level.

    Rule Class: Identifies the type of transaction (budgetary, financial, or encumbrance) and its source (journal, recharge, invoice, etc.). Rule Classes contain codes that determine how the transaction is reported to the ledgers.

    Sequence Number (SEQ.): Numbers that appear in Banner forms to designate a specific record when multiple records are present. Each document may have hundreds of sequences.

    Sign: The indicators signifying whether a transaction is a (d)ebit, (c)redit, (+) Increase or (-) decrease.

    STIP: Short Term Interest Pool; interest earned on University money.

    Transfer of Expenditures (TOE): The process and form used to transfer revenue and realized expenditures from one fund, organization, account and/or activity code to another.

    Transfers of Funds (TOF): The process and form used to transfer budget within a funding source from one organization, account and/or activity code to another.

    Transfers: Identifies the classification of movement of revenues or expenditures between elements of the FOAPAL, and also additions to or deductions from a fund balance that are not considered either operating income or expenditures, i.e. indirect cost, principal and interest payments, inventory re-evaluations, etc.

    U/M: Unit of Measure. Used in the Purchasing and Procurement module to designate the form in which a commodity is ordered, i.e., box (BX), each (EA), gallon (GL), etc.

    Validation Tables: Tables that contain codes used by the FIS Banner system and the definitions of these codes. The tables “validate” data entered in specific fields of functional forms such as the Purchase Order. This means that if a user tries to enter an item that does not exist in the validation table as a “valid” entry, the system will not accept the entry. If you want to know what types of entries are valid, use the [F9] List Values function to see the validation table for the field where the cursor is. If you search the available alternatives and can’t find your desired entry, contact the central office responsible for the function you’re performing (e.g. Commodity code, contact Central Purchasing).

    Vendor: Company or person from which goods or services are purchased. Before a vendor can be entered on a Purchase Order, it must exist in the system’s Vendor file.

    Verify: To review for accuracy or correctness.


    Back to Top
  • Appendix A: Vendor Databases (person and non-person)

    Finding a Vendor in the FIS Banner Vendor Database

    ​Use FTIIDEN Enitity Name/ID Search to determine if a vendor (person or company) is in the FIS Banner vendor database and if it is active or terminated. Vendors include Companies and persons who supply goods or services to the University, or Persons (including employees and students) who receive any non-payroll payments.

    FTIIDEN Entity Name/ID Search

    1. Type FTIIDEN in the Banner Welcome page.
    2. Type [alt pagedown] Next Section.
    3. Enter filter criteria (see Filter Techniques).
      ​​Person will have Last and First Name.
      Company will only have Last Name.
      Use wildcards (‘%’ any number of characters, ‘_’ any single character) to broaden your search.

      View Image



    4. Click ‘Go’ and filter results (including Vendor ID number and Active or Terminated status) will display:

      View Image



    5. If query causes no records to be returned, refine your filter criteria to ensure you are filtering correctly.​
    6. If you don't find your vendor after searching, then this means the vendor is probably not yet set up in Banner. The Financial Accounting and Reporting (FAR)​ office manages vendor set-ups, and you can contact them at finpolicy@ucsc.edu for questions.​

    When does a vendor need to be set up in the FIS Banner vendor database?

    • A vendor must be set up in the vendor database for all purchase order and all payment transactions, except for allowable one-time vendors. For more infomation on one-time vendors, see One-Time Vendors.

    When is a Payment Data Record/STD204 form needed?

    • A vendor can be set up in the FIS Banner vendor database only upon receipt of a signed, completed Payment Data Record (form 204). Accounts Payable will either call the vendor directly, call the service center, or return the 204 form to the service center when the 204 form is incomplete or unsigned, or when additional information is needed.

    Why is a Payment Data Record/STD 204 form needed?

    • Purchase orders, direct payments, and PO related payments cannot be processed unless a complete and signed Payment Data Record form is on file.
    • The form 204 provides required information to assist UCSC in complying with Federal and State laws, and in accurately reporting income and withholding taxes.

    How do you obtain a Payment Data Record/STD 204 form?

    What is the difference between a Payment Data Record/STD 204 form and a Withholding Exemption Certificate/590 form?

    • The 590 form does not include all of the required vendor information. For example: The 204 form establishes vendor type and residency status for both California and non-California residents. This required information is not provided on the 590 form.

    How is vendor information updated on the vendor database?

    • The Payment Data Record on file in Accounts Payable should reflect the vendor’s most current information. Therefore, an updated Payment Data Record is required from any vendor who needs to revise information previously submitted to UCSC, except for a change of address. When submitting revisions, enter an asterisk (*) by each field that reflects a change.
      • A change of address may be updated by forwarding the following to Accounts Payable:
      • All vendors, except for employees and students: Forward a copy of the vendor’s invoice, letter or other official notification indicating the change of address.
      • Employee and student addresses may be updated by emailing Accounts Payable (aphelp@ucsc.edu). Please indicate if the vendor is an employee or a student.
    ​ ​​​ ​​​​​​​​​
    Back to Top
  • Rule Codes

    Overview:
    A rule code is a four character code that tells Banner how to process and post documents into accounting ledgers. Different rule codes are used for different document types.

    Journal Rule Codes:
    There are a large number of journal rule codes to accommodate the various needs of campus business offices, recharge units, external systems and automated processing by FIS. Journal rule codes are generally used two ways:

    1. Journals entered by humans: Rule codes beginning with “X” are used in journals entered directly in Banner by a person. Some specialized “X” rule codes are used by business offices to enter their own recharges. For example, BayTree Bookstore and TAPS. Journal numbers begin with “J0” (J zero) and go through approvals routing.
    2. Journals not entered by humans: Rule codes beginning with “W” are used in journals not entered directly in Banner by a person. For example, data fed from external systems such as PPS (payroll files) or AIS (student accounts receivables). This also applies to recharge offices such as the Copier Program or Mail Services. Journal numbers begin with either “J#” or “K#” (where # = another letter like “D” or “S”). These journals bypass approvals routing.
      Additionally, FIS creates automated journals for Central Accounting processing using “W” rule codes. For example, the annual Plant Capitalization process or fiscal close reclassification journals. These journal numbers begin with “J0” (J zero) and bypass approvals routing.

    Invoice Rule Codes:
    A variety of invoice rule codes are used to designate specific types of invoices, such as invoices or credit memos with or without encumbrances, and canceled invoices or canceled credit memos. All invoice rule codes begin with “I” including Procard invoices. Regular invoice numbers begin with “I” or “EI”.  Procard invoice numbers begin with “A”.

    Check Rule Codes:
    Checks use various rule codes beginning with “D”. When a check is canceled a rule code beginning with “C” is used. There are 3 check types using these rule codes:

    1. Paper checks: Checks numbers begin with “0” (zero).
    2. ACH Vendors: Check numbers for ACH vendors begin with “!”.
    3. Wire Transfers: Check numbers for Wire Transfers begin with “X”.

    Purchase Order and Change Order Rule Codes:
    Purchase Order rule codes begin with “P” and PO numbers begin with “P0” (P zero).
    Change Order rule codes begin with “C”. A one-up number starting with “1” is appended to the Purchase Order number to identify a Change Order.

    Table 3: Rule Code for JVs
    Listed below are frequently used Banner rule codes for the most common type of documents. Each rule code is described in detail on the following pages. There are some special cases not included. Please contact fis_probs@ucsc.edu for special rule codes not listed here.
    Important: Only use one rule code per journal voucher.
    Note: When journal vouchers are processed by the FAST office, the rule code should begin with a Z instead of an X. For example, an XTOE journal processed by the FAST Office will use the rule code 'ZTOE'.

    Rule Code Description
    Transfer of Expense (TOE)
    Rule Codes ​ ​
    XTOE Non-Payroll Expense Transfers
    XECG ​Contract and Grants and Special State Appropriation Transfers
    XEPT Construction in Progress/Plant Expense Transfers
    XEQT Inventorial Equipment Expense Transfers
    XPRA Payroll Expense Transfers
    Transfer of Funds (TOF)
    Rule Codes
    XTOF ​Temporary Budget Adjustments
    XDCG ​Contract and Grants and Special State Budget Transfers
    Balance Sheet Journal
    Rule Code
    XJVB Balance Sheet Account Transfers
    ​Sales Tax Entry Rule Code​ XTAX ​Invoice Payment Sales Tax Accrual
    ​XPTX ProCard Sales tax Accrual

    Expense Transfers of Restricted Rule Codes

    Rule codes have been established in Banner for decentralized entry of XTOE and XTOF adjustments. Separate rule codes have been established to facilitate selective approval routing to central accounting office staff for journal transactions for Inventorial Equipment transfers (XEQT), Construction In Progress expense transfers (XEPT), transactions requiring use of balance sheet accounts (XJVB), and allowable payroll expenses (activity code adjustments) (XPRA). FAST office can process any of these rule codes by replacing X with Z for each.

    Transfers Of Funds And Transfers Of Expenditures

    TOF
    At the start of each fiscal year, annual budgets are established for campus programs and activities. These budgets, also known as appropriations, consist of funds allocated to operate various activities and programs for the fiscal year. Budgets may be allocated to pool account and activity code levels to provide benchmark amounts that are then used to monitor particular types of expenditures, such as Staff Salaries, and Supplies and Expenses.
    The permanent budget is allocated to the pool budget accounts for each fund and organization. The budgets represent the planned expenditures in each major expenditure category for the current year. Unit managers may need to redistribute their budgets to achieve better expenditure controls. They may also need to make changes in the budget to reflect changes in their operations. On-line transfers of funds (TOFs) can be used to move budgets from the general pool budget accounts to other expenditure account codes or to unit defined activity codes. TOFs can also be used to transfer budgets to other organizations. TOFs cannot be used to transfer budgets between funding sources.

    TOE
    An expenditure results when a campus activity or program uses money for things like salaries, supplies, equipment, and services. Assigning a FOAPAL code to each expenditure classifies the expenditure to a particular program (organization code, e.g. Biology Instruction), type of expenditure (account code, e.g. Staff Salaries), and type of activity (activity code, e.g. Computer Support Staff). It also associates the expenditure to a particular fund source (fund code, e.g. General Funds). This coding allows the campus to produce financial reports to the public indicating how the campus has used its money and identifying the source of the money used.
    Occasionally, mistakes are made classifying revenues and expenditures. Perhaps the wrong organization code was used or the account code was incorrect. Because of the campus need to accurately report its financial condition, corrections must be made to incorrectly coded revenues and expenditures that have posted to the ledger. These corrections are made through the Transfer of Expenditures (TOE) process.

    When to Use a TOE Form

    1. To move expenses from one fund, org, or account to another;
    2. To add or change activity codes;
    3. To distribute costs within a unit (example: redistributing a phone charge among various orgs);
    4. To move a block of expenses on the ledger from one FOAPAL to another, provided the account code remains the same or within the same classification and the fund source is unrestricted.

    When to Use a TOF Form

    1. To move budget from one organization to another within the same funding source.
    2. To redistribute budget from the pool budget account to expenditure account codes and/or activity codes.

    Office of Record

    A Department or Division that generates a document is the Office of Record for that document. Responsibilities for record keeping include organizing, maintaining, and retrieving the completed and posted document along with any required supporting documentation, such as internal records or logs of usage that support transfers.

    Retention Periods

    The retention period for an expense transfer journal for non-governmental contract and grant funds is five years after the end of the fiscal year in which it was produced.
    The retention period for a budget transfer journal for non-governmental contract and grant funds is ten years after the end of the fiscal year in which it was produced.
    Expense transfers and budget transfers for government contract and grant documents must be held for destruction according to approved government contract and grant retention schedules. Specific instructions for determining government contract and grant retention schedules may be obtained through Extramural Fund Accounting.

    Current Unrestricted Funds

    Opportunity funds 07427 & 09500 - 09595
    General funds 199xx funds
    Tuition and Fee funds 20000 - 20399
    Sales and Service Educational Activity funds 60000 - 65999
    Other income funds 66000 - 69999
    Auxiliary Service Enterprises 70000 - 74999
    Reserve funds 75000 - 75999

    Non Payroll Expense Transfers
    Once an expense entry has been posted in the operating ledger, it is appropriate to make adjustments only in the following situations:

    • to correct an erroneous non-payroll expense recording when the original source document cited an incorrect FOAPAL code;
    • to record a change in the decision made originally for the use of the good or service;
    • to redistribute high numerical but small individual and/or minor charges (e.g. copy machine, telephone charges, or mailing charges) which are billed to a departmental FOAPAL but apply to other FOAPALs under the jurisdiction of the department;
    • to transfer expenses between funds to eliminate deficits within unrestricted funds or from restricted to unrestricted funds.

    Non Payroll Expense Transfers of Inventorial Equipment
    Inventorial equipment must be transferred as a line item entry using the original source document as the document reference number. The document reference number will be the purchase order number in almost all cases.

    Non Payroll Expense Transfers to Restricted Funds
    Non payroll expense transfers can be made to restricted funds, provided the restrictions allow for the type of expense being transferred.

    Non Payroll Expense Transfers Between Fiscal Years
    Non payroll expense transfers can not be made between fiscal years.

    Indirect Cost Calculations for Expenditures for Research Grants
    Banner uses certain fund codes to represent indirect costs associated with research grants. These codes are defined below, for your information. They are not typically entered by users. They may be seen as users enter their JVs. Screenshots of these codes are shown after their definitions.

    GRIC
    GRIC is the Banner-generated rule code representing the indirect charge (debit) that will be incurred with any expenditure charged to the operating ledger on a research fund. It is a negotiated rate with the funding agency. Each research fund will have an indirect cost basis which defines what expenditures are subject to this charge, and what expenditures are exempt from the charge. Each fund will also include the negotiated rate, as well as an account code into which the charges are accrued within that fund. This is the debit side of the charge, which is always account code 009150. The credit side of the entry is the campus' overhead pool FOAPAL.

    GRIR
    GRIR is the Banner-generated rule code representing an indirect cost recovery. This is the credit side of the indirect cost charge against expenditures to the operating ledger against research funds. GRIC & GRIR go hand in hand.

    GRRV
    GRRV is the automatic revenue accrual that will post each time an expenditure hits the operating ledger against a research fund. The REVENUE account field must be populated on FTMFUND form for this to occur. (Credit)

    GRAR
    GRAR is the automatic unbilled accrual that will post to the general ledger each time an expenditure is charged against a research fund. The UNBILLED RECEIVABLE account field must be populated on the FTMFUND form for this to occur. (Debit)

    GRIC and GRAR Example

    View Image


    GRRV and GRIR Example

    View Image


    The page FTMFUND may be used to view GRAV and GRAR revenue accounts. To perform a query go to FTMFUND, tab to the FUND field, enter the appropriate fund code and then enter [F8] Execute Query. Type [control q] to exit FTMFUND when review is complete.

    The form FRMFUND may be used to view GRIC and GRIR account details. To perform a query go to FRMFUND, enter [F7] Enter Query, tab to the FUND field, enter the appropriate fund code and then enter [F8] Execute Query. Type [control q] to exit FRMFUND when review is complete.​

    View Image



    Back to Top
  • XTOE General Transfer of Expense

    Use XTOE for expense transfer transactions and allowable revenue account code adjustments for Unrestricted funds and certain Restricted funds (Restricted Gift, Endowment and Endowment Income Funds are allowable with rule code XTOE).
    Note: When journal vouchers are processed by the FAST office, the rule code should begin with a Z instead of an X. For example, an XTOE journal processed by the FAST Office will use the rule code 'ZTOE'.
    Transactions created with this rule code are not electronically routed to the Accounting Office for approval. Selective post audit review of transactions created by this rule code will be conducted by the Accounting Office.
    Summary expense transfers are allowable as long as they sum multiple actual expenses that exist within the same account code.​

    Disallowed Fund Codes

    Plant Funds 00300 - 01599 series
    Loan Funds 02200 - 03999 series
    Special State Approp. Fund 18000 - 18199, 20501 - 20599
    State Agencies Funds 18200 - 18999, 20600 - 20939
    Local Government Funds 20600 - 20999
    Federal Government Funds 21000 - 33999
    Private Contract & Grants Funds 57000 - 59999
    Renewal & Replacement Reserve Funds 76000 - 76999

    Disallowed Organization Codes

    Construction in Progress Org 97xxxx series

    Disallowed Account Codes

    Balance Sheet Accounts 1xxxxx series
    Capital Expenditures/Inventorial Equipment Account xx7xxx series
    Contract and Grant Overhead Account 009150
    Construction in Progress Accounts 009500 - 009699
    Payroll Expense Account Pxxxxx series
    Transfer Accounts Txxxxx series

    XTOE Description Field

    Identify the transaction being transferred. For example:

    1. For a transfer of a line item expense or revenue transfer, use the same description that appears on the ledger for the transaction that is being transferred. (See XTOE Line Item Transfer Example.)
    2. For a transfer of summary expenses by account code, use “To: fund/org code” (i.e. To: 19900/660400) and use “From: fund /org code” (i.e. From: 69750/660400). (See XTOE Account Code Summary Transfer Example.)
    3. For a summary transfer to correct activity code(s) within the same fund/org account use “correct activity code”. (See XTOE Activity Code Summary Transfer Example.)
    4. For a transfer of expenses to distribute charges to another unit, identify the charge and the department/unit being charged. (See XTOE High Numerical/Small Individual Expense Distribution Example.)

    Document Reference Field

    1. If the expense being transferred is a line item expense appearing on your ledger use the document number appearing on the ledger for that line item. (See XTOE Line Item Transfer Example.)
    2. If a summary expense by account code is being transferred, use “ACCTSUM” as the document reference. (See XTOE Account Code Summary Transfer Example.)
    3. If activity code adjustments are being made within the same fund/organization/account code use “ACTVSUM” as the document reference. (See XTOE Activity Code Summary Transfer Example.)
    4. For distribution of certain high numerical but small individual and or minor charge items use “EXPDIST” for the document reference. (See XTOE High Numerical/Small Individual Expense Distribution Example.)

    Text Field

    The text field should contain the Who, What, and Why of the transfer. Include the name, office and phone number of the preparer.

    Sign Indicator Field

    Use a (D)ebit: for an increase to an expense account or a decrease to a revenue account.
    Use a (C)redit: for a decrease to an expense account or an increase to a revenue account.

    XTOE Line Item Transfer Example

    View Image



    An example of appropriate text for a line item transfer is shown below:

    View Image


    XTOE Account Code Summary Transfer Example

    View Image



    An example of appropriate text for account code transfers is shown below:

    View Image


    XTOE Activity Code Summary Transfer Example

    View Image



    An example of appropriate text for an activity code transfer is shown below:

    View Image


    XTOE High Numerical/Small Individual Expense Distribution Example

    View Image



    An example of appropriate text for expense distribution is shown below:

    View Image



    Back to Top
  • XEQT TOE Inventorial Equipment

    ​Use XEQT for Inventorial Equipment expense transfer transactions for all current funds including Special State appropriations and all Contract and Grant funds.
    Note: When journal vouchers are processed by the FAST office, the rule code should begin with a Z instead of an X. For example, an XEQT journal processed by the FAST Office will use the rule code 'ZEQT'.
    Transactions are electronically routed to Equipment Administration for review and approval.

    Disallowed Fund Codes

    Agency Funds 00001 - 00299
    Loan Funds 02200 - 03999 series

    Disallowed Account Codes

    Balance Sheet Accounts 1xxxxx series
    Contract and Grant Overhead Account 009150
    Payroll Expense Accounts Pxxxxx series
    Revenue Accounts Rxxxxx series
    Transfer Accounts Txxxxx series

    Other XEQT Restrictions

    1. An Inventorial Equipment expense transfer must be a line item expense for a specific piece of equipment.
    2. Do not reclassify inventorial expenses unless the original document appearing on the ledger cited the wrong account code classification.
    3. Account Code 007080 must be used to record the sale of inventorial equipment between two departments.

    Debits and Credits (D/C Sign Indicator Field)

    A (D)ebit is an increase to an expense account.
    A (C)redit is a decrease to an expense account.

    Description Field

    Use the description that appears on the ledger for the inventorial equipment transaction when it is an internal adjustment for a current year purchase. If the transaction is a sale between two units then use the description of the equipment being sold.

    Document Reference Field

    Reference the original Purchase Order number. This is the only link to equipment Data Reports. If the source document is not a Purchase Order (i.e. Bookstore recharge, IOC, etc.) reference that source document. You may reference the I-doc number in text for finer identification.

    Text Requirements

    Include the serial number and property number of the equipment being transferred in addition to the Who, What, and Why of the transaction.

    XEQT TOE Inventorial Equipment Example

    View Image



    An example of appropriate text for inventorial equipment is shown below.

    View Image



    Back to Top
  • XEPT TOE Construction In Progress/Plant Fund

    ​Use XEPT for Construction In Progress (Plant Fund) expenditure transfers. Transactions are electronically routed to Plant Accounting for review and approval. This rule code is generally only used by Plant Accounting and Physical Planning and Construction.
    NOTE: When journal vouchers are processed by the FAST office, the rule code should begin with a Z instead of an X. For example, an XEPT journal processed by the FAST Office will use the rule code 'ZEPT'.

    Disallowed Fund Codes

    Agency Funds 00001 - 00299
    Loan Funds 02200 - 03999 series

    Disallowed Account Codes

    Balance Sheet Accounts 1xxxxx series
    Contract and Grant Overhead Account 009150
    Payroll Expense Accounts Pxxxxx series
    Revenue Accounts Rxxxxx series
    Transfer Accounts Txxxxx series

    Debits and Credits (D/C Sign Indicator Field)
    A (D)ebit is an increase to an expense account.
    A (C)redit is a decrease to an expense account.

    Description Field
    Use either the description that appears on the ledger for the expense being transferred or else describe the transfer.

    Document Reference Field
    Use the source document number of the original transaction appearing on the ledger for the expense being transferred.

    Text Field
    The text field should contain the Who, What, and Why of the transfer. Include the name, office and phone number for the preparer.

    XEPT TOE - Construction In Progress/Plant Fund Example

    View Image



    An example of appropriate text for construction in progress is shown below.

    View Image



    Back to Top
  • XPRA Allowable Payroll Adjustment

    ​Use XPRA rule code to record limited allowable payroll expense adjustments for all current funds. Limited allowable payroll expense adjustments are restricted to only activity code transactions paid properly in payroll that were not established in Banner at the time of payment.
    Payments made through the payroll system with correct FOAPALs default in Banner if the FOAPAL is not established at the time of payment. A journal prepared by Payroll will transfer the payroll expense adjustments from the default account in Banner to the appropriate payroll FOAPAL.
    Intercampus payroll expenses can be transferred using XPRA to move all associated payroll expenses, including benefits, to another FOAPAL.
    Transfers of all other payroll expenses should be processed through the payroll system.
    XPRA expense transfers can be made to the following benefit account codes: P68570 & CG8570 “Graduate Health Insurance”, P68590 & CG8590 “Partial Fee Remission”, P68970 & CG8970 “Tuition Remission”. Expenses recorded in these benefit account codes originate from a recharge journal created by the Graduate Office. These codes are not used in the PPS system.

    Allowable Account Codes
    Transactions must be from this Account Group:

    C&G/Grad Student Health Insurance CG8570
    C&G/Partial Fee Remission CG8590
    C&G/Tuition Remission (RA) CG8970

    Disallowed Funds

    Agency Funds 00001-00299
    Plant Funds 00300-01599 series
    Loan Funds 02200-03999 series

    Disallowed Organization Codes:
    Construction in Progress Org codes: 97xxxx series

    Disallowed Account Codes:
    Construction in Progress: 009500-009699 series

    Debits and Credits (D/C Sign Indicator Field):
    A (D)ebit is an increase to an expense account.
    A (C)redit is a decrease to an expense account.

    Description Field:
    Use “correct activity code” as your description when you are correcting an activity code. If you are correcting graduate student benefit expenses recharged from the Graduate Office, then use the description that appeared on the ledger when the expense was originally charged (the name of the graduate student for which the benefit expense is charged).

    Document Reference Field:
    Use ACTVSUM if correcting an activity code for multiple months. If you are correcting an activity code for a specific month use the original payroll journal document number. If you are transferring graduate student benefit recharge transactions use the original source journal document number.

    Text Field:
    The text field should contain the Who, What, and Why of the transfer. Include the name, office and phone number of the preparer.

    XPRA Allowable Payroll Adjustment Example:

    View Image


    An example of appropriate text for construction in progress is shown below:

    View Image



    Back to Top
  • XJVB Balance Sheet Account Transfers

    ​Use XJVB when a transaction involves a balance sheet account (1xxxxx series).
    Transactions are electronically routed to General Accounting for review and approval.

    Disallowed Fund Codes:

    Agency Funds 00001 - 00299 series
    Plant Fund 00300 - 01599 series
    Special State Appropriations Funds 18000 - 18199, 20501 - 20599
    State Agencies Funds 18200 - 18999, 20600 - 20939
    Local Government Funds 20950 - 20999
    Federal Government Funds 21000 - 33999
    Private Contract and Grants Funds 57000 - 59999

    Disallowed Organization Codes:
    Construction in Progress Orgs: 97xxxx series

    Disallowed Account Codes:

    Capital Expenditures/Inventorial Equipment Account xx7xxx series
    Contract and Grant Overhead Account 009150
    Construction in Progress Accounts 009500 - 009699
    Payroll Expense Accounts Pxxxxx series

    FOAPAL Fields For Balance Sheet Account Transfers:

    Index Field Required the balance sheet account number
    Fund Field * Fund number associated with bal sheet defaults
    Organization Code not used
    Account Code the balance sheet account number defaults
    Program Code not used
    Activity Code not used

    * For loan fund balance sheet accounts, fund does not default, but must be entered, as there are multiple funds associated with the same loan fund balance sheet account. Entries to loan fund balance sheet accounts are only made by the Accounting Office and the Office of Accounts Receivable.

    Debits and Credits (D/C Sign Indicator Field):
    A (D)ebit is an increase to an Expense account or a decrease to a Revenue account.
    A (C)redit is a decrease to an Expense account or an increase to a Revenue account.
    A (D)ebit is an increase to an Asset balance sheet account or a decrease to a Liability balance sheet account.
    A (C)redit is a decrease to an Asset balance sheet account or an increase to a Liability balance sheet account.

    Description Field:
    Describe the reason for entering this transaction, such as “Nov. principle payment” if it is a summary collection entry for a receivable account where the detail is maintained in a subsidiary system.
    If it is an account where the collection detail is maintained in the balance sheet account for reconciliation purposes, then provide the name of the individual for whom the transaction is being made.

    Document Reference Field:
    If the balance sheet account is a reference controlled balance sheet account (a balance sheet account that provides subtotals by reference number on reference control ledger reports to monitor individual receivable balances), then the assigned reference number for the individual must be recorded in the document reference field for the entry.
    No Document Reference number is needed for non-reference controlled balance sheet accounts.

    Text Field:
    The text field should contain the Who, What, and Why of the transfer. Include the name, office and phone number of the preparer.

    XJVB Balance Sheet Account Journal Example:

    View Image


    An example of appropriate text for a balance sheet account journal is shown below.

    View Image



    Back to Top
  • XECG Contract and Grants and Special State Appropriation Transfers

    ​Use XECG for non-payroll, non-equipment expense transfers to or from Special State appropriations and Contract & Grant funds.
    Transactions created with this rule code are not electronically routed to the Accounting Office for approval. For training in expense transfers to restricted funds, contact the Extramural Funds office at emf_help@ucsc.edu.

    Allowable Fund Codes:
    At least one of the funds involved in the transfer transaction must be from this group.

    Special State Appropriations Funds 18000 - 18199, 20501 - 20599
    State Agencies Funds 18200 - 18999, 20600 - 20939
    Local Government Funds 20950 - 20999
    Federal Government Funds 21100 - 33999
    Private Contract and Grants Funds 57000 - 59999, 62000 - 62999

    Disallowed Fund Codes:

    Agency Funds 00001 - 00299
    Plant Funds 00300 - 01599 series
    Loan Funds 02200 - 03999 series

    Disallowed Organization Codes:
    Construction in Progress Orgs: 97xxxx series

    Disallowed Account Codes:

    Balance Sheet Accounts 1xxxxx series
    Capital Expenditures/Inventorial Equipment Account xx7xxx series
    Contract and Grant Overhead Account 009150
    Construction in Progress Accounts 009500 - 009699
    Payroll Expense Accounts Pxxxxx series
    Revenue Accounts Rxxxxx series
    Transfer Accounts Txxxxx series

    Debits and Credits (D/C Sign Indicator Field):
    A (D)ebit is an increase to an expense account.
    A (C)redit is a decrease to an expense account.

    Description Field:
    Use the description that appears on the ledger for the expense being transferred or describe the transfer.

    Document Reference Field:
    Reference the source document number of the original transaction appearing on the ledger. If the expense transfer is a distribution of high numerical value but small individual and/or minor charge items use “EXPDIST” as the document reference.

    Text Field:
    The text field should contain the Who, What, and Why of the transfer. Include the name, office and phone number of the preparer. One of the following conditions for cost transfers to contract and grant funds must apply and be clearly explained in the text:

    • To correct bookkeeping or clerical errors.
    • To record the PI's change in decision made originally as to the use of goods or services (must confirm that the transfer has the approval of the PI).
    • To redistribute high volume/low value costs.
    • To clear an overdraft on one fund by transferring to an award fund allocable charges that were once transferred out of the award fund and, due to a credit posting, can now be transferred back.

    XECG Example:

    View Image


    An example of appropriate text for an XECG transfer is shown below:

    View Image


    ​​
    Back to Top
  • XTOF General Transfer of Funds

    ​The XTOF rule code is used for budgetary transfers of Unrestricted funds and certain Restricted funds (Gift, Endowment and Endowment Income funds).
    XTOF has its own rule group security restrictions and are routed accordingly. XTOF journal vouchers are not routed to the General Accounting Office or the Budget and Planning Analysis Office for electronic approval. Budget Anaylsis and Planning will review post audit reports of XTOF transactions.

    Disallowed Funds Codes

    Agency funds 00001 - 00299 series
    Plant funds 00300 - 01999 series
    Loan funds 02000 - 03999 series
    Special State Approp. and
    State Agencies funds
    18000 - 18999 series
    20500 - 20599 series
    Local Government funds 20600 - 20999 series
    Federal Government funds 21000 - 33999 series
    80000 - 84999 series
    Private Contract and Grant funds 57000 - 59999 series
    62000 - 63999 series
    65000 - 65999 series
    Renewal and Replacement Reserve 76000 - 76999 series

    Disallowed Account Codes

    Balance Sheet 1xxxxx series
    Contract and Grant Overhead expenditures 009150, CG3Y00
    Payroll expenditures Pxxxxx series
    Revenues Rxxxxx series
    Transfers Txxxxx series

    General State Appropriations Fund TOF
    199xx Additional Restrictions

    Restrictions not edited by FIS that users are responsible for observing:

    • General State Appropriations: 199xx

    Primary Budgetary Program Control Points:
    The Campus receives line-item allocations from the State. This funding must remain in the program code to which it has been allocated to ensure that these funds are spent in accordance with the State's intent:

    • Instructional Equipment Replacement
    • Instructional Technology
    • Library Materials
    • Deferred Maintenance
    • Operation and Maintenance of Plant (OMP)
    • Student Financial Aid

    Accordingly, on 19900, 19906 and 19922 funds, no transfers are allowed between program codes, except for the following cases:

    • Between Instruction and Academic Support programs (40 and 43).
    • Between Research programs (44, 48 and 50).
    • Between General Administration and Institutional Support programs (66 and 72).
    • To/from Provisional programs (80 and any code).
    • On 19900, 19906 and 19922 funds, no transfers from pool account B00000 'Academic Salaries' to any budget pool account other than B08000 'Unallocated'.

    Restrictions on Other Funds

    • Educational Fee Outlay fund 20095 may not be used for Research (44-59) or Public Service (62).
    • Lottery funds (18082-18085 and 20590-20593) must remain in program 40 'Instruction' and/or 43 'Academic Support'.
    • Auxiliary Enterprise funds (70000-74999) must remain in program 76 'Auxiliary Enterprises'.
    • NO Operating funds may be transferred to program 97 'Plant Construction'. Only Plant funds can be transferred to 97, and usually only by Budget and Planning Analysis.
    • Although units may transfer funds TO 78 ‘Student Financial Aid’ from another program code, funds may not be transferred FROM 78 ‘Student Financial Aid’ to another program code unless reviewed and processed by Budget and Planning Analysis.

    Exceptions to these restrictions may be sought by submitting a signed paper TOF form to Budget and Planning Analysis for review and subsequent processing. TOF Form

    Pluses and Minuses Sign Indicator Field (“Sign”)
    A (+) plus is an increase to an expenditure budget.
    A (-) minus is a decrease to an expenditure budget.
    The XTOF rule code requires that the document be balanced within each fund - the sum of all transaction amounts must equal zero for each fund code.

    Description Field
    The description field should indicate which FOAPAL the funds are being transferred to or transferred from in addition to any other text describing the transfer.

    Document Reference Field
    A Document Reference number is not required in this field, however Budget Analysis and Planning​ recommends using a five character, unit assigned code comprised of the two character unit alpha code plus 3 alphanumeric characters (i.e. Accounting - AC005). Budget and Planning Analysis maintains a current listing of Unit Alpha Codes here.

    Text Field
    The text field should contain the Who, What, and Why of the transfer. Include the name, office and phone number of the preparer.

    Transfer of Funds Example

    View Image


    An example of appropriate text for a transfer of funds is shown below:

    View Image


    ​​​​​​​​
    Back to Top
  • XDCG Contract and Grants and Special State Budget Transfers

    ​Use XDCG for decentralized on-line budgetary transactions for Special State Appropriation and Contract & Grant funds.
    Transactions are not electronically routed to a central office for approval. Selective post audit review of transactions created by this rule code will be conducted by the Extramural Accounting Office.
    Budget transactions must be made within the same funding source.
    Budget transactions must use the Contract and Grant Budgetary Pools below.

    Allowable Fund Codes:
    Transactions must be from this group:

    Special State Appropriations Funds 18000 - 18199, 20501 - 20599
    State Agencies Funds 18200 - 18999, 20600 - 20939
    Local Government Funds 20950 - 20999
    Federal Government Funds 21100 - 33999
    Private Contract and Grants Funds 57000 - 59999, 62000 - 62999

    Disallowed Account Codes:

    Balance Sheet Accounts 1xxxxx series
    Contract and Grant Overhead Account 009150
    Revenue Accounts Rxxxxx series
    Transfer Accounts Txxxxx series
    Construction in Progress Accounts 009500-009699 series

    Contracts and Grants Budgetary Pools:

    B02000 Salaries
    B03000 Supplies and Expenses
    B04000 Inventorial Equipment
    B06000 Fringe Benefits
    CG3500 Travel - Domestic
    CG3A00 Travel - Foreign
    CG3C00 Subcontracts
    CG3P00 Participant Support
    CG3Y00 Indirect Costs - (Overhead)
    CG6000 Tuition and Fees

    Pluses and Minuses Sign Indicator Field (“Sign”):
    A (+) plus is an increase to an expenditure budget.
    A (-) minus is a decrease to an expenditure budget.
    The XDCG rule code requires that the document be balanced within each fund -- the sum of all transactions amounts must equal zero for each fund code.

    Description Field:
    Use the organization code and account code of the budget into which the dollars are being moved when you do a decrease transaction; use the organization code and account code of the budget from which dollars are being moved for an increase transaction.

    Document Reference Field:
    No Document Reference number is required in this field.

    Text Field:
    The text field should contain the Who, What, and Why of the transfer. Include the name, office and phone number of the preparer.

    XDCG Example:

    View Image


    An example of appropriate text for decentralized on-line budgetary transactions for Special State Appropriation and Contract & Grant funds is shown below:

    View Image


    ​​
    Back to Top
  • Cheat Sheet – TOE / TOF Quick Reference

    TOE/TOF Quick Reference Cheat Sheet PDF

    Form Name Form Title Form Function
    FZAJVCD UCSC Journal Voucher Entry Form Input for TOE/TOFs
    FZIJVCD UCSC Pending Journal Vouchers List of incomplete/unposted journals
    FGIJSUM Journal Voucher Summary Form Summarizes transactions within an incomplete journal
    FOAUAPP User Approval Form Displays a Journal in an Approval Queu
    FZIDOCR Completed Document Retrieval Summarizes a completed journal (no description)
    FGIDOCR Document Retrieval Shows completed journal with description

    When to Use a TOE Form

    • to move expenses from one fund, org, or account to another;
    • to distribute costs within a unit (example: redistributing a phone charge among various orgs);
    • to add or change activity codes;
    • to move a block of expenses on ledger from one FOAPAL to another, provided the account code remains the same or within the same classification and the fund source is unrestricted.

      • IMPORTANT: TOEs should only be processed when there is a need to transfer incurred expenses that have already posted*. Expenses can be transferred individually or grouped together if they share the same account code. TOEs are not intended to move money, so year-end cleanup transfers using generic account codes that do not transfer actual expenses are not permissible.

        *Allowable Exceptions to this rule:  Approved Recharges and Multiple Units Sharing Costs Associated with an Event. Questions? Contact Budget and Planning Analysis  at budget-group@ucsc.edu.​​

    XTOE: TOE — General Transfer Of Expense

    Description Field​ Document Reference Sign Indicator Text
    Line Item transfer:
    Same description that appears on the ledger for the transaction being transferred. ​
    ​Line Item transfer:
    Use the document # appearing on the ledger for that line item.
    (D)ebit:
    An increase to an expense account / a decrease to a revenue account.

    (C)redit:
    A decrease to an expense account / an increase to a revenue account.​
    REQUIRED:
    • What
    • Why
    • Who
      • Name
      • Office
      • Phone
    Transfer of summary expense by account code:
    • To: fund/org code
    • From: fund/org code
    Transfer of summary expense by account code: ACCTSUM.
    Summary transfer to correct activity codes within same FOA: Correct activity code.​ ​Summary transfer to correct activity codes within same FOA: ACTVSUM.
    To redistribute charges within the same unit or to another unit: Use a description that identifies the charge and the unit being charged e.g.: “Cowell/Xeroxing charges”.​ To redistribute charges within the same unit or to another unit: EXPDIST.

    XEQT: TOE — Inventorial Equipment
    (Route to Equipment Administration for Final Approval)

    Description Field Document Reference Sign Indicator Text
    Should use the description that appears on the ledger for the inventorial equipment transaction when it is an internal adjustment for a current year purchase.

    If the transaction is a sale between two units then the description of the equipment being sold would be more appropriate.
    Must reference the source document # of the original transaction appearing on the ledger for the expense being transferred.

    The purchase order # for a vendor purchase.

    If the transaction constitutes a sale of inventorial equipment between two units, then the purchase order number appearing on the units inventory listing is appropriate document reference (account code 007080 must be used to record the sale of inventorial equipment between two departments).
    (D)ebit:
    An increase to an expense account.

    (C)redit:
    A decrease to an expense account.
    REQUIRED:
    • What
    • Why
    • Who
      • Name
      • Office
      • Phone

    XEPT: TOE — Construction In Progress/Plant
    (Route to Plant Accounting for Final Approval)

    Description Field Document Reference​ Sign Indicator Text​
    Should use the description that appears on ledger for the expense being transferred or a description that describes the transfer. Reference the source document # of the original transaction appearing on the ledger for the expense being transferred. (D)ebit:
    An increase to an expense account.

    (C)redit:
    A decrease to an expense account.
    REQUIRED:
    • What
    • Why
    • Who
      • Name
      • Office
      • Phone

    XPRA: TOE — Allowable Payroll Adjustment
    (Route to General Accounting for Final Approval)

    Description Field Document Reference Sign Indicator Text
    If correcting an activity code use:
    “correct activity code” as your description.

    If correcting Graduate student benefit expense recharged from the Graduate Office, use the description that appeared on the ledger when the expense was originally charged, which is the name of the graduate student for which the benefit expense is charged.
    Use ACTVSUM if correcting by activity code for multiple months.

    If correcting an activity code for a specific month use the original payroll journal document #.

    If transferring Graduate student benefit recharge transactions use original source journal document #.
    (D)ebit:
    An increase to an expense account.

    (C)redit:
    A decrease to an expense account.
    REQUIRED:
    • What
    • Why
    • Who
      • Name
      • Office
      • Phone

    When to Use XPRA

    • Corrections to FIS activity code errors.
    • Expense transfers made to P68570& CG8570 “Graduate Health Insurance,” P68590 & CG8590 “Partial Fee Remission,” P68970 & CG8970 “Tuition remission”.

    XJVB: TOE — Balance Sheet Account Transfers

    Description Field Document Reference Sign Indicator Text
    Describe reason for entering transaction if it is a summary collection entry for a receivable account where detail is maintained in subsidiary system. If it is an account where the collection detail is maintained in balance sheet account for reconciliation purposes, provide name of individual for whom transaction is being made. If balance sheet account is reference controlled, then the assigned reference number for individual must be used in document reference field for the entry. No document reference number is needed for non-reference controlled balance sheet accounts. (D)ebit:
    An increase to an Asset balance sheet account or a decrease to a Liability balance sheet account.

    (C)redit:
    A decrease to an Asset balance sheet account or an increase to a Liability balance sheet account.
    REQUIRED:
    • What
    • Why
    • Who
      • Name
      • Office
      • Phone

    XECG: Contract & Grant Transfer of Expense

    Description Field Document Reference Sign Indicator Text
    Line Item Transfer:
    Same description that appears on the ledger for the original transaction being transferred
    Line Item Transfer:
    Use the document number that appears on the ledger for that line item
    (D)ebit:
    An increase to an expense account/an increase to revenue, an increase to indirect cost if applicable.

    (C)redit:
    A decrease to an expense account/a decrease to revenue, a decrease to indirect cost if applicable.
    REQUIRED:
    • What
    • Why
    • Who
      • Name
      • Office
      • Phone

    When to Use XECG

    • Fund is a Restricted fund
    • To correct bookkeeping or clerical errors in original charges
    • To add or change activity codes
    • To distribute expenses associated with closely related work supported by more than one funding source
    • To record a change in a decision made originally as to the use of goods or services
    • To clear an overdraft to another Restricted fund

    XTOF: TOF — General Transfer Of Funds

    Description Field Document Reference Sign Indicator Text
    Suggest using the organization/account code the budget is being moved to for the decrease transaction and using the organization/account code the budget is being moved from for the increase transaction. Required. Starts with assigned two-character Unit Alpha Code. (+)
    An increase to an expense budget.

    (-)
    A decrease to an expense budget.
    REQUIRED:
    • What
    • Why
    • Who
      • Name
      • Office
      • Phone

    When to Use a TOF Form

    • to move budget from one organization to another within the same funding source.
    • to redistribute budget from the pool budget account to expenditure account codes and/or activity codes.

    XDCG: Contract & Grant and Special State Budget Transfer

    Description Field Document Reference Sign Indicator Text
    Use ORG code and account code
    to which the budget is being
    moved for the decrease, Use
    ORG code and account code of the
    budget from which dollars are being removed​
    Not required (+) An increase to an expense budget.

    (-) A decrease to an expense budget.

    This XDCG rulecode REQUIRES that the document be balanced WITHIN each fund; the sum of all transaction amounts must equal zero for each fund
    • WHAT
    • WHY and
    • WHO
      • Name
      • Office
      • Phone

    When to Use XDCG

    • Fund is a Restricted Contract & Grant, or Special State Appropriation
    • To move budget to another budget pool account code within fund

    Multiple Units Sharing Costs Associated with an Event

    Use a TOE to process transactions required for units sharing costs of an event (when there is an aggregate of event expenditures to distribute or when the coordinating unit requests contributions prior to incurring event expenditures).

    • Unit receiving the charge: Debit account code 001280
    • Unit recharging the expense: Credit account code 006500
    Note: A contributing unit cannot use contract or grant funds under the temporary recharge activity method.

    Office of Record

    A Department/Division that generates a document is the Office of Record for that Document. Responsibilities include organizing, maintaining, and retrieving documents including supporting documentation.

    Retention Guidelines

    • (Non-government) TOE: 5yrs; TOF: 10yrs. Starts after the end of the fiscal year in which it was produced.
    • Government and Contracts and Grants: Check with Extramural Funds

    Back to Top
  • Recharge and System Generated Rule Codes and Contacts

    Many journals in FIS are generated by Recharge processing data files and by cyclical system processes (such as fiscal close).  These journals do not have an associated person’s userid.  The chart below details these Rule Codes, the Journal Prefix used with each, and a contact email to use if there are questions about transactions on these journals.  Note that all these types of journals bypass Journal Voucher Approval routing.

    ​​Rule Code Prefix​ ​Description Contact​
    W032 ​KQ Catering Services Encumbrance Liquidation ​fis_probs@ucsc.edu
    W032 ​KW Software Licensing Encumbrance Liquidation ​fis_probs@ucsc.edu
    ​WACR ​J ​Prior Year Accrual Reversing JVs ​fis_probs@ucsc.edu
    WAIL ​KL AIS Loan Balance Transfer ​fis_probs@ucsc.edu
    WAIS ​KS AIS Transaction Feed ​fis_probs@ucsc.edu
    WBAP ​JU Budget Analysis & Planning Interface JVs ​bap-uploads-group@ucsc.edu
    WCFR ​JF Physical Plant Recharges ​CruzFixHelp@ucsc.edu
    WCPY ​JM Copier Program Recharges ​copierprogram@ucsc.edu
    WCPY ​JM Copy Center Recharges ​copy@ucsc.edu
    WCTE ​JU CTE Card Expense Distribution (non-CruzFly) ​finpolicy@ucsc.edu
    WCTE ​KT CTE Card Expense Distribution (CruzFly) ​cruzfly-help@ucsc.edu
    WCTR ​JU Catering Services Recharge ​fis_probs@ucsc.edu
    WD01 ​ZN July 1 Adjusted Budget ​bap-uploads-group@ucsc.edu
    WEDR ​JU E-invoice Discount Reallocation ​fis_probs@ucsc.edu
    WEND ​JR UCOP Endowment Transfer ​fis_probs@ucsc.edu
    WGRG ​JG Fleet Services Recharges ​fleets@ucsc.edu
    WGSR ​KG Distribution of GSR Fees ​bap-uploads-group@ucsc.edu
    WLIB ​J Pro-Card Liability Transactions ​fis_probs@ucsc.edu
    WLTR ​JU Learning Technologies Recharges ​media@ucsc.edu
    WMAL ​JJ Mail Services Recharges ​mailbilling@ucsc.edu
    WPBS ​KN PBSci Recharges fis_probs@ucsc.edu
    ​WPRA ​LW ​Payroll Work-Study Admin Fee ​fis_probs@ucsc.edu
    ​WPRB ​LB ​Payroll Benefits Budget Offsets ​fis_probs@ucsc.edu
    ​WPRF ​LD ​Payroll Expense
    ​fis_probs@ucsc.edu
    WPTX ​JU Pro-Card Tax Expense Allocation ​fis_probs@ucsc.edu
    WREC ​KC Receiving Services Recharges ​mailbilling@ucsc.edu
    WRES ​KP Office of Research Recharges ​fis_probs@ucsc.edu
    WSOE ​KM BSOE Recharges fis_probs@ucsc.edu
    WSRB ​KB Surplus Sales - Budget ​mailbilling@ucsc.edu
    WSRR ​KR Surplus Sales - Revenue ​mailbilling@ucsc.edu
    WSTB ​JU STIP Budgetary Redistribution
    ​fis_probs@ucsc.edu
    WSTF ​JU STIP Financial Redistribution ​fis_probs@ucsc.edu
    WSWO ​JU Software Licensing Recharge ​fis_probs@ucsc.edu
    WTEL ​JT Telecommunications (phone, computing & networking) Recharges ​itsbill@ucsc.edu (creates ticket)
    WTL2​ ​KD ​Software Subscription Recharges​ ​​itsbill@ucsc.edu (creates ticket)
    WTIL ​KA Interlocation Transfer of Funds ​bap-uploads-group@ucsc.edu
    ​WUC4
    WUCL
    WUCX
    ​JU ​UCO Lick Recharges ​ljcarver@ucsc.edu,
    aeredia@ucsc.edu
    WUFB ​JU Foundation Budget Transfer ​chareyno@ucsc.edu
    WUFR ​JU Foundation Revenue Transfer ​chareyno@ucsc.edu
    ​WUJV ​JU ​Miscellaneous System Transactions ​fis_probs@ucsc.edu
     

    ​​​

    Back to Top
  • UCOP CCoA Fund Attributes
    UCOP Common Chart of Accounts (CCoA) Fund Attributes are primarily entered by Central Accounting and Extramural Fund Accounting on the FZMFUND page in FIS Banner. Attributes entered on this page provide a mapping to UCOP's CCoA fund hierarchy, and provide additional information to the UCOP financial system.

    UCOP Parent Fund Code CCoA Attribute:

    UCOP Parent Fund Code is a CCoA element used to map a UCSC fund code to the CCoA fund hierarchy. UCOP Parent Fund code functionally replaces UCOP Fund Group code. Going forward, UCOP will not maintain Fund Group codes; however current fund group codes can usually be used to determine the new UCOP Parent Fund Code.

    View Image


    To determine and enter UCOP Parent Fund Code:

    • Tab to the UCOP Fund Group field and use List of Values (or press F9) which opens FZVUFGC Fund Group Code List.
    • Filter on FZVUFGC using the assigned Fund Group Code.
    • If the UCOP Parent Fund Code is ‘SPEC’ or ‘MULT’, email fis_probs@ucsc.edu.
      • Note: it is possible that UCOP Parent Fund code maps to multiple Fund Group Codes; these are notated as MULT (Multiple). Additionally, it is possible that there is not a direct mapping from a UCOP Parent Fund code to a Fund Group code; these are notated as SPEC (Special).
    • Otherwise, copy the corresponding UCOP Parent Fund Code from FZVUFGC into the FZMFUND UCOP Parent Fund Code field.

    UCOP Endowment Type CCoA Attribute:

    UCOP Endowment Type is a Common Chart of Accounts (CCoA) element used to track funds functioning as an endowment for UCOP reporting purposes.

    View Image


    To determine and enter UCOP Endowment Type:

    • Values are either ‘FFE’ (Fund Functioning as an Endowment) or blank.
    • University Advancement Department of Operations & Finance requests Endowment Fund setup from EMF. The value in the “Type” column of the spreadsheet request will indicate if a fund should be coded FFE in the UCOP Endowment Type field.
      • If ‘Type’ is FFE, enter FFE in UCOP Endowment Type.
      • If ‘Type’ is not FFE, then leave UCOP Endowment Type blank.
    • If the fund setup request is not endowment-related, leave the UCOP Endowment Type field blank.


    UCOP Program Code CCoA Attribute:

    View Image



    UCOP Program Code: If there is a Program Code that needs to be indicated on a fund,Budget Analysis and Planning will request EMF to make the update. This is a rare occurrence. Please contact ask-bap-group@ucsc.edu for questions regarding this field.
    ​​
    ​​​​​

    Back to Top
  • FZMUFND UCOP Fund Structure Page
    FZMUFND is a resource to query and review the UCOP Common Chart of Accounts fund hierarchy. This page displays all levels of the UCOP hierarchy. The UCOP Parent Fund code is designated as Fund Level C on FZMUFND. The FIS Office will maintain this page as UCOP updates their fund hierarchy.

    FZMUFND can also be accessed from the FZMFUND page by tabbing to UCOP Parent Fund Code and using the list of values (or F9).

    View Image


    Please contact fis_probs@ucsc.edu with any questions.​​​


    Back to Top
  • FZVUFGC Fund Group Code List
    FZVUFGC now includes UCOP Parent Fund Code and Title and includes mapping to existing Fund Group code. As UCOP deprecates fund group codes, the FZMUFND UCOP Fund Structure page can be referenced to determine appropriate UCOP Parent Fund Codes.

    View Image

    Back to Top
There are no results.