BeyondERP.Newsletter
Menu

Setup page · Transportation management

Freight bill type assignments

A setup page where you specify the freight bill type that is used for a shipping carrier.

Used by
Logistics manager, Transportation coordinator
Business process
Manage freight and transportation
Menu item
TMSFreightBillTypeAssignment
Main table
TMSFreightBillTypeAssignment
Data entity
TMSFreightBillTypeAssignmentEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you specify the freight bill type that is used for a shipping carrier.
What you do hereUse this page to assign a freight bill type to a carrier, so that the system can determine the matching requirements when an invoice is received from that carrier.
Freight bill type assignments 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 › Freight bill type assignments
Set up firstFreight bill type 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.

Setup steps on this page

Set up Freight bill type assignments

Use this page to assign a freight bill type to a carrier, so that the system can determine the matching requirements when an invoice is received from that carrier.

Steps from Microsoft

  1. Go to Transportation management > Setup > Freight reconciliation > Freight bill type assignments.
  2. Select New.
  3. In the Mode field, enter or select a value.
  4. In the Shipping carrier field, enter or select a value.
  5. In the Freight bill type field, select the freight bill type that you created earlier.
  6. Close the page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
SiteLeave blank when the carrier ships from or to multiple sites and warehouses within the same legal entity.Microsoft Learn InventSiteId
WarehouseLeave blank when the carrier ships from or to multiple sites and warehouses within the same legal entity.Microsoft Learn InventLocationId
Freight bill typeThe freight bill type whose matching requirements are used for invoices from the carrier.Microsoft Learn FreightBillTypeId

Test checklist

  1. Create an assignment for a mode and shipping carrier with Site and Warehouse blank.
  2. Receive or create carrier invoices for loads from two different warehouses.
  3. Run auto matching and check both invoices are matched using the assigned freight bill type.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Freight bill type assignmentsOne assignment per mode and shipping carrier; leave Site and Warehouse blank when the carrier ships from or to several sites and warehouses in the legal entityThe assignment tells the system which freight bill type, and so which matching requirements, to use when an invoice arrives from the carrier. Microsoft says to leave Site and Warehouse blank for carriers that serve multiple sites and warehouses.Filling in one site and warehouse for a carrier that serves several, so invoices for the other sites have no freight bill type to match against.
Solution architect

5Design impact

Can it be undoneReversible: Assignments can be changed at any time and apply to carrier invoices received afterwards. Microsoft Learn
Technical architect

6Technical

Menu itemTMSFreightBillTypeAssignment Checked in Dynamics 365
FormTMSFreightBillTypeAssignment Checked in Dynamics 365
TableTMSFreightBillTypeAssignmentShown as “FREIGHT BILL TYPE ASSIGNMENTS” in Record infoChecked in Dynamics 365
Data entitiesTMSFreightBillTypeAssignmentEntityFreight bill type assignments Microsoft data model
Who can open itPrivilegesMaintain freight bill type assignments TMSFreightBillTypeAssignmentMaintainView freight type assignments TMSFreightBillTypeAssignmentViewDutiesInquire into freight reconciliation master TMSFreightReconcileMasterInquireMaintain freight reconciliation master TMSFreightReconcileMasterMaintain
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=TMSFreightBillTypeAssignment
Integrate withTMSFreightBillTypeAssignmentEntity data entity Microsoft data model
Table definitionTMSFreightBillTypeAssignment columns and relations Microsoft data model
Everyone

8Sources