Pricing Rule

From Fishbowl

Jump to: navigation, search

Icon.Pricing Rule.png The Pricing Rule module, located in the Sales group, allows prices to be automatically adjusted for each sales order according to a variety of variables such as average cost, order quantity, customer, day, product, etc.

Contents

Module buttons
Jump to top of page

New Button.png New creates a new pricing rule.

Save Button.png Save saves any changes made to the pricing rule.

Delete Button.png Delete deletes the pricing rule. A pricing rule can also be inactivated by unchecking the Checked.png Active checkbox on the General tab

Duplicate Button.png Duplicate creates a copy of the pricing rule.

Adjust Prices Button.png Adjust Prices adjusts the prices in the product module according to a pricing rule.

Email Button.png Email opens a window to compose an email. If the module's default report is specified, the PDF report will be attached. Email can be configured on the Email tab of the Small.Company.png Company module.

Print Button.png Print sends the default module report to the printer.

How To Button.png How To opens this article in a web browser.

Refresh Button.png Refresh reloads whatever is currently open in the module.

Adjustment types and values
Jump to top of page

To create a new pricing rule, click the New Button.png New button on the module toolbar. After selecting the applicable customers and products, choose an adjustment type and a price/cost value.

Pricing rule general subtab.png
Pricing Rule Values.png

Adjustment types

Price/Cost values

The specific dollar amounts of these price/cost values can also be seen by clicking the Details tab of a saved pricing rule. Right-click the column header and select which values to display. The values will be shown for all of the products that the pricing rule applies to.

Pricing rules can also be imported.

Adjust product prices
Jump to top of page

In addition to affecting the sales price on a sales order, pricing rules can be used to adjust the actual Price field in the Small.Product.png Product module.

  1. Open the pricing rule that will be used to adjust product prices.
  2. Click the Adjust Prices Button.png Adjust Prices button located on the module toolbar and then click Next.
    Adjust prices new list prices.png
  3. Review the New Price column which shows how each product price will be affected and then click Finish.

If a pricing rule will only be used to adjust prices, it can be disabled for sales orders on the Advanced tab of the Small.Pricing Rule.png Pricing Rule module.

Precedence
Jump to top of page

Pricing rules offer a lot of flexibility with the combination of types, tiers, and module options. To understand the final price on the sales order, it is vital to understand pricing rule precedence.

Pricing rule precedence.png
  1. TYPE - Below are the pricing rules types listed from highest precedence to lowest precedence.
    1. Customer pricing rules
    2. Customer group pricing rules
    3. Fixed pricing rules
    4. Other pricing rules
  2. TIER - At each tier, the pricing rules with the highest precedence type are compared. The highest/lowest price of that type wins based on the Small.Pricing Rule.png Pricing Rule module options.
    1. Tier 1 (product price): The tier 1 price is the amount in the Price field of the product.
    2. Tier 2 (list price): The tier 2 rules are compared to the product price. The winning price (not the pricing rule) then flows down and is included in the tier 3 comparison without its rank. For example if a customer type rule wins in tier 2, a customer group rule could win in tier 3 because the customer rule comes down as a price without any rank.
    3. Tier 3 (sales price): The tier 3 rules are compared to the winning price from tier 2. The winning price will be the amount on the sales order. If the winning price is different than the list price (the tier 2 winner), the price on the sales order will be blue as described here.
  3. TREE - Pricing rules referencing nodes lower in the product tree take precedence over rules assigned to higher nodes of the tree. When two or more pricing rules are deemed valid, but each rule applies to a distinct product tree branch, rule 2 will be used to determine which rule to apply.

In the example to the right, there are five tier 3 pricing rules that are valid and the module option is set to look for the lowest price in tier 3. Because of pricing rule precedence, the customer rule with the lowest price ($90) will be applied by default, even though it is not the lowest total price. This is because customer rules have the highest precedence. The image shows the rules in order of precedence/rank. The applied pricing rule can be changed at any time by double-clicking the item on the sales order and clicking the Pricing button.

Examples
Jump to top of page

Lowest lowest diagram.png

Lowest/Lowest

In this example, both module options are set to Lowest. This allows discounts to be stacked together. Everything is marked down 10% and a VIP customer group gets an additional 20% off.

Lowest Lowest.png
  1. Tier 1 product price = $100
    Tier 2 pricing rule created to mark everything down 10%
  2. Tier 2 list price = $90 ($100 * .9)
    Tier 3 pricing rule created to give 20% off for VIPs
  3. Tier 3 sales price = $72 ($90 * .8)




Highest/Lowest
Highest lowest diagram.png

In this example, the tier 2 module option is set to Highest and the tier 3 module option is set to Lowest. An item has a manufacturing cost of $5.

Highest Lowest.png
  1. Tier 1 product price = $8
    Tier 2 pricing rule created to mark the manufacturing cost up by 100%
  2. Tier 2 list price = $10 ($5 * 2)
    Tier 3 pricing rule created to give 10% off the list price
  3. Tier 3 sales price = $9 ($10 * .9)

TABS

General tab
Jump to top of page

The General tab displays the name, description, customers, products, and adjustment types and values.

Pricing rule general subtab.png

Advanced tab
Jump to top of page

The Advanced tab displays rounding options, dates, quantities, tiers, etc.

Pricing rule advanced subtab.png

Details tab
Jump to top of page

The Details tab displays a summary of the rule.

Pricing rule details subtab.png

MODULE OPTIONS

Some aspects of the Small.Pricing Rule.png Pricing Rule module can be customized by opening the module, clicking the Tools menu, and then selecting Module Options.

General tab
Jump to top of page
Pricing Module Options.png
The tier 2 rules with the highest precedence type will be compared. This option determines if tier 2 then looks for the Highest or Lowest price.
The tier 3 rules with the highest precedence type will be compared. This option determines if tier 3 then looks for the Highest or Lowest price.
This option prevents the calculated price from going below a specified level. Options include Average Cost, Default Vendor's Cost, Last Cost, List Price, Product Price, or Standard Cost.

Personal tools
Namespaces
Variants
Actions
Navigation
Other Pages
Toolbox
Print/export
Translate