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

This section lists the reports in this Documentation.

  • 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.

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

OMX3210 (XML format)

Sold-To Customer Master

Lists the address and the processing options for Sold To Customers for the selected SetID. (BI Publisher)

Customers > Reports > Sold To Customer Master > Sold-To Customer Master

RUN_OMC3210

OMX3240 (XML format)

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. (BI Publisher)

Customers > Reports > Sold To Cust Relationships > Sold-To Cust Relationships

RUN_OMC3240

OMX3220 (XML format)

Ship-To Customer Master

Lists the address and the processing options for Ship To Customers for the selected SetID. (BI Publisher)

Customers > Reports > Ship To Customer Master > Ship-To Customer Master

RUN_OMC3220

OMX3260 (XML format)

Ship To Customer Relationships

Lists each ship to customer, its status, and all associated customer relationships in order of priority for the selected SetID. (BI Publisher)

Customers > Reports > Ship To Cust Relationships > Ship-To Cust Relationships

RUN_OMC3260

OMX3230 (XML format)

Ship Date Exceptions

Lists both block and standing ship date exceptions by ship to customer for the selected SetID. (BI Publisher)

Customers > Reports > Ship Date Exceptions

RUN_OMC3230

Report ID and Report Name

Description

Navigation

Run Control Page

OMX4100 (XML format)

Product Master

Lists all products by SetID. Identifies the item ID, status, and whether the product is a product kit, among other details. (BI Publisher)

Products > Reports > Product Master

RUN_OMC4100

OMX4200 (XML format)

Product Price List

View list prices for products, unit of measure, and ship from warehouses. (BI Publisher)

Products > Reports > Product Price List

RUN_OMC4200

OMX4300 (XML format)

Product Catalogs

View which products and or product groups belong to a product catalog. (BI Publisher)

Products > Reports > Product Catalogs

RUN_OMC4300

CRCARDHST

Credit Card History Report

This report lists credit card transmissions that have been performed from the PeopleSoft Order Management, Billing and Receivables modules. Search parameters allow you to search by business unit and transmission date range.

Set Up Financials/Supply Chain > Common Definitions > Credit Cards > Credit Card History Report

RUN_CRCARD_HST

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

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

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