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	NavBar>Navigator>Accounts Payable>Reports>Archiving>Payment Archive Report Roles: <no college-grantable roles>
Voucher Archive Selection	APX6001 Voucher Archive Selection	NavBar>Navigator>Navigator>Accounts Payable>>Reports>>Archiving>>Voucher Archive Report Roles: <no college-assignable roles>
Payment Aging by Bank	Payment Aging by Bank	NavBar>Navigator>Accounts Payable>>Reports>>Payments>>Payment Aging by Bank Roles: ZZ Accounts Payable Reports
Payment History by Bank	Payment History by Bank Report	NavBar>Navigator>Accounts Payable>>Reports>>Payments>>Payment History by Bank Roles: ZZ Accounts Payable Reports
Payment History By Method	Payment History By Method	NavBar>Accounts Payable>>Reports>>Payments>>Payment History by Pay Method Roles: ZZ Accounts Payable Reports
Payment Register	Payment Register Report	NavBar>Accounts Payable>>Reports>>Payments>>Payment History by Payment Roles: ZZ Accounts Payable Reports
Trial Register	Trial Register Report	NavBar>Accounts Payable>>Reports>>Payments>>Trial Register Roles: ZZ Accounts Payable Reports ZZ Payment Creation
Withholding Calculation	Withholding Calculation	NavBar>Accounts Payable>>Reports>>Payments>>Withhold Calculation Roles: ZD Accounts Payable Inquiry
Open Prepayment Report	Open Prepayment Report	NavBar>Accounts Payable>>Reports>>Prepayments>>Open Prepayments Roles: <no college-grantable roles>
Prepayments Settlements	Prepayments Settlements	NavBar>Accounts Payable>>Reports>>Prepayments>>Prepayment Settlements Roles: <no college-grantable roles>
Payment Aging Report -Supplier	Payment Aging Report - Supplier	NavBar>Accounts Payable>>Reports>>Supplier>>Payment Aging by Supplier Roles: ZZ Accounts Payable Reports
Payment History By Supplier	Payment History By Supplier Report	NavBar>Accounts Payable>>Reports>>Supplier>>Payment History by Supplier Roles: ZZ Accounts Payable Reports
AP/GL Account Recon Report	AP/GL Account Recon Report	NavBar>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	NavBar>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	NavBar>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.	NavBar>Accounts Payable>> Reports>> Voucher Reconciliation>> Open Liability Reconciliation Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Payables Open Liability	Payables Open Liability Report	NavBar>Accounts Payable>> Reports>> Voucher Reconciliation>> Payables Open Liability Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Supplier Liability Aging	Supplier Liability Aging Report	NavBar>Accounts Payable>> Reports>> Voucher Reconciliation>> Supplier Liability Aging Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Match Exceptions	Match Exceptions Report	NavBar>Accounts Payable>> Reports>> Vouchers>> Match Exceptions Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Posted Voucher	Posted Voucher Listing	NavBar>Accounts Payable>> Reports>> Vouchers>> Posted Voucher Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
Voucher Register	Voucher Register	NavBar>Accounts Payable>> Reports>> Vouchers>> Voucher Register Roles: ZZ Accounts Payable Reports ZZ Purchasing Reporting
1099 Withholding to Send Detail	1099 Withholding to Send Detail	NavBar>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	NavBar>Suppliers>>1099/Global Withholding>>1099 Reports>>Withhold 1099 Report Job Roles: ZZ 1099 Processing
Wthd Voucher/Supplier Mismatch	Withholding Mismatch Report	NavBar>Suppliers>>1099/Global Withholding>>General Reports>>Wthd Voucher/Supplier Mismatch Roles: ZZ Accounts Payable Reports
Supplier Audit Log	Supplier Audit Log	NavBar>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!)

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

Recent Updates