This appendix provides:
A summary table with general descriptions of PeopleSoft Source to Settle Common Information standard reports.
Report details.
Note. For samples of these reports, see the PDF files published on CD-ROM with the documentation (for online users) or PeopleSoft Procurement Reports (for hardcopy users).
In addition to the standard reports, we also provide reporting tools that you can use to create new reports.
See Also
Enterprise PeopleTools 8.46 PeopleBook: PeopleSoft Process Scheduler
This table lists the PeopleSoft Procurement reports, sorted alphanumerically by report ID. If you need more information about a report, refer to the report details at the end of this appendix.
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
APY0005 |
Lists detailed SpeedChart information by setID. (Crystal) |
Set Up Financials/Supply Chain, Product Related, Procurement Options, Reports, SpeedCharts |
RUN_APY0005 |
APY1230 |
Displays the beginning balance, ending balance, and credit and debit totals for selected vendors by payables account or alternate account. |
Statutory Reports, Accounts Payable, Balance by Account/Vendor, Balance Account Vendor |
RUN_APY1230 |
APY3000 |
Lists vendors by status along with their associated detail data including address information and payment options. |
Accounts Payable, Reports, Vendor, Vendor Detail Listing, Parameters |
RUN_APY3000 |
APY3001 |
Lists all the vendors by status along with basic summary information. |
Accounts Payable, Reports, Vendor, Vendor Summary Listing, Parameters |
RUN_APY3001 |
APY3020 |
Lists the gross amount of all the outstanding vouchers for the specified vendor. |
Accounts Payable, Reports, Vendor, Vendor Balance, Outstanding Balance by Vendor |
RUN_APY3020 |
APY3200 |
Displays journal entries by vendor, account and accounting period. |
Statutory Reports, Accounts Payable, Transaction Detail by Vendor |
RUN_APY3200 |
APY3210 |
Displays vendor beginning and ending balances and total debits and credits. |
Statutory Reports, Accounts Payable, Balance by Vendor/Account, Balance Vendor/Account |
RUN_APY3210 |
APY3215 |
Shows vendors that erroneously have duplicate TINs, withholding names, withholding addresses, vendor names, vendor short names, or vendor addresses. (Crystal Report) |
Vendors, Vendor Setup/Maintenance, Duplicate Vendor Report, Duplicate Vendors |
DUP_RPT_POST |
APY6002 |
Lists the vendors that have been selected for archiving. |
Accounts Payable, Administration, Archive Vendors, Vendor Archive Selection |
VNDR_ARCH_REPT |
POCNT100 |
Lists all the vendor contracts based on selection criteria you enter on the Vendor Contracts Report page. (SQR) |
Purchasing, Procurement Contracts, Reports, Order Contracts, Vendor Contracts |
RUN_POCNT100 |
POCNT200 |
Lists all internal contracts based on selection criteria you enter on the Internal Contract Report page. You can view item usage by category, by vendor, and by contract. (SQR) |
Purchasing, Procurement Contracts, Reports, Internal Order Contracts, Internal Contract |
RUN_POCNT200 |
POCNT300 |
Lists use and monetary value of items not under contract. Additionally, you can identify items being used that should be substituted for items currently under contract. (SQR) |
Purchasing, Procurement Contracts, Reports, Non-Contracted Items |
RUN_POCNT300 |
POCNT400 |
Lists, by vendor/category or category/vendor, contracts that are scheduled to expire within a selected date range. This enables you to be proactive in contract renewals or to generate entirely new contracts with existing or new vendors. This report also enables you to synchronize multiple contracts with a vendor; you can enter into negotiations with that vendor for multiple contracts all at once. (SQR) |
Purchasing, Procurement Contracts, Reports, Contract Expiration |
RUN_POCNT400 |
GPO Price Comparison (group purchase order price comparison) |
Displays manufacturer prices, distributor prices, expected distributor markups, and actual item markups for all items on a GPO contract. All prices are displayed in the GPO manufacturer currency. (SQR) |
Purchasing, Procurement Contracts, Reports, GPO Price Comparison |
RUN_POCNT500 |
POCNT505 |
Lists all items for which the distributor markup on the actual price does not equal that on the GPO contract. (SQR) |
Purchasing, Procurement Contracts, Reports, GPO Price Exception |
RUN_POCNT505 |
POCNT510 |
Lists the amount spent, by GPO manufacturer contract. The amounts in this report do not include distributor markup. The report is sorted by distributor (vendor) or item category. (SQR) |
Purchasing, Procurement Contracts, Reports, GPO Manufacturer Commitment |
RUN_POCNT510 |
POCNT515 |
Displays the total amount spent with a GPO distributor for items supplied by a particular manufacturer. Compare this report to the contract commitments made to the distributor (amount purchased per quarter, for example). (SQR) |
Purchasing, Procurement Contracts, Reports, GPO Distributor Commitment |
RUN_POCNT515 |
POCNT520 |
Displays the amount spent with a single group purchasing organization (GPO), including all current contracts. Amounts include distributor markups. The report is sorted by distributor (vendor) or item category code. (SQR) |
Purchasing, Procurement Contracts, Reports, GPO Purchases |
RUN_POCNT520 |
POY1050 |
Lists all the master voucher contracts for a specified setID. (Crystal) |
Purchasing, Procurement Contracts, Reports, Master Contracts |
RUN_POY1050 |
POY1051 |
Lists all the voucher contracts for a specified setID with contract header and distribution information. (Crystal) |
Purchasing, Procurement Contracts, Reports, Recurring Vouchers, Recurring Voucher Contracts |
RUN_POY1051 |
POY1052 |
Lists recurring voucher contract details by setID and contract ID. (Crystal) |
Purchasing, Procurement Contracts, Reports, Recurring Voucher Details, Recurring Voucher Detail |
RUN_POY1052 |
This section provides detailed information on individual reports including important fields. The reports are listed alphanumerically by report ID.
As of Data |
Enter a date to generate a report with information about all SpeedCharts in the system as of this date. |
SpeedType |
Type of security set up for the SpeedChart, along with a short description. |
Operator ID |
The user ID of the single user who can use the designated SpeedChart when the speed type is O (one user). |
Operator Class |
The class of users from the primary permission list that has access to the designated SpeedChart when the speed type is C (class). |
Percentage |
Percentage by which the cost of the total amount is distributed for the SpeedChart line. |
Set ID |
Select the SetID on which you want to report by selecting it from the available options. |
As of Date |
Select the date as of which you want to report data for the vendors. Use the calendar button to select a date, or type one directly into the field. |
Vendor Status |
Select from the following options: Approved, Inactive, To Archive, or Unapproved. |
Class |
References the vendor's classification as defined on the Vendor Information - Identifying Information page. |
Persistence |
References the vendor's persistence as defined on the Vendor Information - Identifying Information page. |
WTHD |
Indicates whether the vendor is defined as a withholding vendor on the Vendor Information - Identifying Information page. |
Location |
References the location(s) defined for the vendor on the Vendor Information — Location page. |
Approve Flag |
At the vendor location level, voucher approval processing can default from the control hierarchy, be specified as pre-approved, or be controlled by workflow processes using the Virtual Approver model. You can define the approval processing for the vendor location on the Matching Options page in the Vendor component. |
Bus Proc Name (business process name) |
If you are using the Virtual Approver model, this references the business process name that controls the routing of vouchers to roles in the organization. This field is defined on the Matching Options page in the Vendor component. |
Apprvl Rule Set (approval rule set) |
If you are using the Virtual Approver model, this references the Approval Rule Set that controls the routing of vouchers to roles in the organization. This field is defined on the Matching Options page in the Vendor component. |
Terms Code |
References the Payment Terms Code defined on the Procurement Options page in the Vendor component. |
Handling |
References the Payment Handling Code specified for this vendor location on the Payment Options page in the Vendor component. Each payment handling code has a sort sequence related to it that determines the order in which it will print. Checks will be printed according to the sort sequence in ascending order: the lower the sort sequence number, the higher the sort priority. You must always have a payment handling code on a scheduled payment. You define payment handling codes on the Structure Procurement Options menu. |
Pay Group |
References the pay group defined on the Payment Options page in the Vendor component. This feature enables you to assign vendors to a group and pay them all at once. |
Invoice Address |
References the invoicing address for the vendor as defined on the Vendor Information — Location page. |
Remit Address |
References the remit to address for the vendor as defined on the Vendor Information — Location page. |
Other Address |
References the ordering address for the vendor as defined on the Vendor Information — Location page. |
Return Address |
References the return address for the vendor as defined on the Vendor Information — Location page. |
ID |
The vendor ID of all of the vendors for this SetID as defined on the Vendor Information - Identifying Information page. |
Name |
The vendor name defined on the Identifying Information page in the Vendor component. |
Corporate |
The corporate ID of the vendors for the selected SetID, as defined on Vendor Information — Identifying Information Page |
AR Customer # |
The Accounts Receivable Customer Number of vendors for the selected SetID, as defined on the Additional ID Numbers page. This number indicates that this vendor is also a customer. |
Total for Voucher ID |
Totals the Discount Amount and Gross Amount for the voucher. |
Total for Business Unit |
Totals the Discount Amount and Gross Amount for the business unit. |
Archive ID |
The archive ID defined on the Vendor Archive Request page. |
Archive Date |
The archive date defined on the Vendor Archive Request page. The Archive Date indicates the date on which you want to archive. This date will help you keep track of when you actually ran the archive process. |
Wthd Sw (Withholding Switch) |
The Withholding Switch for the vendors selected for archiving. If this field is Y then the vendor is a withholding vendor. |
VAT Sw (VAT Switch) |
The VAT Switch for the vendors selected for archiving. If this field is Y then the vendor is a VAT vendor. |
Last Activ Dt (Last Activity Date) |
The system-maintained date that is assigned to the vendor, which records when that vendor's most recent transaction occurred. |
Allow Multicurrency PO |
Whether you allow the purchase order to have multiple currencies. This is set on the Maintain Contracts — Header Page. |
See Also
Creating Contract Line Information
Rate - Type |
The currency rate type for the contract. |
Rate - Date |
The date on which the currency rate is based. |
MC PO |
Whether this is a multicurrency purchase order. |
Open Item Ref (open item reference) |
Whether open items against the contract are included. |
Select an Option for the From/To date:
C (current date) |
Report expiring contracts beginning/ending with the current date. |
M (current date minus days) |
Report expiring contracts beginning/ending with the date that is a specified number of days before the current date. Specify that number in the Nbr Days field. |
N (no selection by date) |
Date criteria not used to report expiring contracts. |
P (current date plus days) |
Report expiring contracts beginning/ending with the date that a specified number of days after the current date. Specify the number in the Nbr Days field. |
S (specified date) |
Report expiring contracts beginning/ending with the dates you select in the Date field. |
Gross Amount |
The gross amount you defined for the contract. This field is used by PeopleSoft Payables voucher contracts, and not by PeopleSoft Purchasing order contracts. |
See Also
Product |
The product number of the item. The product is generally used to capture additional information useful for profitability and cash flow analysis, for example. |
Post Status |
The status of the posting of the voucher. |
Entry Status |
The contract voucher status. Available options are Recycled, Open, Postable, and Complete. |