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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- of this document home nationwide service
- usda aphis home landing page
- general liability renewal application market finders
- grants analysis refresher course fi gm 315
- microsoft word
- transaction form gl 5
- microsoft word agent portal updates
- accounts payable reports core ct
- zzgl trans dtl table data dictionary
Related searches
- accounts payable titles and job descriptions
- accounts payable procedures manual sample
- accounts payable procedures manual pdf
- accounts payable manager salary
- accounts payable policies and procedures
- accounts payable policy and procedures manual
- accounts payable procedure template
- accounts payable expense reports
- accounts payable expense or liability
- accounts payable and expense
- accounts payable policy example
- accounts payable policy sample