News  
   Documentation  
   Help  
 Training 
 Labs
 Contacts 
 Connecting
 About   
 Purchases
 Policies
 TTU Home  
 ITS Home

 

FileMaker Requisition System for use with FOAPAL - Banner Finance

Other Forms          New FY Instructions


Download the FOAPAL ready files
  1. Create a folder on your computer for the upcoming fiscal year, such as FY 07-08
    For example in Windows, right-click and select New > Folder
     
  2. Create a folder within the FY 07-08 folder for each specific account, such as Main Dept Account
  3. Click on the links below under the correct version of FileMaker that you are using. 
    If you are unsure, open a requisition file for this FY and from the menu select Help > About FileMaker Pro and note the version.
  4. For the Requisition System, download the files:  Supplies, Clone, and AccountCodes
  5. From your current FY, copy the file "vendors" to your new FY account folder, so that you retain your own list of vendors.  New users only should download the file Vendors from this web site.
  6. Download any other files you use to the appropriate folders, such as Grants_Req to a grants folder.

FileMaker v. 3 or 4.1

FileMaker v.5 or 6 FileMaker v.7 or 8 Needed For:
Supplies Supplies Supplies Supplies Requisitions
Equipment Equipment Equipment Equipment Requisitions
Travel Requisiton Travel Requisiton Travel Requisiton Travel Requisitions
AccountCodes AccountCodes AccountCodes Supplies, Equipment, and Travel Requisitions
List of Account Codes in Excel format
Clone Clone Clone Supplies Requisitions
Vendors
(use your current file in most cases)
Vendors
(use your current file in most cases)
Vendors
(use your current file in most cases)
Supplies and Equipment Requisitions
FileMaker v. 3 or 4.1 FileMaker v.5 or 6 FileMaker v.7 or 8 Needed For:
IDTs
IDTs
(Debit and Credit FOAPALS can change.)
IDTs
(Debit and Credit FOAPALS can change.)
IDTs
(Debit and Credit FOAPALS can change.)
Interdepartmental Transfers
IDTs
(Credit FOAPAL is Static)
IDTs
(Credit FOAPAL is Static)
IDTs
(Credit FOAPAL is Static)
Interdepartmental Transfers
IDT (Word Version) New
FileMaker v. 3 or 4.1 FileMaker v.5 or 6 FileMaker v.7 or 8 Needed For:
Personnel Action Forms
PAF PAF PAF Personnel Action Form

 

FileMaker v. 3 or 4.1 FileMaker v.5 or 6 FileMaker v.7 or 8 Needed For:
Student Payroll Forms
Work Study Form/Req Work Study Form/Req Work Study Form/Req Work Study Payroll
Work Study Student Data Work Study Student Data Work Study Student Data Needed with file above
       
Student Salaries Form/Req. Student Salaries Form/Req. Student Salaries Form/Req. Student Workers Payroll
Student Workers Data Student Workers Data Student Workers Data Needed with file above
 

Student Payroll Report (PDF fill-in form version  with Banner ID) New

Work Study Payroll Report (PDF fill-in form version with Banner ID) New

New Student Hire or Change of Position Form (PDF fill-in form version) New

 

FileMaker v. 3 or 4.1 FileMaker v.5 or 6 FileMaker v.7 or 8 Needed For:
GRANTS
Grants Requisitions Grants Requisitions Grants Requisitions Grants Requisitions
Grants Student Workers Data Grants Student Workers Data Grants Student Workers Data Use with above Grants Req
AccountCodes AccountCodes AccountCodes Use with above Grants Req
Clone Clone Clone Use with above Grants Req
Vendors
(use your current file in most cases)
Vendors
(use your current file in most cases)
Vendors
(use your current file in most cases)
Use with above Grants Req
 
Forms in Other Formats
Claim for Personal Mileage
(Office XP - Excel format)
 
Travel Claim Form (Overnight)
(Office XP - Excel format)
 
Right click on a link below and select Save Target As... and navigate to the location you want to save it.

Supplies Requistion - Word Version  - ONLY for those with very few requisitions

Supplies Requisition - PDF version - ONLY for those with very few requisitions - Does some computations.

 

Hourly Time Sheet  (with Banner ID) New 
(Excel)
 
Reallocation form - Labor  New                   Reallocation Form - Benefits  New 
(Word)
 

Using the FileMaker Supplies, Equipment or Travel Requisitions

  1. Lookup your FOAPAL
  2. Double click on the supplies file to open it.
  3. You do NOT need to go into layout mode to set up this file.  Instead, there are now global fields for the account information. Simply click into the field and type the COAS, Index, Fund, Organization, and Program Codes ONE time.

 

  1. Switch to the Requisition view and type in the Account Name, College, Department, Name, Building, and Room one time.
  2. Close supplies.

 


 
  1. If needed, open Equipment and do the same as for supplies to enter FOAPAL information and departmental information.
  1. Double click on Travel_Req file to open it and and type the COAS, Index, Fund, Organization, and Program Codes one time.  Type in the College and Department.
  2. Do this for the supplies, equipment and travel requisition files in each account folder that you have.

 

Trimming the Account Codes File (Optional)

  • Double click on the AccountCode file.
  • You will see 161 records which are all the possible account codes.
  • In order to make the list more manageable as a dropdown list in the supplies file, you may wish to delete some of these codes IF you know you will never use them in a given account.
  • Type an "x" into the Flag field for those records that you want deleted.
  • Enter Find mode and type an "x" in the flag field to find the marked records.
  • Click the Find button or hit Enter.
  • Look over your list of items to delete.
  • From the menu, select Mode > Delete All 
  • Confirm that you want to delete the items in the found set.
  • If you wish to start over, just download the AccountCode file again.
  • If this reduced list applies to several of your accounts, just copy it into the appropriate folders.


If you see errors in the way these files were set up or for help with the FileMaker Requisition System contact Tracy Farris (tfarris@tntech.edu) or Elaine Wells (ewells@tntech.edu).

 

 

 

Maintained by:  Academic Computing Support Last updated: May 14, 2007
TTU Home     ITS Home     Contacts     News
Copyright © Tennessee Technological University. All rights reserved.
Information Technology Services, Box 5071— Clement Hall 220, Cookeville, Tennessee 38505   Phone: 931.372.3387