Case Study

NetSuite to Microsoft Dynamics 365 Business Central Migration for a Multi-Country Distributor

How Traffi Replaced NetSuite OneWorld with Microsoft Dynamics 365 Business Central to Unite Finance, Warehousing and Reporting Across Four Countries

  • B2B Safety Clothing
  • UK, Italy, US & Canada
  • Multiple Legal Entities
Client Story

A Crux of the Case Story

Traffi, a B2B safety clothing business operating in the UK, Italy, the US and Canada, wanted to leave NetSuite OneWorld and consolidate on the Microsoft platform it already used every day. Its finance, warehouse and reporting tools sat in separate systems, and Power BI was difficult to connect to NetSuite. Dynamics Square planned a migration to Microsoft Dynamics 365 Business Central, timed to go live before the NetSuite contract ended.

Business Overview

Traffi sells safety clothing to business customers across four countries. The UK operation fulfils orders from its own warehouse, while Italy, the US and Canada use third-party logistics providers. Trading between the entities creates regular intercompany transactions.

The business processes around 500 to 700 sales orders and 20 to 30 purchase orders a month. Its catalogue is focused: around 60 active products, each in five sizes. Pricing combines price bands with customer-specific prices.

Traffi ran on NetSuite OneWorld. Around it sat a separate warehouse management system and a standalone BI tool, so data lived in several places. Connecting Power BI to NetSuite proved difficult, which limited the reporting the team could build.

The company already used Microsoft 365 across the business and wanted its ERP to sit on the same platform. Its CRM, HubSpot, was heavily customised to the way the sales team works and was staying in place.

With the NetSuite contract due to end in July 2026, Traffi had a fixed deadline. Leadership was clear that the priority was not the lowest price, but a capable partner with UK-based support.

Traffi UK business overview

What are The
Business Challenges

Finance, warehousing and BI ran in separate, disconnected systems.

Power BI was difficult to integrate with NetSuite.

The ERP sat outside the Microsoft 365 environment the business used every day.

Four countries brought different tax rules, including VAT, US sales tax and Canadian HST.

Intercompany trading between entities added complexity to finance.

Warehouse processes in the UK needed better mobile tools and container tracking.

Sales performance and cash flow reporting required manual effort.

A fixed NetSuite contract end date left no room for an extended project.

The organisation needed a single, modern ERP that fitted its Microsoft environment and could support growth across four countries.

What the Business Needed

Traffi UK NetSuite to Business Central migration requirements
  • One ERP platform for finance, warehousing and reporting.
  • Localised finance for the UK, Italy, the US and Canada.
  • Clean handling of intercompany transactions.
  • Mobile warehouse management for the UK warehouse.
  • Power BI connected directly to ERP data.
  • Continued integration with the existing HubSpot CRM.
  • Support for price bands and customer-specific pricing.
  • A partner with UK-based support and a delivery plan that met the contract deadline.

The goal was not simply to replace NetSuite, but to bring the whole operation onto one connected Microsoft platform.

Business Objectives

Traffi set clear objectives for the migration:

Move from NetSuite OneWorld to Microsoft Dynamics 365 Business Central.

Deliver finance, accounts payable, accounts receivable and warehouse management in phase one.

Set up separate localised companies for each country.

Connect Power BI for financial, sales and cash flow reporting.

Keep HubSpot in place and integrated with Business Central.

Go live before the NetSuite contract ended in July 2026.

Traffi UK NetSuite to Business Central migration

Solutions Proposed by Dynamics Square

Dynamics Square recommended Microsoft Dynamics 365 Business Central rather than Finance and Operations, matching the platform to Traffi’s size and order volumes. The project was run using the Microsoft Sure Step methodology, led by a principal solution architect and a dedicated project manager, with a steering committee and clear escalation path on both sides. Phase one was scoped to go live before the NetSuite contract ended.

Finance Across Multiple Legal Entities

  • Set up Business Central for multiple legal entities, each with its own chart of accounts, fiscal periods, currencies and VAT handling.
  • Configured journals, recurring and reversal journals, deferrals, budgets, cost accounting and cash flow functions.
  • Delivered fixed assets, bank management with automatic reconciliation matching, and financial reporting by dimension.
  • Set up intercompany sales between entities, with dedicated reporting.
  • Applied permissions and approval workflows across finance processes.

Procure-to-Pay and Order-to-Cash

  • Vendor management with approval workflows, purchase order approvals and receipt tracking for under- and over-supply.
  • Suggested vendor payments and payment approval workflows, including multi-currency payments to the same vendor.
  • Customer management with approval workflows, sales price and discount management, and credit limit approvals.
  • Sales orders, shipments, delivery notes, returns and credit memos, with on-demand emailing of documents.
  • Purchase and sales analysis reports, including top 10 vendors, top customers and sales trends by customer group.

Warehouse Management with Tasklet

  • Implemented locations, transfers, replenishment policies and physical inventory processes.
  • Set up warehouse receipts, put-aways, picks, shipments and movements for the UK warehouse.
  • Added Tasklet WMS for mobile scanning and warehouse tasks.
  • Delivered inventory ageing, valuation and stock movement reporting.

Import Container Tracking

  • Recorded bill of lading details, document checklists and attachments for each import consignment.
  • Linked containers to purchase order and transfer order lines, including split lines, pallets, weights and freight.
  • Updated expected receipt dates on linked orders automatically when a container’s ETA changes, while keeping the original dates for comparison.
  • Updated shipment dates on reserved sales order lines automatically.
  • Added dashboard tiles showing containers due at port this week and next, and sales orders whose shipment dates changed recently.

Automation Add-Ons

HubSpot Integration and Power BI

  • Integrated Business Central with the existing HubSpot CRM to synchronise customers, quotes, orders and financial information.
  • Built Power BI reports for sales performance and cash flow forecasting.

Data Migration and UK-Based Support

  • Migrated three years of history from NetSuite: monthly trial balances, sales orders, purchase orders and sales invoices, using custom history tables in Business Central.
  • Provided UK-based project leadership and support, a key selection requirement.

Results and Impact: What This Transformation Means

The migration gives Traffi one connected platform for finance, warehousing and reporting across four countries.

Finance for the UK, Italy, the US and Canada runs on a single Microsoft platform.

Intercompany transactions are handled within Business Central.

The UK warehouse uses mobile scanning for faster, more accurate picking.

Inbound containers are tracked against purchase orders, with order dates updating automatically when arrival dates change.

Power BI reports draw directly from ERP data.

HubSpot and Business Central share customer and order information.

The business is no longer tied to NetSuite contract renewals.

Why This Case Matters and Future Prospects

Many growing distributors adopt NetSuite early, then find that their reporting and day-to-day tools live elsewhere. For businesses that already run on Microsoft 365, moving the ERP onto the same platform removes a layer of integration work and makes reporting far simpler.

Traffi’s migration also shows the value of matching the platform to the business. Dynamics 365 Finance and Operations was not needed; Business Central covered multi-country finance, intercompany trading and warehousing at the right scale and cost.

The next phase of the journey is already defined:

  • Advanced Power BI forecasting.
  • Further automation of intercompany processes.
  • Deeper integration between HubSpot and Business Central.
  • Additional Business Central modules as the business expands.
  • Ongoing UK-based support and optimisation.

With its operations on one platform, Traffi can grow into new markets without adding new systems.

Business consultant

Consult To Reveal Best Approach

Connect with us to facilitate your system to drive a parallel approach in the market you deal with. We help enterprises to implement their unique needs.

Let’s build the future of your business—together!

The right technology can change everything, and Dynamics Square ensures your business gets the tools it needs to succeed. Take the first step towards smarter solutions now!

Phone