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
- Dynamic Ship records shipments, packages, carriers, and freight costs in Business Central as your team ships.
- 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.
- A logistics manager opens the Shipping Agents page.
- They compare spend, shipment count, and average spend per shipment for each carrier, and look at spend by province or state.
- 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.
Related Dynamic Ship Analysis features
All Dynamic Ship Analysis features →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.
