BeyondERP.Newsletter
Menu

Inquiry page · Transportation management

Freight invoice details

A list page that shows freight invoices from shipping carriers, with their workflow status, invoice status, carrier, carrier service, vendor account, invoice number and invoice date, together with the invoice lines of the selected invoice.

Used by
Logistics manager, Transportation coordinator
Business process
Process freight invoice in Dynamics 365 Supply Chain Management
Menu item
TMSInvoiceTable
Main table
TMSInvoiceTable
Data entity
TMSFreightInvoiceHeaderEntity
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 list page that shows freight invoices from shipping carriers, with their workflow status, invoice status, carrier, carrier service, vendor account, invoice number and invoice date, together with the invoice lines of the selected invoice.
What you do hereUse this page to review carrier freight invoices, match them with freight bills and submit them for approval.
Freight invoice details 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.

Steps from Microsoft

  1. Go to Transportation management > Inquiries and reports > Freight invoice details.
  2. Select the freight invoice that you want to reconcile.
  3. Select Match freight bills and invoices.
  4. In the Invoice details section, expand the Unmatched freight bill details section, mark the row and select Match.
  5. Select Submit for approval.
  6. Clear the Hide approved check box, select Vendor invoice journals and, in the Reference journal number field, select the link.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Technical architect

5Technical

Menu itemTMSInvoiceTable Checked in Dynamics 365
FormTMSInvoiceTable Checked in Dynamics 365
TableTMSInvoiceTableShown as “FREIGHT INVOICE DETAILS” in Record infoKey field: InternalInvNumberChecked in Dynamics 365
Data entitiesTMSFreightInvoiceHeaderEntityFreight invoice headers Microsoft data model TMSFreightInvoiceHeaderV2EntityFreight invoice headers V2 Microsoft data model
Who can open itPrivilegesMaintain invoice tables TMSInvoiceTableMaintainView invoice table TMSInvoiceTableViewDutiesMaintain 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): Match freight bills and invoices, Submit for approval, Vendor invoice journalsChecked in Dynamics 365
Developer

6Developer

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

7Sources