Calculate bracket threshold by quantity
When the Threshold Type field value is set to Quantity on the Bracket Thresholds page, the system evaluates the Quantity field value from the sales document against the Minimum Quantity and Maximum Quantity field values defined on the Bracket Thresholds page.
For example, consider the following configuration:
| Bracket Pricing Group Code | Source Type | Source No. | Maximum Quantity | Minimum Quantity |
|---|---|---|---|---|
| Code 1 | Cust. Price Group | Bracket 01 | 100 | 70 |
| Code 2 | Cust. Price Group | Bracket 02 | 40 | 20 |
| Code 3 | Cust. Price Group | Bracket 03 | 60 | 30 |
| Code 4 | Cust. Price Group | Bracket 04 | 25 | 11 |
Scenario 1:
If the Quantity field value is set to 12 on the source document, it falls within the range of Bracket 04 (between 11 and 25).
The system updates the Customer Price Group field value with Code 4.
Scenario 2:
If the Quantity field value is set to 30 on the source document, it falls within the range of Bracket 02 and Bracket 03.
The system compares the Minimum Quantity field values of the qualifying brackets and selects the one with the highest minimum quantity.
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 the quantity value falls outside all defined ranges. The system displays a notification.