PeopleSoft Payables Reports: A to Z
This table provides general information about delivered PeopleSoft Payables reports, sorted alphanumerically by report ID.
Note: You may see both of the terms XML Publisher (XMLP) and BI Publisher, depending on the version of your PeopleTools installation and the Bundle version of your 9.1 application. As of PeopleTools 8.52, references to XML Publisher (XMLP) have changed to BI Publisher. This does not denote a change to the reports; only the naming convention has changed.
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
---|---|---|---|
APCX8053 Payables Report by Schedule and Appropriation Symbol |
(USF) Lists voucher distribution lines by federal schedule and appropriation symbol. Because each distribution line of a voucher references a different appropriation symbol, the detailed level of this report shows individual voucher distribution lines. |
|
RUN_APC8053 |
APS2001 Prompt Pay Report |
(USF) Summarizes how efficiently a government agency made supplier payments for a year. (SQR Report) |
|
RUN_APS2001 |
APSX8001J Federal Voucher Activity |
(USF) Lists voucher activity by business unit, fund, department, program, class, account, budget period, project/grant, remaining amount, due date, and agency location code. |
|
RUN_APS8001 |
APSX8002J Federal Disbursement Activity |
(USF) Lists disbursement activity by business unit, fund, department, program, class, account, budget period, project/grant, remaining amount, due date, and agency location code. |
|
RUN_APS8002 |
APS8004 SPS Summary File |
Generates the SF1166 Summary Certification file from the data you entered on the SPS Summary Totals page. |
|
GFAP_RUN_SPS |
APX0000 List of Voucher Origins |
Lists the voucher origin options by SetID. |
|
RUN_APY0000 |
APX0010 Business Unit List |
Lists all the PeopleSoft Payables business units and their operating parameters. |
|
RUN_APY0010 |
APX0011 Business Unit Options |
Lists the PeopleSoft Payables business unit options by SetID. |
|
RUN_APY0011 |
APX1010 Voucher Register |
Lists vouchers by business unit, date entered, and Voucher ID. |
|
RUN_APY1010 |
APX1011 Control Group Register |
Lists vouchers entered into PeopleSoft Payables by business unit, control group ID, date entered, and voucher ID. For each Business Unit and Control Group ID combination, the report lists all the vouchers that meet these criteria by their Date Entered. For each Voucher, the report lists Voucher Header Information, Voucher Line Information, and Distribution Line Information. |
|
RUN_APY1011 |
APX1020 Posted Voucher Listing |
Lists all posted vouchers for a given business unit and date range. For each Voucher ID, the report lists Document Type, Document Date, Document Sequence, Ledger, Accounting Date, Application Journal, Dist Type, Vchr Line, Dist Line, GL Unit, Account, Dept, Product, Project, Debit Amount, Credit Amount, Currency Code, and Unpost Seq#. |
|
RUN_APY1020 |
APX1060J Self-Billed Invoice |
Lists all of the Documents that comprise an SBI. For each Document, the report lists Item, Quantity, UOM, Price, Amount, Tax Amount, Tax%, VAT Amount, VAT%, and Total. |
|
VCHR_SBI_PRINT |
APX1065 Self-Billed Invoices Review |
Lists SBI data that has been selected by the SBI process. For each Dummy SBI Number, the report lists SBI Hold, Unit, Voucher, Invoice, Invoice Date, Item, Quantity, Merchandise Amount, VAT Amount, Tax Amount, and Total Amount. |
|
RUN_APY1065 |
APX1070 AP SBI Suppliers |
Lists the available SBI suppliers you selected on the SBI Supplier Listing page. For each Supplier ID, the report lists Supplier Name, Remit, Corporate, AR Customer Number, Entered By, Location, SBI Option, SBI Approval, and Last SBI Number. |
|
RUN_APY1070 |
APX1080 Unapproved SBIs by Supplier |
Lists unapproved SBIs by supplier. For each SBI Number, the report lists Creation Date, Business Unit, and Voucher ID. |
|
RUN_APY1080 |
APX1090 Match Detail Report |
Lists the match exceptions with voucher data, purchase order data, receiver data, and match error information. For each Buyer Name, the report lists Voucher Data (Unit, Voucher, Line Vchr Qty, Vchr Price, Vchr Amt); Purchase Order Data (Unit, PO ID, Line, Sched, PO Qty, PO Price, PO Amt); Receiver Data (Unit, Recv ID, Line, Seq); and Match Error information (Match Control ID, Match Rule). (BI Publisher Report) |
|
RUN_APY1090 |
APX1099 1099-MISC Copy B |
(USA) IRS Form 1099-MISC for your suppliers. (BI Publisher Report) |
|
RPT_1099_JOB |
APX1099N 1099-NEC Copy B |
(USA) IRS Form 1099-NEC for your suppliers. (BI Publisher Report) |
|
RPT_1099_JOB |
APX1099G 1099-G Copy B |
(USA) IRS Form 1099-G for your suppliers. (BI Publisher Report) |
|
RPT_1099_JOB |
APX1099I 1099-INT Copy B |
(USA) IRS Form 1099-INT for your suppliers. (BI Publisher Report) |
|
RPT_1099_JOB |
APX1100 Debit Memo |
Provides detail debit memo adjustment voucher information for your suppliers. |
|
RUN_DBMEMO_DSP |
APX1101 Unpaid Debit Memos |
Lists unpaid debit memo adjustment vouchers by supplier. |
|
RUN_APY1101 |
APX1102 Debit Memos on Hold |
Lists debit memo adjustment vouchers on payment hold by supplier. |
|
RUN_APY1102 |
APX1103 Suppliers with Debit Memo Agreements |
Lists suppliers with debit memo agreements and their debit memo options. |
|
RUN_APY1103 |
APX1104 Voucher Adjustment Voucher Cross Reference |
Lists vouchers and their associated debit memo adjustment vouchers. |
|
RUN_APY1104 |
APX1400 Summary AP/GL Open Liability Account Reconciliation Report |
Compares the AP Open Liability balance to the GL Open Liability balance. (BI Publisher Report) |
|
RUN_APY1405 |
APX1405 Detail AP/GL Open Liability Account Reconciliation Report |
Shows all accounting activity for accounts payable transactions for each voucher. Use the detail report to validate the AP Open Liability balance to the General Ledger. (BI Publisher Report) See APX1400. |
|
RUN_APY1405 |
APX1406 Payables Open Liability Report |
Lists all open liabilities by business unit. (BI Publisher Report) |
|
RUN_APY1406 |
APX1408 Supplier Open Liability |
Lists all vouchers that have not been paid by the As of Date. You can run the report in either summary or detail format for specific suppliers. The report excludes vouchers that are in the Recycled status and categorized scheduled payments on hold or on hold for withholding. (BI Publisher Report). |
|
RUN_APY1406 |
APX1410 AP/GL Journal Reconciliation Report |
Lists totals by journal line and journal ID. (BI Publisher Report). |
|
APGL_RECN_REQ1 |
APX1420 AP/GL Account Reconciliation Report |
Lists account totals by Journal ID and Account. (BI Publisher Report). |
|
APGL_RECN_REQ2 |
APX2000 Payment History by Supplier |
Provides a register of payments for a supplier. Using the Print Options radio buttons on the Payment History by Supplier page, you can generate either a Detail, or a Summary version of this report. |
|
RUN_APY2000 |
APX2001 Payment Register |
Provides a register of payments by Pay Cycle, run date, and payment method. Using the Print Options radio buttons on the Payment Register by Payment page, you can generate either a Detail, or a Summary version of this report. The title is based on the payment method. For example, Detailed Check Register, Detailed EFT Register, etc. |
|
RUN_APY2001 |
APX2004 Payment History by Bank |
Provides a register of the payments for a bank. Using the Detail/Sum field on the Pymnt Control Rpt page, you can generate either a Detail, or a Summary version of this report. |
|
RUN_APY2004 |
APX2021 Check Overflow Payment Advice |
Produced only from the Pay Cycle Manager, generates the overflow payment advice for payment forms Check1, Check2, Check3, and LC1. You do not access a report page to generate this or other payment advices. (BI Publisher) |
|
N/A |
APX2027 EFT/Giro/Wire Advice |
Produced only from the Pay Cycle Manager, creates checks, letters of credit, and payment advice when you run the pay cycle. (BI Publisher) Note: If you install the bank transfer charge option, fields for information related to bank transfer charges are added to this report. (USF) If you have federal payments enabled on the Installation Options - Payables page, the purchase order ID and contract ID are included in the report, if these elements exist on the voucher. |
|
N/A |
APX2030 Trial Payment Register |
Provides a printable summary of payments by bank account, after payment selection and creation, but before you print checks or create EFT or ACH files. (BI Publisher Report) |
|
RUN_APY2030 |
APX2031 SF1166 Schedule Register |
(USF) Provides a listing of all vouchers that were paid by a schedule ID. |
|
RUN_APY2030 |
APX2040 Payment Forecast |
List of your payment forecasts. |
|
PYFRCST_RQST |
APX2050 Payment History by Payment Method - Detail or Summary |
Provides a history of payments by payment method. |
|
RUN_APY2050 |
APX2051 Payment Aging by Bank |
Provides a listing of payments aging by bank. |
|
RUN_APY2051 |
APX2052 Payment Aging Summary (Detail) Report by Supplier |
Provides a report listing payments aging by supplier. |
|
RUN_APY2052 |
APX2053 Drafts Create Detail List |
Provides a detailed report for created draft payments. |
|
RUN_APY2053 |
APX2054 Drafts Create Detail - Stamp Tax Summary |
Provides a summary of the draft stamp tax associated with draft payments. |
|
RUN_APY2054 |
APX2056 Drafts Create Summary |
Provides a summary report for created draft payments. |
|
RUN_APY2056 |
APX2060 Agency Location Codes |
(USF) Lists the ALC's defined in the Agency Location Code setup table for federal customers. |
|
RUN_APY2060 |
APX2100 Open Prepayments |
Lists unapplied prepaid vouchers. |
|
RUN_APY2100 |
APX2101 Prepayment Settlements |
Lists regular voucher payment schedules that have been fully applied. |
|
RUN_APY2101 |
APX3012 Supplier Withholding Balances Control Report |
Lists withholding activity for internal audits. Oracle recommends that you run the report on a regular basis to check the withholding summaries. |
|
RUN_APY3012 |
APX3020 Outstanding Balance by Supplier |
Lists the gross amount of all the outstanding vouchers for the specified supplier. |
|
RUN_APY3020 |
APX3215 Duplicate Suppliers |
Shows potential duplicate suppliers. These suppliers may share duplicate TINs, withholding names, withholding addresses, supplier names, supplier short names, or supplier addresses, depending on your search criteria. (BI Publisher Report) |
|
DUP_RPT_POST |
APX6000 Payment Archive Report |
Shows payment transactions selected for archiving by Payment ID, Payment ID Reference, Name, Payment Amount, Payment Date, Clear Date, Reconcile Different Amount, Business Unit, Invoice ID, Paid Amount, and Paid Amount Discount, so you can check that the correct payments have been selected. |
|
PYMNT_ARCH_REPT |
APX6001 Voucher Archive Report |
Lists vouchers selected for archiving by Voucher ID, Supplier ID, Invoice ID, Invoice Date, Gross Amount, Merchandise Amount, Currency Code, Payment ID, Paid Amount, and Paid Amount Discount, so you can check that the correct vouchers have been selected for archiving. |
|
VCHR_ARCH_REPT |
APX6002 Supplier Archive Report |
Lists suppliers selected for archiving by Supplier ID, Short Name, Name, Vndr Status, Vndr Class, Vndr Persist, Remit Vndr, Corp Vndr, Cust ID, Wthd Sw, VAT Sw, and Lst Activ Dt, so you can check that the correct suppliers have been selected. |
|
VNDR_ARCH_REPT |
APX7010 Withholding Rules |
Shows the information entered on the withholding rule page. For each As of Date, the report lists Withholding Rule, VAT, Freight, Sales/Use Tax, Discount, Payment, Hold, Percent, and Minimum Amount. |
|
RUN_APY7010 |
APX7020 Withholding Types |
Shows the information from the Withholding Type page. For each Withholding Type, the report lists Class and Description. |
|
RUN_APY7020 |
APX7030 Withholding Entities |
Shows the information from the Entity page. For each entity, the report lists supplier SetID, supplier ID, location, currency, rate type, last report date, file layout, type, jurisdiction, class, rule, business unit, account, department, product, and project ID. |
|
RUN_APY7030 |
APX7040 Withholding Codes |
Shows information entered on the Withholding Code page. For each code, the report lists entity, type, jurisdiction, and class. |
|
RUN_APY7040 |
APX7050 Withholding Calculations Query |
Shows calculations made during the pay cycle that pertain to withholding. For each voucher ID, the report lists detail withholding calculation information, including withholding entity, withholding type, and withholding rules that applied to the voucher. |
|
RUN_APY7050 |
APX8025 Japan Withholding Report |
(JPN) Provides details of amounts withheld from payments for goods and services. (BI Publisher Report). |
Select WTH as the Withholding Report ID. |
WTHD_RPT_RUN |
APX8030 Spain IRPF Model 190 |
(ESP) Provides details of amounts withheld from payments for goods and services. (BI Publisher Report). |
Select IRPF as the Withholding Report ID. |
WTHD_RPT_RUN |
APY8031 Spain IRPF Model 190 File |
(ESP) Provides a file of detailed amounts withheld from payments for goods and services. |
Select IRPF_FILE as the Withholding Report ID. |
WTHD_RPT_RUN |
APY8032 CIS (construction industry scheme) File |
(UK) Provides a file of detailed amounts withheld from payments for goods and services. (SQR). |
Select CIS as the Withholding Report ID. |
WTHD_RPT_RUN |
APX8035 DAS-2 'Declaration d'honoraires'/Fees return |
(FRA) Provides details of payments subject to DAS2. (BI Publisher Report). |
Select DAS2 as the Withholding Report ID. |
WTHD_RPT_RUN |
APY8041 PAYG Voluntary Agreement |
(AUS) Provides a payment summary for suppliers working under voluntary agreements that enable businesses to withhold amounts from their payments and send them to the ATO (SQR Report). |
|
WTHD_RPT_RUN2 |
APY8042 PAYG Labour Hire |
(AUS) Provides a payment summary for suppliers working under labour hire agreements that enable businesses to withhold amounts from their payments and send them to the ATO (SQR Report). |
|
WTHD_RPT_RUN2 |
APY8043 PAYG No ABN Quoted |
(AUS) Provides a payment summary for suppliers with no Australian Business Number (ABN) (SQR Report). |
|
WTHD_RPT_RUN2 |
APY8044 PAYG Payment Summary Statement |
(AUS) Provides details of amounts withheld from payments for goods and services to suppliers having an Australian Business Number (ABN) (SQR Report). Note: You must select the Issued option on the Withholding by Supplier page to retrieve the proper data for this report, since it provides information about the payments issued to payees during the fiscal year. |
|
WTHD_RPT_RUN3 |
APX8045 PPS Remittance Advice to ATO |
(AUS) Provides details of amounts withheld from payments for goods and services. (BI Publisher Report). Note: You must select the Issued option on the Withholding by Supplier page to retrieve the proper data for this report, since it provides information about the payments issued to payees during the fiscal year. |
Select PPS1 as the Withholding Report ID. |
WTHD_RPT_RUN |
APX8048 PPS Annual Reconciliation Statement to ATO |
(AUS) Provides details of amounts withheld from payments for goods and services. (BI Publisher Report). |
Select PPS2 as the Withholding Report ID. |
WTHD_RPT_RUN |
APX8049 PPS Payment Summary to ATO |
(AUS) Provides summary information of amounts withheld from payments for goods and services, by Tax Rate. (BI Publisher Report). |
Select PPS3 as the Withholding Report ID. |
WTHD_RPT_RUN |
APX8050 T4A - Statement of Pension, Retirement, Annuity, and other Income |
(CAN) Produces tax form T4A that reports pension, retirement, annuity, and other income, including the amount of tax withheld. (BI Publisher Report). |
Select T4A as the Withholding Report ID. |
WTHD_RPT_RUN |
APX8055 Withholding Report 770 |
(ITA) Provides details of amounts withheld from payments for goods and services. (BI Publisher Report). |
Select IT770 as the Withholding Report ID. |
WTHD_RPT_RUN |
APX8056 1099 Withhold to Send Detail |
Lists all the information created by the 1099 reporting process and is a replica of the data in the file you are sending to the IRS. (BI Publisher Report) |
|
TO_SEND_RPT |
APY8070 TDS Register |
(IND) Contains detailed information for each withholding class and supplier on TDS applicable vouchers and related payments issued to the withholding entity. It also includes total amounts of applicable invoice on which tax has not been deducted. (SQR Report) |
|
RUN_APY8070 |
APX8080 TDS Certificate |
(IND) Certificate issued by the payer to the payee for proof of deduction of income tax. (BI Publisher Report) |
|
RUN_APY8080 |
APX8085 TDS Challan Information |
(IND) Report generated every month, when the payment of tax deduction for that month is paid to the government to provide information for the TDS Challan. |
|
RUN_APY8070 |
APX8090 Work Cont. Certificate |
(IND) Certificate issued by the payer to the payee for proof of deduction of tax on Work Contract. |
|
RUN_APY8080 |
APX9010 Withholding Mismatch Report |
Identifies all voucher lines on which the withholding applicable flag does not match the withholding flag on the supplier. The report does not compare the withholding code on the supplier to the withholding code on the voucher lines. It only checks the withholding flag. (BI Publisher Report) |
|
WTHD_MISMTCH_RQST |
APX9024 Federal Schedule Report |
(USF) Lists federal payment schedules paid as of a specific date. (BI Publisher Report) |
|
RUN_APY9024 |
APXVR_LC Registered Voucher Listing |
Lists all registered vouchers that have not been completed. For each supplier, the report lists voucher, invoice, accounting date, VAT amount, gross amount, and voucher status. (BI Publisher Report) |
|
RUN_APYVR_LC |
BCHX1000 EFT Bank Transfer Charge Detail |
Provides a list of all EFT payments processed in a specified period of time shown with bank charge information. This report supports GENX only. |
|
BCH_RUN_1000 |
FSX2025 EFT File Cover Sheet |
Provides cover sheet for your EFT payments. |
|
RUN_FIN2025 |
FIN2026 DTAUS Cover Sheet |
(GER) Provides cover sheet for your EFT payments. |
|
RUN_FIN2025 |
FSX2027 EFT Bank Advice Letter |
Provides advice for your EFT payments. |
|
RUN_FIN2027 |
FSX2028 EFT Remittance Advice Letter |
Provides advice for your EFT payments. |
|
RUN_FIN2027 |
APXT4A T4A Reporting |
Provides statement of Pension, Retirement, Annuity, and Other Income. |
|
AP_T4A_RUN_CTRL |
APXT4ANR T4A-NR Reporting |
Provides statement of Fees, Commissions, or Other Amounts Paid to Non-Residents for services rendered in Canada. |
|
AP_T4A_RUN_CTRL |
WTP2X_001 Japan Withholding Record |
Corresponds to the year-end Japan Withholding report, which is printed per supplier. The summary sheet has both detailed and summarized information for the applicable withholding transactions that are processed (paid) in the PeopleSoft Payables module. |
|
WTP2_RUN_WTP2_001 |