BeyondERP.Newsletter
Menu

Job page · Transportation management

Auto match batch

A periodic task that matches all available freight invoices with freight bills at once, according to the setup of the audit master and freight bill type.

Business process
Reconcile freight in Dynamics 365 Supply Chain Management
Menu item
action:TMSAutoMatchBatch
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic task that matches all available freight invoices with freight bills at once, according to the setup of the audit master and freight bill type.
What you do hereUse this task to run automatic freight reconciliation, so that freight invoices are matched with freight bills without matching each invoice line by hand.
Auto match batch 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

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.

When to run it

When to run itWhen carrier freight invoices have arrived and are waiting to be matched to the freight bills that were created when the loads were confirmed.
How oftenOn the schedule set by Match interval in Transportation management parameters when Automatically match and pay the freight invoice is turned on (Microsoft recommends at least 120 seconds), or on demand when new carrier invoices arrive.
Batch settingsRun it as a recurring batch job so freight invoices are matched on the reconciliation schedule without matching each invoice line by hand.
What the output showsFreight invoices and freight bills set to Partially matched or Fully matched. Differences inside the audit master tolerance go to the overpayment or underpayment reason code. An invoice that stays unmatched usually has a mandatory freight bill type value that differs from the bill, or a difference outside the tolerance.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Transportation management > Freight bills and invoices > Auto match batch.
  2. Before the first run, set up a freight bill type assignment and an audit master for each shipping carrier. Auto matching only pairs a bill and an invoice when the mandatory freight bill type criteria match, and it uses the audit master tolerance for differences.
  3. Run the job. It sorts the unmatched freight invoices by amount, largest first, and matches them one by one until the freight bill has no positive remaining amount.
  4. Match freight invoices with negative amounts by hand on the Freight bill and invoice matching page. Once a freight bill is fully matched, auto matching doesn't process the remaining invoices for it.
  5. Review the invoices the job couldn't match and reconcile them manually before you post the invoices for payment.

Source: Microsoft Learn

Test checklist

  1. A test invoice with the same amount as its freight bill shows Fully matched.
  2. An invoice with a small difference inside the tolerance is matched with the expected reason code.
  3. An invoice outside the tolerance stays unmatched for manual review.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undonePartly: Unmatched invoices stay open for manual matching. If the parameters create and post vendor invoice journals automatically, those postings stay in the ledger. Microsoft Learn
If you change it laterSets the match status of freight invoices and freight bills. When Write vendor invoice journal and Post journal are turned on in the parameters, the reconciliation also creates and posts vendor invoice journals. Microsoft Learn
Technical architect

5Technical

Menu itemaction:TMSAutoMatchBatch
Roles to set it up and use itTo use itTransportation coordinator TMSTransportationCoordinatorGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=action:TMSAutoMatchBatch
Everyone

7Sources