Work with Price Codes Screen

Purpose: Use this screen to create and work with price codes used to define price breaks you offer for orders of a group of items.

How to display this screen: Enter WPCD in the Fast path field at the top of any menu or select Work with Price Codes from a menu.

.

Field

Description

Price code

This code defines a repricing method you offer to your customers when they order a sufficient quantity of items associated with this price code.

Enter a price code and select OK to display price codes in numeric order, beginning with your entry.

Numeric, 7 positions; Optional

Description

A description of the price code.

Enter a full or partial description and select OK to display price codes that contain your entry.

Alphanumeric, 30 positions; Required.

Seq (Sequence number)

This number controls the order in which the system evaluates pricing for an item; if two or more price codes would apply, the system uses the price code with the lowest sequence number.

Numeric, 7 positions; display-only.

Discount

The type of discount:

Price Code Special Price Discount: Displays as Sp: followed by the Special price. For orders subject to VAT, displays as Tax incl price: followed by the Tax inclusive price for special price.The discount is a special price for the qualifying items associated with the price code.

Price Code Dollar Off Discount: Displays as $: followed by the Dollar discount. The discount is a dollar amount to subtract from the regular item price for the qualifying items associated with the price code.

Price Code Percent Off Discount: Displays as %: followed by the Percent discount. The discount is a percentage to subtract from the regular item price for the qualifying items associated with the price code.

Price Code Group Price Discount: Displays as Grp: followed by the Group price. For orders subject to VAT, displays as Grp tax incl: followed by the Tax inclusive price for group price. The discount is a group price for the qualifying items associated with the price code.

Numeric, 7 positions with a 2-place decimal; display-only.

Start Date

The beginning date when the price code discount becomes effective. The system compares this date to the date on the Order Header to determine whether the order qualifies for the price code discount.

Numeric, 6 positions (in user date format); display-only.

End Date

The end date when the pice code discount becomes effective. The system compares this date to the date on the Order Header to determine whether the order qualifies for the price code discount.

Numeric, 6 positions (in user date format); display-only.

Screen Option

Procedure

Create a price code

Select Create to advance to the Create Price Code Screen.

Change a price code

Select Change for a price code to advance to the Change Price Code screen. You can change any information on this screen except the Price code field. For field descriptions, see Create Price Code Screen.

Delete a price code

Select Delete for a price code to delete it. When you delete a price code, the system deletes any associated records in the Price Code Customer table.

Display a price code

Select Display for a price code to advance to the Display Price Code screen. You cannot change any fields on this screen. For field descriptions, see Create Price Code Screen.

Define the customer price group or sold to customer number eligible for the price code discount

Select Customer for a price code to advance to the Work with Qualifying Customer/Price Groups Screen.

Create, update, and delete records in the Price Code, Price Code Customer, and Price Code Details tables from an external system

Select Upload. See Price Code Upload for processing details.

Create Price Code Screen

Purpose: Use this screen to create a price code.

How to display this screen: Select Create at the Work with Price Codes Screen.

.

Field

Description

Price code

This code defines a repricing method to apply in Order Entry when the customer orders a sufficient quantity of qualifying items.

Numeric, 7 positions.

Create screen: required.

Change screen: display-only.

Description

A description of the price code.

Alphanumeric, 30 positions; required.

Start date

The beginning date when the price code discount becomes effective.

Numeric, 6 positions (in user date format); optional.

End date

The end date when the pice code discount becomes effective.

Numeric, 6 positions (in user date format); optional.

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; required.

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.

Optional.

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.

This field must be selected if you define a Distinct By setting or Group price.

One of the following repricing methods is required:

Special price

Dollar discount

Percent discount

Group price

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; required if dollar discount percent discount, or group price not entered.

Tax inclusive price for special price

The special price to charge the customer for all qualifying items associated with the price code on orders subject to VAT. Displayed 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; optional.

Dollar discount

The dollar amount to subtract from the regular price of 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, 7 positions with a 2-place decimal; required if special price, percent discount, or group price not entered.

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; required if special price, dollar discount, or group price not entered.

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; required if special price, dollar discount, or percent discount not entered.

Tax inclusive price for group price

The group price to charge the customer for all qualifying items associated with the price code on orders subject to VAT. Displayed 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; optional.

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; required.

Note: The system will not prevent you from defining a repricing method that would change the item price into a credit (that is, a discount of more than 100% the item price).

Work with Qualifying Customer/Price Groups Screen

Purpose: Use this screen to define the customer price groups and sold to customers that qualify for the price code discount.

Important: If you do not define any sold to customers or customer price groups for a price code, then ALL sold to customers and customer price groups qualify for the price code.

How to display this screen: Select Customer for a price code at the Work with Price Codes Screen.

Qualifying customers display on this screen in alphanumeric sold to customer number, price group code sequence.

Fields

Description

Price Code

The code and description of the price code.

Code: Numeric, 7 positions; display-only.

Description: Alphanumeric, 30 positions; display-only.

Group

The code for the customer price group that qualifies for the price code discount.

Customer price group codes are defined in and validated against the Customer Price Group table.

Alphanumeric, 4 positions; Required if a customer is not defined.

Customer

The sold to customer number that qualifies for the price code discount.

Sold to customer numbers are defined in and validated against the Customer Sold To table.

Numeric, 9 positions; Required if a customer price group is not defined.

Name

The description of the customer price group code or the name of the sold to customer.

• If a company is not defined for the customer, the last name followed by the first name displays; for example: MIRANDA, BERNADETTE.

• If a company is defined for the customer, the company name followed by the last name and first name displays; for example: MILL VILLAGE ATTN:NONNIE, NO.

The system truncates the name to 30 positions.

Alphanumeric, 30 positions; display-only.

Screen Option

Procedure

Define a qualifying customer price group

Enter a valid customer price group code and select OK. The qualifying customer price group displays in the bottom half of the screen.

Define a qualifying sold to customer

Enter a valid sold to customer number and select OK. The qualifying sold to customer number display in the bottom half of the screen.

Delete a qualifying customer price group or sold to customer

Select Delete for a qualifying customer price group or sold to customer to delete it.

WPCD OMSCS 19.0 December 2019 OHC