Below is a list of Queries that will assist in managing your purchases
 |
 |
|
 |
FSU >> Purchasing Home >> Departmental Contacts | |
|
||||||
 |
|
|
|
|
|
|
|
|
|
Below is a list of Queries that will assist in managing your purchases
Queries by Budget
FSU_REQ_BY_REQUESTOR Identifies POs by requestor FSU_PO_BY_DEPTID_DATE – Identifies all PO’s in all statuses for a particular department
FSU_PO_BY_PROJECT_DATE – Identifies all PO’s in all statuses for a particular project.
FSU_PO_PAST_DUE_DATE – Identifies PO’s 30 days or more past due date.
FSU_PO_PAST_DUE_DATE_AP_DETAIL – same as above with more information.
FSU_DPT_PO_WITH_RECVRS_VCHRS – Detailed information about all PO’s on a chartfield combination. FSU_PO_AMT_BY_DEPTID_DATE_FUND - PO amount by DeptID-Date-Fund FSU_DPT_PO_CHANGE_ORDER - PO Change Orders by Dept
Reconciliation Queries
FSU_CAT_CATEGORY_ACTIVE – Lists all active category codes with its corresponding account code.
FSU_CAT_ACCOUNT_CATEGORY – Search for account code description and corresponding code information.
Summary Queries
Activity Summary – Overview of total receipts and payments against a PO. Navigation: Purchasing>Purchase Orders>Review PO Information>Activity Summary
Document Status – Detailed summary of all activity against a PO. Navigation: Purchasing>Purchase Orders>Review PO Information-Document Status
Manage Requisitions – You can get a quick look at your requisitions for this and last fiscal year by changing your beginning and end dates. Navigation: eProcurement – Manage Requisitions
Tracking Down Financial Information Queries
FSU_DPT_DDDH_BUD_MGR – Allows users to look up the current Department Head and Budget Manager for their department(s) or to view a list of all departments that a particular individual is responsible for as the Budget Manager and/or Department Head.
FSU_DPT_TRIAL_BALANCE – Gives users the ability to run a trial balance for their department(s) at any time.
FSU_DPT_CTR_INST_ANNUAL_EXP – Developed specifically for the University’s Centers and Institutes, this query provides these organizations with annual operating expenditure information in order for them to complete their year-end Board of Governors reports.
FSU_DPT_AM_ASSET_ACQ-CUSTODIAN – Generates detailed acquisition and custodial (i.e. offsite to) information for Property Managers and other departmental personnel that have responsibilities related to assets. FSU_PO_BUDGET_ERROR_STATUS -PO with Status=Bgt Error<>Disp FSU_PO_LN_RECV_WITH_NO_VOUCHER - PO line recv without voucher FSU_REQ_PO_RECV_PAID_BY_DEPTID - Search PO Status from requistion to purchase order to payment by Dept ID and PO date range (canceled POs are excluded) Identifing who an order belongs to FSU_PO_RECV_DELIVERY_TICKET- list the names in the comments field FSU_PO_STATUS_WITH_RECV_LN_DTL- Obtain receiving status of POs
|
|
|
| |||
| |||
|