Home > Administration > University Offices > Admin Info Systems > Advantage > Table Inquiry

Why change from CUFS to Advantage?

Advantage Financial is the replacement for the College and University Financial System (CUFS).  This change is part of the University's year 2000 remediation plan.

Accessing Advantage
· Select ‘5’ from the VTAM Switch menu
·If the Advantage Financial sign-on screen is not present, type AFN1 to access Advantage

Signing on to Advantage for the first time:
· Enter ‘1’ to scan tables for budget or purchase order information or ‘2’ to enter a document at the Command
  prompt.
·Enter your userid, which is the first four characters of your current CUFS password
·Enter a user defined password in New Password. The password must be a minimum of four characters in length.
·You will then be asked to verify your password by entering your password at the Verification prompt.

You may change your password at any time. If you forget your password, call the Budget Office at ext. 2024 to have your password reset.  If you do not currently have a CUFS/Advantage userid and password, contact the Budget Office to establish an Advantage userid.

To scan budget data:
·Enter ‘1’ in Action to scan tables
·Press <Enter> to go to the Advantage Main Menu screen

Either use the menus or perform the following functions to move directly to the desired table:
·Enter ‘N’ in Action
·Enter ‘EXP2’ in Screen to view budget data
 Enter ‘ESUM’ in Screen to view budget data for multiple objects
·Press <Enter>

At the EXP2 Screen:
·Enter ‘S’ in Action
·Enter Budget Fiscal Year
·Enter Fund
·Enter Agency, Area in CUFS is the same as Agency in Advantage
·Enter Organization
·Tab past Activity and Object
·Enter Object
·Press <Enter>
·Press <Enter> to move to the next screen within the EXP2 table

Advantage Helpful Hints:

  • Area is referred to as Agency in Advantage
  • Use 'N' in Action followed by the table name in Screen to change tables
  • Use 'S' in Action to scan for data within a table
  • Use 'E' in Action to exit Advantage
  • Use '<' in Action or press F8 to page backward
  • An 'R' in Action will resume scanning with the next record in the table
  • The 'EB' document in CUFS is replaced by the 'TB' document in Advantage
  • The 'PD' document in CUFS is replaced the the 'PDQ' document in Advantage
  • The 'EXPC' table is termed 'ESUM' in Advantage

Advantage Tables
CUFS 
 TABLE
ADV
TABLE
DESCRIPTION
EXPB  EXP2 Budget table with only one object per screen.  Indicates the Approved Budget, Current Budget, Expended Amount, Encumbered Amount, Unobligated and Uncommitted Amount.
EXPC ESUM Budget table with multiple objects and their names on one screen.  Indicates Current Budget, Expended Amount, Encumbered Amount and Available Amount.
EXPD  EXPD Detail expenditure, encumbrance and budget transactions.  Users may view Budget, Expense, Pre-Encumbrance and Encumbrance transactions by object.
ORGN ORGN Index of organizations, their names and managers.
OBJT OBJT Index budget objects and their names.
SOBJ SOBJ Lists the expenditure sub-objects that are associated with each budget object.
VENA VNAS List vendor names alphabetically (Last Name, First Name)
VENA  VNAM  List vendor names alphabetically (First Name, Last Name)
VEND VEN2 List vendor information for a specific vendor
OPPH OPHD List open purchase order documents for PC and PD documents by document number.  OPHD is similar to OPPH in CUFS.
OPPL OPLD List open purchase order accounting lines for PC and PD documents by document number.  OPLD is similar to OPPL in CUFS.
OPPC OPCD List open purchase order commodity lines for PC and PD documents by document number.  OPCD is similar to OPPC in CUFS.
  OPPH List open purchase order header information for PC and PD documents by vendor code and document number.
  OPPC List open purchase order commodity line information for PC and PD documents by vendor code and document number.
  OPPL List open purchase order accounting line information for PC and PD documents by vendor code and document number.
  OPOD List document number and vendor codes for PO documents by document number.
  OPOH List open purchase order header information for PO documents by vendor number and document number.
  OPOC List open purchase order commodity line information for PO documents by vendor number and document number.
  OPOL List open purchase order accounting line information for PO documents by vendor number and document number.
REVB REV2 Revenue budget table with only one revenue source per screen.  Indicates the Approved Budget, Current Budget, Recognized Amount and Unrecognized Amount
REVA RSUM Revenue budget table with multiple revenue sources and their names on one screen.  Indicates Current Budget, Recognized Amount and Available Amount
VHIS   VXRF Vendor History Table
     


Data Inquiry Function Keys:

FUNCTION
KEY
ACTION
F2
T
Top of Table
F3
P
Pause
F4
E
End
F6
L
Leaf
F7
>
Display Next Screen 
F8
>
Display Previous Screen

Send questions to carrie.birckbichler@sru.edu


Slippery Rock University . 1 Morrow Way. Slippery Rock, PA . 16057
Phone 1.800.SRU.9111