BeyondERP.Newsletter
Menu

Setup step on the Audit master page · Transportation management

Set up Audit master

Use this page to specify how much the amounts on a freight bill and a carrier invoice can differ during automatic reconciliation, and which reason codes record the difference.

Used by
Logistics manager, Transportation coordinator
Business process
Manage freight and transportation
Menu item
TMSAuditMaster
Main table
TMSAuditMaster
Data entity
TMSFreightBillMatchingAuditToleranceLevelEntity
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 audit masters, which set the tolerance limits for automatic freight reconciliation and how discrepancies are handled.
What you do hereUse this page to specify how much the amounts on a freight bill and a carrier invoice can differ during automatic reconciliation, and which reason codes record the difference.
Audit master 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 › Audit master
Set up firstFreight bill type Microsoft Learn Reconciliation reasons Microsoft Learn
In this process Set up Transit time engine · Set up Accessorial masters
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 Audit master

Use this page to specify how much the amounts on a freight bill and a carrier invoice can differ during automatic reconciliation, and which reason codes record the difference.

Steps from Microsoft

  1. Go to Transportation management > Setup > Freight reconciliation > Audit master.
  2. Select New, and then enter a value in the Audit master ID field.
  3. In the Shipping carrier field, select the shipping carrier.
  4. In the Freight bill type field, select the freight bill type.
  5. On the Tolerance FastTab, enter the Minimum tolerance level and the Maximum tolerance level.
  6. On the Result FastTab, enter or select the Overpayment reason code and the Underpayment reason code.
  7. Close the page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Minimum tolerance levelThe lower tolerance limit for the difference between the freight bill and the carrier invoice. Outside the limits, reconciliation is prevented.Microsoft Learn
Maximum tolerance levelThe upper tolerance limit for the difference between the freight bill and the carrier invoice. Outside the limits, reconciliation is prevented.Microsoft Learn
Overpayment reason codeThe reason code that specifies the accounts that an overpayment within tolerance is registered on.Microsoft Learn OverageReasonCode
Underpayment reason codeThe reason code that specifies the accounts that an underpayment within tolerance is registered on.Microsoft Learn UnderageReasonCode
ExceptionsTypes of charges that should not be evaluated according to the same criteria as the audit master during automatic reconciliation.Microsoft Learn

Test checklist

  1. Create an audit master for the carrier with the freight bill type, minimum and maximum tolerance, and both reason codes.
  2. Run automatic reconciliation for an invoice within tolerance and check it is reconciled to the reason code.
  3. Run it for an invoice outside tolerance and check that reconciliation is prevented.
  4. Match a negative-amount invoice manually and check it matches a freight bill that isn't fully matched.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Audit masterOne audit master per shipping carrier, using that carrier's freight bill type, with tolerance limits agreed with Finance and an overpayment and underpayment reason codeThe audit master sets how far the freight bill and carrier invoice may differ in automatic reconciliation, and the reason codes record where a difference inside tolerance posts.Relying on auto matching for invoices with negative amounts. Auto matching sorts invoices by amount and can leave a negative invoice unmatched once the freight bill is fully matched, so Microsoft says to match those manually.Test: Auto matching respects tolerance
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Tolerances and reason codes can be changed and apply to the next automatic reconciliation run.
Technical architect

6Technical

Menu itemTMSAuditMaster Checked in Dynamics 365
FormTMSAuditMaster Checked in Dynamics 365
TableTMSAuditMasterShown as “AUDIT MASTER” in Record infoKey field: AuditMasterIdChecked in Dynamics 365
Data entitiesTMSFreightBillMatchingAuditToleranceLevelEntityFreight bill matching audit tolerance levels Microsoft data model
Who can open itPrivilegesMaintain audit master TMSAuditMasterMaintainView audit master TMSAuditMasterViewDutiesEnable 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=TMSAuditMaster
Integrate withTMSFreightBillMatchingAuditToleranceLevelEntity data entity Microsoft data model
Table definitionTMSAuditMaster columns and relations Microsoft data model
Everyone

8Sources

To cite this step: TM-FREIGHT-040, Set up Audit master. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/TM-FREIGHT-040