BeyondERP.Newsletter
Menu

Setup page · Transportation management

Reconciliation reasons

A setup page where you define reconciliation reasons, which specify the accounts that are debited and credited with variances between freight bills and carrier invoices.

Used by
Logistics manager, Transportation coordinator
Business process
Manage freight and transportation
Menu item
TMSFreightMatchReason
Main table
TMSFreightMatchReason
Data entity
TMSFreightReconciliationReasonCodeEntity
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 reconciliation reasons, which specify the accounts that are debited and credited with variances between freight bills and carrier invoices.
What you do hereUse this page to set up the reason codes that determine how differences between freight bills and invoices are posted in the general ledger, in both manual and automatic reconciliation.
Reconciliation reasons 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 › Freight reconciliation › Reconciliation reasons
Used next byMatch freight bills and invoices Microsoft Learn Audit master Microsoft Learn
Related pagesShipping carriers 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 Reconciliation reasons

Use this page to set up the reason codes that determine how differences between freight bills and invoices are posted in the general ledger, in both manual and automatic reconciliation.

How to use it

  1. Go to Transportation management > Setup > Freight reconciliation > Reconciliation reasons.
  2. Select New.
  3. Enter a Reconciliation reason and a Description.
  4. Select the Debit account and the Credit account.
  5. Set the Pay the freight vendor and Override accounts options as required.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansTable column
Debit accountThe account that is debited with a variance between the freight bill and the invoice.Microsoft Learn OffAcctLedgerDimension
Credit accountThe account that is credited with a variance between the freight bill and the invoice.Microsoft Learn LedgerAccount
Pay freight vendorSelect this option when any credit should be paid to the vendor instead of being credited to a specific account.Microsoft Learn
Override accountsSelect this option to charge the debit and credit accounts on this page instead of apportioning the charges back to the original source document.Microsoft Learn OverrideAccts

Test checklist

  1. Set Enable freight reconciliation to Yes in Transportation management parameters.
  2. Create one overpayment and one underpayment reason code with debit and credit accounts.
  3. Reconcile a carrier invoice that differs from the freight bill and choose a reason code for the difference.
  4. Post the vendor invoice journal and check the voucher uses the reason code's accounts.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Reconciliation reasonsSeparate reason codes for overpayment and underpayment, each with debit and credit accounts; select Pay freight vendor only where the credit should be paid to the carrier, and Override accounts only where the reason's accounts should be charged instead of the source documentReconciliation reasons determine how variances between freight bills and invoices post in the general ledger, and the audit master uses an overpayment and an underpayment reason code.Selecting Pay freight vendor without a vendor account on the carrier on the Shipping carriers page, so the credit can't be paid to the carrier.Test: Freight variance posts to the reason code accounts
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: Reason codes can be edited, but they decide how differences post to the general ledger when the reconciliation journal is posted. Posted variances aren't changed by a later edit. Microsoft Learn
Technical architect

6Technical

Menu itemTMSFreightMatchReason Checked in Dynamics 365
FormTMSFreightMatchReason Checked in Dynamics 365
TableTMSFreightMatchReasonShown as “RECONCILIATION REASONS” in Record infoKey field: FreightReasonCodeChecked in Dynamics 365
Data entitiesTMSFreightReconciliationReasonCodeEntityFreight reconciliation reason codes Microsoft data model
Who can open itPrivilegesMaintain freight match reasons TMSFreightMatchReasonMaintainView freight match reasons TMSFreightMatchReasonViewDutiesInquire into freight reconciliation master TMSFreightReconcileMasterInquireMaintain freight reconciliation master TMSFreightReconcileMasterMaintain
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=TMSFreightMatchReason
Integrate withTMSFreightReconciliationReasonCodeEntity data entity Microsoft data model
Data migrationTMSFreightReconciliationReasonCodeEntity (Freight reconciliation reason codes): loaded for each company, in Microsoft's default template 405 - Transportation management.Load order: Microsoft's default template 405 - Transportation management loads Freight reconciliation reason codes 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 definitionTMSFreightMatchReason columns and relations Microsoft data model
Everyone

8Sources