BeyondERP.Newsletter
Menu

Setup step on the Carrier fuel indexes page · Transportation management

Set up Carrier fuel indexes

Use this page to set up the fuel surcharge levels that apply to a carrier, so that the surcharge follows changes in fuel prices over time.

Used by
Logistics manager, Transportation coordinator
Business process
Manage freight and transportation
Menu item
TMSCarrierFuelIndex
Main table
TMSCarrierFuelIndexTable
Data entity
TMSCarrierFuelIndexEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define carrier fuel indexes, each with lines that set an effective start date and time, a PPG From and PPG To fuel price range, a percentage or rate, and a currency.
What you do hereUse this page to set up the fuel surcharge levels that apply to a carrier, so that the surcharge follows changes in fuel prices over time.
ExampleFor example, a line can apply a percentage of 3 when the fuel price per gallon is between 1.95 and 2.
Carrier fuel indexes 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 › Fuel indexes › Carrier fuel indexes
Used next byRating profiles Microsoft Learn Shipping carriers Microsoft Learn
Related pagesFuel index regions Microsoft Learn Fuel indexes Microsoft Learn
In this process Set up Freight bill type assignments · Set up Equipment
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 Carrier fuel indexes

Use this page to set up the fuel surcharge levels that apply to a carrier, so that the surcharge follows changes in fuel prices over time.

Steps from Microsoft

  1. Go to Transportation management > Setup > Fuel indexes > Carrier fuel indexes.
  2. Select New.
  3. In the Carrier fuel index field, enter a value, and in the Description field, enter a description.
  4. On the Details FastTab, select New to add a line.
  5. In the Effective start date and time field, enter a date and time.
  6. In the PPG from and PPG to fields, enter the fuel price range for the line.
  7. In the Percentage field, enter a number, and in the Currency field, select the currency.
  8. Select Save.

Source: Microsoft Learn

Test checklist

  1. Create the carrier fuel index with lines that cover the price range without gaps.
  2. Select it in Carrier fuel index on the carrier's rating profile.
  3. Set up a fuel surcharge accessorial assignment for the carrier.
  4. Rate a load and check the surcharge matches the band for the current fuel price.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Carrier fuel indexesOne carrier fuel index per carrier surcharge table, with dated lines of PPG from, PPG to and Percentage (or rate) and currency, then selected on the carrier's rating profileThe carrier fuel index must exist before it is linked to the carrier through an accessorial assignment and the rating profile.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Lines are dated; add new lines for new surcharge tables.
Technical architect

6Technical

Menu itemTMSCarrierFuelIndex Checked in Dynamics 365
FormTMSCarrierFuelIndexTable Checked in Dynamics 365
TableTMSCarrierFuelIndexTableShown as “CARRIER FUEL INDEX” in Record infoKey field: CarrierFuelIndexCodeChecked in Dynamics 365
Data entitiesTMSCarrierFuelIndexEntityCarrier fuel indexes Microsoft data model
Who can open itPrivilegesMaintain carrier fuel indexes TMSCarrierFuelIndexMaintainView carrier fuel indexes TMSCarrierFuelIndexViewDutiesInquire 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=TMSCarrierFuelIndex
Integrate withTMSCarrierFuelIndexEntity data entity Microsoft data model
Data migrationTMSCarrierFuelIndexEntity (Carrier fuel indexes): loaded for each company, in Microsoft's default template 405 - Transportation management.Load order: Microsoft's default template 405 - Transportation management loads Carrier fuel indexes 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 definitionTMSCarrierFuelIndexTable columns and relations Microsoft data model
Everyone

8Sources