Rates are used to calculate the actual freight cost on a completed consignment. Once calculated the freight charge can be used for invoicing or reporting purposes, such as running an accruals report, or reconciling a supplier invoice. A rate card specifies the details on how the cost is to be calculated for each customer, carrier, route and product combination.
When loaded into eCargo a rate is assigned to the specified customer and carrier. The customer may be one of your own sites, or one of your logistics customers.
Rates are imported into eCargo using a specific file format. Go to the Import rates section for a detailed description.
Rate card selection logic
When a consignment is dispatched the rate card is selected based on the criteria below. If a rate card is found the freight charge is subsequently calculated based on the consignment quantities.
|Selection criterion||Rate matching rules|
|Effective from date (including)||
date/time must include movement date
|Effective to date (including)||date/time must include movement date|
|Rate card type||must be exact match|
|Charge type||must be exact match|
|Customer (aka consignment owner)||must be exact match|
|Sold to||exact match or not specified|
|Carrier||carrier, charge supplier, rates owner, or not specified (left-most preferred)|
|From zone||exact match preferred, otherwise next cascaded zone|
|To zone||exact match preferred, otherwise next cascaded zone|
|Order line rate product||mapped from order line product by strength, or not specified (least preferred)|
|Rate product||mapped from rate product by strength|
Rating zones are determined based on the mapping rules setup in the Zone mapping page.
Prime Contractor and sub contractor rates logic
eCargo will initially search for the rates for the sub contractor. If it finds any it will then look for and use the rate cards for that sub contractor. If no rates were found for the sub contractor it will then search for any tables for the primary carrier originally assigned to the consignment.