BeyondERP.Newsletter
Menu

Page · Transportation management

Rate route workbench

A workbench page where you find rates and routes for a shipment and match loads to routes, either manually or automatically, by using route guides.

Business process
Manage freight and transportation
Menu item
TMSRateRouteWorkbench
Main table
TMSRouteSegmentTable
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA workbench page where you find rates and routes for a shipment and match loads to routes, either manually or automatically, by using route guides.
What you do hereUse this page to rate shop across shipping carriers and to find a route and rate for a shipment, based on its origin, destination, weight, volume and other shipment data.
ExampleFor example, you can use it to identify the fastest route or the least expensive rate for a shipment.
Rate route workbench page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage freight and transportation
Menu pathTransportation management › Planning › Rate route workbench
Related pagesRoute guides Microsoft Learn Load building workbench Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

How to use it

  1. Go to Transportation management > Planning > Rate route workbench.
  2. On the Criteria FastTab, under FROM and TO, select the Address type and ID, or enter the name and address of the origin and the destination.
  3. Under DATA, enter the Weight, Volume and Value, and, as needed, the LTL class, Delivery terms, STCC code, Equipment, Requested ship date and time and Requested delivery date and time.
  4. Under WAREHOUSE and ACCOUNTS, select the Site, Warehouse, Customer or Vendor and the related Invoice account.
  5. Under RATE SHOP DATA, limit the search to a Shipping carrier, Carrier service, Carrier group or Mode if needed.
  6. On the Action Pane, select Rate, Rate shop, Route, Route with rate or Scheduled route.

Source: Checked in Dynamics 365

Test checklist

  1. Open a load with Loading strategy set to Full load shipping only and open the Rate route workbench from the Loads grid.
  2. Select Rate and check that the cheapest carrier is returned.
  3. Select Rate shop and check that every carrier with a valid rating profile is listed with rate and total transit time.
  4. Select a result and Assign it, then check carrier, service and rate on the load.
  5. Confirm the load and check that a freight bill is generated with the assigned rate.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Assigning a rate and route only updates the load while it is open. When the load is confirmed, a freight bill is generated with those rates and the costs are apportioned to the source orders as miscellaneous charges, so a wrong rate is then fixed through freight reconciliation, not here. Microsoft Learn
Technical architect

5Technical

Menu itemTMSRateRouteWorkbench Checked in Dynamics 365
FormTMSRateRouteWorkbench Checked in Dynamics 365
TableTMSRouteSegmentTableShown as “ROUTE SEGMENT” in Record infoChecked in Dynamics 365
Roles to set it up and use itTo set it up or change itTransportation coordinator TMSTransportationCoordinatorTo use itLogistics manager TMSLogisticsManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Rate, Rate shop, Route, Route with rate, Scheduled routeChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=TMSRateRouteWorkbench
Table definitionTMSRouteSegmentTable columns and relations Microsoft data model
Everyone

7Sources