BeyondERP.Newsletter
Menu

Setup step on the Fuel indexes page · Transportation management

Set up Fuel indexes

Use this page to record the current fuel prices for the regions where you operate, so that fuel prices can be tracked as they change over time.

Used by
Logistics manager, Transportation coordinator
Business process
Manage freight and transportation
Menu item
TMSFuelIndex
Main table
TMSFuelIndex
Data entity
TMSFuelIndexEntity
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 enter the fuel price for a fuel index region for a particular period of time.
What you do hereUse this page to record the current fuel prices for the regions where you operate, so that fuel prices can be tracked as they change over time.
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 › Fuel indexes
Set up firstFuel index regions Microsoft Learn
Related pagesCarrier fuel indexes Microsoft Learn
In this process Set up Reconciliation reasons · Set up Load building strategies
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 Fuel indexes

Use this page to record the current fuel prices for the regions where you operate, so that fuel prices can be tracked as they change over time.

Steps from Microsoft

  1. Go to Transportation management > Setup > Fuel indexes > Fuel indexes.
  2. Select New.
  3. In the Region field, select the region.
  4. In the Price per gallon field, enter a number.
  5. In the Effective start date and time field, enter a date and time.
  6. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
RegionThe fuel index region that the price applies to.Microsoft Learn FuelIndexRegionCode
Price per gallonThe fuel price for the region.Microsoft Learn PPG
Effective start date and timeThe date and time from which the fuel price applies.Microsoft Learn EffectiveUTCDateTimeFrom

Test checklist

  1. Create a fuel index row for a region with Price per gallon and Effective start date and time.
  2. Check the carrier fuel index has a PPG from and PPG to range that covers the price.
  3. Rate a load in that region and check the fuel surcharge uses the matching percentage.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Fuel indexesA new row per region each time the published fuel price changes, with its own Effective start date and timeThe fuel index holds the price for a period, so adding dated rows keeps the history and lets the surcharge follow prices over time.Overwriting the price on the existing row, which loses the history and applies the new price to the wrong period.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Rows are dated; a new row applies from its effective start.
Technical architect

6Technical

Menu itemTMSFuelIndex Checked in Dynamics 365
FormTMSFuelIndex Checked in Dynamics 365
TableTMSFuelIndexShown as “FUEL INDEXES” in Record infoKey field: FuelIndexRegionCodeChecked in Dynamics 365
Data entitiesTMSFuelIndexEntityFuel indexes Microsoft data model
Who can open itPrivilegesMaintain fuel index records TMSFuelIndexMaintainView fuel index details TMSFuelIndexViewDutiesInquire 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=TMSFuelIndex
Integrate withTMSFuelIndexEntity data entity Microsoft data model
Data migrationTMSFuelIndexEntity (Fuel indexes): loaded for each company, in Microsoft's default template 405 - Transportation management.Load order: Microsoft's default template 405 - Transportation management loads Fuel indexes at execution unit 1, level 40, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: Fuel index regions, the default templates at lower levels (System setup to dependency bands 30 to 90)Microsoft Learn
Table definitionTMSFuelIndex columns and relations Microsoft data model
Everyone

8Sources

To cite this step: TM-FUEL-010, Set up Fuel indexes. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/TM-FUEL-010