• Funds Available Screen
• Funds Available Screen
• "9eb15ca1-a8c5-4d55-8809-f4c4a6f392fb
• This session will walk you through the steps required to find your Funds Available for a particular cost center.
• Funds Available (FA)
• = Budget (B) - Actual (A) - Encumbrance(E)
• Budget:
• Estimate of revenues and expenditures for which actuals may be measured against.
• Encumbrance:
• Commitment of expenses.  Monies which have been committed for a particular expenditure.  E.g. A new computer has been ordered but not yet received.
• Actual:
• Expenditures or revenues that have already been incurred/received.  E.g. The invoice for the new computer has been received and processed into Accounts Payable.
• It is important to understand that a user cannot make any changes in the General Ledger but can only review the information. 
• This session starts after the login process. For assistance on how to login refer to the Login training session.
• When the Funds Available form opens. The Ledger Field will always be
• Ryerson University.
• Tab
• passed the Ledger field.
• Click the drop down list in the
• Amount Type
•  field.
• The Amount Type is used to determine how the system will calculate and display the Funds Available.
• You will have four choices:
• Period To Date
• : Displays the balance for the period selected (e.g. Oct-08)
• Quarter To Date Extended:
• Is used when you want to view balances for a particular quarter. 
•  (1st Quarter: May, June, July - 2nd Quarter: Aug., Sept., Oct. - 3rd Quarter: Nov., Dec. Jan. - 4th Quarter - Feb., March, April)
• Year To Date Extended
• : Will display the data from the beginning of the fiscal period (May 2008)
•  up to the period you select in the period field. (ex. Oct.-08)
• Project To Date
• : Is used to view balances from the beginning of the project up to the period you selected (ex. Oct-08)
• In this example you will select 
• Year To Date Extended
• You will notice that when you click in certain fields the
• List of Values (LOV)
• button appears (grey button with three dots).
• The budget field has a List Of Values attached to it. If we select the LOV for this field there are two different budgets types to choose form:
• 1. The
• Fiscal Budget -
• Will be displayed as
• FY XXX BUDGET
•                                       
• where XXX represents the fiscal year.
•                                        eg. FY089 Budget stands for Fiscal Year
•                                              May 1st,2008 - April 30,2009
• 2.
• The Project Budget
• -  Will display data from the year the project
•                                            started to the current period or when the
•                                            project ended.
• Click the Budget field
• List of Values
•  button.
• Select
• FY 089 Budget
• from the list.
• Click on the 
• Encumbrance Type
•  
• LOV
• (List of Values).
• You can select any Encumbrance Type that you would like to view.  Typically
• All
• is selected to view all commitments or obligations.
• Below are 3 types of Encumbrances.
• 1. Requisition
• (called a
• Commitment
• if created after June 2008)
• 2. Purchase Order
• (called an
• Obligation
• if created after June 2008)
• 3. Invoice
• (called
• Invoices
• after June 2008)
• For this lesson select
• All
• The period becomes important based on the Amount Type selected above.
• Since we selected
• Year To Date Extended
• for the amount type, the period we select here will display the data from the beginning of the Fiscal Year indicated in our Budget up until  the Period we select here.
• Example:  If we chose to leave the period as  May 2008 then we would only retrieve the data for May 2008. By selecting Oct-2008 we will retrieve data from may 2008 until Oct 2008.
• Select the
• LOV
• (list of values) button for the Period.
• In this example select
• Oct-08
•  
• as the period.
• The company value of 1 represents Ryerson University.  This is the value that will always be used.
• Enter the value
• 1
• into the COMPANY Field
• .
• Select the
• Fund
• field. 
• Select the
• Fund LOV
• .
• A
• caution message
• will appear.  Select the
• OK Button
• . 
• Select
• OP (Oper/SRC Summary)
•  
• for the operating fund.
• Your cursor automatically moves to the High Value Field.
• Press 
• [Tab]
• t
• o move to the next field
• Select the
• Cost Centre LOV
• A
• Longlist
• text box will appear.  The text box will say that
• "This is a long list.  Please enter a partial value to shorten list
• ." 
• In Oracle you can use the
• %
• (
• wild character
• ) to search for all values in the list.
• Enter the
•  
• %
•  
• to search for the cost centres
• .
• Click the 
• OK
•  button.
• A
• caution message
• will appear, click the
• OK Button
• .
• All items that contain training% appear.
• Select -
• 10113
• (Financial Systems & Training).
• The Amount Type is used to determine how the system will calculate and display the Funds Available.
• You will have four choices:
• Period To Date
• : Displays the balance for the period selected (e.g. Oct-08)
• Quarter To Date Extended:
• Is used when you want to view balances for a particular quarter. 
•  (1st Quarter: May, June, July - 2nd Quarter: Aug., Sept., Oct. - 3rd Quarter: Nov., Dec. Jan. - 4th Quarter - Feb., March, April)
• Year To Date Extended
• : Will display the data from the beginning of the fiscal period (May 2008)
•  up to the period you select in the period field. (ex. Oct.-08)
• Project To Date
• : Is used to view balances from the beginning of the project up to the period you selected (ex. Oct-08)
• In this example you will select 
• Project To Date.
• You will notice that when you click in certain fields the
• List of Values (LOV)
• button appears (grey button with three dots).
• The budget field has a List Of Values attached to it. If we select the LOV for this field there are two different budgets types to choose form:
• 1. The
• Fiscal Budget -
• Will be displayed as
• FY XXX BUDGET
•                                       
• where XXX represents the fiscal year.
•                                        eg. FY089 Budget stands for Fiscal Year
•                                              May 1st,2008 - April 30,2009
• 2.
• The Project Budget
• -  Will display data from the year the project
•                                            started to the current period or when the
•                                            project ended.
• Click the Budget field
• List of Values
•  button.
• Select
• Project Budget
• from the list.
• Click on the 
• Encumbrance Type
•  
• LOV
• (List of Values).
• You can select any Encumbrance Type that you would like to view.  Typically
• All
• is selected to view all commitments or obligations.
• Below are 3 types of Encumbrances.
• 1. Requisition
• (called a
• Commitment
• if created after June 2008)
• 2. Purchase Order
• (called an
• Obligation
• if created after June 2008)
• 3. Invoice
• (called
• Invoices
• after June 2008)
• For this lesson select
• All
• The period becomes important based on the Amount Type selected above.
• Since we selected
• Project To Date
• for the amount type, the period we select here will display the data from the beginning of the Project indicated in our Project Budget up until  the Period we select here.
• In this example we will retrieve data from the start of the project until Aug 2009.
• Select the
• LOV
• (list of values) button for the Period.
• Select
• Aug-09
• for the period list.
• Click in the 
• Summary Account
•  field.
• The
• Find Accounts
• form will launch.
• The company value of 1 represents Ryerson University.  This is the value that will always be used.
• Enter the value
• 1
• into the COMPANY Field
• .
• Your cursor automatically moves to the High Value Field.
• Press 
• [Tab]
• t
• o move to the next field
• Select the
• Fund LOV
• .
• A
• caution message
• will appear,
• Click the 
• OK
•  button.
• Select
• PJ (Project Summary)
•  
• for the operating fund.
• Your cursor automatically moves to the High Value Field.
• Press 
• [Tab]
• t
• o move to the next field
• Select the
• Cost Centre LOV
• A
• caution message
• will appear, click the
• OK Button
• .
• Click in the 
• Find
•  field.
• All items that contain oia% appear.
• Select  -
• 57432
• (OIA: OHSB-Related Activities).
• When the Find Accounts form opens this is where you key in your Chart of Accounts information.
• Company - Fund - Cost Centre- Account - Activity - Employee/Course - Location
• eg. 1-OP-10113-7731-0000-00000000-000   (Note: The Location segment is not currently used.)
• It is important to note that for the Funds available screen you are only
• required
• to enter information from the
• Company
• to the
• Cost Center
• in order to search for the funds available. You
• do not
• need to enter the Account to Location information in the Chart of Account unless you require specific details in your search.
• We will go into further detail of each segment as we enter the data into this window.
• When entering in the Account information we have 2 options. Entering the values directly into the field for using the List of Values (LOV) for each field to search any of the value you are unsure of.
• In this example we will review both options.
• Enter the value
• "
• training%
• " into the
• Find
• field
•  
• after the
• %.
• Note:
• You can search by the cost centre value or the description of the cost centre.  For this example we will be searching by the cost centre description "
• training%"
• .
• The Account Level will remain as the default
• All
• .
• The
• Chart of Summary Accounts Codes
• lists the funds checking parameters defined for each summary template set-up by finance.
• Summary Inquiry Example:
• 1-OP-10113-xxxx-xxxx-xxxxxxxxx-xxx
• Summary Accounts can be used to perform summary level inquiries.  Summary accounts group your revenue and expenses into specific major categories: Total Revenue, Total Salaries, Total Benefits, Total Non-Salary Expenses & Net Total lines.
• Listed in this screen capture the Summary Account Values and the Account Code Ranges.
• Click in the 
• Summary Account
•  field.
• The
• Find Accounts
• form will launch.
• Your cursor automatically moves to the High Value Field.
• Press 
• [Tab]
• t
• o move to the next field
• The Account Level will remain as the default
• All
• .
• When the Find Accounts form opens this is where you key in your Chart of Accounts information.
• Company - Fund - Cost Centre- Account - Activity - Employee/Course - Location
• eg. 1-PJ-10113-7731-0000-00000000-000   (Note: The Location segment is not currently used.)
• It is important to note that for the Funds available screen you are only
• required
• to enter information from the
• Company
• to the
• Cost Center
• in order to search for the funds available. You
• do not
• need to enter the Account to Location information in the Chart of Account unless you require specific details in your search.
• We will go into further detail of each segment as we enter the data into this window.
• When entering in the Account information we have 2 options. Entering the values directly into the field for using the List of Values (LOV) for each field to search any of the value you are unsure of.
• In this example we will review both options.
• The
• Chart of Summary Accounts Codes
• lists the funds checking parameters defined for each summary template set-up by finance.
• Summary Inquiry Example:
• 1-PJ-57432-xxxx-xxxx-xxxxxxxxx-xxx
• A
• Longlist
• text box will appear.  The text box will say that
• "This is a long list.  Please enter a partial value to shorten list
• ." 
• In Oracle you can use the
• %
• (
• wild character
• ) to search for all values in the list.
• Enter the
• %
•  
• to search for the cost centres
• .
• Enter the value
• "
• oia%
• "
• into the
• Find
• field
•  
• after the
• %.
• Note:
• You can search by the cost centre value or the description of the cost centre.  For this example we will be searching by the cost centre description
• "oia%"
• .
• Summary Accounts can be used to perform summary level inquiries.  Summary accounts group your revenue and expenses into specific major categories: Total Revenue, Total Salaries, Total Benefits, Total Non-Salary Expenses & Net Total lines.
• Listed in this screen capture the Summary Account Values and the Account Code Ranges.
• Here you can see the following:
• Total Revenue:
• 5999
• Total Salaries:
• 6899
• Total Benefits:
• 6999
• Total Non-Salary Expenses:
• 8999
• Net Total Line:
• 9999
• To see the Funds Available for this cost center look at the net total line
• 9999
• .
• In this example our
•  
• Funds Available
• is
• 51,664.89
• .
• Press 
• [End]
• .
• Here you can see the following:
• Total Revenue:
• 5999
• Total Salaries:
• 6899
• Total Benefits:
• 6999
• Total Non-Salary Expenses:
• 8999
• Net Total Line:
• 9999
• To see the Funds Available for this cost center look at the net total line
• 9999
• .
• In this example our
•  
• Funds Available
• is
• 23,502.30
• .
• Original Path
• Please make a selection from the options listed below.
• Fiscal Budget
• Project Budget
• Ledger
• Amount Type
• Year To Date Extended
• Year To Date Extended
• FY 089 Budget
• OK
• Encumbrance Type
• All
• OK
• Period
• ListView13
• OK
• Company Information
• Fund
• IconButton1
• OK
• Fund LowOP
• OK
• FUND: High
• Cost Centre LOV
• Partial Value
• OK
• OK
• Find
• Find
• ListView60
• OK
• OK
• Project To Date
• Budget List of Values
• Project Budget
• OK
• Encumbrance Type
• All
• OK
• Period
• Aug-09
• OK
• Summary Account
• Company Information
• COMPANY: Low
• Fund LOV
• OK
• Project Summary
• OK
• IconButton16
• Cost Centre LOV
• OK
• Find
• ListView133
• OK
• OK
• Find Account Search
• Summary Account
• COMPANY: High
• Partial Value
• OK
• Find
• Find