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 1,000 pieces were delivered, the system would create a single invoice detail for 1,000 pieces.
However, you can use the Rating Option 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 applies 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 invoice detail’s quantity to the amount recorded in the next row/column.
Incremental Rating
The system treats the quantity recorded in each row/column as a tier. If the trip’s quantity spans multiple tiers, the system creates a separate invoice 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 you select an option 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.