BeyondERP.Newsletter
Menu

Setup page · Transportation management

Rating metadata

A setup page where you define rating metadata, the rate base type that describes the data used by rate bases and rate base assignments.

Used by
Logistics manager, Transportation coordinator
Business process
Manage freight and transportation
Menu item
TMSRateBaseType
Main table
TMSRateBaseType
Data entity
TMSTransportationRatingMetadataEntity
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 setup page where you define rating metadata, the rate base type that describes the data used by rate bases and rate base assignments.
What you do hereUse this page to define the data a rate engine expects when it calculates rates, so that rates can be searched by values such as postal codes.
ExampleFor example, a rate engine can require the origin address, the destination state and country/region, and the start and end point of the shipment.
Rating metadata 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 › Setup › Rating › Rating metadata
Used next byBreak masters Microsoft Learn Rate masters Microsoft Learn
Related pagesRate engine 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.

Setup steps on this page

Set up Rating metadata

Use this page to define the data a rate engine expects when it calculates rates, so that rates can be searched by values such as postal codes.

How to use it

  1. Go to Transportation management > Setup > Rating > Rating metadata.
  2. Select New.
  3. Enter a Rating metadata ID and a Name.
  4. On the Rate base type metadata FastTab, select the Described data type, such as Rate base.
  5. Select New and enter the Sequence, Name, Data type, Lookup type and Mandatory setting for each field.

Source: Checked in Dynamics 365

Test checklist

  1. Create rating metadata with mandatory assignment fields for origin postal code and destination start and end postal code.
  2. Create a rate master that uses this Rating metadata ID and check that the Rate base assignments FastTab shows the postal code columns.
  3. Add a rate base assignment for one postal code range and link the rate master to a carrier's rating profile.
  4. Rate a load with a destination inside the range and check that a rate is returned; repeat with a postal code outside the range and check that no rate is found.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Rating metadataSet up rating metadata first, with assignment fields that use the Postal Code lookup type for origin and destination (for example origin postal code and destination start and end postal code)Metadata controls the data used to search for rates; to search rates by postal code you must set up metadata with the postal code lookup type. The standard engines rely on postal codes, and rating elements must be configured in order, starting with rating metadata.What data should rates be searched on?Designing metadata around longitude and latitude. The standard engines don't support it, so you would need a custom engine.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: A rate master can be associated with only one rating metadata ID, and the rate base assignment columns depend on that metadata. Changing metadata that rate masters already use means rebuilding their rate data. Microsoft Learn
Technical architect

6Technical

Menu itemTMSRateBaseType Checked in Dynamics 365
FormTMSRateBaseType Checked in Dynamics 365
TableTMSRateBaseTypeShown as “RATE BASE TYPES” in Record infoKey field: RateBaseTypeCodeChecked in Dynamics 365
Data entitiesTMSTransportationRatingMetadataEntityTransportation rating metadata Microsoft data model
Who can open itPrivilegesMaintain rate base types TMSRateBaseTypeMaintainView rate base types TMSRateBaseTypeViewDutiesInquire into carrier master and network planning information TMSCarrierMasterInquireMaintain transportation management engine configuration TMSEngineConfigurationMaintain
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=TMSRateBaseType
Integrate withTMSTransportationRatingMetadataEntity data entity Microsoft data model
Data migrationTMSTransportationRatingMetadataEntity (Transportation rating metadata): loaded for each company, in Microsoft's default template 405 - Transportation management.Load order: Microsoft's default template 405 - Transportation management loads Transportation rating metadata at execution unit 1, level 30, sequence 10. 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 General ledger)Microsoft Learn
Table definitionTMSRateBaseType columns and relations Microsoft data model
Everyone

8Sources