Freight Cost Analysis and Shipping Profitability for Microsoft Dynamics 365 Business Central
Freight price rules, the Dynamic Ship settings that add markups, discounts, or free freight to what a customer pays, change the amount billed without changing what the carrier charges you. Dynamic Ship records the actual carrier cost and the amount billed to the customer on every sales order freight line in Business Central.
Dynamic Ship Analysis, Insight Works' free Power BI reporting app for Dynamic Ship, reports the two side by side by customer, carrier, service level, and region. This is a completely free app from Insight Works for Business Central. Dynamic Ship Analysis is a separate app and needs Business Central online.
How Freight cost analysis works in Dynamic Ship
- When a shipment is rated and labeled, Dynamic Ship records the actual freight cost the carrier charged.
- The freight price rule applied to the order, whether a markup, discount, flat rate, or free-freight campaign, determines what the customer is billed.
- Both figures post to the sales order freight line and flow into Dynamic Ship Analysis.
- Your team reviews cost-versus-charge dashboards by customer, carrier, service level, or region, finds where freight loses money, and adjusts freight price rules.

Key capabilities
Cost versus charge
Every sales order freight line stores your actual carrier cost in Unit Cost and the amount billed to the customer in Unit Price, so the freight margin is visible on the order.
Profitability by customer
Identify which customers or price groups ship at a loss once markups, discounts, and free-freight rules are applied.
Profitability by carrier and service
Compare which carriers and service levels recover their freight cost and which ones reduce your margin.
Regional and trend views
Track shipment frequency, total spend, and average spend by shipment weight over time, with comparisons to the previous year.
Power BI foundation
Dynamic Ship Analysis is a Power BI template app, so your team can extend the reports or add company-specific visuals.
Shipment detail without Power BI
The Freight Information report on the Insight Works License Plates list shows the actual cost and charge for an individual shipment in Business Central.
See Freight cost analysis on screen
Real screens from Dynamic Ship, shown with demo data.
Details that matter on the floor
Cost and charge on every order
Dynamic Ship pairs the actual freight cost with the amount charged on every order, so the question of whether freight makes or loses money has a measured answer rather than an estimate.
Pricing rules you can check
A generous free-freight rule can reduce margin for months before anyone notices. Dynamic Ship Analysis shows that gap by customer, carrier, and region, so the rule can be corrected early.
Built on Business Central data
Dynamic Ship Analysis connects directly to the shipping and pricing data Dynamic Ship captures in Business Central.
Who uses Freight cost analysis
Operations managers and controllers
Check whether freight price rules are protecting margin across the customer base.
Shipping managers
Compare carrier and service-level costs when deciding which options to configure or recommend.
Supply chain analysts
Use customer, carrier, and regional trend data to spot patterns and forecast freight spend.
Customer service representatives
Look up the cost and charge behind a freight line when a customer questions it on an invoice.
Questions about Freight cost analysis
How does Dynamic Ship track freight profitability?
Dynamic Ship stores your actual carrier cost and the amount billed to the customer on every sales order freight line. Dynamic Ship Analysis rolls that data up into cost-versus-charge reports by customer, carrier, service level, and region, so you can see where shipping makes or loses money.
Does Dynamic Ship reconcile carrier invoices automatically?
No. Dynamic Ship does not import carrier electronic invoices or audit charges automatically. It captures your actual freight cost for each shipment and reports it through Dynamic Ship Analysis, so your team reviews spend and profitability directly.
Is Dynamic Ship Analysis included with Dynamic Ship?
Dynamic Ship Analysis is a separate, free companion app with its own Microsoft Marketplace listing. It is available to Dynamic Ship customers on Business Central online and is not available for Business Central on-premises. For licensing details, see the licensing FAQ.
Can I see freight cost and charge without Power BI?
Yes. The Freight Information report on the Insight Works License Plates list shows the actual cost and charge for an individual shipment directly in Business Central.
What does the profitability reporting break down by?
Customer, carrier, service level, and region, along with shipment frequency and spend trends over time. That lets you compare performance across each dimension instead of looking only at total freight spend.
Related Dynamic Ship features
All Dynamic Ship features →Part of Dynamic Ship
Easily add carrier integration, real-time shipping rates, package management and shipment tracking to Business Central.
Have a question about Freight cost analysis?
Send us a note and the Dynamic Ship team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.



