Calculate bracket threshold by weight
When the Threshold Type field value is set to Weight, and the Source Type field value is set to Cust. Price Group on the Bracket Thresholds page, the system evaluates the Quantity field value on the sales document against the Maximum Weight and Minimum Weight field values defined on the Bracket Thresholds page.
- The quantity on the sales document 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 |
|---|---|---|---|---|
| Code 1 | Cust. Price Group | Bracket 01 | 300 | 200 |
| Code 2 | Cust. Price Group | Bracket 02 | 40 | 20 |
| Code 3 | Cust. Price Group | Bracket 03 | 600 | 350 |
| Code 4 | Cust. Price Group | Bracket 04 | 200 | 110 |
Weight Calculation = Quantity × Gross Weight
Scenario 1:
If the Quantity field value is set to 12 and the Gross Weight field value is 10, the calculated weight is: 12 × 10 = 120.
The calculated value falls within the range of Bracket 04 (between 110 and 200).
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 30 and the Gross Weight field value is 20, the calculated weight is: 30 × 20 = 600.
The weight falls 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.
For example: The system updates the Customer Price Group field value with Code 3.
The record is not accepted if the weight value falls outside all defined ranges. The system displays a notification.