BeyondERP.Newsletter
Menu

Setup page · Transportation management

Rating profile

A list page that shows all rating profiles, where each profile links a shipping carrier to a rate engine, rate master, transit time engine and carrier fuel index for a period.

Used by
Logistics manager, Transportation coordinator
Business process
Manage freight and transportation
Menu item
TMSRatingProfile
Main table
TMSRatingProfile
Data entity
TMSShippingCarrierRatingProfileEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list page that shows all rating profiles, where each profile links a shipping carrier to a rate engine, rate master, transit time engine and carrier fuel index for a period.
What you do hereUse this page to review, create and edit the rating profiles that determine transportation tariffs for loads.
Rating profile 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

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.

Setup steps on this page

Set up Rating profile

Use this page to review, create and edit the rating profiles that determine transportation tariffs for loads.

Steps from Microsoft

  1. Go to Transportation management > Setup > Rating > Rating profile.
  2. On the Action Pane, select New to add a rating profile, or select Edit to edit an existing one.
  3. Enter a unique Rating profile ID and a descriptive Name.
  4. Select the Shipping carrier, Site and Warehouse.
  5. Select the Rate engine, Rate master, Transit time engine and Carrier fuel index.
  6. Enter the effective start and end date and time to define when the profile is active.
  7. On the Action Pane, select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Shipping carrierThe carrier the rating profile belongs to. The profile is also shown on the Shipping carriers page for that carrier.Microsoft Learn CarrierCode
Rate engineThe rate engine used for the rating profile.Microsoft Learn RateEngineCode
Rate masterThe rate master for the profile, which defines the rate base assignment and the rate base that determine the carrier's rate.Microsoft Learn RateMasterCode
Transit time engineThe transit time engine used for the rating profile.Microsoft Learn TransitTimeEngineCode
Carrier fuel indexThe carrier fuel index used for the rating profile.Microsoft Learn CarrierFuelIndexCode
Effective start date and timeTogether with the effective end date and time, defines the period when the rating profile is active.Microsoft Learn EffectiveUTCDateTimeFrom

Test checklist

  1. Create the profile with carrier, site, warehouse, rate engine, rate master, transit time engine and carrier fuel index.
  2. Check it also shows on the carrier's Rating profiles FastTab.
  3. Run Rate shop for a load from that warehouse and check the carrier's rate.
  4. Run Rate shop for a load from another warehouse and check this profile isn't used.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Rating profileOne rating profile per shipping carrier, site and warehouse, linking the rate engine, rate master, transit time engine and carrier fuel index for a defined effective periodThe rating profile is the logistics contract that decides the tariff for a load and is unique to a carrier.Choosing a rate master whose rating metadata doesn't match the rate engine, or leaving gaps in effective dates, so the carrier returns no rate.Test: Rating profile drives the carrier rate
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Profiles are active only for their effective dates; end-date the old one and add a new one. Freight bills of confirmed loads keep their rates. Microsoft Learn
Technical architect

6Technical

Menu itemTMSRatingProfile Checked in Dynamics 365
FormTMSRatingProfile Checked in Dynamics 365
TableTMSRatingProfileShown as “RATING PROFILE” in Record infoKey field: RatingProfileCodeChecked in Dynamics 365
Data entitiesTMSShippingCarrierRatingProfileEntityShipping carrier rating profile Microsoft data model
Who can open itPrivilegesMaintain rating profiles TMSRatingProfileMaintainView rating profiles TMSRatingProfileViewDutiesInquire into carrier master and network planning information TMSCarrierMasterInquireMaintain carrier and network planning master TMSCarrierMasterMaintain
2 security rolesLogistics manager TMSLogisticsManagerTransportation coordinator TMSTransportationCoordinator
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itLogistics manager TMSLogisticsManagerTo use itTransportation coordinator TMSTransportationCoordinatorGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=TMSRatingProfile
Integrate withTMSShippingCarrierRatingProfileEntity data entity Microsoft data model
Data migrationTMSShippingCarrierRatingProfileEntity (Shipping carrier rating profile): loaded for each company, in Microsoft's default template 405 - Transportation management.Load order: Microsoft's default template 405 - Transportation management loads Shipping carrier rating profile at execution unit 1, level 405, sequence 20. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Warehouse management)Microsoft Learn
Table definitionTMSRatingProfile columns and relations Microsoft data model
Everyone

8Sources