Work with Pricing Upload (WPUP)
Purpose: Use this menu option to review, correct, and process records in the Pricing Upload Table.
Records in the Pricing Upload table:
- Create, update, or delete records in the Special Pricing by Source table. See Uploading Special Pricing by Source Records
- Create, update, or delete records in the QPM Detail table. See Uploading Quantity Price Matrix Detail Records.
In this topic:
- Work with Pricing Upload Screen
- Change Pricing Upload Screen
- Pricing Upload Error Records Report
- Pricing Upload Processed Records Report
For more information: See Pricing Upload Process for an overview.
Work with Pricing Upload Screen
How to display this screen: Enter WPUP in the Fast path field on a menu screen or select Work with Pricing Upload from a menu.
The system displays Pricing Upload records on this screen is descending date sequence.
Field | Description |
---|---|
Date |
The date the Pricing Upload record was created. Enter a valid date and select OK to display Pricing Upload records in descending date sequence, starting with the date you enter. Numeric, 6 positions (in user date format); optional. |
Type |
The type of Pricing Upload record. Valid values are:
Select a type and select OK to display Pricing Upload records that match the type you selected. Alphanumeric, optional. |
Action |
Indicates whether the Pricing Upload record creates, updates, or deletes a record in the Special Pricing by Source or QPM Detail table. Valid values:
Select an action and select OK to display Pricing Upload records that match the action you selected. Alphanumeric, optional. |
Status |
The status of the Pricing Upload record. Valid values:
Select a status and select OK to display Pricing Upload records that match the status you selected. Alphanumeric, optional. |
Error |
A description of the error. Enter a full or partial error and select OK to display Pricing Upload records whose error description contains your entry. Alphanumeric, 30 positions; optional. |
Screen Option | Procedure |
---|---|
Change a Pricing Upload record |
Select Change for a Pricing Upload record to advance to the Change Pricing Upload Screen. |
Review a Pricing Upload record |
Select Display for a Pricing Upload record to advance to the Display Pricing Upload screen. You cannot change any fields on this screen. See the Change Pricing Upload Screen for field descriptions. |
Delete a Pricing Upload record |
Select Delete for a Pricing Upload record to delete it. |
Submit the Pricing Upload process |
Select Process. See Pricing Upload Process for processing details. |
Print the Pricing Upload Error Records report |
Select Error Report. See Pricing Upload Error Records Report for details. |
Change Pricing Upload Screen
Purpose: Use this screen to review and update a Pricing Upload record.
The fields that display on this screen depend on the Record Type defined for the Pricing Upload record: SRC (Special Pricing by Source upload record) or QPM (QPM Detail upload record).
When you select OK on this screen, the system validates the fields on the screen and displays an error message if an error exists. See Pricing Upload Interface Errors for a list of errors.
How to display this screen: Select Change for a Pricing Upload record on the Work with Pricing Upload Screen.
Field | Description |
---|---|
Type |
The type of Pricing Upload record. Valid values are:
Alphanumeric, 3 positions; display-only. |
Status |
The status of the Pricing Upload record. Valid values:
Alphanumeric, display-only. |
Action |
Indicates whether the Pricing Upload record creates, updates, or deletes a record in the Special Pricing by Source or QPM Detail table. Valid values:
Alphanumeric, display-only. |
Error |
A description of the error. See Pricing Upload Interface Errors for a list of errors. Alphanumeric, 30 positions; display-only. |
Seq # |
A unique sequence number assigned to the Pricing Upload record. Numeric, 9 positions; display-only. |
Date |
The date the Pricing Upload record was created. Numeric, 6 positions (in user date format); display-only. |
Item |
The item defined for the Pricing Upload record. Item codes are defined in and validated against the Item table. Special Pricing by SourceThe item associated with the special source price. Corresponds to the ITM Number field in the Special Pricing by Source table. QPM DetailA code for the item associated with the quantity price matrix detail. You must define an item category or item for a quantity price matrix price, but not both. Corresponds to the Item field in the QPM Detail table. Alphanumeric, 12 positions; required for SRC record type. |
SKU |
Displays for QPM Pricing Upload records only. A code for the SKU of the item associated with the quantity price matrix detail. SKU codes are defined in and validated against the SKU table.
Corresponds to the SKU field in the QPM Detail table. Alphanumeric, 14 positions; optional. |
Quantity |
Special Pricing by Source The quantity of the item that must be purchased to receive the specified price break. Corresponds to the Qty field in the Special Pricing by Source table. QPM DetailThe 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. You cannot create more than one quantity price matrix price break for the same item category and quantity, item and quantity, or item and SKU and quantity. Corresponds to the Quantity field in the QPM Detail table. Numeric, 5 positions; required. |
Source |
The source code associated with the pricing upload record. Source codes are defined in and validated against the Source Code table. Special Pricing by SourceThe source code associated with the Special Pricing by Source record. Corresponds to the Source Code field in the Special Pricing by Source table. QPM DetailThe source code that must exist on the order header in order to qualify for the QPM price. Corresponds to the Source field in the QPM Detail table. Alphanumeric, 9 positions; required for Record Type SRC. |
Price |
The price at which the item will be sold if the pricing requirements are met. Special Pricing by SourceCorresponds to the Price field in the Special Pricing by Source table. Note: For Special Pricing by Source records, the price cannot be greater than 7 positions with a 2 place decimal.Corresponds to the Price field in the QPM Detail table. Numeric, 13 positions with a 2 place decimal; required for Record Type SRC. |
Tax Inclusive Price |
The price at which the item will be sold to customers if the order is subject to VAT and if the pricing requirements are met. Note: This field displays only if the Tax Included in Price (E70) system control value is selected.Special Pricing by Source Corresponds to the Tax Price field in the Special Pricing by Source table. Note: For Special Pricing by Source records, the tax price cannot be greater than 7 positions with a 2 place decimal.Corresponds to the Tax Price field in the QPM Detail table. Numeric, 13 positions with a 2 place decimal; optional. |
Associate Price |
Displays for SRC Pricing Upload records only. The price at which the item will be sold to associate customers if the pricing requirements are met. Corresponds to the Associate Price field in the Special Pricing by Source table. Note: The associate price cannot be greater than 7 positions with a 2 place decimal.Numeric, 13 positions with a 2 place decimal; optional. |
Tax Inclusive Associate Price |
Displays for SRC Pricing Upload records only. Note: This field displays only if the Tax Included in Price (E70) system control value is selected.The price at which the item will be sold to associate customers if the order is subject to VAT and if the pricing requirements are met. Corresponds to the Associate Tax Price field in the Special Pricing by Source table. Note: For Special Pricing by Source records, the associate tax price cannot be greater than 7 positions with a 2 place decimal.Numeric, 13 positions with a 2 place decimal; optional. |
QPM Code |
Displays for QPM Pricing Upload records only. The quantity price matrix code associated with the QPM Detail price. QPM codes are defined in and validated against the QPM Header table. Corresponds to the Code field in the QPM Detail table. Alphanumeric, 4 positions; required for Record Type QPM. |
Item Category |
Displays for QPM Pricing Upload records only. A code for the item category associated with the quantity price matrix detail. You must define an item category or item for a quantity price matrix price, but not both. Item category codes are defined in and validated against the Item Category table. Corresponds to the Item Category field in the QPM Detail table. Alphanumeric, 4 positions; optional. |
Customer Sold To # |
Displays for QPM Pricing Upload records only. The sold to customer that must exist on the order in order to qualify for the QPM price. Customer sold to numbers are defined in and validated against the Customer Sold To table. Corresponds to the Customer field in the QPM Detail table. Numeric, 9 positions; optional. |
Customer Price Group |
Displays for QPM Pricing Upload records only. The customer price group for the sold to customer on the order header in order to qualify for the QPM price. Customer price group codes are defined in and validated against the Customer Price Group table. Corresponds to the Price Group field in the QPM Detail table. Alphanumeric, 4 positions; optional. |
Expire date |
Displays for QPM Pricing Upload records only. The date the quantity price matrix price expires. The date cannot be earlier than the current date. Corresponds to the Exp Date field in the QPM Detail table. Numeric, 6 positions (in user date format); optional. |
Discount % |
Displays for QPM Pricing Upload records only. The percentage of 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. Corresponds to the Discount % field in the QPM Detail table. Example: The % discount is based on the following criteria:
In this example, the 10% discount is a 1.00 discount (10.00 QPM detail - 10% QPM special = 9.00 discount price) If a quantity price matrix detail is not defined for item category HG and quantity 2, the system uses the next lowest quantity for the item category (in this example, the system uses item category HG and quantity 1). See Calculating the QPM Price for more information on how the system finds the price for a quantity price matrix detail and quantity price matrix special. Numeric, 4 positions with a 2 place decimal; optional. |