Display Price Code Assignments (DPCA)
Price codes allow you to define a price discount for items/SKUs in a specified offer or source code when you order a specified quantity. The price code can offer a dollar or percentage off the price of the item, a special price for the item, or a group price for a defined group of items. The system applies price code pricing to an order during repricing and end-of-order pricing.
1. Use Working with Price Codes (WPCD) to create a price code and to define the requirements that must be met for an item to be eligible for the price code. In addition, the Price Code Upload Table (PriceCdUpload) allows you to upload price code information from an external system. Use the Upload option on the Work with Price Codes Screen to perform the Price Code Upload Process. This process creates, updates, and deletes records in the Price Code, Price Code Customer, and Price Code Details tables. See Price Code Upload for more information.
2. Use Assigning Price Codes (APCD) to assign items/SKUs to a price code by offer or source code.
3. Use Display Price Code Assignments (DPCA) to review the items/SKUs assigned to a price code by offer or source code and the requirements that must be met for an order to be eligible for the price code. Note: You must use the Work with Qualifying Customer/Price Groups Screen in Working with Price Codes (WPCD) to review the customer price groups and sold to customers that qualify for the price code discount.
For more information: See:
• Types of Price Code Discounting for an overview on the types of price code discounting you can offer.
• Price Code Setup for more information on how to set up a price code pricing method.
• Regular Price Code Pricing for an overview of price code pricing when the Price Codes (D93) system control value is selected.
• Customer Price Group Price Code Pricing for an overview on price code pricing when the Customer Price Group Code for CPG Pricing Only (L58) system control value contains a customer price group code.
Display Price Code Assignments Screen
Purpose: Use this screen to review the items/SKUs assigned to a price code by either offer or source code and the requirements that must be met for an order to be eligible for the price code.
How to display this screen: Enter DPCA in the Fast path field at the top of any menu or select Display Price Code Assignment from a menu.
Column sort: You can sort on any column on this screen by clicking on the column name. An arrow pointing up displays next to the field when the values for the field display in ascending sequence; an arrow pointing down displays next to the field when the values for the field display in descending sequence.
Price codes first display on this screen in ascending alphanumeric price code, item/SKU sequence.
Field |
Description |
Price Code |
The price code that defines a repricing method you offer to your customers when they order a sufficient quantity of items associated with this price code. Price codes are defined in and validated against the Price Code table. Search: Enter a valid price code to display price codes that starts with your entry. Numeric, 7 positions; optional. |
Description |
A description of the price code. Alphanumeric, 30 positions; display-only. |
Item |
A code representing an item assigned to the price code. Item codes are defined in and validated against the Item table. Search: Enter a valid item code to display price codes that match your entry. Alphanumeric, 12 positions; optional. |
SKU |
The SKU of an item assigned to the price code. SKU codes are defined in and validated against the SKU table. Search: Enter a valid SKU code to display price codes that contains your entry. Alphanumeric, 14 positions; optional. |
Offer |
An offer code assigned to the price code. The price code defined for an item/offer combination applies to orders whose header-level source code points to the offer. Offers are defined in and validated against the Offer table. See Working with Offers (WOFR). Search: Enter a valid offer code to display price codes that match your entry. Alphanumeric, 3 positions; optional. |
Source |
A source code assigned to the price code. The price code defined for an item/source code combination applies to orders with this source code on the order header. Source codes are defined in and validated against the Source Code table. See Working with Source Codes (WSRC). Search: Enter a valid source code to display price codes that match your entry. Alphanumeric, 9 positions; optional. |
Screen Option |
Procedure |
Review the details of a price code |
In the Action field, select Display for a price code assignment to advance to the Display Price Code Window. |
Review the qualifying customers and/or price groups for a price code |
In the Action field, select Qual CPG to advance to the Display Qualifying Customer/Price Groups Screen. |
Purpose: Use this window to review the details of a price code.
How to display this screen: Select Display for a price code assignment on the Display Price Code Assignments Screen.
Field |
Description |
Price Code |
The price code that defines a repricing method you offer to your customers when they order a sufficient quantity of items associated with this price code. Price codes are defined in and validated against the Price Code table. Numeric, 7 positions; display-only. |
Description |
The description of the price code. Alphanumeric, 30 positions; display-only. |
Start Date |
The beginning date when the price code discount becomes effective. Numeric, 6 positions (in user date format); display-only. |
End Date |
The end date when the pice code discount becomes effective. Numeric, 6 positions (in user date format); display-only. |
Qty Required |
The total quantity the customer must order of all qualifying items to get the price break. Note: The system evaluates minimum price code quantity by ship-to address. Numeric, 7 positions; display-only. |
Distinct By |
The method the system uses to determine whether the customer ordered the quantity required to receive the group price. Valid values: • Item = The quantity required is by item. • SKU = The quantity required is by SKU. • Category = The quantity required is by item category. Display-only. |
Special Price |
The special price to charge the customer for all qualifying items associated with the price code. Numeric, 7 positions with a 2-place decimal; display-only. |
Tax Inclusive (Special) Price |
The special price to charge the customer for all qualifying items associated with the price code on orders subject to VAT. This field displays only if the Tax Included in Price (E70) system control value is selected. Note: If an order is subject to VAT, but the item is subject to a price code with a only a special price and not a Tax-inclusive price, the system uses the special price for the price code. Numeric, 7 positions with a 2-place decimal; display-only. |
Dollar Discount |
The dollar amount to subtract from the regular price of each qualifying item associated with the price code. I the Tax Included in Price (E70) system control value is selected, the system applies the discount against the regular tax-inclusive price to calculate the tax-inclusive price code price. Numeric, 7 positions with a 2-place decimal; display-only. |
Percent Discount |
The percentage of the regular item price to subtract for each qualifying item associated with the price code. If the Tax Included in Price (E70) system control value is selected, the system applies the discount against the regular tax-inclusive price to calculate the tax-inclusive price code price. Numeric, 5 positions with a 2-place decimal; display-only. |
Group Price |
The group price to charge the customer for all qualifying items associated with the price code. Numeric, 7 positions with a 2-place decimal; display-only. |
Tax Inclusive (Group) Price |
The group price to charge the customer for all qualifying items associated with the price code on orders subject to VAT. This field displays only if the Tax Included in Price (E70) system control value is selected. Note: If an order is subject to VAT, but the item is subject to a price code with a only a special price and not a Tax-inclusive price, the system uses the special price for the price code. Numeric, 7 positions with a 2-place decimal; display-only. |
Allow Multiples |
Defines whether the order qualifies for a discount multiple times if the correct number of qualifying items/SKUs is added to the order. • Selected = Allow multiples. • Unselected = Do not allow multiples. Display-only. |
Sequence |
The order in which the system evaluates whether a price code applies to an order. Regular Price Code Pricing: If an order qualifies for two or more price codes, the system uses the price code with the lowest sequence number. If two price codes have the same sequence number, the system uses the price code with the lowest price code number. Customer Price Group Price Code Pricing: If an order qualifies for two or more price codes, the system uses the price code that provides the greatest discount to the order. If two price codes provide the same discount, the system uses the price code with the lowest sequence number. If two price codes have the same sequence number, the system uses the price code with the lowest price code number. Numeric, 7 positions; display-only. |
Display Qualifying Customer/Price Groups Screen
Purpose: Use this screen to review the customers and/or price groups that qualify for the price code.
How to display this screen: Select Qual CPG for a price code assignment at the Display Price Code Assignments Screen.
Column sort: You can sort on any column on this screen by clicking on the column name. An arrow pointing up displays next to the field when the values for the field display in ascending sequence; an arrow pointing down displays next to the field when the values for the field display in descending sequence.
Qualifying customers and customer price groups first display on this screen in ascending sold to customer number, then ascending customer price group code sequence.
Field |
Description |
Price Code |
The price code that defines a repricing method you offer to your customers when they order a sufficient quantity of items associated with this price code. Price codes are defined in and validated against the Price Code table. Numeric, 7 positions; display-only. |
Description unlabeled field to the right of Price Code |
A description of the price code. Alphanumeric, 30 positions; display-only. |
Group |
The code for the customer price group that qualifies for the price code. Customer price groups are defined in and validated against the Customer Price Group table. Search: Enter a full or partial customer price group code to display customer price groups that begin with your entry. Alphanumeric, 4 positions; display-only. |
Customer |
The sold to customer number of a customer that qualifies for the price code. Sold to customers are defined in and validated against the Customer Sold To table. Search: Enter a full or partial sold to customer number to display sold to customers that begin with your entry. Numeric, 9 positions; display-only. |
| Price Code Upload Errors Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Working with Price Tables (WPTB) |
DPCA OMS 17.1 September 2018 OTN