Appendix: PeopleSoft Promotions Management Reports

PeopleSoft applications offer a wide range of query and reporting possibilities. PeopleSoft provides standard reports, as well as reporting tools that you can use to create new reports.

This appendix enables you to:

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

See Also

Enterprise PeopleTools 8.48 PeopleBook: PeopleSoft Process Scheduler

Click to jump to parent topicPeopleSoft Promotions Management Reports: A to Z

This table lists the Promotions Management reports. The Promotion Contract report that is listed is a Crystal report and the Promotion Forecast Report is an SQR report. If you need more information about these reports, refer to the report details at the end of this appendix.

Report ID and Report Name

Description

Navigation

Run Control Page

TDC1000

Promotion Contract

Records the signed acknowledgement of a customer promotion from the customer.

Promotions, Manage Promotions, Reports, Promotion Contract

RUN_TD_FORM

TDS1000

Promotion Forecast

Provides you with the tool necessary to sync Demand Planning events with planned promotional activities that you create in Promotions Management.

Promotions, Manage Promotions, Reports, Promotion Forecast

RUN_TDS1000

See Also

PeopleSoft Promotions Management Selected Reports

Click to jump to parent topicPeopleSoft Promotions Management Selected Reports

This section provides detailed information about fields for the individual reports in Promotions Management.

Click to jump to top of pageClick to jump to parent topicTDC1000 - Promotion Contract Report

Promotion Code and Description

References the promotion code and description of the customer promotion offered. The system uses the Promotion Code and Description fields that you defined on the Create Customer-Specific Promo - Promotion Details page for this information.

Customer Name

References the customer name to which the promotion is offered. The system uses the Customer ID field that you defined on the customer promotion for this information.

Broker Name, Broker Phone, and Broker Address

References the name and address of the broker who is responsible for the customer promotion. The system uses the Contact ID field that you defined on the Create Customer-Specific Promo - Promotion Details page for the broker name. The system uses the location that you defined on the Promotions Options - General Options page for the broker phone and address information.

From and To Order Dates

References the valid order dates for this customer promotion. The system uses the First Order Date and Last Order Date fields on the Create Customer-Specific Promo - Promotion Details page for this information.

From and To Ship Dates

References the valid scheduled shipment dates for this promotion. The system uses the First Scheduled Ship Date and Last Scheduled Ship Date fields on the Create Customer-Specific Promo - Promotion Details page for this information.

From and To Delivery Dates

References the valid requested arrival dates for this customer promotion. The system uses the First Requested Arrival Date and Last Requested Arrival Date fields on the Create Customer-Specific Promo - Promotion Details page for this information.

From and To Performance Dates

References the valid performance dates for this customer promotion. The system uses the First Performance Date and Last Performance Date fields on the Create Customer-Specific Promo - Promotion Details page for this information.

Merchandising Activity

References the merchandising activities that are defined for the customer promotion. Each merchandising activity's information for the promotion is broken out on the report. The system uses the Merch Type field that you defined on the Create Customer-Specific Promo - Merchandising Activities page to retrieve the syndicated data type that you defined for the merch type on the Merchandising Types page for this information. The syndicated data type is printed next to the Merchandising Activity code.

For purchasing merchandising activities the following fields appear:

Lump Sum

References the lump sum costs for any merchandising activities that are associated with the customer promotion. The system uses the Lump Sum Cost field on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Overhead Costs

References the overhead costs for any merchandising activities that are associated with the customer promotion. The system uses the Overhead Cost field on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Period-To-Date

References the period-to-date option for the merchandising activity associated with the customer promotion. The system uses the Period-to-Date check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back.

Tiered

References the tiered pricing option for the merchandising activity associated with the customer promotion. The system uses the Tiered Pricing check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back and a Price Action Type of Discount.

Mutually Exclusive

References the mutually exclusive option for the merchandising activity associated with the customer promotion. The system uses the Mutually Exclusive check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back.

One Time Only

References the one-time only option for the merchandising activity associated with the customer promotion. The system uses the One-Time Only check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back.

Buying Agreement

References the applicable to buying agreement option for the merchandising activity associated with the customer promotion. The system uses the Applicable to Buying Agreement check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back.

Adjustment Flag

References the adjustment flag for the merchandising activity associated with the customer promotion. The system uses the Adjustment Flag field for the price formula defined on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back.

Off-Invoice

References the off-invoice discounts for any merchandising activities associated with the customer promotion. The system uses the off-invoice adjustment type Discount field for the price formula defined on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Bill Back

References the bill back discounts for any merchandising activities associated with the customer promotion. The system uses the bill back adjustment type Discount field for the price formula defined on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Low Amount and Upper Amount

References the low amount and upper amount that must be met on a sales order to receive the discount. The system uses the Low Amount and Upper Amount fields for the price formula defined on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Low Quantity and Upper Quantity

References the lower and upper quantity that must be met on a sales order to receive the discount. The system uses the Low Quantity and Upper Quantity fields for the price formula marked as use for metrics on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Discount

References the discount amount or percent for the merchandising activity and promotion. The system uses the Discount field for the price formula defined on the Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. and a Price Action Type of Discount.

Product Add, Qty/BOGO (quantity/BOGO), and Product Add Adj ( (product add adjustment)

References the product add product, the quantity/BOGO factor, and the product add adjustment percent or amount of the giveaway for this merchandising activity and promotion. The system uses the Product Add product, Quantity/BOGO Factor, and Product Add Adjustment fields for the price formula defined on the Customer-Specific Promo - Merchandising Activities page for this information. These fields are only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. and a Price Action Type of Product Add.

Product ID, Product Description, UPC Code, UOM (unit of measure), Price, and Plan Ship Qty (plan ship quantity)

References the products and their UPC codes that are offered on the customer promotion. The system uses the Product ID, Unit of Measure, Price, and Plan Ship Qty (plan ship quantity) fields that you defined on the Create Customer-Specific Promo - Product Details page for this information.

For consumption merchandising activities the following fields appear:

Insertion Costs

References the insertion costs for the customer promotion and merchandising activity. The system uses the Insertion Costs field on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Unit Value

References the value of the offer for the consumption merchandising activity and promotion. The system uses the Unit Value field on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Unit Handling

References the per unit cost of running this merchandising activity and promotion. The system uses the Unit Handling Cost field on the Create Customer-Specific Promo - Merchandising Activities page for this information.

Product ID, Product Description, UPC Code, UOM (unit of measure), Price, and Plan Ship Qty (plan ship quantity)

References the products and their UPC codes that are offered on the customer promotion. The system uses the Product ID, Unit of Measure, Price, and Plan Ship Qty (plan ship quantity) fields defined on the Create Customer-Specific Promo - Product Details page for this information.

Information that appears at the bottom of the report:

Signature Block containing Signed, Date, and Comments

Represents the individual who has agreed to this customer promotion. The system uses the Comments field on the Create Customer-Specific Promo - Merchandising Activities page for this information. The other fields are available so that a signature and date can be entered.

See Also

Defining Promotions

Click to jump to top of pageClick to jump to parent topicTDS1000 - Promotion Forecast Report

Product ID and Item ID

References the products and items that are forecasted in any Inventory business unit. If a forecaster was entered on the request page, only the products and items that the forecaster is responsible for will print on the report.

Cust Group (customer group)

References the forecast customer group (group type = FCST) for the customer ID.

Prod Group (product group)

References the forecast product group (group type = FCST) for the product ID.

Base Qty (base quantity)

References the base units defined for the promotion. If the promotion is associated with a promotion group, then the weights that you defined for each product determine the base quantity for the individual product.

Lift Qty (lift quantity)

References either the target lift quantity or planned lift quantity for the product on the promotion.

target lift quantity = (weighted base quantity * incremental lift percent) * participation percent

planned lift quantity = weighted planned ship quantity − weighted base quantity

Lift Pct (lift percent)

References either the target lift percent or the planned lift percent.

target lift percent = ((target plan ship quantity / weighted base quantity) − 1) * 100)

planned lift percent = ((planned plan ship quantity / weighted base quantity) − 1) * 100

Plan Ship Qty (plan ship quantity)

References either the target plan ship quantity or the planned plan ship quantity for the product on the promotion. If the promotion is associated with a promotion group then the weights that you defined for each product determine the planned ship quantity for the individual product.

target plan ship quantity = weighted base quantity + target lift quantity

planned plan ship quantity = weighted planned ship quantity that you defined on the promotion

Promotion Price

References the product price for a product after having taken into account all per unit discounts (off-invoice and bill back) for the promotion.

Total Lift Qty (total lift quantity)

If either item ID or product ID are selected as a sort option, the total lift quantity by product or item appears.

Discount Amount

References the discount amount or percent for the merchandising activity and promotion. The system uses the Discount field for the price formula marked as use for metrics on the Customer-Specific Promo - Merchandising Activities page for this information.

Lump Sum Cost

References the lump sum cost for the merchandising activity and promotion. The system uses the Lump Sum Cost field defined on the Customer-Specific Promo - Merchandising Activities page for this information.

Product Add, Qty/BOGO (quantity/BOGO), and Adjustment

References the product add product, the quantity or BOGO factor, and the product add adjustment of the product add for this merchandising activity and promotion. The system uses the Product Add, Quantity/BOGO Factor, and Product Add Adjustment fields for the price formula defined on the Customer-Specific Promo - Merchandising Activities page for this information.

Cnsmptn Unit Value (consumption unit value)

References the unit value for the consumption merchandising activity and promotion. The system uses the Unit Value field defined on the Customer-Specific Promo - Merchandising Activities page for this information.

See Also

Defining Promotions