ctcLink Reference Center

test

Accounts Payable Reports

Purpose: Use this document as a reference for running AP report in ctcLink.

Audience: Accounts Payable Staff

You must have at least one of these local college managed security roles:

<see table below for report-specific security roles>

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Accounts Payable Reports

The following table lists reports available in PeopleSoft Payables and vetted by the ctcLink Reporting & Analytics team (as of 2014-11-19). Please refer to the Reporting team's SharePoint site for up-to-date information.

Report ID / Name	Description	Navigation/ Roles
Payment Archive Report BIP	Payment Archive Report BI Publisher	Navigation: Accounts Payable>Reports>Archiving>Payment Archive Report Roles: <no college-grantable roles>
Voucher Archive Selection	APX6001 Voucher Archive Selection	Navigation: Accounts Payable>>Reports>>Archiving>>Voucher Archive Report Roles: <no college-assignable roles>
Payment Aging by Bank	Payment Aging by Bank	Navigation: Accounts Payable>>Reports>>Payments>>Payment Aging by Bank Roles: ZZ Accounts Payable Reports
Payment History by Bank	Payment History by Bank Report	Navigation: Accounts Payable>>Reports>>Payments>>Payment History by Bank Roles: ZZ Accounts Payable Reports
Payment History By Method	Payment History By Method	Navigation: Accounts Payable>>Reports>>Payments>>Payment History by Pay Method Roles: ZZ Accounts Payable Reports
Payment Register	Payment Register Report	Navigation: Accounts Payable>>Reports>>Payments>>Payment History by Payment Roles: ZZ Accounts Payable Reports
Trial Register	Trial Register Report	Navigation: Accounts Payable>>Reports>>Payments>>Trial Register Roles: ZZ Accounts Payable Reports ZZ Payment Creation
Withholding Calculation	Withholding Calculation	Navigation: Accounts Payable>>Reports>>Payments>>Withhold Calculation Roles: ZD Accounts Payable Inquiry
Open Prepayment Report	Open Prepayment Report	Navigation: Accounts Payable>>Reports>>Prepayments>>Open Prepayments Roles: <no college-grantable roles>
Prepayments Settlements	Prepayments Settlements	Navigation: Accounts Payable>>Reports>>Prepayments>>Prepayment Settlements Roles: <no college-grantable roles>
Payment Aging Report -Supplier	Payment Aging Report - Supplier	Navigation: Accounts Payable>>Reports>>Supplier>>Payment Aging by Supplier Roles: ZZ Accounts Payable Reports
Payment History By Supplier	Payment History By Supplier Report	Navigation: Accounts Payable>>Reports>>Supplier>>Payment History by Supplier Roles: ZZ Accounts Payable Reports
AP/GL Account Recon Report	AP/GL Account Recon Report	Navigation: Accounts Payable>>Reports>>Voucher Reconciliation>>AP/GL Account Recon Request Roles: ZZ Accounts Payable Reports
Report ID / Name	Description	Navigation/ Roles
AP/GL Journal Recon Report	AP/GL Journal Recon Report	Navigation: Accounts Payable>> Reports>> Voucher Reconciliation>> AP/GL Journal Recon Request Roles: <no college-grantable roles>
Summary AP/GL Open Liability	Payables AP/GL Liability Account Reconciliation Report	Navigation: Accounts Payable>> Reports>> Voucher Reconciliation>> Open Liability Reconciliation Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Detail AP/GL Open Liability	Detail version of the AP/GL Open Liability Account Reconciliation Report.	Navigation: Accounts Payable>> Reports>> Voucher Reconciliation>> Open Liability Reconciliation Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Payables Open Liability	Payables Open Liability Report	Navigation: Accounts Payable>> Reports>> Voucher Reconciliation>> Payables Open Liability Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Supplier Liability Aging	Supplier Liability Aging Report	Navigation: Accounts Payable>> Reports>> Voucher Reconciliation>> Supplier Liability Aging Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Match Exceptions	Match Exceptions Report	Navigation: Accounts Payable>> Reports>> Vouchers>> Match Exceptions Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Posted Voucher	Posted Voucher Listing	Navigation: Accounts Payable>> Reports>> Vouchers>> Posted Voucher Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Voucher Register	Voucher Register	Navigation: Accounts Payable>> Reports>> Vouchers>> Voucher Register Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
1099 Withholding to Send Detail	1099 Withholding to Send Detail	Navigation: Suppliers>> 1099/Global Withholding>> 1099 Reports>> 1099 to Send Detail Roles: ZZ Accounts Payable Reports
Withhold 1099 Report Job	Creates the 1099 IRS Electronic File	Navigation: Suppliers>>1099/Global Withholding>>1099 Reports>>Withhold 1099 Report Job Roles: ZZ 1099 Processing
Wthd Voucher/Supplier Mismatch	Withholding Mismatch Report	Navigation: Suppliers>>1099/Global Withholding>>General Reports>>Wthd Voucher/Supplier Mismatch Roles: ZZ Accounts Payable Reports
Supplier Audit Log	Supplier Audit Log	Navigation: Suppliers>>Supplier Information>>General Reports>>Supplier Audit Log Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting

ctcLink Reference Center

Accounts Payable Reports

Accounts Payable Reports

0 Comments

Add your comment

Topics

Last Updated

Other Resources

Welcome to ctcLink (Start Here!)

Process Alignment

Resources

9.2 Campus Solutions

9.2 Finance

9.2 Financial Aid

9.2 Human Capital Management

9.2 Self Service

9.2 Student Financials

Archived Project Materials

Recent Updates