Skip to content
Dynamic Ship Analysis app iconDynamic Ship AnalysisFeature

Shipping Spend by Carrier for Microsoft Dynamics 365 Business Central

When several carriers handle your shipments, the total freight bill hides how much each one costs you and how much work each one does. Dynamic Ship Analysis shows how shipping spend divides across carriers, called shipping agents in Business Central. This is a completely free app from Insight Works for Business Central.

The report uses the carrier and cost of each shipment recorded by Dynamic Ship, so every carrier you ship with appears in one view.

How Shipping spend by carrier works in Dynamic Ship Analysis

  1. Dynamic Ship records shipments, packages, carriers, and freight costs in Business Central as your team ships.
  2. An administrator installs the Business Central extension that supplies the report data, then installs the Dynamic Ship Analysis Power BI app from Microsoft Marketplace and connects it to the same Business Central environment.
  3. A logistics manager opens the Shipping Agents page.
  4. They compare spend, shipment count, and average spend per shipment for each carrier, and look at spend by province or state.
  5. They use the findings in carrier reviews and when deciding how to route shipments.

Key capabilities

Spend by carrier

Total spend for each shipping agent shows where your freight budget goes.

Volume by carrier

The number of shipments per shipping agent shows how work is split between carriers.

Average cost per shipment

Average spend per shipment for each shipping agent puts carriers on the same basis.

By destination region

Spend by shipping agent for each province or state shows where each carrier is used most.

Trends by carrier

Monthly spend and average spend per shipment for each carrier are on the Shipping Agent Trends page. See Carrier Data in One Report.

Drill down

Drill into a carrier's figures for more detail.

See Shipping spend by carrier on screen

Real screens from Dynamic Ship Analysis, shown with demo data.

Details that matter on the floor

Cost and volume side by side

Seeing spend next to shipment count and average cost shows whether a carrier costs more because it carries more, or because each shipment costs more.

Questions for carrier reviews

Spend by province or state shows where each carrier is used, which helps when preparing for a conversation with a carrier.

Who uses Shipping spend by carrier

Logistics managers

Review carrier cost and performance and decide where to route shipments.

Financial analysts and controllers

See how shipping spend divides across carriers for budgeting.

Supply chain managers

Weigh carrier mix in supply chain cost decisions.

Questions about Shipping spend by carrier

Can I see shipping spend by carrier in Business Central?

Yes, with Dynamic Ship Analysis and Dynamic Ship. The Shipping Agents page in Power BI shows total spend, shipment count, and average spend per shipment for each carrier.

What is a shipping agent?

Shipping agent is the Business Central name for a carrier. Dynamic Ship Analysis groups spend by the shipping agent on each shipment.

Where does the cost data come from?

From the shipments Dynamic Ship records in Business Central. For freight cost reporting inside Dynamic Ship itself, see Freight Cost Analysis.

Dynamic Ship Analysis app icon

Part of Dynamic Ship Analysis

Analyze your Dynamic Ship shipping costs and trends in Power BI.

Have a question about Shipping spend by carrier?

Send us a note and the Dynamic Ship Analysis team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions