Bracket Pricing Module
User Guide
Background / Problem Statement
Many businesses price sales orders based on the total weight
or total quantity of the entire order, rather than pricing each item
independently.
Standard pricing in Business Central evaluates pricing at the line level.
However, certain pricing models require:
- Pricing based on total net weight
- Pricing based on total gross weight
- Pricing based on total quantity (units)
- Automatic adjustment of pricing once the full order total is known
Because the total weight or quantity cannot be determined until the entire
order is entered, pricing cannot reliably be calculated at the time each line
is created.
This module introduces Bracket Pricing, which evaluates pricing at the sales
order header level upon release.
Solution Overview
Customer Price Group Enhancements
Two new fields are added to the Customer Price Group:
- Bracket Price (Boolean): Identifies the price group as using bracket pricing
- Bracket Based On (Option): Determines calculation method
Bracket Based On Options:
1. Total Net Weight
2. Total Gross Weight
3. Total Qty
If Bracket Price = TRUE, bracket pricing logic is applied.
- Bracket Minimum
- Bracket Maximum
4. Sales Order Behavior
During Order Entry
- System identifies if customer belongs to a Bracket Price
Group
- Pricing defaults to the base price list
- Price list does NOT automatically change during entry
- Pricing remains stable until order release
Upon Sales Order Release
When the Sales Order is released:
1. System calculates Total Net Weight, Total Gross Weight, or Total Quantity
2. Based on the Price Group’s Bracket Based On selection:
- System evaluates totals
- Finds matching bracket range
- Applies the appropriate price list
- Updates sales line pricing
5. Sales Order Totals Enhancement
The following fields are added to the Sales Order Totals
Section:
- Total Net Weight
- Total Gross Weight
- Total Units
These totals update dynamically and flow to the Posted Sales Invoice.
Pricing Flow Example
Customer assigned to Price Group 'FOOD-BRKT'
Price Lists:
- PR 1: Min Qty 0 → $20.00
- PR 2: Min Qty 10 → $18.00
During Entry:
Order line entered for 5 units → Price = $20.00
After Adding Lines:
Total Qty = 12
On Release:
Total Qty ≥ 10 → Price updated to $18.00
Result
- Sales orders are priced correctly based on total weight or
quantity
- Pricing reflects full order context
- Manual price overrides are reduced
- Pricing logic becomes consistent and automated
Business Impact
- Supports weight-based and volume-based commercial pricing
models
- Improves pricing accuracy
- Reduces pricing disputes
- Enhances automation
- Aligns Business Central with real-world wholesale pricing practices