Item Level Pricebreaks allow you specify information about special pricing provided to you from your vendors. These typically come in two forms - a "Flat Deal", or "Volume Discount" (aka Matrix Pricing).
You can access the screen to configure pricebreaks by going to Admin --> System Configuration --> Item Level Pricebreaks.
Pricebreaks are used by the Place Orders screen to optimize your buying quantities. For more information on how StockIQ analyzes the pricebreaks to decide what to use, see the Pricebreak Analysis topic.
Do not use this for future cost increases. For that, use the Supplier Cost Changes feature.
Supplier List
Once in the screen, you are shown a list of suppliers. The number of price breaks associated with the supplier is shown in the "Pricebreaks" column. Click on a supplier to load pricebreaks for that supplier, or, select a supplier and click the "+ New" Button to make a new one.
NOTE: If you have price break information in your ERP system, it can be loaded in via data feeds automatically if you wish - please contact StockIQ Support.
Pricebreaks List
Clicking on a supplier will show the list of pricebreaks loaded for that supplier. Column details are as follows. See the "Settings" section below for more discussion on the different possible values of each and their meanings.
- Item Code - The part number for which the discount applies. Note that pricebreaks are item-specific, not item-site specific.
- Type - The type of pricebreak, volume discount or flat deal.
- Discount Measure - Shows what is the measure that is in play for this discount
- Discount Type - What kind of discount is offered from base price
- Note - Any notes associated with the pricebreak
- Date Effective - When the pricebreak window starts
- Date Expires - When the pricebreak is no longer valid
Settings
This section is where you enter the settings for your selected (or new) pricebreak.
Enter the values below:
-
Type - What category of pricebreak is this new record. Choose between:
- Flat Deal - This means the pricebreak is simply a new/temporary price you can take advantage of, usually for a limited time. There is no scale of discount based on how much you buy.
- Volume Discount - Also known sometimes as "matrix pricing", this means that there is a table of discounts to provide, e.g. as quantity goes up, your price gets better. StockIQ will try to optimize the purchase quantity by comparing savings on the purchase versus holding cost for that additional quantity.
- Item - What is the item that has special pricing?
-
Discount Type - How is the discount expressed. Choose from:
- Percent - Discount is expressed as a percent off of normal vendor price.
- Cost - the discount is provided to StockIQ as a new cost quantity (StockIQ does not have to calculate the resulting new cost)
- Discount - The discount is expressed as a simple amount off of the normal price
- BOGO - The discount is of a Buy X Get Y free, e.g. Buy one get one
-
Discount Measure - What is the discount measured on? This applies for volume-based discounts, e.g. do you get the discount buy buying enough:
- Units
- Cost (before discount)
- Net Cost (after discount)
- Weight
- Cubes
- Pallets
- Equivalency Units - e.g. gallons of product etc.
- Max Number of Buys - the maximum number of times you are allowed to use this pricebreak, according to your supplier
- Max Buy Quantity - The maximum quantity you are allowed to buy on this pricebreak, according to your supplier. Often specified on flat "for a limited time only!" type deals.
- Amount - Specify the amount of the discount, e.g. the percent discount, the new price, or the discount quantity. (Flat deals only -- see below for Matrix style discounts)
- Date Effective - When this pricebreak comes available.
- Date Expires - When the pricebreak is no longer valid.
- Number of Times Used - Tracked by StockIQ, this is how many times you have used the pricebreak.
- Quantity Bought - Tracked by StockIQ, this is how much you have bought referencing this pricebreak.
- Supplier Quote Number - If provided, this is a supplier quote number that will be added to the external line notes for the item on the PO to reference the supplier quote for making sure the discount is valid/applied.
When you are done entering data, click "Save" and this item level pricebreak entry is saved. StockIQ will immediately begin checking for this pricebreak when recommending order quantities in the Place Orders screen.
Matrix Lines
If you have a "Volume Discount" (e.g. Matrix) style pricebreak, the matrix lines grid will be shown, so you can enter the different discount levels.
click the "+" at the right side of the matrix to add each matrix amount. The headers will match the entries StockIQ is expecting, such as the discount measure (e.g. Cubes), and the discount type (e.g. Percent)