Setting up a rate table > Quantity-based options that affect how table rates are applied
Quantity-based options that affect how table rates are applied
By default, when the system applies a rate from a table that is defined by a quantity (such as pieces), it applies the exact quantity recorded on the trip. For example, if 630 pieces were delivered, the system would create a single pay detail for 630 pieces.
However, you can use the Rating Options field and the Option Applies To field on the rate’s header to set up an alternate calculation method for quantity-based table rates.
Three rating options are available in the Rating Options field:
None (default)
The system will apply the quantity exactly as it was recorded for the trip.
Note: You must use this option for mileage-based rates.
Use Next (use range Qty)
When the trip’s quantity falls between the quantities recorded for two rows/columns, the system will round up the pay detail’s quantity to the amount recorded in the next row/column.
Incremental
The system will treat the quantity recorded in each row/column as a tier. If the trip’s quantity spans multiple tiers, the system will create a separate pay detail (with a separate rate) for each tier.
When you select an option other than None in the Rating Option field, you must select either Rows or Columns in the Option Applies To field. This determines whether the Rating Option selection applies to the table’s rows or columns.
Note: The Rating Option and Option Applies To fields display only when an option is selected in the Rows and/or the Col's field.
When no selection is made in the Rows or the Col's fields, the Rate field is displayed instead.