16.3 Freight Bills, Freight Invoicing, and Manual/Automatic Freight Reconciliation

16.3 Freight Bills, Freight Invoicing, and Manual/Automatic Freight Reconciliation

Quick Answer: The financial lifecycle in Transportation Management (TMS) bridges freight execution and Accounts Payable. When an outbound load is confirmed for shipment (or an inbound load is received), D365 SCM automatically generates a Freight Bill containing estimated line-haul rates and Accessorial Charges (e.g., fuel surcharges, liftgate fees). When the carrier submits their commercial freight invoice—either manually or via electronic EDI 210 transactions—the invoice must be matched against the freight bill. Freight reconciliation evaluates discrepancies using Tolerance Parameters (percentage and monetary thresholds) and Reconciliation Match Reasons, which dictate general ledger posting accounts for price variances. Matching can be performed manually in the Freight bill matching workbench or automated via a periodic batch job. Once approved, the system generates a Vendor Invoice Voucher in Accounts Payable under the carrier's linked vendor account.

---

1. Automatic Freight Bill Generation Architecture

In transportation management, costs are estimated before physical transit begins, but actual carrier liabilities must be accounted for upon dispatch.

Generation Trigger

When an outbound load is dispatched from the facility, the shipping supervisor clicks Ship and receive > Confirm > Outbound shipment on the Load record. (For inbound loads, confirmation occurs when the purchase order receipt or inbound load is confirmed).

This confirmation action triggers the TMS rating engine to generate a Freight Bill record:

• Navigation: Transportation management > Inquiries > Freight bills (or from the Load form via Related information > Freight bill details).
• Header Data: Captured details include Freight bill ID, Shipping carrier ID, Vendor account, Load ID, Currency, and Total estimated charge.
• Status: The freight bill is initially created with a status of Ready to match.

[Load Dispatch / Confirmation]
              │
              ▼
┌────────────────────────────────────────────────────────┐
│ Automated Freight Bill Generation:                     │
│ • Reads Rating Engine calculations from the Load       │
│ • Populates Line Haul base rate                        │
│ • Populates Accessorial charges & Fuel surcharges      │
│ • Status set to: 'Ready to match'                      │
└────────────────────────────────────────────────────────┘

---

2. Freight Bill Details and Accessorial Surcharges

A freight bill breaks down total transportation expenses into discrete charge lines, mirroring standard transportation industry billing practices.

Line-Haul Charges vs. Surcharges

• Line-Haul Charge: The core freight cost covering movement between origin and destination based on weight, distance, or zone tariffs.
• Fuel Surcharges: A variable fee calculated by an accessorial rating engine tied to floating diesel fuel price indices (such as the Department of Energy weekly national average diesel index).
• Accessorial Charges (Transportation management > Setup > Rating > Accessorial charges and Accessorial assignments): Supplementary service fees billed by carriers for handling beyond standard dock-to-dock transport.

Accessorial Charge Assignments

Accessorial assignments define the business rules governing when extra fees are added to a freight bill. For example:

• Liftgate Delivery: Applied when the destination customer record has the Liftgate required attribute flagged.
• Residential Delivery: Applied when the destination postal code is classified as a residential zone rather than a commercial dock.
• Driver Detention / Demurrage: Billed when loading or unloading exceeds the carrier's contractual free time (e.g., exceeding 2 hours at the dock).
• Hazardous Materials (Hazmat): Added when shipment lines contain products linked to hazardous material classification codes.

---

3. Carrier Freight Invoice Ingestion: Manual vs. Electronic EDI

After transporting the goods, the shipping carrier submits a commercial invoice requesting payment. D365 SCM supports two ingestion methods:

1. Manual Invoice Entry

For smaller carriers, local couriers, or specialized flatbed operators lacking electronic data interchange capabilities, freight invoices are entered manually:

• Navigation: Transportation management > Inquiries > Freight invoice details (or directly from the Freight bill by clicking Generate freight invoice).
• Input Fields: The user enters the carrier's physical invoice number, invoice date, carrier ID, billed line-haul amount, fuel surcharge, and any billed accessorial charges.

2. Electronic EDI Invoice Integration

High-volume distribution enterprises integrate carrier invoicing electronically using standard Electronic Data Interchange (EDI) protocols:

• ANSI X12 210: Motor Carrier Freight Details and Invoice (the North American standard for truckload and LTL carrier invoicing).
• EDIFACT IFTMIN / INVOIC: The international standard for multimodal transport invoicing.

In D365 SCM, electronic freight invoices are imported through the Data Management Framework (DMF) or configured via Electronic Reporting (ER). The integration maps EDI segment elements directly into the TMS Freight Invoice staging tables, generating ready-to-reconcile freight invoice records automatically without human data entry.

4. Freight Reconciliation: Matching, Tolerances, and Match Reasons

Freight reconciliation is the auditing engine that verifies carrier invoice amounts against internal freight bill estimates before financial disbursement occurs.

Freight Reconciliation Parameters and Tolerances

Navigate to Transportation management > Setup > Freight reconciliation > Freight reconciliation parameters and tolerance profiles.

Organizations establish acceptable variance limits to prevent small rounding differences or minor mileage adjustments from halting invoice processing:

• Percentage Tolerance: Specifies the maximum allowable percentage variance between the freight bill and carrier invoice (e.g., ±3.0%).
• Amount Tolerance: Specifies the maximum allowable monetary variance (e.g., $50.00).

If both tolerances are defined, an invoice line must satisfy both conditions to be considered within tolerance. For example, on a $5,000 freight bill, a 3% variance equals $150. However, if the maximum amount tolerance is capped at $50.00, any invoice variance exceeding $50.00 will fail tolerance validation and require manual exception approval.

Reconciliation Match Reasons (Transportation management > Setup > Freight reconciliation > Reconciliation match reasons)

When discrepancies occur between a freight bill and an invoice, D365 SCM requires a Reconciliation Match Reason code to categorize the variance. Match reason codes govern both operational auditing and financial accounting:

• Match reason code and Description: e.g., APPROVED_TOL, DETENTION_APPR, RATE_DISPUTE, UNAPPROVED_ACCESSORIAL.
• Debit / Credit Ledger Account: Specifies the exact general ledger main account to receive the variance posting. For example, approved detention fees post to a Carrier Detention Expense account, while standard rate differences post to Freight Expense Variance.
• Credit Type: Determines how the financial adjustment is settled with the carrier.
• Approval Flag: Indicates whether the match reason permits invoice approval or flags the record for carrier chargeback.

---

5. Manual Matching vs. Automatic Reconciliation Batch Processing

D365 SCM provides two distinct execution paths for freight reconciliation:

1. The Freight Bill Matching Workbench (Manual Auditing)

• Navigation: Transportation management > Inquiries > Freight bill matching.
• Operation: The workbench displays unmatched freight bills in the upper pane and unmatched carrier invoices in the lower pane. Transportation auditors select matching pairs and compare line items.
• Line Splitting and Detail Matching: If a carrier submits a single consolidated invoice covering three separate loads, auditors can split the invoice lines and match each segment against its corresponding freight bill. If an accessorial fee is added, the auditor selects an appropriate Reconciliation match reason code and clicks Match.

2. Automatic Reconciliation Batch Jobs (Periodic Task)

• Navigation: Transportation management > Periodic tasks > Freight bill matching.
• Operation: This recurring batch job automates the audit process. It evaluates all open freight invoices against open freight bills, applying active tolerance profiles.
• Execution Outcome:
  • Within Tolerance: If invoice amounts match the freight bill within configured percentage and amount tolerances, the system automatically matches the records, assigns the default system match reason, and marks the invoice as approved.
  • Exceeds Tolerance: If an invoice exceeds allowable tolerances, the batch job skips the record, leaving it open in the Freight bill matching workbench for manual exception review.

---

6. Accounts Payable Integration and Vendor Invoice Voucher Generation

The final step in the transportation financial lifecycle is transferring approved freight liabilities into the general ledger for payment disbursement.

┌────────────────────────────────────────────────────────┐
│ Approved Matched Freight Invoice in TMS                │
└───────────────────────────┬────────────────────────────┘
                            │
                            ▼
┌────────────────────────────────────────────────────────┐
│ Execute 'Submit freight invoice' Periodic Task         │
│ (or click 'Submit for approval' on Invoice Workbench)  │
└───────────────────────────┬────────────────────────────┘
                            │
                            ▼
┌────────────────────────────────────────────────────────┐
│ D365 SCM Generates Pending AP Vendor Invoice           │
│ • Module: Accounts payable > Invoices > Open invoices  │
│ • Vendor: Carrier's linked AP Vendor Account           │
│ • Lines: Matched freight charges & match reason splits │
└───────────────────────────┬────────────────────────────┘
                            │
                            ▼
┌────────────────────────────────────────────────────────┐
│ Accounts Payable Posts Invoice Voucher                 │
│ • Debit: Freight Expense Accounts (600100 / 600150)    │
│ • Credit: Vendor AP Liability Account (200100)         │
└────────────────────────────────────────────────────────┘

Submitting Invoices to Accounts Payable

1. Navigate to Transportation management > Periodic tasks > Submit freight invoice (or click Submit for approval on the Freight invoice details form).
2. D365 SCM creates a pending vendor invoice in Accounts Payable (Accounts payable > Invoices > Open vendor invoices).
3. The invoice header is automatically populated with the shipping carrier's linked Vendor account (VendTable).
4. The invoice lines represent the approved freight bill lines and variance adjustments, mapped to their designated general ledger accounts.
5. When Accounts Payable posts the vendor invoice, D365 SCM updates the TMS freight invoice status to Closed.
6. The invoice enters standard Accounts Payable payment proposal routines for check, ACH, or electronic wire disbursement.

---

7. Implementation Scenarios and Exam Traps

[!IMPORTANT] Exam Tip — Vendor Account Linkage Requirement: On the MB-330 exam, questions frequently test why an approved freight invoice fails to generate a voucher in Accounts Payable. The carrier record must have a valid Vendor account configured in Transportation management > Setup > Carriers > Shipping carriers. Without this vendor link, the integration cannot determine which vendor ledger account to credit.

[!WARNING] Exam Trap — Interaction Between Percentage and Amount Tolerances: If a company defines both a percentage tolerance (e.g., 5%) and an amount tolerance (e.g., $100), both limits apply. On a $10,000 full-truckload freight bill, 5% is $500. However, because the amount tolerance is capped at $100, an invoice variance of $150 will fail auto-reconciliation and require manual approval.

[!TIP] Best Practice — Tiered Auto-Reconciliation: Schedule the automatic Freight bill matching batch job to run nightly. This resolves 85–90% of routine parcel and LTL carrier invoices without human intervention, allowing logistics accounting teams to focus strictly on resolving high-value exceptions, unapproved accessorials, and rate dispute chargebacks.