Accounts Payable Reports
Report ID / Report Name / Legacy Report / Report Description / Navigation/PathVouchers
APY1010 / Voucher Register Report / N/A / Lists vouchers by business unit, date entered, and Voucher ID. / Accounts Payable > Reports > Vouchers >Voucher Register
APY1011 / Control Group Register Report / N/A / Lists vouchers entered into Payables by business unit, control group ID, date entered, and voucher ID. For each Business Unit and Control Group ID combination, the report lists all the vouchers that meet these criteria by their Date Entered. / Accounts Payable > Reports > Vouchers > Control Group Register
**APY1020 / Posted Voucher Listing Report / N/A / Lists all posted vouchers for a given business unit and date range. / Accounts Payable > Reports > Vouchers > Posted Voucher Listing
APY1090 / Match Exception Report / N/A / Lists the match exceptions with voucher data, purchase order data, receiver data, and match error information. / Accounts Payable > Reports > Vouchers > Match Exceptions
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
*AP_APGLOPEN / AP/GL Open Liability Recon / N/A / Updates the AP Liability Report table with a list of all vouchers that have an open liability balance and the reason for the open liability. Vouchers with an open liability are included, even if the balance has been reported to the General Ledger. / Accounts Payable > Reports > Voucher Reconciliation > AP Open Liability Request
*APY1400 / Summary AP/GL Open Liability / N/A / Compares the AP Open Liability balance to the GL Open Liability balance. The AP Open Liability Request must be run to populate the run control. / Accounts Payable > Reports > Voucher Reconciliation > AP Open Liability Recon
*APY1405 / Detail AP/GL Open Liability / N/A / Shows all accounting activity for accounts payable transactions for each voucher. The AP Open Liability Request must be run to populate the run control. / Accounts Payable > Reports > Voucher Reconciliation > AP Open Liability Recon
*APY1406 / AP Open Liability / N/A / Lists all open liabilities by business unit. The AP Open Liability Request must be run to populate the run control. / Accounts Payable > Reports > Voucher Reconciliation > AP Open Liability Recon
*APY1407 / AP Unrecorded Liability / N/A / Lists all unposted transactions (such as, vouchers, closures, and payment cancellations), transactions that have not been journal generated and, therefore, not visible to GL. The AP Open Liability Request must be run to populate the run control. / Accounts Payable > Reports > Voucher Reconciliation > AP Open Liability Recon
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
*APY1408 / Aged Vendor Liability / N/A / Lists all vouchers that have not been paid by the As of Date. You can run the report in either summary or detail format for specific vendors. The AP Open Liability Request must be run to populate the run control. / Accounts Payable > Reports > Voucher Reconciliation > Aged Vendor Liability
*AP_APGLRECN / AP/GL Reconciliation / N/A / Loads the AP/GL Reconciliation table used by the AP/GL Journal Reconciliation report. / Accounts Payable > Reports > Voucher Reconciliation > AP/GL Journal Recon Request
*APY1410 / AP/GL Journal Reconciliation Report / N/A / Lists totals by Journal Line and Journal ID. The AP/GL Journal Recon Request must be run to populate the run control. / Accounts Payable > Reports > Voucher Reconciliation > AP/GL Journal Reconciliation
*APY1420 / AP/GL Account Reconciliation Report / N/A / Lists account totals by Journal ID and Account. / Accounts Payable > Reports > Voucher Reconciliation > AP/GL Journal Reconciliation
**CTAPR007 / Retainage Liability Report / N/A / Identifies all Vouchers to which retainage applies or a penalty has been assessed, listed by associated contracts or Purchase Order. It includes detailed retainage and penalty details. / Accounts Payable > Reports > Vouchers > Retainage Liability
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
**CTAPR149 / Voucher Activity Report / 03-01 Document by Account Code
03-05 Expenditure Documents
05-02 Detail Reconciliation
05-03 Summary Reconciliation
ACBI50 Post Audit Report
ACBX10 Special Code 14 Report
ACBY64-01 Monthly Expenditures-Attorney Fees / Lists voucher activity by business unit, fund, department, program, SID, account, budget reference, project, expended amount, budget date, and amount paid. / Accounts Payable > Reports > Vouchers > Voucher Activity Report
Vendors
**APY2000 / Payment History By Vendor / N/A / Provides a register of payments for a vendor. / Accounts Payable > Reports > Vendor > Payment History by Vendor
*APY2001 / Payment History by Payment / N/A / Provides a history of payments by type of payment. / Accounts Payable > Reports > Vendor > Payment History by Payment
*APY2004 / Payment History by Bank / N/A / Provides a register of the payments for a bank. / Accounts Payable > Reports > Vendor > Payment History by Bank
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
*APY2050 / Payment History by Payment Method / N/A / Provides a history of payments by payment method. / Accounts Payable > Reports > Vendor > Payment Hist by Pymnt Method
*APY2051 / Payment Aging by Bank / N/A / Provides a listing of payments aging by bank. / Accounts Payable > Reports > Vendor > Payment Aging by Bank
**APY2052 / Payment Aging by Vendor / N/A / Provides a report listing payments aging by vendor. / Accounts Payable > Reports > Vendor > Payment Aging by Vendor
**APY3020 / Outstanding Balance by Vendor / N/A / Lists the gross amount of all the outstanding vouchers for the specified vendor. / Accounts Payable > Reports > Vendor > Vendor Balance
*APY3000 / Vendor Detail Listing / N/A / Provides a report listing vendors by status along with associated details including address information and payment options. / Accounts Payable > Reports > Vendor > Vendor Detail Listing
*APY3001 / Vendor Summary Listing / N/A / Provides a report listing all vendors by status along with basic summary information / Accounts Payable > Reports > Vendor > Vendor Summary Listing
*APY3215 / Duplicate Vendors / N/A / Shows vendors that erroneously have duplicate TINs, withholding names, withholding addresses, vendor names, vendor short names, or vendor addresses. / Vendors > Vendor Setup/Maintenance > Duplicate Vendor Report
**CTAPR199 / Vendor Payment Report (Total for Towns) / ACRX74 Vendor Payment Report / Lists the Vendor Payments by specified Vendor ID's (used primarily to distribute to towns). / Accounts Payable > Reports > Vendor > Vendor Payment
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
*CTAPR111 / Payment Warrant Report / ACBW10 Checkwriter Extract Control Report
ACBW50 Batch Control Report
ACRW55 Warrant Report by Check NO/Fein
ACRW56 Warrant Report by Agency / Provides the necessary payment data to OSC and OTT. The Treasurer uses the Payment Warrant report to verify OSC payments and make sure the funds are available to support these payments. The Payment Warrant report is sorted by ascending check reference number within the payment method and payment handling code groups. / Accounts Payable > Reports > Payments > Payment Warrant Reports
*CTAPR147 / Sorted Payment Warrant Report / ACBW10 Checkwriter Extract Control Report
ACBW50 Batch Control Report
ACRW55 Warrant Report by Check NO/Fein
ACRW56 Warrant Report by Agency / Provides a sorted list of payments by check amount. / Accounts Payable > Reports > Payments > Payment Warrant Reports
*CTAPR205 / Offset Payment Report / ACBW40 Offset Program Report--DRS offset
ACBW57 Non DRS Offset Program Report Special Code 11 / Listing of all offset transactions and vendor information. / Accounts Payable > Offset Processing > Offset Payment Report
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
Withholdings
*APCOPYB / 1099 Copy B Report / N/A / Prints Copy B for you to send to vendors. / Vendors> Withholdings > Print 1099 Copy B
*APY1099 / Withhold 1099 Report / N/A / Generates the IRS file. / Accounts Payable>
Reports > Withholding >
Withhold 1099 Report
*APY3012 / Withhold Control Report / N/A / Creates withholding control report listing with withholding activities for internal audits. / Vendors > Withholdings > Withhold Control Report
*APY7010 / Withholding Rules / N/A / Shows the information entered on the withholding rule page. For each As of Date, the report lists Withholding Rule, VAT, Freight, Sales/Use Tax, Discount, Payment, Hold, Percent, and Minimum Amount. / Vendors > Withholdings > Rules
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
*APY7020 / Withholding Types / N/A / Shows the information from the Withholding Type page. For each Withholding Type, the report lists Class and Description. / Vendors > Withholdings > Types
*APY7030 / Withholding Entities / N/A / Shows the information from the Entity page. For each Entity, the report lists Vendor SetID, Vendor ID, Location, Currency, Rate Type, Last Report Date, File Layout, Type, Jurisdiction, Class, Rule, Business Unit, Account, Department, Product, and Project ID. / Vendors > Withholdings > Entities
*APY7040 / Withholding Codes / N/A / Shows information entered on the Withholding Code page. For each Code, the report lists Entity, Type, Jurisdiction, and Class. / Vendors > Withholdings > Codes
*APY8045 / Withholding Report / N/A / Creates global withholding reports. / Vendors > Withholdings > Withholding Report
*APY8056 / 1099 to Send Detail / N/A / The report lists all the information created by the 1099 reporting process and is a replica of data in the file you are sending to the IRS. / Vendors > Withholdings > 1099 to Send Detail
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
*WTP2_001 / Withholding Report by Class / ACBV66 IRS 1099M Control Totals Report
ACBV66S IRS 1099S Control Totals Report / Reports vendor withholding information by vendor by class. Provides both detailed and summarized information for the applicable withholding transactions that are processed (paid) in the Payables module. / Vendors > Withholdings > Withholding Report by Class
Procurement Cards
POY8000 / Cardholder Information / N/A / Provides information relating to each cardholder and their assigned procurement card. The information printed in the report includes card number, transaction and monthly limits, and authorized purchasing categories. / Purchasing > Procurement Cards > Reports > Cardholder Information
POY8010 / Amount Limit per Transaction / N/A / Provides information about employee procurement card expenditure amount limits per transaction. / Purchasing > Procurement Cards > Reports > Purchase Exceptions
POY8011 / Amount Limit per Month / N/A / Provides information about employee procurement card expenditure amount limits per month. / Purchasing > Procurement Cards > Reports > Purchase Exceptions
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
POY8012 / Number of Transactions per Day / N/A / Provides information about employee number of procurement card transactions per day limits. / Purchasing > Procurement Cards > Reports > Purchase Exceptions
POY8013 / Number of Transactions/ Month / N/A / Provides information about employee number of procurement card transactions per month limits. / Purchasing > Procurement Cards > Reports > Purchase Exceptions
POY8020 / Expected Results / N/A / Provides a list of disputed procurement card transactions. / Purchasing > Procurement Cards > Reports > Expected Credits
POY8030 / Purchase Detail by Vendor / N/A / Provides procurement card expenditures made using a particular credit card provider. / Purchasing > Procurement Cards > Reports > Purchase Details
POY8031 / Purchase Detail by Merchant / N/A / Provides procurement card expenditures for a specific merchant. / Purchasing > Procurement Cards > Reports > Purchase Details
POY8032 / Purchase Detail by Employee / N/A / Provides procurement card expenditures of a single cardholder or all of the cardholders. / Purchasing > Procurement Cards > Reports > Purchase Details
Report ID / Report Name / Legacy Report / Report Description / Navigation/Path
POY8050 / Purchase Summary by Vendor / N/A / Provides a summary of all procurement card purchases sorted by vendor. / Purchasing > Procurement Cards > Reports > Account Summary
POY8051 / Purchase Summary by Merchant / N/A / Provides a summary of all procurement card purchases sorted by merchant. / Purchasing > Procurement Cards > Reports > Account Summary
POY8052 / Purchase Summary by Employee / N/A / Provides a summary of all procurement card purchases sorted by employee. / Purchasing > Procurement Cards > Reports > Account Summary
LEGEND: * = Central User
* * = Central & Agency User
Blank = Agency User