Stock Detail Structured Prices Tab
Table Of Contents
) see Overview
The Stock | Detail | Structured Prices screen provides a read-only view of all structured pricing configured for the selected stock item or the Level 2 Stock Type it belongs to.Structured pricing can be configured for:- Individual customers
- Groups of customers through Price Lists
This screen helps you understand how pricing has been configured and which pricing rules may apply when the item is sold.The screen contains two sub-tabs:- Stock Prices – displays structured pricing configured for individual stock items.
- Stock Type Prices – displays structured pricing configured for the stock item's Level 2 Stock Type.
The Stock | Detail | Structured Prices screen provides a read-only view of all structured pricing configured for the selected stock item or the Level 2 Stock Type it belongs to.
Structured pricing can be configured for:
- Individual customers
- Groups of customers through Price Lists
This screen helps you understand how pricing has been configured and which pricing rules may apply when the item is sold.
The screen contains two sub-tabs:
- Stock Prices – displays structured pricing configured for individual stock items.
- Stock Type Prices – displays structured pricing configured for the stock item's Level 2 Stock Type.
Stock Prices
The Stock Prices sub-tab contains two grids:
Grid Description Company Prices Displays structured pricing configured in Promotions | Price Lists | Stock Item / Customer. Price Lists Displays pricing configured in Promotions | Price Lists | Stock Item / Price List.
The Stock Prices sub-tab contains two grids:
| Grid | Description |
|---|---|
| Company Prices | Displays structured pricing configured in Promotions | Price Lists | Stock Item / Customer. |
| Price Lists | Displays pricing configured in Promotions | Price Lists | Stock Item / Price List. |
Company Prices Grid
This grid shows customer-specific pricing configured for the stock item.
This grid shows customer-specific pricing configured for the stock item.
URN
The unique customer reference linked to the structured pricing.
The unique customer reference linked to the structured pricing.
Company Name
The name of the customer receiving the structured pricing.
The name of the customer receiving the structured pricing.
Quantity Break Bands
Structured pricing can be applied based on quantity ordered.
Field Description Low The minimum quantity required for the pricing rule to apply. High The maximum quantity that the pricing rule applies to.
Structured pricing can be applied based on quantity ordered.
| Field | Description |
|---|---|
| Low | The minimum quantity required for the pricing rule to apply. |
| High | The maximum quantity that the pricing rule applies to. |
Discount
Structured pricing can be calculated using either a fixed amount or a percentage discount.
Structured pricing can be calculated using either a fixed amount or a percentage discount.
Amount
A fixed selling price for the stock item when the pricing rule is triggered.Note: The value displayed may be Net or VAT-inclusive, depending on how the pricing has been configured in [ Promotions | Price Lists | Stock Item / Customer ].
A fixed selling price for the stock item when the pricing rule is triggered.
Note: The value displayed may be Net or VAT-inclusive, depending on how the pricing has been configured in[ Promotions | Price Lists | Stock Item / Customer ].
%
The percentage discount applied when the structured pricing rule is triggered.
The percentage discount applied when the structured pricing rule is triggered.
Mark-Up %
Creates a selling price by adding a percentage mark-up to the item's buy price.
Creates a selling price by adding a percentage mark-up to the item's buy price.
Price Lists Grid
This grid shows pricing configured through Price Lists.
This grid shows pricing configured through Price Lists.
Price List
The Price List associated with the stock item.
The Price List associated with the stock item.
Price
The selling price that will be used when the selected Price List applies.Note: The value displayed may be Net or Gross depending on the Price List configuration.
For more information, see Promotions | Price Lists | Stock Item / Price List.
The selling price that will be used when the selected Price List applies.
Note: The value displayed may be Net or Gross depending on the Price List configuration.
For more information, see Promotions | Price Lists | Stock Item / Price List.
Quantity Breaks
Pricing can vary based on quantity ordered.
Field Description Low The minimum quantity required for the pricing rule to apply. High The maximum quantity that the pricing rule applies to.
Pricing can vary based on quantity ordered.
| Field | Description |
|---|---|
| Low | The minimum quantity required for the pricing rule to apply. |
| High | The maximum quantity that the pricing rule applies to. |
Amount
A manually defined value used as the basis for pricing calculations.If an amount has been entered, it overrides the List Price when discounts or mark-ups are calculated.
A manually defined value used as the basis for pricing calculations.
If an amount has been entered, it overrides the List Price when discounts or mark-ups are calculated.
Disc %
The percentage discount applied to the List Price or Amount.The resulting value is displayed in the Price column.
The percentage discount applied to the List Price or Amount.
The resulting value is displayed in the Price column.
List Price
The standard selling price of the stock item.The value displayed may be Net or Gross depending on the settings configured in:
The standard selling price of the stock item.
The value displayed may be Net or Gross depending on the settings configured in:
Base Pricing
Mark-Up %
Calculates the selling price by applying a percentage mark-up to the buy price.
Calculates the selling price by applying a percentage mark-up to the buy price.
Buy Price
The current buy price held against the stock item.This value is automatically updated when stock is purchased and can be viewed in:
The current buy price held against the stock item.
This value is automatically updated when stock is purchased and can be viewed in:
Massaged Pricing
Massaged pricing allows you to use an alternative buy price for pricing calculations.
Massaged pricing allows you to use an alternative buy price for pricing calculations.
Mark-Up %
Shows the calculated mark-up percentage based on the actual stock buy price and the final calculated selling price.Important: If a Massaged Buy Price is used, the system still calculates the displayed Mark-Up % using the actual current stock buy price.
Shows the calculated mark-up percentage based on the actual stock buy price and the final calculated selling price.
Important: If a Massaged Buy Price is used, the system still calculates the displayed Mark-Up % using the actual current stock buy price.
Buy Price
An alternative buy price used instead of the stock item's actual buy price when calculating selling prices.This can be useful when additional costs need to be included in pricing calculations.
An alternative buy price used instead of the stock item's actual buy price when calculating selling prices.
This can be useful when additional costs need to be included in pricing calculations.
Currency
Displays the currency restriction applied to the Price List.This corresponds to the Limit by Currency setting in the Price List configuration.
Displays the currency restriction applied to the Price List.
This corresponds to the Limit by Currency setting in the Price List configuration.
Is Net
Indicates whether the Price List displays Net prices.If enabled, prices are shown excluding VAT.
Indicates whether the Price List displays Net prices.
If enabled, prices are shown excluding VAT.
Why Use a Massaged Buy Price?
Two common reasons for using a Massaged Buy Price are:
Two common reasons for using a Massaged Buy Price are:
Include Additional Costs
Additional costs can be factored into pricing calculations, such as:- Landed costs
- Delivery charges
- Import duties
- Customs fees
- Agent commissions
Additional costs can be factored into pricing calculations, such as:
- Landed costs
- Delivery charges
- Import duties
- Customs fees
- Agent commissions
Maintain Consistent Selling Prices
A Massaged Buy Price can help keep selling prices consistent throughout the life of a Price List, regardless of changes to the actual stock buy price.Important: Massaged Buy Prices are not updated automatically. They must be maintained manually.
A Massaged Buy Price can help keep selling prices consistent throughout the life of a Price List, regardless of changes to the actual stock buy price.
Important: Massaged Buy Prices are not updated automatically. They must be maintained manually.
Stock Type Prices
The Stock Type Prices sub-tab displays pricing configured against the stock item's Level 2 Stock Type.Like the Stock Prices tab, it contains two grids:
Grid Description Company Prices Displays pricing configured in Promotions | Price Lists | Stock Type / Customer. Price Lists Displays pricing configured in Promotions | Price Lists | Stock Type / Price List.
The Stock Type Prices sub-tab displays pricing configured against the stock item's Level 2 Stock Type.
Like the Stock Prices tab, it contains two grids:
| Grid | Description |
|---|---|
| Company Prices | Displays pricing configured in Promotions | Price Lists | Stock Type / Customer. |
| Price Lists | Displays pricing configured in Promotions | Price Lists | Stock Type / Price List. |
Company Prices Grid
Displays customer-specific pricing applied at Stock Type level.
Displays customer-specific pricing applied at Stock Type level.
Company Code
The unique customer reference linked to the pricing rule.
The unique customer reference linked to the pricing rule.
Company Name
The company receiving the structured pricing.
The company receiving the structured pricing.
Low
The minimum quantity required for the pricing rule to apply.
The minimum quantity required for the pricing rule to apply.
High
The maximum quantity covered by the pricing rule.
The maximum quantity covered by the pricing rule.
Amount
A fixed selling price applied when the pricing rule is triggered.Note: The value displayed may be Net or VAT-inclusive depending on the Price List configuration.
A fixed selling price applied when the pricing rule is triggered.
Note: The value displayed may be Net or VAT-inclusive depending on the Price List configuration.
Discount %
The percentage discount applied when the pricing rule is triggered.
The percentage discount applied when the pricing rule is triggered.
Mark-Up %
Calculates a selling price based on the stock item's buy price.
Calculates a selling price based on the stock item's buy price.
Price Lists Grid
Displays Price List pricing configured at Stock Type level.
Displays Price List pricing configured at Stock Type level.
Price List
The Price List associated with the Stock Type.
The Price List associated with the Stock Type.
Quantity Breaks
Field Description Low The minimum quantity required for the pricing rule to apply. High The maximum quantity covered by the pricing rule.
| Field | Description |
|---|---|
| Low | The minimum quantity required for the pricing rule to apply. |
| High | The maximum quantity covered by the pricing rule. |
Amount
The fixed price that will be charged.
The fixed price that will be charged.
Discount %
The percentage discount applied when the pricing rule is triggered.
The percentage discount applied when the pricing rule is triggered.
Mark-Up %
The mark-up percentage calculated from the stock buy price.Important: The Amount, Discount %, and Mark-Up % methods operate independently and are not intended to be used together when calculating the same price.
The mark-up percentage calculated from the stock buy price.
Important: The Amount, Discount %, and Mark-Up % methods operate independently and are not intended to be used together when calculating the same price.
Additional Information
- This screen is read-only and cannot be used to create or amend pricing.
- It provides visibility of all structured pricing that may affect the selected stock item.
- Pricing may come from either stock item pricing rules or stock type pricing rules.
- Quantity breaks can be used to offer different prices based on order volume.
- Customer-specific pricing takes precedence where configured.
- Review both tabs when investigating unexpected pricing on sales orders.
- This screen is read-only and cannot be used to create or amend pricing.
- It provides visibility of all structured pricing that may affect the selected stock item.
- Pricing may come from either stock item pricing rules or stock type pricing rules.
- Quantity breaks can be used to offer different prices based on order volume.
- Customer-specific pricing takes precedence where configured.
- Review both tabs when investigating unexpected pricing on sales orders.