CAPPS Reports
Financials
Or click on the headings below to open a topic individually.
Accounts Payable [+]
| Report Title | System | Navigation | Description |
|---|---|---|---|
| Draft Voucher Print | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > Draft Voucher Print | Report provides a printable version of an AP voucher but, unlike the Voucher Print Report, this can be printed from the voucher via the Draft Voucher Print pushbutton on the voucher Identifying Information page. Typically, this is used to view a voucher prior to submitting it for processing by the USAS interface (TXCAPD02). |
| Prompt Pay Act Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > Prompt Pay Act Report | Prompt Pay Act Report (TXCAP001) – Payment for goods and/or services provided to the agency are paid in accordance with HB 1209, the Prompt Pay and Scheduling Act, which is 30 days from the date the invoice was received in the agency or the date the service was completed or the goods were received in the agency, whichever is later. The HB 1209 Compliance Report lists the interest vouchers and their associated vouchers generated for a particular range of time and notes the percentage of vouchers that were in compliance with HB 1209 |
| Receipts Pending Aging Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > Receipts Pending – Aging Rpt | Lists open receipts. (TXCAP005A) |
| Single Vendor Payment Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > Single Vendor Payment Report | Lists vouchers for Single Vendor Payment Report. (TX_SNGLVNDR) |
| Transactions by Vendor Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > Transactions by Vendor Report | Ties together information from the Voucher, PO, KK and Receiver records for vendor transactions/payments (TXEAP70B). |
| USAS Pre-Release Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > USAS Pre-Release report | CPA USAS Pre-Release Report (TXCAP003) – lists the vouchers picked up by the outbound interface and ready to be released in USAS for processing. |
| USAS Pre-Release Report by Origin | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > USAS Pre-Release Rpt by Origin | Provides the same information as the current USAS Pre-release Report but will not include batch information and adds Voucher Origin as a prompt (TXCAP003A). |
| USAS Pre-Release with PO/Invoice | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > USAS Pre Release PO/Invoice | An expanded version of the current USAS Pre-release Report with Purchase Order and Invoice information added (TXCAP003B). |
| Voucher Exceptions Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > Voucher Exceptions Report | Lists all possible issues that are preventing a voucher from being picked up by the outbound interface (TXCAP018). |
| Voucher Print | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Accounts Payable > Voucher Print | Provides a printable version of an AP voucher. Typically this report is used to print vouchers that have been picked up by the USAS interface and are ready for review prior to releasing them in USAS. Added the ability to optionally select vouchers for a specific voucher origin and to optionally include DLT to the Voucher Print report (TXCAP002). |
| AP Invoice Aging Report | Business Objects | CAPPS Financials Reports > Accounts Payable > Statewide Report > Invoice Aging | Report breaks out outstanding invoice totals by vendor into: Current, 1-30 Days, 31-60 Days, 61-90 Days, 91-120 Days, and > 120 Days. |
| AP-PO Encumbrance Detail | Business Objects | CAPPS Financials Reports > Accounts Payable > Statewide Reports > AP-PO Encumbrance Detail | Report will be used to track detailed encumbrance balances along with voucher transactions and budgets associated with those PO's. |
| Expenditures by Coding Block | Business Objects | CAPPS Financials Reports > Accounts Payable > Statewide Report > Expenditures by Coding Block | Lists the following voucher fields: PCA, Account, Department, Fund, Product, Project ID, Program, Chartfield1, AY, Voucher ID, Vendor, Vendor Name, Payment #, Pay Date and Amount. |
| Payments Against Contracts | Business Objects | CAPPS Financials Reports > Accounts Payable > Statewide Report > Payments Against Contracts | Payments against Contracts (TXEAP510B) – Report lists contracts and vouchers that made payments against those contracts. It includes the voucher, Vendor name, PO, dates, payment number and payment amount. The report has a total by contract and a remaining balance. The total and remaining balance do not show online when you run the report, but when you print it, they display. |
| Voucher Processing Results Exception Report | Business Objects | CAPPS Financials Reports > Accounts Payable > Statewide Reports > Voucher Processing Results | Report lists vouchers that had exceptions during the budget check, document tolerance and post processes. It lists the error and as well as additional information such as the userid, chartfields, amount, dates, etc. |
Asset Management [+]
| Report Title | System | Navigation | Description |
|---|---|---|---|
| Asset Active Listing Report | CAPPS Financials | Asset Management Dashboard > CAPPS AM Reports Tile > Asset Active Listing Report | Active Property Listing Report (TX_ASSET_ACT) – Report displays Active Property with report types by list, class, category, location, or custodian (BI Publisher) |
| Asset Cost ADJ and RCT Report | CAPPS Financials | Asset Management Dashboard > CAPPS AM Reports Tile > Asset Cost ADJ and RCT Report | TX_COST_ADJUST Asset Cost ADJ and RCT (TXEAM503B) – This report lists Assets Cost Adjustments and Re-categorization by AM Business Units |
| Capital Asset Summary Report | CAPPS Financials | Asset Management Dashboard > CAPPS AM Reports Tile > Capital Asset Summary Report | This report provides the cost of Assets by Asset Class Code for the Asset Capitalization Indicator statuses (Always Capitalized, Controlled, Never Capitalized, and Capitalized). |
| CAPPS SPA Reconciliation Rpt | CAPPS Financials | Asset Management Dashboard > CAPPS AM Reports Tile >CAPPS SPA Reconciliation Rpt | TXSPA001B – SPA001B-SPA Reconciliation (TXEAM515B) – Report compares/reconciles CAPPS data to SPA data. Agencies must first request the Property and Balance Extract files from SPA and then request CAPPS process SPA001B to be run for current data to be populated. |
| Active Asset Property Listing | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Active Property Listing | Lists active assets. Fields include: Asset Id, Asset Description, Condition, Location, Asset Class, Asset Class Description, Serial Id, Cost, Custodian and Area. |
| AM Non CAP Cost ACQ Detail | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > AM Non CAP Cost ACQ Detail | AM Non CAP Cost ACQ Detail (TXEAM512B) – This report lists Asset Acquisition detail prior to capitalizing an asset and is used for data entry cleanup. |
| Asset Accounting Entries Report | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Accounting Entries Report | Asset Accounting Entries Report (TXEAM511B) – This report lists the GL journal entries generated by Asset Management. |
| Asset Acquisitions by AFR Category | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Acquisitions by AFR Category | Asset Acquisitions by AFR Category (TXEAM506B) – This report lists Asset Acquisitions by AFR Categories by AM business Units |
| Asset Acquisitions by Dept ID | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Acquisitions by Dept ID | Asset Acquisitions by Dept ID (TXEAM507B) – This report lists Asset Acquisitions by Asset Departments |
| Asset Acquisitions by Location | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Acquisitions by Location | Asset Acquisitions by Location (TXEAM508B) – This report lists Asset Acquisitions by Asset Locations |
| Asset Acquisitions by SPA Class | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Acquisitions by SPA Class | Asset Acquisitions by SPA Class (TXEAM509B) – This report lists Asset Acquisitions by AFR Categories by Asset SPA classes |
| Asset Cost Transaction Summary and Details | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Cost Transaction Summary and Details | Asset Cost Transaction Summary and Details (TXEAM502B) – This report lists Assets Cost in a summary and detail format by date range and by AM Business Units |
| Asset Parent-Child Component | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Parent-Child Component Report | This report is needed to list all child assets (SPA components) associated withe the Parent asset. It should be based in part on the custom record tx_asset_comp. It should include breaks by Parent ID as well as basic descriptive information. |
| Asset Purchase Orders | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Purchase Orders | This new report will be used by property managers to identify purchase orders and receiving documents for assets to help plan for the tagging and distribution of assets. It is based on the CAPPS Purchase Order universe in business objects. |
| Asset Retirements by AFR Category | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Retirements by AFR Category | Asset Retirements by AFR Category (TXEAM505B) – This report lists Asset Retirements by AFR Categories by AM business Units |
| Asset Retirements by Retirement Method | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > Asset Retirements by Retirement Method | Asset Retirements by Retirement Method (TXEAM504B) – This report lists the Assets retirements by AM business Units |
| Missing Property Two Years or More | Business Objects | CAPPS reports > Statewide Reports > Asset Management > Listing of Property Missing Two Years or More | New agency report of property missing more than two years, currently in disposal method 19 in SPA. |
| Property Accountability Report | Business Objects | CAPPS Reports > Statewide > Asset Management > Property Accountability Report | Modeled after report used by CPA that includes custodian initial boxes, signature lines and legal certification language. Used for required annual certification. |
| SPA Reconciliation | Business Objects | CAPPS Financials Reports > Asset Management > Statewide Reports > SPA001B-SPA Reconciliation | SPA001B-SPA Reconciliation (TXEAM515B) – Report compares/reconciles CAPPS data to SPA data. Agencies must first request the Property and Balance Extract files from SPA and then request CAPPS process SPA001B to be run for current data to be populated. |
General Ledger [+]
| Report Title | System | Navigation | Description | Report Type |
|---|---|---|---|---|
| Balance Sheet / Statement of Net Position | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > General Ledger > Bal Sheet/Stmt of Net Position | Displays the Net Position for an agency by Fund with GL Account, by GAAP Fund, by GAAP Fund Type, by GAAP Fund Type with GL A/C, and by GAAP Fund with GL Account (TXGLAFR3). | General Ledger |
| Changes in Assets/Liabilities | CAPPS Financials | Menu > Financials > CAPPS Reports >Statewide Reports > General Ledger > Changes in Assets/Liabilities | Displays the Agency Funds Assets/Liabilities by Fund with GL- Account, by GAAP Fund, and by GAAP Fund with GL Account (TXGLAFR1). | General Ledger |
| Changes in Fund Balances- Gov | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > General Ledger > Changes in Fund Balances-Gov | Displays the Changes in Fund Balances by GAAP Fund-Gov, by GAAP Fund & Object-Gov, by GAAP Fund Type-Gov, and by Gov-GSO GSWF-GSO Cmpt Obj (TXGLAFR5). | General Ledger |
| Changes in Net Position- Fiduciary | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > General Ledger > Changes in Net Position-Fidu | Displays the Changes in Net Position by Fund – Fiduciary, by Fund and Object – Fiduciary, and by GAAP Fund – Fiduciary (TXGLAFR2) | General Ledger |
| USAS/CAPPS Reconciliation Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > General Ledger > USAS-CAPPS Expenditure Recon | Report to reconcile expenditures between USAS and CAPPS at a Summary Level, USAS Doc Number, USAS Doc Number/Ref Doc, or Report Details (TX_RECONUSAS) | General Ledger |
| Outstanding Pre-Encumbrances | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > General Ledger > Outstanding Pre-Encumbrances | Displays the Outstanding Pre-Encumberances (TX_OUTPREENC) | General Ledger |
| Journal Entry Detail | CAPPS Financials | Menu > Financials > General Ledger > General Reports > Print Journal Entry Detail | Journal Entry Detail (FIN2001) – This report displays all journal entries that were entered in the system for a business unit and ledger within the date range specified. Prints the journal entries in ascending ID order within the ledger and shows the journal date, the source, whether a reversal entry was created, journal status, posted date (if any), and a description. For each line that is included in the journal entry, lists the line number of the entry, the account number, a description, the department, product, and project ChartField values, and debit and credit detail This report was delivered by PeopleSoft and does not contain any Texas-specific fields. | GL General Report |
| Ledger Activity Report | CAPPS Financials | Menu > Financials > General Ledger > General Reports > Print Ledger Activities | Ledger Activity (GLS7002) – This report lists the beginning and ending ledger balances by ChartField combination and account. Also lists the detailed journal line activity that is posted against the ledger for the accounting periods that are specified. This report was delivered by PeopleSoft and does not contain any Texas-specific fields. | GL General Report |
| Trial Balance Report | CAPPS Financials | Menu > Financials > General Ledger > General Reports > Print Trial Balance | Trial Balance Report (GLS7012) – This report combines detail and summary balance information. Shows the ending ledger balances for the specified year and period by ChartField combination. Also displays subtotals by ChartField. Prints a final total for debits and credits. This report was delivered by PeopleSoft and does not contain any Texas-specific fields. | GL General Report |
| Agency Accounts by Type | Business Objects | CAPPS Financials Reports > General Ledger > Statewide Reports > Agency Accounts by Type | Lists agency account values by Account Type (e.g., Assets, Liabilities, Fund Balance, Revenues, and Expenditures) | General Ledger |
| Binding Encumbrance Report | Business Objects | CAPPS Financials Reports > General Ledger > Statewide Reports > Binding Encumbrances | Provide CAPPS Binding Encumbrance Listing | General Ledger |
| Journal Details | Business Objects | CAPPS Financials Reports > General Ledger > Statewide Reports > Journal Details | Journal Details (TXEGL551B) – Allows agency to review journal details by fiscal year, journal status, accounting period and fund. | General Ledger |
| Journal List by Account Type | Business Objects | CAPPS Financials Reports > General Ledger > Statewide Reports > Journal List by Account Type | For the new agency implementation. The purpose of this report is so that the agencies can review a list of all journals for a specific account type such as Revenue, etc. This report will satisfy the requirements for the RRC Revenue Query, PUC Open Records Request, and PUC Penalty Revenue Report. | General Ledger |
| Outstanding Pre-Encumbrances | Business Objects | CAPPS Financials Reports > General Ledger > Statewide Reports > Outstanding Pre-Encumbrances | This report details the pre-encumbrance chartfields and balances for outstanding requisitions. | General Ledger |
| Commitment Control Activity Log Report (summary & detail) | CAPPS Financials | Menu > Financials > Commitment Control > Budget Reports > Create KK Activity Log | Displays budget-checking activity by Commitment Control Transaction Date, Commitment Control Transaction ID, source transaction type, Commitment Control ledger group, and ledger type (amount type). (BI Publisher detail GLX8570 and summary GLX8571) | KK Budget |
| Commitment Control Associated Budgets Report | CAPPS Financials | Menu > Financials > Commitment Control > Budget Reports > Associated Budgets Report | Displays all associations between expenditure and revenue budgets for a business unit, including the budgets' Commitment Control ledger groups and Chartfield combinations along with revenue linking method, revenue cap, and revenue percentage. (BI Publisher GLX8110) | KK Budget |
| Commitment Control Budget Control Report | CAPPS Financials | Menu > Financials > Commitment Control > Budget Reports > Budget Control Report | Displays the Ruleset ChartField, Control ChartField, and Commitment Control Option for each Ledger Group in a SetID, as of the date you specify. (BI Publisher GLX8051) | KK Budget |
| Commitment Control Budget Key Translations Report | CAPPS Financials | Menu > Financials > Commitment Control > Budget Reports > Budget Key Translations Report | Displays each key ChartField for each Ruleset in each Commitment Control ledger group in a SetID, along with the ChartField's translation tree name and budgetary tree level. (BI Publisher GLX5080) | KK Budget |
| Commitment Control Budget Ledger Details Report | CAPPS Financials | Menu > Financials > Commitment Control > Post Control Budget Journals > Budget Ledger Details Report | Displays budgets and their budget journals. (SQR GLS8002) | KK Budget |
| Commitment Control Budget Status Report | CAPPS Financials | Menu > Financials > Commitment Control > Budget Reports > Print Budget Status Report | Displays all Commitment Control ledger amounts (budget, pre-encumbrance, encumbrance, expense, collected, recognized) and the available balance for the budgets you selected. (SQR GLS8020). | KK Budget |
| Commitment Control Budget Transaction Detail Report | CAPPS Financials | Menu > Financials > Commitment Control > Budget Reports > Run Budget Txn Detail Rpt | Displays transaction line details (budget post date, source transaction type, document ID, ledger amounts, override user ID) for budgets. (SQR GLS8005) Note: Select User Budget Override to limit the report to transaction lines that were successfully budget-checked after an override. Displays the user ID of the user who performed the override. | KK Budget |
| Commitment Control Ledger Details Report | CAPPS Financials | Menu > Financials > Commitment Control > Budget Reports > Print Ledger Details | Displays such details as amounts and currency for each ledger (amount type) in the control budgets you select, as well as the available amount for the budget. (SQR GLS8510) | KK Budget |
Interface [+]
| Report Title | System | Navigation | Description |
|---|---|---|---|
| Interface Batch Info Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Interface > Interface Batch Info Report | Lists Exceptions, Warnings, and Informational messages encountered for a specified list of batch module interfaces (TX_BAT_INFO). |
| Interface Exception Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Interface > Interface Exception Report | Lists open Expception Report |
| Interface Control Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Interface > Interface Control Report | The Interface Control Report (TXBATCTL2) is a summary of interface processing. Users select the CAPPS interface and processing date to be reported on. |
| USAS IN – All Current Records | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Interface > USAS IN – All Current Records | USAS IN All Current Records Report (TXCGL002) lists all transactions on the IN Browser, including Status for a range of dates. This is an old ISAS report that was designed to assist users with managing transactions on the IN Browser. |
| USAS HX Recycle – All Cur Recs | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Interface > USAS HX Recycle – All Cur Recs | USAS HX All Current Records Report (TXCGL001) lists all transactions on the HX Recycle Browser. This is an old ISAS report that was designed to assist users with managing transactions on the HX Recycle Browser. |
| Pre-Release Daily Activity | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports > Interface > Pre-Release Daily Activity | The Pre-Release Daily Activity Report (TXPREREL) – lists the GL journals, budget journals and AP vouchers picked up by the outbound interface and ready to be released in USAS for processing. |
Inventory [+]
| Report Title | System | Navigation | Description |
|---|---|---|---|
| Delivery Receipt Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports >Inventory > Delivery Receipt Report | Displays Delivery Receipt (TXCIN028) |
Purchasing [+]
| Report Title | System | Navigation | Description |
|---|---|---|---|
| Class and Item Changes | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Class and Item Changes | This report identifies Class and Item code differences between Requisition and associated PO lines. |
| Contract Management Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Contract Management | Lists all contract details for a specific contract record including all PO's associated to a contract with all vouchers associated to those PO's subtotaled by PO and any unencumbered vouchers associated to the contract. Totals provided from contract module for PO releases and remaining balance which takes into consideration unencumbered payments, if any. |
| HUB Bids Sent/Received | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > HUB Bids Sent/Received | Summary and detail info. |
| LBB Interface | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > LBB Interface | Lists procurement contracts designated as LBB reportable that were transmitted, in pending status, to the LBB reporting portal. |
| Payment Status Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Payment Status Report | Lists Payment Status by Business Unit and Receipt Date Greater Than (TX_PAYSTATUS) |
| PO Print Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > PO Print | PO Print Report (PO XMLP Dispatch) – Provides a pdf copy of your Purchase Order sorted by PO ID. You can print a single or multiple Purchase Orders. |
| PO Remaining Balance Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > PO Remaining Balances | (TX_POREM_BAL) Report shows all remaining balances from PO's for a specific AY range. |
| PO Summary Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > PO Summary | (TX_POSUMMARY) Report lists all Buyers for a specific agency and the total number of PO's created. |
| PO/Contract >= $100000 | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > PO/Contract >= $100000 | Lists POs and/or Contracts $100,000 or greater. |
| Receiving Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Receiving | Receiving Report (TXCPO003) – Provides a report of the items received along with associated receiving details. |
| Requisition Print Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Requisition Print | Requisition Print Report (TXCPO002) – Provides a PDF copy of your requisitions sorted by requisition ID. You can print a single requisition or multiple requisitions. |
| Requisition Status Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Requisition Status | Requisition Status Report (TXCPO004) – Provides a status of your requisitions which can include Open, Pending, Approved, or Denied depending on where the requisition is in the Workflow process. |
| Requisition Workflow Report | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Requisition Workflow Report | This report provides the Requisition Workflow details and includes 5 reports. 1) Requisition Workflow – Summary 2) Requisition Workflow – Days to Approve with Sub Totals 3) Requisition Workflow – Days to Approve by Req & Approver 4) Requisition Workflow – Days to Approve without Sub Totals 5) Requisition Workflow – Average Days by Approver |
| Requisitions to be Sourced | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Requisitions to be Sourced | Requisitions to be Sourced (TXCPO017) – Provides a listing of requisition IDs that are eligible to be sourced/copied to purchase orders. |
| Tx Smartbuy Purchases | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Tx Smartbuy Purchases | Lists Tx Smartbuy Purchases |
| Vendor Conflict of Interest | CAPPS Financials | Navbar > Financials > Menu > CAPPS Reports > Statewide Reports > Conflict of Interest Report | Lists vendor contact info where a conflict of interest has been noted by agency contract solicitation staff. |
| Class and Item Expenditures | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Class and Item Expenditures | Create new BO Class and Item Expenditure report. Report can be saved as CSV file to submit to meet statewide purchasing requirement. Report displays amount corrected. |
| Contracts Report | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Contracts Report | Multi-purpose report has following prompts: 1) Business Unit 2) Contract Begin Date (optional) 3) Contract End Date (optional) 4) Contract Status (optional) 5) Contract ID(s) (optional) 6) Supplier (optional) |
| HUB Bids Sent/Received | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > HUB Bids Sent/Received | This HUB report provides summary and detail bid information. |
| HUB Expenditure | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > HUB Expenditure | HUB Expenditure (TXEPO537B) – Provides data in support of the State mandated HUB Expenditure report. Report requires account attribute configurations to map account codes to HUB Categories. |
| HUB Supplement | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > HUB Supplement | HUB Supplemental (TXEPO538B) – Provides data in support of the State mandated HUB Supplemental report. |
| Open PO By Department | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Open PO by Department | Open PO By Department (TXEPO536B) displays the following fields on open purchase orders: AY, Account, Dept, PO ID, PO Date, Line No, Distrib Line Num, Sched Nbr, Line Description, Vendor Id, Vendor Name, Req ID, Fund Code, Product, Class/PCA, NIGP, Ordered Amount, Vouchered Amount and PO Line Remaining Amount |
| Open PO's by BU | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Open PO's by BU | CAPPS Report listing all Open PO's by BU displays the following fields: PO ID, PO Date, PO Status, Vendor Id and Vendor Name. |
| PO Remaining Balance | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Purchase Order Remaining Balance | Lists POs that have been vouchered, but still contain an outstanding encumbrance balance. Date prompt is for the latest PO date being reviewed (i.e., end of month, end of FY). |
| PO Remaining Balance by PCA and Account | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Remaining Balance by PCA and Account | PO Remaining Balance with Chartfield Data (TXEPO533B) – Displays POs (at the summary level) with remaining encumbrance. User can filter by PO, date, vendor. Along with PO Totals, Voucher Totals and Remaining Amount, user can click the Chartfields Detail link to view comparison of chartfields between lines of the associated Requisition, PO, Receipt, and Voucher documents. |
| PO Remaining Balance with Chartfield Data | Details | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > PO Remaining Balance with Chartfield Data | Purchase Order Remaining Balance report (TXEPO539B) displays the following fields: Po Id, Vendor ID / Name, Chartfield Details (via a drilldown link), PO Totals, Voucher Totals and PO Remaining Amount. The drilldown link displays the chartfield values for all related documents (requisitions, POs, Voucher). |
| Procurement Contracts Report | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Procurement Contracts | TXEPO714B Procurement Contracts Report provides essential contract information, and can identify contracts that have expired or are nearing expiration. |
| Purchaser Workload – PO Summary | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Purchaser Workload – PO Summary | Purchaser Workload – PO Summary report shows the count of POs by buyer. |
| Purchaser Workload – POs Not Dispatched | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Purchaser Workload – POs Assigned But Not Dispatched | Purchase Orders Assigned but not Dispatched report lists the following fields: Fiscal Year, PO Status, Budget Check Date, Requestor, PO ID, Req ID, Description and Merchandise Amount. Identifies POs associated not in Dispatched status. POs must be dispatched for further processing. |
| Purchaser Workload – Req Summary | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Purchaser Workload – Req Summary | Purchaser Workload – Req Summary report shows the count of requisitions by buyer. |
| Quarterly PO Change Notices | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Quarterly PO Change Notices | Quarterly PO Change Notices (TXEPO540B) – Report which provides the specific date when changes were made to a PO along with the PO ID, revised PO total amount, and vendor name and ID information. |
| Receipt – Voucher Status | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > CAPPS Receiving – Payment Status | Report to display receiving actions with associated voucher information if it exists. Report includes numerous input controls and filters. Prompts for business Unit and minimum receipt date. |
| Receiving Report | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > Receiving Report | Receiving Report (TXEPO514B) – Displays receipt lines against PO ordered quantity, and gives item detail and chartfield info. |
| State Use Exception Report | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > State Use Exception Report | This report will track Texas Industries for the Blind and Handicapped (TIBH) procurement exceptions. |
| State Use Report | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > State Use Report | Create new "CAPPS State Use Report". This report will track TIBH and TCI purchase amounts and categorized them as either commodities or services. |
| TIBH Procurement Report | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > TIBH Procurement Report | TIBH Procurement Report lists TIBH purchases. Report fields include: Business Unit, PO ID, PO Status, PO Date, PO Line Number, Vendor ID, Vendor Name and Price. |
| TIBH Set Aside | Business Objects | Dashboard: CAPPS Financials Reports > Purchasing > Statewide Reports > TIBH Set-A-Side | Lists purchases made from other vendors for TIBH related class/items. |
Travel and Expense [+]
| Report Title | System | Navigation | Description |
|---|---|---|---|
| Expense Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports >Travel & expense> Expense Report | Lists Travel Expense details by Employee ID and Report ID (TXEXP001) |
| Travel Authorization Report | CAPPS Financials | Menu > Financials > CAPPS Reports > Statewide Reports >Travel & expense> Travel Authorization Report | Lists Travel Authorization details by Employee ID and Travel Authorization ID (TXTA001) |