BeyondERP.Newsletter
Menu

Page · Transportation management

Unmatched freight bills

A details page, titled Freight bill summary, that shows freight bill lines with their freight bill type, route, sequence and amount remaining, together with the shipment, load, reconciliation status, billing group and rate details.

Used by
Logistics manager, Transportation coordinator
Business process
Reconcile freight in Dynamics 365 Supply Chain Management
Menu item
TMSFreightBillSummary
Main table
TMSFreightBillDetail
Data entity
TMSFreightBillDetailEntity
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 details page, titled Freight bill summary, that shows freight bill lines with their freight bill type, route, sequence and amount remaining, together with the shipment, load, reconciliation status, billing group and rate details.
What you do hereUse this page to review freight bills that are not yet matched to a carrier invoice and to discard a selected freight bill.
Unmatched freight bills 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 › Reconcile freight › Reconcile freight in Dynamics 365 Supply Chain Management
Menu pathTransportation management › Freight bills and invoices › Unmatched freight bills
Related pagesTransportation management parameters 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.

How to use it

  1. Go to Transportation management > Freight bills and invoices > Unmatched freight bills.
  2. Select a freight bill in the list pane, or use the Filter field to find it.
  3. Review the Freight bill type, Route, Sequence and Amount remaining in the header.
  4. On the Information FastTab, review the Type of invoice line, Shipment ID, Load ID, Reconciliation status, Pro number, Hub, Billing group ID and Currency.
  5. Expand the Dimensions, Dates, Rate, Accounts, Shipping carrier and Address FastTabs for more details.
  6. On the Action Pane, select Discard to discard the selected freight bill.

Source: Checked in Dynamics 365

Test checklist

  1. In Transportation management parameters, set Enable freight reconciliation to Yes.
  2. Confirm a rated load and check that a freight bill appears here with its amount remaining.
  3. From the load, select Freight bill details > Generate freight bill invoice and enter an invoice number.
  4. Select Match freight bills and invoices, match the line, and check it leaves the unmatched list.
  5. Enter a different invoice amount on a second load and check a reconciliation reason is needed for the difference.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Discarding a freight bill can create a vendor invoice journal, depending on the Freight bill discard vendor invoice journal creation policy in Transportation management parameters (default: Only for reconciliation reasons with pay the freight vendor). Learn does not describe how to bring a discarded freight bill back. Microsoft Learn
Technical architect

5Technical

Menu itemTMSFreightBillSummary Checked in Dynamics 365
FormTMSFreightBillSummary Checked in Dynamics 365
TableTMSFreightBillDetailShown as “FREIGHT BILL DETAILS” in Record infoChecked in Dynamics 365
Data entitiesTMSFreightBillDetailEntityFreight bill details Microsoft data model
Who can open itPrivilegesMaintain freight bill summary TMSFreightBillSummaryMaintainView freight bill summary details TMSFreightBillSummaryViewDutiesMaintain freight reconciliation master TMSFreightReconcileMaintainInquire into freight reconciliation status TMSFreightReconcileStatusInquireReview transportation management process performance TMSTransportationMgmtProcessPerfReview
2 security rolesLogistics manager TMSLogisticsManagerTransportation coordinator TMSTransportationCoordinator
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itTransportation coordinator TMSTransportationCoordinatorTo use itLogistics manager TMSLogisticsManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): DiscardChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=TMSFreightBillSummary
Integrate withTMSFreightBillDetailEntity data entity Microsoft data model
Table definitionTMSFreightBillDetail columns and relations Microsoft data model
Everyone

7Sources