Calculate bracket threshold by weight and quantity
When the Threshold Type field value is set to Weight and Quantity, and the Source Type field value is set to Cust. Price Group on the Bracket Thresholds page, the system evaluates whether both the quantity and the calculated weight on the sales document fall within the defined threshold ranges.
- The quantity 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 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 | 40 | 25 |
| Code 2 | Cust. Price Group | Bracket 02 | 40 | 20 | 20 | 10 |
| Code 3 | Cust. Price Group | Bracket 03 | 600 | 350 | 30 | 21 |
| Code 4 | Cust. Price Group | Bracket 04 | 200 | 60 | 15 | 3 |
Weight Calculation = Quantity × Gross Weight
Scenario 1:
If the Quantity field value is set to 6 and the Gross Weight field value is 10, the calculated weight is: 6 × 10 = 60.
Both the quantity and the calculated weight fall 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 30 and the Gross Weight field value is 15, the calculated weight is: 30 × 15 = 450.
Both the quantity and the calculated weight 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 either the quantity or the weight value falls outside all defined ranges. The system displays a notification.