9.2 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



0 Comments

Add your comment

E-Mail me when someone replies to this comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.