Most distribution businesses know their overall gross margin. Fewer know their margin by product line, and fewer still know it by customer, channel or route.
That gap matters more than it seems. Without margin at that level, pricing, sales incentives, account investment and range decisions are all made without the commercial data they need.
Why Margin Visibility Is Poor in Distribution
Distribution makes margin hard to see. Large catalogues, supplier prices that move, customer-specific agreements, carrier costs that vary by zone and regular promotions all affect the margin on each sale. Spreadsheets and older systems tend to average these costs, which hides the detail that matters.
Margin also erodes quietly. A supplier increase is not passed on, delivery costs creep up, returns rise or a customer stretches its credit terms. Each change is small, but together they mean the business keeps investing in products and customers that earn less than it thinks.
What Dynamics 365 Business Central Captures That Makes Margin Visible
Dynamics 365 Business Central records the components of margin on every transaction: the selling price, any discounts, the cost of the goods sold and, where carrier costs are captured against orders, the cost of fulfilment. The challenge is turning that data into a view managers can use.
How accurate that cost is depends on how Business Central is set up. When goods are received, Business Central records an expected cost. The actual cost is confirmed when the supplier invoice is posted, and landed costs such as freight and duty are added as item charges. The adjust cost routine then updates the cost of goods already sold. If any of those steps is missing, margin reports will be wrong, which is why Advantage addresses cost configuration early in every implementation.
Building a Margin View with Power BI
Power BI connected to Business Central can show gross margin by product, category, customer and channel, refreshed on a schedule throughout the day rather than once a month when the management accounts arrive.
Commercial teams can see which lines earn their keep. Account managers can judge how profitable each account really is. The managing director can check whether past pricing decisions still hold.
Trend analysis is just as valuable. It shows margin slipping gradually, quarter by quarter, in a way the monthly accounts can easily miss.
Customer Profitability Is the Other Half of the Picture
Product margin tells you what each line earns. Customer profitability adds the cost of serving each customer. A high-revenue customer that places frequent small orders, demands urgent deliveries and returns goods can be worth less than a smaller customer that orders full pallets on a predictable schedule and pays on time.
Business Central holds most of the data needed: order frequency and value, credit days and returns. Delivery costs per customer are available where carrier costs are posted against orders, for example through carrier integration or item charges. Power BI can then combine this with product margin to show the true profitability of each account.
The Commercial Decisions That Become Possible
With margin visible by product and customer, you can target pricing reviews where they matter, link sales incentives to margin rather than revenue, rationalise the range on evidence and decide which accounts deserve more investment.
None of this needs a new strategy. It means applying the commercial judgement you already have to accurate data. For the wider reporting picture, see our guide to Power BI for logistics.
Talk to Our Logistics Team
If you cannot rely on your margin figures by product or customer, speak to our team about what Business Central and Power BI can provide for your business.
Contact Advantage today or call 020 3004 4600.
Related Resources
- Power BI Reporting and Dashboards
- Dynamics 365 Business Central
- Faster, Smarter Financial Control
- Power BI for Logistics: The 6 Dashboards That Replace Your Spreadsheets
- Signs Your Logistics Business Has Outgrown Its Current ERP
Frequently Asked Questions: Margin Visibility in Distribution
Why do distribution businesses often lack product-level margin visibility?
Large ranges, supplier prices that change, customer-specific pricing and variable delivery costs make margin hard to calculate line by line. Spreadsheets and older systems usually average these costs, which hides the products and customers that earn less than they appear to.
Which costing methods does Dynamics 365 Business Central support?
Business Central supports five costing methods: FIFO, LIFO, average, standard and specific. Most UK distributors use average or FIFO. LIFO is not permitted for financial reporting under UK accounting standards (FRS 102 and IAS 2), so UK businesses should not use it. The method can be set per item, so different product groups can use different methods.
Can Power BI show customer profitability as well as product margin?
Yes. Power BI can combine order data, product costs, delivery costs, credit days and returns from Business Central to show contribution margin and cost to serve by customer. Delivery costs per customer depend on carrier costs being posted against orders.
How long does it take to build a margin dashboard from Business Central data?
If costs are already configured correctly in Business Central, a margin dashboard can usually be built in a few weeks. It takes longer where cost setup needs fixing first, the range is very large or pricing agreements are complex.
