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:
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:
Enter the name of the Pricing Schedule.
Enter a description to identify the Pricing Schedule.
Enter the date when the Pricing Schedule becomes effective.
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.
Enter the date when the Pricing Schedule expires.
Display lists all sold Items or Product Categories assigned to this Pricing Schedule.
Select the currency.
This field is only enabled when multiple currencies are used.
Select the Site to be used for calculating Net Price when Average Cost is used as the markup basis.
Pricing schedules are not updated by Site. The Site indicated here is only used for calculating the Net Price.
To create a new Pricing Schedule Item, select the NEW button. The following screen will appear:
When creating a new Pricing Schedule Item, you are presented with the following options:
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:
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.
Inventory Unit of Measure.
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.
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.
Displays the List Price for the specified Item.
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.
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.
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.
Displays the ratio between the Price and Inventory Units of Measure for the specified Item.
Displays Standard Cost and Actual Cost for the specified Item.
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:
When defining Characteristic pricing for configured Items, you are presented with the following options:
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:
When adding a new Characteristic pricing Item, you are presented with the following options:
Select a Characteristic from the list of Item Characteristics defined for the specified Item.
Select a Value from the list of Values defined for the specified Item Characteristic.
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.
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:
When discounting by Item, you will be presented with the following options:
Specify the Item you want to add to the Pricing Schedule.
Enter the lowest quantity that must be purchased to receive the specified Discount.
Enter the Discount percentage off List Price to be used when the specified Quantity Break is reached.
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:
When discounting by Product Category, you will be presented with the following options:
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.
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.
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.
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.
When the "Markup" option is selected, you will be presented with the following choices:
Select this option if the Markup depends on the Item that is selected. You will be prompted for the Item Number.
Enter the Item Number this Pricing Schedule Item will be applied to.
Select this option if the Markup depends on the Product Category that is selected. You will be prompted for the Product Category.
Enter the Product Category this Pricing Schedule Item will be applied to.
Enter the lowest quantity that must be purchased for the specified Markup to be applied.
Enter the Markup Percent that needs to be added to the Inventory Cost.
Enter the Fixed Amount the Inventory Cost will be increased by.
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:
When creating Price breaks for Freight, you are presented with the following options:
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.
Enter the Price you want to charge.
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.
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.
Specify which sold from Sites the Pricing Schedule Item applies to:
Select if the Pricing Schedule Item applies to all sold from Sites.
Specify the sold from Site you want the Pricing Schedule Item to apply to.
Specify which Shipping Zones the Pricing Schedule Item applies to:
Select if the Pricing Schedule Item applies to all Shipping Zones.
Specify the Shipping Zones you want the Pricing Schedule Item to apply to.
Select if the Pricing Schedule Item applies to all Ship Vias.
Specify the Ship Vias you want the Pricing Schedule Item to apply to.
Select if the Pricing Schedule Item applies to all Freight Classes.
Specify the Freight Classes you want the Pricing Schedule Item to apply to.