Rate Entry Detail

The Rate Entry Detail Lightning Web Component (LWC) is found on the Rate Entry Lightning Record Page.

From TMS Admin, click the Rate Entries link and then the New Rate Entry button to open the LWC. It is also in the Shipper/Consignee Transportation Profiles on the Rate Entries related lists and in the Lanes Lightning record page’s Rate Entries related list by clicking the New button.

This LWC allows users to create stored/negotiated rates for use in the TMS. When matching the appropriate criteria, these stored rate entries populate in Customer and Carrier Quotes for a Load. Many rate entries can populate a single quote.

For bulk importing Rate Entries, see Stored Rate Support.

Rate Entry Fields

There are several required fields to create a Rate Entry. Set the value for each of the following fields:

• Transportation Profile

• Mode

• Lane

• Category (Customer or Carrier)

• Rate Type

• Match Priority (set by the Lane, default is 999)

• Currency ISO Code (default is USD - U.S. Dollar)

• Status

• Rate Method

• Rate (dependent on the Rate Method selected)

The Transportation Profile field on the Rate Entry matches to the Customer on the Load. Set a default Rate Entry for all customers with the Global Default Transportation Profile set in TMS Admin → Configuration.

Note: The value for the Match Priority field is set by the Lane field but can be overridden on the Rate Entry record.

The LWC includes other optional fields in the General Information section. Set these values for the following fields as necessary:

• Contract Id

• Effective Date: Determines when the Rate Entry takes effect.

  • Stored rates and quoting integrations, except for Project44, set the Effective Date field to today’s date.

• Expiration Date: Determines when the Rate Entry expires.

• Lane Match Option: Select whether the Lane match is Interstate Only or Intrastate Only.

• Fleet Loads Only: Only match on Fleet loads.

• Pricing Notes

Depending on the value set for the Rate Type field, additional fields are added to the LWC.

The table below describes the additional fields based on the value of the Rate Type.

Enter the Rate Entry information as required.

Transportation Service Information

When the Category field is Customer, the Category field does not add any additional fields in the Transportation Service Information section.

When the Category field is Carrier, the required Carrier Service field populates in the Transportation Service Information section. The Carrier Service’s Mode must match the Mode selected for the Rate Entry. In the lookup field, search for the appropriate Carrier Service this Rate Entry applies to.

When Rate Type is either Freight+Fuel+Accessorial, Freight+Fuel, or Freight, and Category is Carrier, these additional fields appear in this section:

• Service Level

• Priority

• Auto-Tender

• Direct/Interline

• Estimated Transit Time (Days)

Warning: Do not create Rate Entries where the Rate Type is either Freight, Fuel, or Freight+Fuel with Carrier Services where the Service Type is Vendor.

Carrier Service Note: If the Rate Type doesn’t have a value and the Carrier Service uses an API integration (such as Project44, Banyan, and SMC3), then the Rate Type automatically defaults to a value and presents the additional fields previously mentioned.

If necessary, include a Service Level for the specified Carrier Service.

The Priority field sets the preference for the carrier on the Rate Entry for the selected Lane.

Priority Field Note: Adding additional values to the Priority picklist beyond those packaged with the TMS (1, 2, and 3) requires further setup. The Rate Entry Priority field picklist values must match the Carrier Quote Priority field picklist values. Configure both picklists in Setup → Object Manager.

Base Rate Calculation

The Base Rate Calculation section determines the pricing for the Rate Entry.

Select a Rate Method from the picklist. Depending on the selection, relevant fields populate the page to refine pricing information further.

API

An API Rate Method requires no fields.

Note: LTL Customer Rate Entries that request quotes via the SMC3 API require tariff information.

Email and Manual

Email and Manual Rate Method selections require no fields.

Fixed Amount

The Fixed Amount Rate Method requires the Rate field.

Per Mile/Per Kilometer

Selecting a Rate Method of either Per Mile or Per Kilometer includes an additional field: Distance Override. This field overrides the Load distance when quoting from stored rates. The decimal precision for the Distance Override field is three (3) figures.

Per Pound/Per Kilogram/Per CWT/Per Ton (US)/Per Cubic Foot/Per Cubic Meter/Per Gallon/Per Liter/Per Linear Foot/Per Square Foot/Per Square Meter/Per Stop/Per Day/Per Hour

Choose any of the following Rate Methods to enter a Rate for that method.

• Per Pound

• Per Kilogram

• Per CWT

• Per Ton (US)

• Per Cubic Foot

• Per Cubic Meter

• Per Gallon

• Per Liter

• Per Linear Foot

• Per Square Foot

• Per Square Meter

• Per Stop

• Per Day

• Per Hour

Per Additional Stop

The Per Additional Stop selection requires a Pickup Stop Baseline and a Delivery Stop Baseline field. Each field is used to determine the number of stops before additional charges are applied to the Load.

See the Stop Charges section for more information on this rate method and how to apply it.

Per Pound (Billable) / Per Kilogram (Billable)

The Per Pound (Billable) and Per Kilogram (Billable) Rate Method selections are based on the DIM Factor and Volume Units of the Load.

See the Billable Weight-Based Notes article for more information.

Per Handling Unit

The Per Handling Unit Rate Method selection requires the Handling Units and HU Calculation Method, and optionally the HU Max Weight and the Weight Units fields.

This rate method uses tiered logic to calculate the base rate. Create a Rate Entry Calculation with an Axis Type of Total Handling Unit Count to use the total number of handling units, and multiply it by the axis amount.

Minimum and Maximum Charge Calculation

In addition to base rates, minimum and maximum calculations set boundaries on the Rate Entry. Minimum and Maximum Charge Calculations are not required.

Freight Surcharge Note: If a minimum or maximum charge is entered on a Rate Entry, the Carrier Quote Freight Surcharge is not applied. For example, if an API Carrier Quote is returned and the minimum value included on a Rate Entry is applied, the Freight Surcharge does not render and is not included in any calculations.

Calculation Axis Setup

The Calculation Axis Setup allows for finer control over rate calculations.

Click the Axis Setup button to create axis calculations for each charge rate calculation.

Each row and column is defined by the Axis Type, Axis Units, Range Type, Range Boundary, and Row or Column Count. Add or remove rows and columns with the Add (+) and Subtract (–) buttons.

The following screenshot shows a basic Fixed Amount rate with a 3-column, 3-row calculation axis. The Axis Type calculations are the Handling Unit Height and the Weight of the Load.

The following numbers correspond to the demonstration screenshot:

1. The arrows indicate the direction (row or column) of the Axis Type.

2. The greater than or equal to (>=) and less than (<) operators determine the minimum and maximum values for that particular row.
   In this case, greater than or equal to 10 and less than 20.

3. The greater than or equal to (>=) and less than (<) operators determine the minimum and maximum values for that particular column.
   In this case, greater than or equal to 0 and less than 100.

4. Loads that match the Rate Entry’s general information and contain a line item that meets the row (2) and column (3) conditions are charged the Fixed Amount rate method of $100.

Note: If a load contains multiple line items, each line item is calculated individualy based on the Rate Entry. The rates are then added together for the total amount.

Example

Line Item 1: 65 lbs, 15 in = $100.

Line Item 2: 150 lbs, 25 in = $500.

Total quote amount based on the Rate Entry = $600.

Repeat this setup as necessary for the Minimum and Maximum Charge Calculation sections with axis calculations.

When the rate information and calculations are complete, click Save to save the Rate Entry. Once saved, the Clone, Clone & Reverse Lane, and Delete action buttons become available in the banner.

Create Rate Entry records more efficiently with these actions.

Accessorial Rate Entries

Create Rate Entries with a Rate Type of Accessorial to match on Loads where additional Accessorial Charges are necessary. Use accessorial-stored rated entries to supplement quoting integrations that do not support accessorial charges (like SMC3 RateWare).

Matched Freight or Freight+Fuel rate entries are linked on the Freight Quote Assistant LWC with any matching Accessorial Rate Entries. However, Accessorial Rate Entries don’t need to be associated with an existing Freight Rate Entry to apply to Carrier Quotes.

Auto-Apply Note: Accessorial rate entries that are auto-applied to a Load are added as Load-type accessorial charges. See the Auto-Apply Accessorials article for more information.

Enter the appropriate Rate Entry matching information:

• Transportation Profile

• Mode

• Lane

• Category

• Rate Type (Accessorial)

• Accessorial

• Status

• Currency

Note: Stored rate entries take precedent and apply first before any Accessorial Carrier Markup. When a Carrier Quote is created and saved manually, any matching Carrier Markup Group is applied to generate the Customer Quote, even when a customer-stored rated entry is available.

Notice that no Transportation Service Information fields are available.

Provide pricing information by selecting a Rate Method and a Rate.

Stop Charges

The Stop Charge Accessorial is set in the Global Settings section of TMS Admin → Configuration and is used for stop charges. This accessorial is not explicitly added to loads as a Load Accessorial but is added to Customer and Carrier Quotes as an Accessorial Rate Entry. The default accessorial is Stop Off.

To create stop charges for a Load, set the Accessorial field to Stop Off, the Auto-Apply field to Checked, and the Rate Method field to Per Additional Stop.

Set the Pickup Stop Baseline and Delivery Stop Baseline as desired.

Rating Loads by Per Additional Stop applies the same base rate to each Stop once the baseline values are reached.

For example, if the Pickup Stop and Delivery Stop Baseline fields are each 1 and Rate is $100, then $100 is added for each additional Stop beyond one (1) Pickup and one (1) Delivery. A Load with two (2) Pickup and two (2) Delivery Stops has a $200 ($100 per additional Stop) Stop Off accessorial charge added to either the carrier or customer quotes, depending on the Category of the Rate Entry.

Matrix Calculations for Stop Charges

Configure matrix calculations for stop charges as desired.

Note: These charges are not determined by the Stop type (Pickup or Delivery) but the Stop Count. They are calculated based on the total number of Stops for the Load. For example, if Pickup Stop Baseline is 1 and Delivery Stop Baseline is 2, then the stop charges begin to apply if a Load has 3 or more Stops, regardless of the Stop type.

If a Load with two (2) Pickup and two (2) Delivery Stops matches to the matrix Accessorial Rate Entry for stop charges, the total Stop Count determines which rate to apply. In this case, the Load has 4 Stops corresponding to the $75 charge. The Pickup Stop and Delivery Stop Baseline fields account for 3 Stops. 1 Stop Off accessorial charge of $75 is applied to the quote.

If a Load has 5 Stops and matches to this Rate Entry, the Stop Off accessorial charge of $100 is applied to the quote ($50 each for the 2 Stops).

Rate Entries for API Integrations

Create Rate Entries that are affiliated with specific API integration partners when generating quotes.

The following screenshot shows a rate entry for a Banyan carrier service. This process is the same for other integrations (such as AccuFrate, Project44, SMC3, and WWEX).

Enter all required fields for new Rate Entries. Each rate entry requires the following fields:

• Transportation Profile

  • May be set for each Customer Transportation Profile for specific control.

  • Set a default rate entry for all customers with the Global Default Transportation Profile. Choose the Global Transportation Profile to use in TMS Admin → Configuration.

• Category

  • Set to Carrier for all quoting API integration rate entries.

• Mode

  • Enter the appropriate Mode.

  • The Mode automatically adjusts if an integration only supports specific Mode types. (Example: Banyan only supports LTL Loads.)

• Lane

  • Lanes are usually set as country to country (US to US, CA to US, US to CA).

  • Rate entries are required for each Lane. (CA to US and US to CA need 2 Rate Entry records)

• Rate Type

  • The Rate Type auto-adjusts based on the Carrier Service selected.

  • API integrations may only support a specific set of rate types. The Rate Type field automatically updates to a supported type based on the Carrier Service selected.

• Carrier Service

  • Select a Carrier Service.

  • The selected API Carrier Service should have the Quote Method field set to API and a value in the API Provider field.

• Rate Method

  • Set to API to get a quote using an API integration.

Click Save to create the Rate Entry record. Then, click the Clone button to clone the rate entry and change the Carrier Service for each carrier as necessary.

SMC3 Tariffs

Request LTL Tariff-based carrier and customer quotes with the SMC3 RateWare API integration. Define Tariff Schedules to include in the rating process.

Combine Tariff Schedules with the appropriate Rate Entries. Prevent a deficit rating with SMC3 RateWare by checking the Prevent Deficit Rating checkbox on the Rate Entry record.

As a shipment increases in weight, the rate per 100 pounds decreases. Each weight break generally has a weight at which the charge is lower if a higher weight break is used (alternation). Deficit weight rating is used in this case. The weight necessary to take the shipment up to the higher weight break is added. The shipper receives the benefit of the lower rate.

When the Prevent Deficit Rating checkbox is checked, the maximum weight to stop the rating alternation is set to the total load weight plus one pound. Stop Alternation allows the user to turn off a desired weight level (and higher).

Note: It is possible to set up Fuel Surcharge and Accessorial Rate Entry records for SMC3-based quotes (as only Line Haul is provided via the API).

Carrier Connect

The TMS uses the Direct/Interline field to filter Rate Entry records before sending information to the SMC3 RateWare integration.

SMC3 Note: Matching rate entries on the Origin and Destination Movement Types (Direct/Interline) requires both the SMC3 RateWare and Carrier Connect integrations enabled. Rating without Carrier Connect does not allow filtering rate entries based on the dual-value Direct/Interline field.

Rate entries must have a Rate Type of Freight to filter. See the SMC3 integration article for more information.

SMC3 EVA - Service Levels

Create Rate Entry records with a desired Service Level and tender Loads to Carriers. Create Service Level records and search for the appropriate Service Level to include it on the Rate Entry. When the Rate Entry matches a Carrier Service, the Service Level is included in the carrier quote.