PeopleSoft Working With Order to Cash Common Information Reports

Appendix: PeopleSoft Working With Order to Cash Common Information Reports

This appendix provides an overview of the reports in the this PeopleBook.

Note. For samples of these reports, see the Portable Document Format (PDF) files published on CD-ROM with the documentation.

PeopleSoft Working With Order to Cash Common Information Reports: A to Z

This section lists the reports in this PeopleBook.

Customer reports.
Product reports.
Product nVision reports.
Return material authorization (RMA) reports.
Cash drawer reports.

Note. nVision reports are run only from the PeopleTools window client.

Customer Reports

Report ID and Report Name	Description	Navigation	Run Control Page
AR31001 TableSet Customers	Lists all customers by business unit for the setID.	Customers, Reports, Customers by SetID, TableSet Customers Accounts Receivable, Customer Accounts, Customer Reports, Customers by SetID, TableSet Customers	RUN_AR31001
AR31002 Business Unit Customers	Lists all customers for the business unit.	Accounts Receivable, Customer Accounts, Customer Reports, Customers by Unit, Business Unit Customers Customers, Reports, Customers by Unit, Business Unit Customers	RUN_AR31002
AR31003 TableSet Contacts	Lists customer contacts by SetID, including their title, phone, and fax numbers.	Customers, Reports, Contacts by SetID, TableSet Contacts Accounts Receivable, Customer Accounts, Customer Reports, Contacts by TableSet, TableSet Contacts	RUN_AR31003
AR31004 Business Unit Contacts	Lists customer contacts by business unit, including their title, phone, and fax numbers.	Accounts Receivable, Customer Accounts, Customer Reports, Contacts by Unit, Business Unit Contacts Customers, Reports, Contacts by Unit, Business Unit Contacts	RUN_AR31004
OMC3210 Sold-To Customer Master	Lists the address and the processing options for Sold To Customers for the selected setID. (Crystal)	Customers, Reports, Sold To Customer Master, Sold-To Customer Master	RUN_OMC3210
OMC3240 Sold To Customer Relationships	Lists each sold to customer, its status, and all associated ship to and bill to customers in order of priority for the selected SetID. (Crystal)	Customers, Reports, Sold To Cust Relationships, Sold-To Cust Relationships	RUN_OMC3240
OMC3220 Ship-To Customer Master	Lists the address and the processing options for Ship To Customers for the selected SetID. (Crystal)	Customers, Reports, Ship To Customer Master, Ship-To Customer Master	RUN_OMC3220
OMC3260 Ship To Customer Relationships	Lists each ship to customer, its status, and all associated customer relationships in order of priority for the selected setID. (Crystal)	Customers, Reports, Ship To Cust Relationships, Ship-To Cust Relationships	RUN_OMC3260
OMC3230 Ship Date Exceptions	Lists both block and standing ship date exceptions by ship to customer for the selected SetID. (Crystal)	Customers, Reports, Ship Date Exceptions	RUN_OMC3230

Product Reports

Report ID and Report Name	Description	Navigation	Run Control Page
OMC4100 Product Master	Lists all products by SetID. Identifies the item ID, status, and whether the product is a product kit, among other details.	Products, Reports, Product Master	RUN_OMC4100
OMC4200 Product Price List	View list prices for products, unit of measure, and ship from warehouses.	Products, Reports, Product Price List	RUN_OMC4300
OMC4300 Product Catalogs	View which products and or product groups belong to a product catalog.	Products, Reports, Product Catalogs	RUN_OMC4300

Product nVision Reports

Report ID and Report Name	Description	Navigation	Run Control Page
OMBOOKP Product Booked by Product ID	Product bookings by business unit	Run from the PeopleTools window client.	OM_BOOKP.XLS
OMSALEP Product Sales by Product ID	Product sales by business unit	Run from the PeopleTools window client.	OM_SALEP.XLS
OMBOOKC Product Booked by Sold To Customer	Customer bookings by business unit.	Run from the PeopleTools window client.	OM_BOOKC.XLS
OMSALEC Product Sales by Sold To Customer	Customer sales by business unit	Run from the PeopleTools window client.	OM_SALEC.XLS
OMPRC Product Prices	Product Prices	Run from the PeopleTools window client.	OM_PRC.XLS

RMA Reports

Report ID and Report Name	Description	Navigation	Run Control Page
INS3000 Return Material Authorization	Lists RMA transactions for internal and external locations. Use this report to provide staff at the internal or external locations with an acknowledgment of a return request and direction on where to send the returned materials. You can also generate this report to aid receiving clerks in matching returned material at the receiving docks with an RMA in the PeopleSoft system. For each RMA, this report includes header and line information.	Inventory, Manage Returned Material, RMA Report, Returned Material Authorization	RUN_INS3000
OMS3000 Print RMA	Lists the details of an authorized return for a customer. Note. Notes are printed on the RMA report without configuration.	Customer Returns, Reports, RMA, Print RMA	RUN_OMS3000
OMS7100 RMA Register	Lists RMAs by business unit.	Customer Returns, Reports, RMA Register, RMA Register	RUN_OMS7100
OMS7110 Overdue RMAs	Lists RMA line for products that are not returned by the estimated return date on the RMA Line page.	Customer Returns, Reports, Overdue RMAs, Overdue RMAs	RUN_OMS7110

Cash Drawer Reports

Report ID and Report Name	Description	Navigation	Run Control Page
CDRDEPST Print Bank Deposit Slip	Print a bank deposit slip from the reconciliation. This slip lists cash to deposit, as well as a list of the checks (check number and amount ) to deposit.	Accounts Receivable, Payments, Cash Drawer, Print Bank Slip Deposit	RUN_CDR_PRNTDEP

Report ID and Report Name

Description

Navigation

Run Control Page

CDRDEPST

Print Bank Deposit Slip

Print a bank deposit slip from the reconciliation. This slip lists cash to deposit, as well as a list of the checks (check number and amount ) to deposit.

Accounts Receivable, Payments, Cash Drawer, Print Bank Slip Deposit

RUN_CDR_PRNTDEP