Freight Item Override - Next qty = this qty divide by setting

Freight Item Override - Next qty = this qty divide by setting

Use case:
This feature allows users to customize how freight rates are calculated based on quantity. By enabling the Next qty = this qty divide by settings, pricing can shift from consolidated kilo rates to pallet rate, effectively overriding the quantity-based rate calculation.

The system recalculates the rate based on pallet units instead of kilos, allowing for more accurate freight cost allocation, especially useful for bulk shipments where pallet-based pricing is more appropriate.



Set up requirements:
To configure this override, follow these steps:
Override > Jump to Alternate Step 2
  1. Alternate Freight Item = Pallet (General)
  2. Next qty = this qty divide by = sample 25.00 (this value should be provided by the customer, as it depends on how many units can fit on their pallet based on freight content)
  3. Rounding after above calculation = Always Round Down
Data Filter
To ensure the override applies only when appropriate, configure the following filters:
  1. AverageWeightSingleItemRow >= '200' 
  2. WeightSingleLineItemRow >= '200' 
Note: these weight thresholds should be based on customer-provided data to ensure accurate override rule configuration

Example Scenario:

Total Weight of Consignment: 250 kg
Override Setting: Next qty = this qty divide by 25.00
Original Rate Basis: Per kilo
New Rate Basis: Per pallet
  1. Since the total weight exceeds 200kg, the system automatically switches from kilo rates to pallet rates
  2. Instead of charging based on the full quantity (e.g., 50 units), the system recalculates the quantity as Next qty = 50/25 = 2 pallets
  3. The rate now display charges based on 2 pallet units, overriding the original 50-unit quantity and kilo based rates
Related KB article: Freight Item Overrides