Calculate bracket threshold by weight or quantity
When the Threshold Type field value is set to Weight or Quantity, and the Source Type field value is set to Cust. Price Group on the Bracket Thresholds page, the system evaluates either the quantity or the calculated weight on the sales document falls within the defined threshold ranges.
- The quantity value is inherited from the Quantity field value on the sales document.
- The weight is calculated as a product of the quantity and gross weight.
- The gross weight is inherited from the Gross Weight field value on the Item Card page.
For example, consider the following configuration:
| Bracket Pricing Group Code | Source Type | Source No. | Maximum Weight | Minimum Weight | Maximum Quantity | Minimum Quantity |
|---|---|---|---|---|---|---|
| Code 1 | Cust. Price Group | Bracket 01 | 300 | 200 | 100 | 50 |
| Code 2 | Cust. Price Group | Bracket 02 | 80 | 40 | 30 | 15 |
| Code 3 | Cust. Price Group | Bracket 03 | 500 | 300 | 50 | 25 |
| Code 4 | Cust. Price Group | Bracket 04 | 1500 | 60 | 20 | 5 |
Weight Calculation = Quantity × Gross Weight
Scenario 1:
If the Quantity field value is set to 10, which does not match any defined quantity range, and the Gross Weight field value is 7, the calculated weight is: 10 × 7 = 70.
The calculated weight value falls within the range of Bracket 02 and Bracket 04.
The system compares the Minimum Weight field values of the qualifying brackets and selects the one with the highest minimum weight.
In this case, Bracket 04 is selected, and its source type is updated in the source document. So the system updates the Customer Price Group field value with Code 4.
Scenario 2:
If the Quantity field value is set to 60 and the Gross Weight field value is 28, the calculated weight is: 60 × 28 = 1680.
Both the quantity and the calculated weight values fall within the range of Bracket 01 and Bracket 03.
The system compares the Minimum Weight field values of the qualifying brackets and selects the one with the highest minimum weight.
In this case, Bracket 03 is selected, and its source type is updated in the source document. So the system updates the Customer Price Group field value with Code 3.
The record is not accepted if neither the quantity nor the weight value falls within any of the defined ranges. The system displays a notification.