This article lists the public EPM queries and descriptions for this topic. Please review available public queries below before making a new query.
EPM public query names and descriptions for Accounts Payable (AP)
- Telecomm Expenditures after 7/1/2011 (DOCX) - This query is designed to reveal any posted vouchers created for Telecomm-related expenses after 6-30-2011. Business unit is DASIT, result of agency consolidations.
- Telecomm Expenditures before 7/1/2011 (DOCX) - This query is designed to reveal any posted vouchers created for Telecomm-related expenses before 6-30-2011. BU can be any ITD BU.
- Capital Asset Expenditures (DOCX) - This query is for vouchers that are posted paying for items purchased under the asset Account range from 55420 through 55890. Prompts for Entered Date Range.
- Utility Vouchers, Utility, Account Codes (DOCX) - This query displays utility vouchers, associated utility and account codes. Execution of this query prior to approval allows verification of appropriate account/utility codes. Prompts for business unit and accounting date.
- Payment Count by Business Unit (DOCX) - This query will create a report of Number of Payments (Payment Method) by Business Unit. Prompts are From Payment Date and To Payment Date.
- Voucher Energy Consumption since 7/1/2008 (DOCX) - This query displays energy consumption voucher information. Prompts on business unit, accounting date, account (for all accounts, enter %), and choose a utility code from the drop down menu.
- Deleted vouchers by Accounting Date (DOCX) - This query is used to identify all deleted vouchers (entry status = X) by an Accounting Date Range, DeptID and Business unit for fiscal year end cleanup.
- Internal Service BU reporting (DOCX) - This query returns voucher and purchase order information where the AP and PO business units differ. Specifically designed for those agencies with Internal Service Business Units; DAS, DOC and ITD.
- Non-PO Vouchers by Bus Unit (DOCX) - This query to find all Non-PO Vouchers by Business Unit (One or many) and Accounting Date and Total Amount.
- Voucher Energy Consumption prior to 7/1/2008 (DOCX) - This query displays energy consumption voucher information. Prompts on business unit, accounting date, account (for all accounts, enter %), and choose a utility code from the drop down menu. The query returns voucher/energy consumption information for vouchers prior to 7-01-2008.
- Contract vs Voucher Pay Terms (DOCX) - This query returns all vouchers where the voucher payment terms do not match the contract payment terms and the contract payment terms involve a vendor discount, payment terms code like %D%.
- Vouchers Budget Checked Not Posted (DOCX) - This query is used to identify vouchers that have been budget checked, but not yet posted. Ideal for month-end verification and reconciliation. Modified to add payments to troubleshoot vouchers not progressing.
- Vouchers Budget Checked but Not Paid (DOCX) - This query is used for identifying vouchers that have been budget checked, but not paid. It is ideal for month-end verification and reconciliation. The query was modified to include payment fields to help troubleshoot vouchers not progressing and modified to add criteria where Entry Status = 'P' so users don't see deleted vouchers.
- Number of vouchers by User ID (DOCX) - This query's results give the number of vouchers entered by OperatorID for a given time frame. Query prompts on business unit and entered date. This query may take some time to process. If you are running the query and there are many users or a fairly long time frame, consider scheduling the query.
- Invoice Date versus Entered / Payment Dates (DOCX) - This query can be used to analyze the progress of a vendor invoice through an AP Department, using Inv Date, Voucher Entered Date and Payment Date. Query prompts for business unit and invoice date.
- Voucher Accounting Line by Journal ID (DOCX) - This query is used to find all of the vouchers associated with a Journal ID. This will help the user to reconcile the AP module to the General Ledger.
- RA Vouchers with payment notes (DOCX) - This query returns all vouchers with the payment handling code, RA, payment date, amount and payment notes as required by the COMPTROLLER'S MEMORANDUM NO. 2009 - 31 issued September 18, 2009.
- Vouchers on Hold by BU (DOCX) - This query shows vouchers on Hold by one or all (%) BU, where payment select status = N and Payment Hold = Y and Entry Status does not = X or T.
- Vouchers Paid but Not Posted (DOCX) - This query is used for identifying vouchers that have been paid, but are not posted. Ideal for month-end verification and reconciliation.
- Vouchers not approved by the Business Unit (DOCX) - This query was designed to help with month end or year end voucher clean up.
- Vouchers Not Yet PosteD (DOCX) - This query is used for identifying vouchers that have not yet posted. Ideal for month-end verification and reconciliation.
- Vendor search by Vendor ID (DOCX) - This query identifies vendor name, vendor SETID, Remit Vendor SETID. Prompts for Remit Vendor ID.
- Vendors with credit balances (DOCX) - This query is designed to identify vendors with a current credit balance. Prompt by business unit.
- Vendor ID, name, SET ID (DOCX) - This query provides VendorID, Vendor Name and Vendor SETID. Prompts for vendor name is like, use the % wildcard before and after the name search selection.
- Vendor Check Number by FEIN (DOCX) - This query will return check numbers for a vendor by vendor FEIN for the Business Unit, Short Vendor Name, and date range the user prompts on. The query output includes chartfield values. This means that for each time a chartfield value changes, a new row of information will be added. A voucher may appear multiple times if there are multiple chartfield rows.
- Check Number by Vendor Name (DOCX) - This query gives the check number, vendor name, and vendor short name (FEIN) for a date range. The search allows the use of wild cards in the vendor name field. The query output includes chartfield values. This means that for each time a chartfield value changes, a new row of information will be added. A voucher may appear multiple times if there are multiple chartfield rows.
- SAAAS Option 16, 5-8 (DOCX) - This query is designed to closely approximate the functionality of the legacy SAAAS option 16, 5, 8 report.
- RA Vouchers by Source (DOCX) - This query returns vouchers sourced by XML or QUCK, with payment handling code of RA and associated payment notes and messages. Enable agency compliance with COMPTROLLER'S MEMORANDUM NO. 2009 - 31 issued September 18, 2009. Query to be executed only by interface agencies.
- Vendor Payment History Query (DOCX) - This query will return payment information for the Business Unit, payment date range, Vendor Setid, and Vendor Id the user prompts on.
- Vouchers, Pay Terms, Discounts (DOCX) - This query provides agencies with an audit tool to review all payments with discount pay terms for analysis, including both vouchers with discounts taken and discounts lost.
- Vouchers with pending discounts (DOCX) - This query returns all unpaid vouchers for a BU that have discount pay terms that are still candidates for an awarded discount. This proactive query should be run often (daily, or at least every few days), to catch vouchers about to lose a discount. The number of days pending takes into consideration that EPM data is 24 hours old.
- Paid vouchers from non-expenditure accounts (DOCX) - This query shows posted vouchers against Accounts that are not in the 50000 range. Excluded are vouchers that originate in IR, IP, or IV Business Units.
- FYE Deleted Voucher by BU (DOCX) - This query is derived from the Voucher Transaction Table. It shows vouchers that have been deleted that may need to be budget checked in order to create corrective accounting entries. Query asks for business unit and vendor ID. You may use the % wildcard on both fields.
- 55050 Sub-recipient Vendor Detail (DOCX) - This query developed to assist agencies in monitoring and identifying those vendors receiving payments coded as pass through funds to account 55050 for Federal Grant reporting. Each agency is responsible in the correct reporting of expenditures coded as sub awards.
- Set Aside Voucher Query (DOCX) - This query will provide expenditure data on Set-Aside Vendors. The query prompts on Business Unit, accounting date range, and Certification Source. Query updated to prompt on accounting date to maximize performance. Eliminated the effective date criteria from CT_VNDR_CERT_VW table to ensure capture of all valid certifications in time frame specified.
- Set Aside Voucher Summary (DOCX) - This custom PS/Query was added to facilitate the creation of the Set Aside Vendor report. Query prompts on accounting date to maximize performance. CT_VNDR_VNDR_CERT_VW was added to ensure the capture of all valid vendor certifications within the time frame requested.
More resources