Accounts Payable Reports - Core-CT



|Report ID |Report Name |Legacy Report |Report Description |Navigation/Path |

| | | | | |

|Vouchers |  |  |  |  |

|APY1010 |Voucher Register Report |N/A |Lists vouchers by business unit, date entered, and Voucher|Accounts Payable > Reports > Vouchers |

| | | |ID. |>Voucher Register |

|APY1011 |Control Group Register Report |N/A |Lists vouchers entered into Payables by business unit, |Accounts Payable > Reports > Vouchers > |

| | | |control group ID, date entered, and voucher ID. For each |Control Group Register |

| | | |Business Unit and Control Group ID combination, the report| |

| | | |lists all the vouchers that meet these criteria by their | |

| | | |Date Entered. | |

|**APY1020 |Posted Voucher Listing Report |N/A |Lists all posted vouchers for a given business unit and |Accounts Payable > Reports > Vouchers > |

| | | |date range. |Posted Voucher Listing |

|APY1090 |Match Exception Report |N/A |Lists the match exceptions with voucher data, purchase |Accounts Payable > Reports > Vouchers > |

| | | |order data, receiver data, and match error information. |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 |Accounts Payable > Reports > Voucher |

| | | |vouchers that have an open liability balance and the |Reconciliation > AP Open Liability Request|

| | | |reason for the open liability. Vouchers with an open | |

| | | |liability are included, even if the balance has been | |

| | | |reported to the General Ledger. | |

|*APY1400 |Summary AP/GL Open Liability |N/A |Compares the AP Open Liability balance to the GL Open |Accounts Payable > Reports > Voucher |

| | | |Liability balance. The AP Open Liability Request must be |Reconciliation > AP Open Liability Recon |

| | | |run to populate the run control. | |

|*APY1405 |Detail AP/GL Open Liability |N/A |Shows all accounting activity for accounts payable |Accounts Payable > Reports > Voucher |

| | | |transactions for each voucher. The AP Open Liability |Reconciliation > AP Open Liability Recon |

| | | |Request must be run to populate the run control. | |

|*APY1406 |AP Open Liability |N/A |Lists all open liabilities by business unit. The AP Open |Accounts Payable > Reports > Voucher |

| | | |Liability Request must be run to populate the run control.|Reconciliation > AP Open Liability Recon |

|*APY1407 |AP Unrecorded Liability |N/A |Lists all unposted transactions (such as, vouchers, |Accounts Payable > Reports > Voucher |

| | | |closures, and payment cancellations), transactions that |Reconciliation > AP Open Liability Recon |

| | | |have not been journal generated and, therefore, not | |

| | | |visible to GL. The AP Open Liability Request must be run | |

| | | |to populate the run control. | |

|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 |Accounts Payable > Reports > Voucher |

| | | |Date. You can run the report in either summary or detail |Reconciliation > Aged Vendor Liability |

| | | |format for specific vendors. The AP Open Liability Request| |

| | | |must be run to populate the run control. | |

|*AP_APGLRECN |AP/GL Reconciliation |N/A |Loads the AP/GL Reconciliation table used by the AP/GL |Accounts Payable > Reports > Voucher |

| | | |Journal Reconciliation report. |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 |Accounts Payable > Reports > Voucher |

| | | |Journal Recon Request must be run to populate the run |Reconciliation > AP/GL Journal |

| | | |control. |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 |Accounts Payable > Reports > Vouchers > |

| | | |penalty has been assessed, listed by associated contracts |Retainage Liability |

| | | |or Purchase Order. It includes detailed retainage and | |

| | | |penalty details. | |

| | | | | |

| | | | | |

| | | | | |

|Report ID |Report Name |Legacy Report |Report Description |Navigation/Path |

|**CTAPR149 |Voucher Activity Report |03-01 Document by Account Code |Lists voucher activity by business unit, fund, department,|Accounts Payable > Reports > Vouchers > |

| | |03-05 Expenditure Documents |program, SID, account, budget reference, project, expended|Voucher Activity Report |

| | |05-02 Detail Reconciliation |amount, budget date, and amount paid. | |

| | |05-03 Summary Reconciliation | | |

| | |ACBI50 Post Audit Report | | |

| | |ACBX10 Special Code 14 Report | | |

| | |ACBY64-01 Monthly | | |

| | |Expenditures-Attorney Fees | | |

|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|Accounts Payable > Reports > Vendor > |

| | | |the specified vendor. |Vendor Balance |

|*APY3000 |Vendor Detail Listing |N/A |Provides a report listing vendors by status along with |Accounts Payable > Reports > Vendor > |

| | | |associated details including address information and |Vendor Detail Listing |

| | | |payment options. | |

|*APY3001 |Vendor Summary Listing |N/A |Provides a report listing all vendors by status along with|Accounts Payable > Reports > Vendor > |

| | | |basic summary information |Vendor Summary Listing |

|*APY3215 |Duplicate Vendors |N/A |Shows vendors that erroneously have duplicate TINs, |Vendors > Vendor Setup/Maintenance > |

| | | |withholding names, withholding addresses, vendor names, |Duplicate Vendor Report |

| | | |vendor short names, or vendor addresses. | |

|**CTAPR199 |Vendor Payment Report (Total for Towns)|ACRX74 Vendor Payment Report |Lists the Vendor Payments by specified Vendor ID's (used | Accounts Payable > Reports > Vendor > |

| | | |primarily to distribute to towns). |Vendor Payment |

|Report ID |Report Name |Legacy Report |Report Description |Navigation/Path |

|*CTAPR111 |Payment Warrant Report |ACBW10 Checkwriter Extract |Provides the necessary payment data to OSC and OTT. The |Accounts Payable > Reports > Payments > |

| | |Control Report |Treasurer uses the Payment Warrant report to verify OSC |Payment Warrant Reports |

| | |ACBW50 Batch Control Report |payments and make sure the funds are available to support | |

| | |ACRW55 Warrant Report by Check |these payments. The Payment Warrant report is sorted by | |

| | |NO/Fein |ascending check reference number within the payment method| |

| | |ACRW56 Warrant Report by Agency |and payment handling code groups. | |

|*CTAPR147 |Sorted Payment Warrant Report |ACBW10 Checkwriter Extract |Provides a sorted list of payments by check amount. |Accounts Payable > Reports > Payments > |

| | |Control Report | |Payment Warrant Reports |

| | |ACBW50 Batch Control Report | | |

| | |ACRW55 Warrant Report by Check | | |

| | |NO/Fein | | |

| | |ACRW56 Warrant Report by Agency | | |

|*CTAPR205 |Offset Payment Report |ACBW40 Offset Program |Listing of all offset transactions and vendor information.|Accounts Payable > Offset Processing > |

| | |Report--DRS offset | |Offset Payment Report |

| | |ACBW57 Non DRS Offset Program | | |

| | |Report Special Code 11 | | |

| | | | | |

| | | | | |

| | | | | |

|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 |Vendors > Withholdings > Withhold Control |

| | | |withholding activities for internal audits. |Report |

|*APY7010 |Withholding Rules |N/A |Shows the information entered on the withholding rule |Vendors > Withholdings > Rules |

| | | |page. For each As of Date, the report lists Withholding | |

| | | |Rule, VAT, Freight, Sales/Use Tax, Discount, Payment, | |

| | | |Hold, Percent, and Minimum Amount. | |

| | | | | |

| | | | | |

| | | | | |

| | | | | |

|Report ID |Report Name |Legacy Report |Report Description |Navigation/Path |

|*APY7020 |Withholding Types |N/A |Shows the information from the Withholding Type page. For |Vendors > Withholdings > Types |

| | | |each Withholding Type, the report lists Class and | |

| | | |Description. | |

| | | | | |

| | | | | |

| | | | | |

|*APY7030 |Withholding Entities |N/A |Shows the information from the Entity page. For each |Vendors > Withholdings > Entities |

| | | |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. | |

|*APY7040 |Withholding Codes |N/A |Shows information entered on the Withholding Code page. |Vendors > Withholdings > Codes |

| | | |For each Code, the report lists Entity, Type, | |

| | | |Jurisdiction, and Class. | |

|*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 |Vendors > Withholdings > 1099 to Send |

| | | |reporting process and is a replica of data in the file you|Detail |

| | | |are sending to the IRS. | |

| | | | | |

| | | | | |

|Report ID |Report Name |Legacy Report |Report Description |Navigation/Path |

|*WTP2_001 |Withholding Report by Class |ACBV66 IRS 1099M Control Totals |Reports vendor withholding information by vendor by class.|Vendors > Withholdings > Withholding |

| | |Report |Provides both detailed and summarized information for the |Report by Class |

| | |ACBV66S IRS 1099S Control Totals|applicable withholding transactions that are processed | |

| | |Report |(paid) in the Payables module. | |

| | | | | |

|Procurement Cards | | | | |

|POY8000 |Cardholder Information |N/A |Provides information relating to each cardholder and their|Purchasing > Procurement Cards > Reports >|

| | | |assigned procurement card. The information printed in the |Cardholder Information |

| | | |report includes card number, transaction and monthly | |

| | | |limits, and authorized purchasing categories. | |

|POY8010 |Amount Limit per Transaction |N/A |Provides information about employee procurement card |Purchasing > Procurement Cards > Reports >|

| | | |expenditure amount limits per transaction. |Purchase Exceptions |

|POY8011 |Amount Limit per Month |N/A |Provides information about employee procurement card |Purchasing > Procurement Cards > Reports >|

| | | |expenditure amount limits per month. |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 |Purchasing > Procurement Cards > Reports >|

| | | |card transactions per day limits. |Purchase Exceptions |

|POY8013 |Number of Transactions/ Month |N/A |Provides information about employee number of procurement |Purchasing > Procurement Cards > Reports >|

| | | |card transactions per month limits. |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 |Purchasing > Procurement Cards > Reports >|

| | | |particular credit card provider. |Purchase Details |

|POY8031 |Purchase Detail by Merchant |N/A |Provides procurement card expenditures for a specific |Purchasing > Procurement Cards > Reports >|

| | | |merchant. |Purchase Details |

|POY8032 |Purchase Detail by Employee |N/A |Provides procurement card expenditures of a single |Purchasing > Procurement Cards > Reports >|

| | | |cardholder or all of the cardholders. |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 |Purchasing > Procurement Cards > Reports >|

| | | |sorted by vendor. |Account Summary |

|POY8051 |Purchase Summary by Merchant |N/A |Provides a summary of all procurement card purchases |Purchasing > Procurement Cards > Reports >|

| | | |sorted by merchant. |Account Summary |

|POY8052 |Purchase Summary by Employee |N/A |Provides a summary of all procurement card purchases |Purchasing > Procurement Cards > Reports >|

| | | |sorted by employee. |Account Summary |

-----------------------

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download