Sales Price Calculation

Prev Next

Feature Overview

Sales Price Calculation is an optional, separately activated feature in Sales Configurator that automatically derives the sales price for a configured item from the actual costs in its supply order hierarchy. Rather than relying on a fixed item price or manually entering a unit price, the system calculates the expected cost across all production order components, routing operations, overhead, and indirect costs — and applies a configurable profit percentage on top to arrive at the sales price.

This means that for make-to-order products where the final cost depends on the specific configuration (different components, special operations, varying material prices), the sales price is always based on real cost data rather than estimates. The calculation can be triggered on demand from the sales line and applies the result directly to the unit price on that line.

Profit percentages can be set at three levels: a default percentage in the global setup, item-specific or work-centre-specific overrides in the Configurator Profit Pct. table, and manual overrides directly on the sales line itself. Each level takes precedence over the one above it. The system also supports splitting the profit percentage across the three cost dimensions separately — components, routing, and the overall line — giving fine-grained control over margin management for complex multi-level products.

Important: This feature is disabled by default. It must be activated via Configurator Setup → Abakion Feature Management before the price calculation fields and actions become visible.

Feature activation Configurator Setup → Abakion Feature Management → Sales Price Calculation
Setup page Configurator Setup → Price Calculation group
Per-entity profit overrides Configurator Profit Pct. page
Calculation trigger Sales line → Configurator → Update Sales Price (Shift+Ctrl+U)
Cost fetch scope Components, routing, overhead, indirect cost
Profit % fields on sales line Profit %, Component Profit %, Routing Profit %
Cost sources Item Unit Cost, Purchase Prices, Purchase Line Unit Cost
Roll-up options Rolled Up (full hierarchy), Single Level (top-level only)

Getting Started

  1. Open Configurator Setup and click Abakion Feature Management.
  2. Find the Sales Price Calculation feature and enable it. The Price Calculation group in the setup page and the additional fields on sales lines become visible.
  3. Back in Configurator Setup, go to the Price Calculation group and set the Default Sales Price Calculation Method: choose Through Hierarchy to derive the price from the full supply order cost, or Use Current Line to base it on the sales line's existing unit cost.
  4. Set the Default Profit % to the standard margin you want applied when no item- or line-specific override exists.
  5. Configure Get Purchase Cost From: choose Always from Purchase Line Unit Cost to always use the purchase line's unit cost, or According to Costing Method to use the item's standard cost for standard-costed items and the purchase line cost for others.
  6. Configure Get Component Cost From: choose Item Unit Cost to use the item's standard cost for BOM components, or Purchase Prices to look up the best purchase price (falling back to item unit cost if none is found).
  7. Set the Cost Roll Up Principle: choose Rolled Up to sum costs across all levels of the hierarchy, or Single Level to include only the top-level order's direct costs.
  8. Optionally, open the Configurator Profit Pct. page and add item- or work-centre-specific profit percentage overrides.
  9. Create a supply order hierarchy from a configured sales line (see the Supply Order Hierarchy article).
  10. On the sales line, go to Configurator → Update Sales Price (Shift+Ctrl+U). The system calculates the cost, applies the profit percentage, and updates the unit price on the line.

Related Features

Sales Price Calculation is an extension of Supply Order Hierarchy — the calculation is performed by traversing the linked production and assembly orders to collect actual cost data. There must be an active supply order hierarchy on the sales line for the calculation to have meaningful cost data; without it, the system can only use the item's standard cost. Configuration Search is a prerequisite for the entire workflow: configuration must be completed before a supply order can be created and before a price can be calculated. The feature also interacts with the standard BC pricing engine: the calculated price is written back to the Unit Price field on the sales line, where standard BC pricing rules (customer price groups, campaigns, etc.) may further apply if triggered.


User Stories

US-01: Activate the Sales Price Calculation feature

As a IT Manager
I want to enable the Sales Price Calculation feature for our company
So that sales staff can calculate sales prices from hierarchy costs on configured sales lines

Setup:

  1. Open Configurator Setup.
  2. Click the Abakion Feature Management action.
  3. Find the Sales Price Calculation feature in the list and enable it.
  4. Close and reopen Configurator Setup. The Price Calculation group is now visible with its configuration fields.
US-02: Set the default profit percentage for all configured items

As a Business Manager
I want to define a default profit percentage that applies to all configured items unless overridden
So that sales staff do not have to manually enter a margin every time a price is calculated

Setup:

  1. Open Configurator Setup → Price Calculation.
  2. Enter the desired percentage in the Default Profit % field.
  3. Save. This percentage will be applied during price calculation on any sales line where no item- or line-specific override has been set.
US-03: Set a profit percentage override for a specific item

As a Business Manager
I want to define a different profit percentage for a specific item
So that high-value or cost-sensitive products can have their own margin without affecting the default

Setup:

  1. Open the Configurator Profit Pct. page (accessible from the search or via Configurator Setup).
  2. Add a line, set Type to Item, and enter the No. of the relevant item.
  3. Enter the desired Profit %.
  4. Optionally, set a Sales Price Calc. Method override for this item (Through Hierarchy or Use Current Line).
  5. Save. When a price calculation is run on a sales line for this item, this percentage will be used instead of the default.
US-04: Set a profit percentage override for a specific work centre

As a Production Planner
I want to define a profit percentage for routing work performed at a specific work centre
So that the margin applied to routing costs can differ from the standard component margin

Setup:

  1. Open the Configurator Profit Pct. page.
  2. Add a line, set Type to Work Center, and enter the No. of the relevant work centre.
  3. Enter the desired Profit %.
  4. Save. During price calculation, this percentage is applied to the routing cost attributed to this work centre.
US-05: Set a profit percentage override for a specific machine centre

As a Production Planner
I want to define a profit percentage for routing work performed at a specific machine centre
So that the margin for machine-intensive operations can be set independently

Setup:

  1. Open the Configurator Profit Pct. page.
  2. Add a line, set Type to Machine Center, and enter the No. of the relevant machine centre.
  3. Enter the desired Profit %.
  4. Save.
US-06: Calculate and update the sales price from the hierarchy cost

As a Sales Order Processor
I want to trigger a price calculation on a configured sales line and have the unit price updated automatically
So that the customer is quoted a price that accurately reflects the actual production cost plus our margin

Setup:

  1. On a Sales Order or Sales Quote with a configured line that has an active supply order hierarchy, select the line.
  2. Go to Configurator → Update Sales Price (Shift+Ctrl+U).
  3. The system traverses the supply order hierarchy, collects component and routing costs, applies the profit percentage, and updates the Unit Price on the sales line.
  4. A confirmation dialog may appear asking whether to update the cost and sales price — confirm to proceed.
US-07: Calculate the expected standard cost without updating the sales price

As a Sales Order Processor
I want to calculate the expected cost from the supply hierarchy and review it before deciding whether to update the sales price
So that I can verify the cost is reasonable before it affects the customer's quote

Setup:

  1. On a Sales Order line with an active supply hierarchy, go to Configurator → Get Expected Standard Cost.
  2. The system calculates and populates the cost breakdown fields on the sales line (Component Cost, Routing Cost, Overhead Rate, Indirect Cost) without modifying the Unit Price.
  3. Review the cost fields on the sales line to assess whether the calculated price is appropriate.
  4. If satisfied, follow up with Update Sales Price to apply the price.
US-08: Manually adjust the profit percentage on a specific sales line

As a Sales Order Processor
I want to override the profit percentage on a specific sales line
So that I can apply a different margin for a particular customer or deal without changing the global setup

Setup:

  1. On the Sales Order or Sales Quote subform, locate the Profit % column on the relevant sales line. (This column is visible only when Sales Price Calculation is enabled.)
  2. Enter the desired percentage directly in the Profit % field on the line.
  3. When Update Sales Price is triggered, this line-level percentage will be used instead of the item-level or default percentage.
US-09: Split profit percentage across components and routing separately

As a Sales Manager
I want to apply different profit margins to the component cost and the routing cost on a sales line
So that I can optimise pricing for products where material cost and labour cost have different competitive sensitivities

Setup:

  1. On the sales line subform, locate the Component Profit % and Routing Profit % columns. (These are visible when Sales Price Calculation is enabled.)
  2. Enter the desired percentages in each field independently.
  3. When Update Sales Price is triggered, the component cost and routing cost each use their respective profit percentages to calculate the contribution to the final sales price.
US-10: Configure how purchase costs are sourced for the calculation

As a IT Manager
I want to control whether the calculation uses the purchase line's actual unit cost or the item's standard cost
So that the price calculation reflects our preferred costing approach

Setup:

  1. Open Configurator Setup → Price Calculation.
  2. Set Get Purchase Cost From:
    • Always from Purchase Line Unit Cost — always uses the unit cost from the purchase order line.
    • According to Costing Method — uses the item's standard cost for standard-costed items; uses the purchase line unit cost for all other costing methods.
  3. Save.
US-11: Configure how BOM component costs are sourced for the calculation

As a IT Manager
I want to control whether BOM component costs come from the item's unit cost or from purchase prices
So that the price calculation is consistent with how we manage component costs

Setup:

  1. Open Configurator Setup → Price Calculation.
  2. Set Get Component Cost From:
    • Item Unit Cost — uses the item's standard or average unit cost.
    • Purchase Prices — looks up the best purchase price with a blank currency code for the component; falls back to item unit cost if no purchase price is found.
  3. Save.
US-12: Choose between rolled-up and single-level cost roll-up

As a IT Manager
I want to choose whether the cost calculation accumulates costs across all levels of the hierarchy or only at the top level
So that the pricing method matches our accounting practice for multi-level production orders

Setup:

  1. Open Configurator Setup → Price Calculation.
  2. Set Cost Roll Up Principle:
    • Rolled Up — sums costs from all levels of the supply order hierarchy (full BOM explosion).
    • Single Level — includes only the direct costs of the top-level production or assembly order.
  3. Save.
US-13: Calculate price using the current sales line cost rather than the hierarchy

As a Sales Order Processor
I want to calculate the sales price based on the unit cost already on the sales line rather than traversing the supply order hierarchy
So that I can get a quick price on lines where the supply order has not yet been created

Setup:

  1. Open Configurator Setup → Price Calculation and set Default Sales Price Calculation Method to Use Current Line.
  2. Alternatively, open the Configurator Profit Pct. page and set Sales Price Calc. Method to Use Current Line for the specific item.
  3. On the sales line, go to Configurator → Update Sales Price. The system applies the profit percentage to the existing unit cost on the line rather than calculating from the hierarchy.
US-14: Review the cost breakdown on a sales line after calculation

As a Sales Manager
I want to see the breakdown of component cost, routing cost, overhead, and indirect cost that was used to calculate the sales price
So that I can explain the price to a customer or review the margin in detail

Setup:

  1. After running Get Expected Standard Cost or Update Sales Price on a sales line, personalise or show the columns Component Cost, Routing Cost, Overhead Rate, and Indirect Cost on the sales order subform. (These columns exist on the subform but are hidden by default.)
  2. The values show the raw cost contributions used in the last price calculation for that line.

Note: These fields are read-only. They are updated each time the cost calculation is run.


Field Reference

Field Where to find it What it does Default
Default Sales Price Calculation Method Configurator Setup → Price Calculation Determines whether the price is calculated from the supply order hierarchy or from the current unit cost on the sales line Through Hierarchy
Default Profit % Configurator Setup → Price Calculation The profit percentage applied to the calculated cost when no item- or line-specific override exists
Get Purchase Cost From Configurator Setup → Price Calculation Controls whether purchase order costs come from the purchase line unit cost or from the item's standard cost (when costing method is Standard) Always from Purchase Line Unit Cost
Get Component Cost From Configurator Setup → Price Calculation Controls whether BOM component costs are taken from item unit cost or from purchase prices Item Unit Cost
Cost Roll Up Principle Configurator Setup → Price Calculation Determines whether costs are summed across all hierarchy levels (Rolled Up) or only from the top-level order (Single Level) Rolled Up
Type Configurator Profit Pct. The entity type for the override: Item, Work Center, or Machine Center
No. Configurator Profit Pct. The specific item, work centre, or machine centre the override applies to
Profit % Configurator Profit Pct. The profit percentage override for this entity
Sales Price Calc. Method Configurator Profit Pct. Overrides the calculation method for this specific entity
Profit % Sales line (subform) Line-level profit percentage override; takes precedence over item and default percentages
Component Profit % Sales line (subform) Separate profit percentage applied only to the component cost portion of the calculation
Routing Profit % Sales line (subform) Separate profit percentage applied only to the routing cost portion of the calculation
Component Cost Sales line (subform, hidden) The total component cost from the supply order hierarchy, used in the last calculation
Routing Cost Sales line (subform, hidden) The total routing cost from the supply order hierarchy, used in the last calculation
Overhead Rate Sales line (subform, hidden) The overhead rate component from the last calculation
Indirect Cost Sales line (subform, hidden) The indirect cost component from the last calculation