Report Descriptions

 

MENU STRUCTURE
The Focus menu is arranged by business functions. It allows the user to select reports from the Accounting, Accounts Payable, Purchasing, Fixed Assets or Account Status modules of the FRS system. By placing your cursor on the '+' sign next to the business function of choice you will be brought to a menu of reports available under function. Each of these business functions will offer reports pertinent to that area's activity. Below is a summary of the type of reports you will expect to find under each business function. A more in-depth descussion of the reports also follows.
   
ACCOUNTING
- Offers reports that detail transaction activity.
ACCOUNTS PAYABLE
- Reports to track discounts taken or lost, vendor payments, outstanding invoices.
FIXED ASSETS
- Building, Space & Equipment Inquiries and Lists.
PURCHASING
- Purchase order reports.
ACCOUNT STATUS
- User accounts, budget balances & open encumbrances.

 

ACCOUNTING REPORTS  
  • TRANSACTIONS (F9530U04)
This report allows the user to choose which fiscal year they would like to report transaction data from. Because the report draws data from multiple transaction files, it must link to all of them, which may take a few minutes. Once the links have been established the program will prompt the user for FY, Account number(s), subcodes, etc. The prompts provide examples of how the user should enter the data. Be sure to enter data according to the examples provided by the prompts.
  • CURRENT YEAR TRANSACTIONS (F9530U05)
This report reports on transaction detail for the current fiscal year only. Like the first report, it must also link to the various transaction files for the data. It will prompt for Account number(s), subcodes, start and end dates. Again, follow the input instructions given by the prompts.
  • DETAIL TRANSACTIONS THAT SPAN FISCAL YEARS FOR ONE SELECTED ACCOUNT (F9530U17)
Transactions over several fiscal years for a specified account are reported in this focexec. User may enter only one account at a time.Allows the user to report transactions across Fiscal Years for the specified account. Especially useful for project accounts.
  • EXPENSE REPORT FOR A SPECIFIED PERIOD (F9530U32)
Reports on expenses occurring over a specified period of time. This will report only transactions with trancodes 04x and 06x.
  • REVOLVING ACCOUNT DETAIL BY SELECTED GL ACCOUNT (F9530U15)
Reports the SL expense and revenue subcode detail for a specified GL account. The user must have access to all SL accounts that report up to the specified GL account.
  • REVOLVING ACCT SUMMARY BY SELECTED GL ACCOUNT (F9530U16)

Summarizes the SL expense & revenue amounts under a specified GL account. The user must have access t all SL accounts that report up to the specified GL account.

 

 

ACCOUNTS PAYABLE REPORTS  
  • SUMMARY OF TRADE DISCOUNTS LOST (F9530U07)
This report will display the discounts that a department lost once the discount period expired. The user is prompted to enter a start and end date, as well as their department number. This report gives read access to two FRS data files, so the wait to link to these two files is much shorter than that of the Accounting reports.
  • SUMMARY OF TRADE DISCOUNTS TAKEN (F9530U08)
A department will earn discounts if payment is made within the discount period. This report will reflect all the discounts that a department earns over a specified period. Again, the user is prompted for start & end dates, as well as their department number.
  • PAYMENT HISTORY SEARCH (F9530U09)
This report provides a summary of invoices batched against particular accounts over a specified period of time, as indicated by the user through prompts.
  • OUTSTANDING INVOICES (F9530U31)
Reports outstanding invoices.

 

FIXED ASSETS REPORTS  
  • BUILDING INFORMATION (F9530U18)

This report allows the user to view all buildings by building name or building number. The user may also enter a specific department number to bring up a list of buildings associated with that particular department.

  • ROOM USE DATA (F9530U19)
Lists the room use data based on the information supplied by the user for a particular room.
  • SCREEN/DETAIL PERCENTAGES (F9530U20)
Similar to screen 5SS, which is used for the space study survey. Fields found on the 5SS FRS screen will be found here as well.
  • ENDED/CONTINUING PROJECTS (F9530U21)
This report gives a listing of project accounts that have either ended or are continuing.
  • ROOM OCCUPANTS (F9530U22)
Will list out the occupants for a specified room if the information is available.
  • FRS ACCOUNT LISTING (F9530U23)
This gives a report of the accounts used under the space study for a specified department.
  • BUILDING/EQUIPMENT LISTING (F9530U24)
Report of equipment found in each building for the department specified.

 

PURCHASING REPORTS  
  • PURCHASE ORDER QUERY (F9530U29)
Based on User input, this will produce a report summarizing Purchase Order information.

 

ACCOUNT STATUS REPORTS
  • BUDGET BALANCES BY ACCOUNT - for a specified Department. (F9530U01)
Reports the remaining spendable balance available to Responsible Persons within a department. Represents the direct cost value found on screen 19 of FRS. The report is sorted by account, by end date, by responsible person. The user is prompted for account number, department number and subcodes.Enter upto 5 accounts at any one time.
  • BUDGET BALANCES BY RESPONSIBLE PERSON- For a specified Department. (F9530U02)
This report displays the same information as the Buget Balances by Account report except that the data is sorted first by responsible person. Enter upto 5 accounts at any one time.
  • PRINCIPLE INVESTIGATOR'S BUDGET & EXPENSE SUMMARY. (F9530U27)
Reports the current budget and expenses for a specified PI.
  • BUDGET BALANCES BY PAYROLL ID (F9530U28)
Gives the available budgets based on a specified payroll id.
  • DIRECT & INDIRECT COSTS BY ACCOUNT (F9530U33)
Reports on the total direct and indirect costs for a specified department and account number(s). Will display beginning budget, encumbrances, expenses and remaining budgets under both categorie.
  • ENCUMBRANCES (OPEN COMMITMENTS -F9530U03)
Reports the current encumbrances for specified 6-digit account numbers and subcodes.
  • MY GENERAL LEDGER ACCOUNTS (F9530U26)

Will list the FRS General Ledger accounts that the user has access to. The report will show the account number, description, responsible person, status, grant/contract and an end date if the account is a project account.

  • MY SUBSIDIARY LEDGER ACCOUNTS (F9530U25)
The report contains a list of accounts that the user has access to. It displays the account number, description, responsible person, associated GL account, account status, type of acct and end date.
  • SL TO GL MAPPING (F9530U30)
Use to determine the Subsidiary Ledger accounts that map to a specified General Ledger account.

 

 

 

RETURN TO FOCUS MAIN MENU

Last Edited 8/21/08 c.b.mcevitt

508 UsableNet Approved (v. 1.2.1)