Pricing Upload Processed Records Report

Purpose: Use this report to review the Pricing Upload records that processed successfully during the Pricing Upload Process.

• You can review new and changed Special Pricing by Source Upload records that processed successfully on the Work with Special Source Price Screen in the Working with Source Codes (WSRC) menu option.

• You can review new and changed Quantity Price Matrix Pricing Upload records that processed successfully on the Work with Quantity Price Matrix Details Screen and Work with Quantity Price Matrix Specials Screen in the Working with Quantity Price Matrix (WQPM) menu option.

For more information: See the sample report in PDF format.

How to print: Submit the Pricing Upload Process by selecting Process on the Work with Pricing Upload Screen.

You can also schedule the Pricing Upload process to run periodically by setting up the RIPRCUP periodic function using the PFRRIPRCUP program. See Scheduling Jobs for background.

This report page breaks on Record Type.

For each record type, records sort in ascending Request type, Sequence # sequence.

Contents:

• Record type: Identifies the type of Pricing Upload record.

- QPM = Quantity Price Matrix Detail Upload record; this record creates, updates, or deletes a record in the QPM Detail table.

- SRC = Special Pricing by Source Upload record; this record creates, updates, or deletes a record in the Special Pricing by Source table.

• Request type: Indicates whether the Pricing Upload record creates, updates, or deletes a record in the Special Pricing by Source table or QPM Detail table. Valid values:

- U = Create or update a record. The system determines whether the Pricing Upload record creates or updates an existing record by comparing the information in the Pricing Upload record with the existing records in the Order Management System table. See Uploading Special Pricing by Source Records and Uploading Quantity Price Matrix Detail Records for more information on how the system determines if the Pricing Upload record creates a new record or updates an existing record.

- D = Delete a record. The system uses the information in the Pricing Upload record to determine which record in the Special Pricing by Source table or QPM Detail table to delete.

• Sequence #: The unique sequence number assigned to the Pricing Upload record.

• Record date: The date the Pricing Upload record was created.

For QPM Record Types:

• Item: The item associated with the quantity price matrix detail.

• SKU: A code for the SKU of the item associated with the quantity price matrix detail.

• QPM Code: The quantity price matrix code associated with the QPM Detail price.

• Item category: A code for the item category associated with the quantity price matrix detail.

• Quantity: The quantity of the item that must be ordered to qualify for the quantity price matrix detail. The item qualifies for the quantity price matrix detail if the order line quantity is less than or equal to the quantity pice matrix detail.

• Price: The price at which the item will be sold if the pricing requirements are met.

• Customer price group: The customer price group for the sold to customer on the order header in order to qualify for the QPM price.

• Customer sold to #: The sold to customer that must exist on the order header in order to qualify for the QPM price.

• Source code: The source code that must exist on the order header in order to qualify for the QPM price.

• Discount %: The percentage off the quantity price matrix detail price when the item ordered is eligible for the quantity price matrix special. For example, 10 means the item qualifies for a 10% discount.

• Expire date: The date the QPM price expires.

• Number of processed records for record QPM: The number of QPM Detail Upload records that have processed successfully.

For SRC Record Types:

• Item: The item associated with the special source price.

• Source code: The source code associated with the Special Pricing by Source record.

• Quantity: The quantity of the item that must be purchased to receive the specified price break.

• Price: The price at which the item will be sold if the pricing requirements are met.

• Associate price: The price at which the item will be sold to associate customers if the pricing requirements are met.

• Number of processed records for record SRC: The number of Special Pricing by Source Upload records that processed successfully.

• Total # of records processed: The total number of Pricing Upload records, across record types, that processed successfully.