BeyondERP.Newsletter
Menu

Setup page · Transportation management

Transportation management parameters

A setup page where you set the parameters for Transportation management, grouped on the General, Reports, Print management, Number sequences and Microsoft Cloud for Sustainability integration configuration tabs.

Used by
Logistics manager, Transportation coordinator
Business process
Manage freight and transportation
Menu item
TMSParameters
Main table
TMSParameters
Data entity
TMSTransportationManagementParametersEntity
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 set the parameters for Transportation management, grouped on the General, Reports, Print management, Number sequences and Microsoft Cloud for Sustainability integration configuration tabs.
What you do hereUse this page to control how Transportation management works, with settings for appointment scheduling, driver check-in and check-out, vendor invoices, shipments, loads, engines, freight reconciliation and bills of lading.
Transportation management parameters 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 › Transportation management parameters
Related pagesNumber sequences 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 Transportation management parameters

Use this page to control how Transportation management works, with settings for appointment scheduling, driver check-in and check-out, vendor invoices, shipments, loads, engines, freight reconciliation and bills of lading.

Steps from Microsoft

  1. Go to Transportation management > Setup > Transportation management parameters.
  2. Open the General tab.
  3. On the Performance settings FastTab, set Pro number generation mode to Default or Performance optimized.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Enable freight reconciliationTurns on freight reconciliation in Transportation management. It is set on the Freight reconciliation FastTab of the General tab.Microsoft Learn
Write vendor invoice journalLets the system create an invoice journal that reconciles any differences between the freight bill and the freight invoice.Microsoft Learn WriteInvoiceJournal
Post journalLets the system post the invoice journal after it is approved by the user in the Workflow user field.Microsoft Learn PostJournal
Automatically match and pay the freight invoiceRuns the automated match and pay batch jobs for freight invoices.Microsoft Learn MatchAndPay
Match intervalDefines the schedule for automatic reconciliation or matching of freight bills and invoices.Microsoft Learn MatchInterval
Alert intervalSets the interval, on the Driver check-in and check out FastTab, after which a driver who has checked in but not checked out is shown as late on check out.Microsoft Learn DriverCheckOutInterval
Pro number generation modeControls how the system allocates pro numbers. It is set on the Performance settings FastTab of the General tab.Microsoft Learn

Test checklist

  1. Set Enable freight reconciliation to Yes on the General tab.
  2. Ship-confirm a load and check a freight bill is generated.
  3. Generate a freight bill invoice from Freight bill details and match it on Freight bill and invoice matching.
  4. Submit for approval and check a vendor invoice journal is created (and posted if Post journal is on).

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Transportation management parametersEnable freight reconciliation if carrier invoices are matched in the system; with Automatically match and pay the freight invoice on, set Match interval to at least 120 seconds; choose Pro number generation mode deliberately (Default unless release to warehouse is slow with pro numbers)Learn gives 120 seconds as the minimum standard recommended match interval for automatic match and pay, and recommends Performance optimized only when high-volume processes run slowly with pro numbers.Which Pro number generation mode should the legal entity use?Turning on Write vendor invoice journal and Post journal without a Workflow user; the journal is posted only after approval by the user in the Workflow user field.Test: Freight invoice matched and journal created

Number sequences

ReferenceShared or per companyNote
Appointment IDPer companyBEAT uses number sequence Tran_3. Checked in Dynamics 365
RoutePer companyBEAT uses number sequence Tran_7. Checked in Dynamics 365
Internal invoicePer companyBEAT uses number sequence Tran_11. Checked in Dynamics 365
Transportation orderPer companyBEAT uses number sequence Tran_15. Checked in Dynamics 365
Freight bill IDPer companyBEAT uses number sequence Tran_19. Checked in Dynamics 365
Transport request IDPer companyBEAT uses number sequence Tran_23. Checked in Dynamics 365
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: All settings can be changed at any time; they affect later matching runs, journals and pro numbers. Pro numbers skipped under Performance optimized stay skipped. Microsoft Learn
Technical architect

6Technical

Menu itemTMSParameters Checked in Dynamics 365
FormTMSParameters Checked in Dynamics 365
TableTMSParametersShown as “TRX PARAMETERS” in Record infoChecked in Dynamics 365
Data entitiesTMSTransportationManagementParametersEntityTransportation management parameters Microsoft data model
Who can open itPrivilegesMaintain transportation parameters TMSParametersMaintainView transportation parameters TMSParametersViewDutiesEnable the transportation management process TMSTransportationMgmtEnableInquire into transportation management policies TMSTransportationMgmtPoliciesInquire
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=TMSParameters
Integrate withTMSTransportationManagementParametersEntity data entity Microsoft data model
Data migrationTMSTransportationManagementParametersEntity (Transportation management parameters): loaded for each company, in Microsoft's default template 405 - Transportation management.Load order: Microsoft's default template 405 - Transportation management loads Transportation management parameters at execution unit 1, level 40, 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 dependency bands 30 to 90)Microsoft Learn
Table definitionTMSParameters columns and relations Microsoft data model
Everyone

8Sources