Collapse AllExpand All

11.3.1. Pricing Schedule

A single Pricing Schedule may contain multiple Items or Product Categories—and multiple Quantity Breaks. To create a new Pricing Schedule, select the NEW button. The following screen will appear:

Create New Pricing Schedule

Tip

When Sales Orders are entered, the system will search for Quantity Break matches between the Sales Order Item and the relevant Pricing Schedule. If duplicate Quantity Breaks are found, the lowest Price for the given quantity will be used.

When creating a new Pricing Schedule, you are presented with the following options:

Name

Enter the name of the Pricing Schedule.

Description

Enter a description to identify the Pricing Schedule.

Effective

Enter the date when the Pricing Schedule becomes effective.

Note

The effectivity and expiration dates for Pricing Schedules correspond to the created date for Sales Orders. Changes to Line Item quantities or scheduled dates for already-created Sales Orders can also cause Pricing Schedule effectivity to be recalculated as of the date the changes occur.

Expires

Enter the date when the Pricing Schedule expires.

Schedule

Display lists all sold Items or Product Categories assigned to this Pricing Schedule.

Currency

Select the currency.

Note

This field is only enabled when multiple currencies are used.

Calculate Net Price using Site

Select the Site to be used for calculating Net Price when Average Cost is used as the markup basis.

Note

Pricing schedules are not updated by Site. The Site indicated here is only used for calculating the Net Price.

11.3.1.1. Pricing Schedule Item

To create a new Pricing Schedule Item, select the NEW button. The following screen will appear:

Pricing Schedule for Item

When creating a new Pricing Schedule Item, you are presented with the following options:

Type

Specify which type of Pricing Schedule Item you want to create: Nominal, Discount, or Freight. The screen will present different options depending on which type option you select.

Select the "Nominal" option for simple quantity break pricing by Item. When the "Nominal" option is selected, you will be presented with the following choices:

Item Number

Enter the Item Number of the Item you want to add to the Pricing Schedule. The lookup feature located to the right of the field leads to a searchable sold Items list. Multiple sold Items may be assigned to a single Pricing Schedule.

UOM

Inventory Unit of Measure.

Qty. Break

Enter the lowest quantity of the specified Item that must be purchased to receive the specified Price. The Quantity Break is measured in the Inventory Unit of Measure. Multiple Quantity Breaks may be assigned to a single Item.

Price

Enter the Price the specified Item may be purchased for if the specified Quantity Break is met. The Price is measured in the Price Unit of Measure.

List Price

Displays the List Price for the specified Item.

Qty. UOM

Specify the Unit of Measure you want to use for the Quantity Break. By default, the Inventory UOM will appear here. However, if you have Selling UOMs defined for the specified Item, you may also select one of these. Selling UOMs are defined on the Item master.

Tip

When using a Selling UOM for the Quantity Break, you may not select an alternate Price UOM. The reason for this is that selling UOMs use the same UOM for both quantity and pricing.

Price UOM

Specify the Price Unit of Measure to be used with the specified Quantity Break UOM. If you select a Selling UOM for the Qty. UOM, you will not be able to select a Price UOM. For Selling UOMs, the Selling UOM and the Price UOM are the same.

Price/Inv. Ratio

Displays the ratio between the Price and Inventory Units of Measure for the specified Item.

Cost (Pricing UOM)

Displays Standard Cost and Actual Cost for the specified Item.

Margin

The margin is determined by the following formula: Price - Cost / Price.

If the specified Item is a configured Item, then the "Characteristics" tab will be available. Characteristics for configured Items can carry their own List Prices. These Characteristic Prices may be added to the Base Price when configured Items are sold. To define Characteristic pricing for configured Items, select the "Characteristics" tab. The following screen will appear:

Configured Item Pricing

When defining Characteristic pricing for configured Items, you are presented with the following options:

Characteristic

List displays all the Characteristic Prices which have been associated with the Pricing Schedule Item.

To add a new Characteristic pricing Item, select the NEW button. The following screen will appear:

Characteristic Pricing

When adding a new Characteristic pricing Item, you are presented with the following options:

Characteristic

Select a Characteristic from the list of Item Characteristics defined for the specified Item.

Value

Select a Value from the list of Values defined for the specified Item Characteristic.

Price

Enter a new Price for the Characteristic and Value combination. This alternate Price will be used in place of the standard Characteristic List Price when the Pricing Schedule is used.

List Price

Displays the default List Price for the Item Characteristic. The List Price for Characteristics is added to the Base Price of Sales Order Items when the Characteristic is specified at Sales Order entry time. Pricing Schedules are designed to override standard List Prices.

Select the "Discount" option for fixed amount or percentage based discount pricing by Item or Product Category. For discounts by Item, select the "Item" option. The following screen will appear:

Item Discounts

When discounting by Item, you will be presented with the following options:

Item Number

Specify the Item you want to add to the Pricing Schedule.

Qty. Break (Inventory UOM)

Enter the lowest quantity that must be purchased to receive the specified Discount.

Discount Percent (List Price)

Enter the Discount percentage off List Price to be used when the specified Quantity Break is reached.

Discount By Fixed Amount

Enter the fixed amount you want to be discounted off the List Price. If a Discount percentage is also used, the fixed amount will be subtracted after the Discount percentage. However, the Price can never go below zero.

For discounts by Product Category, select the "Product Category" option. The following screen will appear:

Product Category Discounts

When discounting by Product Category, you will be presented with the following options:

Product Category

Specify the Product Category you want to add to the Pricing Schedule. All Items in the Product Category will be subject to the specified Quantity Break and Discount. Multiple Product Categories may be assigned to a single Pricing Schedule.

Qty. Break (Inventory UOM)

Enter the lowest quantity that must be purchased to receive the specified Discount. The Quantity Break applies to all Items in the specified Product Category. Multiple Quantity Breaks may be assigned to a single Product Category.

Discount Percent (List Price)

Enter the Discount percentage off List Price to be used when the specified Quantity Break is reached. The List Prices for all Items in the Product Category will be reduced by the specified percentage.

Discount By Fixed Amount

Enter the fixed amount you want to be discounted off the List Price. If a Discount percentage is also used, the fixed amount will be subtracted after the Discount percentage. However, the Price can never go below zero.

Select the "Markup" option to calculate the Price as a markup on the Wholesale Price.

Markup

When the "Markup" option is selected, you will be presented with the following choices:

Markup By
Item

Select this option if the Markup depends on the Item that is selected. You will be prompted for the Item Number.

Item Number

Enter the Item Number this Pricing Schedule Item will be applied to.

Product Category

Select this option if the Markup depends on the Product Category that is selected. You will be prompted for the Product Category.

Product Category

Enter the Product Category this Pricing Schedule Item will be applied to.

Qty. Break (Inventory UOM)

Enter the lowest quantity that must be purchased for the specified Markup to be applied.

Markup Percent (Inventory Cost)

Enter the Markup Percent that needs to be added to the Inventory Cost.

Markup By Fixed Amount

Enter the Fixed Amount the Inventory Cost will be increased by.

Note

The Inventory Cost will be increased with the sum of the Markup Percent and the Fixed Amount.

Select the "Freight" option to create Price breaks for Freight. When the "Freight" option is selected, you will be presented with the following choices:

Freight

When creating Price breaks for Freight, you are presented with the following options:

Qty. Break

Enter the quantity (measured in pounds) required to earn the Price break. This option applies only when the "Price per LB" option is selected. Flat rate Freight schedules do not use quantity breaks.

Price

Enter the Price you want to charge.

Flat Rate

Select if the Pricing Schedule Item is a flat rate. If selected, you will not need to enter a quantity break—only the flat rate Price amount.

Price per LB

Select if the Pricing Schedule Item uses a quantity break to earn the Price break. If selected, you must enter the number of pounds required to earn the Price break in the "Qty. Break" field.

From

Specify which sold from Sites the Pricing Schedule Item applies to:

All Sites

Select if the Pricing Schedule Item applies to all sold from Sites.

Selected

Specify the sold from Site you want the Pricing Schedule Item to apply to.

To

Specify which Shipping Zones the Pricing Schedule Item applies to:

All Shipping Zones

Select if the Pricing Schedule Item applies to all Shipping Zones.

Selected

Specify the Shipping Zones you want the Pricing Schedule Item to apply to.

All Ship Vias

Select if the Pricing Schedule Item applies to all Ship Vias.

Selected

Specify the Ship Vias you want the Pricing Schedule Item to apply to.

All Freight Classes

Select if the Pricing Schedule Item applies to all Freight Classes.

Selected

Specify the Freight Classes you want the Pricing Schedule Item to apply to.