L O A D I N G
SAP B1 to Microsoft

SAP Business One to Dynamics 365 Migration UAE: Landing Your Data in Business Central

We move UAE companies from SAP Business One to Dynamics 365 Business Central, rebuilding posting logic, dimensions and VAT setup before a single record is imported.

Free consultation

Get a Free ERP Consultation

Tell us a little about your business. A consultant will reach out within one business day.

  • No obligation
  • Vendor-neutral advice
  • Your data stays private
Quick answer Updated October 2026 · Reviewed by UAE ERP Experts consultants

How do you migrate from SAP Business One to Dynamics 365 Business Central in the UAE?

Migrating from SAP Business One to Dynamics 365 Business Central in the UAE means rebuilding SAP B1 G/L account determination as Business Central posting groups, mapping profit centres and distribution rules to dimensions, and setting up UAE VAT posting and statement layouts before importing data. Loads use configuration packages and journals prepared from SAP B1 extracts, so they are repeatable and auditable.

  • Most SAP Business One users fit Business Central, which targets a similar company size.
  • Business Central has no dedicated assisted migration tool for SAP Business One.
  • VAT business and product posting groups combine into a VAT posting setup for each treatment.
  • Many SAP B1 accounts used only to split costs can be replaced by Business Central dimensions.

Why SAP B1 users look at Dynamics 365 Business Central

Most SAP Business One to Dynamics 365 migration projects in the UAE target Business Central, Microsoft's ERP for small and mid-sized companies. The two products sit in a similar segment, so finance teams recognize many concepts. The draw is usually the Microsoft environment: Outlook and Excel add-ins, Teams, Power BI reporting and Entra ID sign-in that the company already pays for through Microsoft 365.

The biggest structural change is how postings work. In SAP B1, G/L account determination decides which accounts a document hits. Business Central uses posting groups instead: general business and product posting groups, customer and vendor posting groups, inventory posting groups and VAT business and product posting groups combine in setup matrices. Getting those matrices right is the core of the migration, because every imported customer, vendor and item references them.

We are a Microsoft Partner for Dynamics 365 based in Dubai, and we do not implement SAP. For larger groups that may need Dynamics 365 Finance and Supply Chain Management instead of Business Central, we assess that during discovery. If you are still weighing options, read our Dynamics 365 vs SAP Business One comparison first.

Why SAP B1 users look at Dynamics 365 Business Central
  • SAP B1 G/L account determination rebuilt as Business Central posting groups
  • Profit centers and distribution rules mapped to dimensions
  • Configuration packages used for repeatable, auditable loads
  • UAE VAT posting setup and statement layout prepared before data import
The Challenge

Common sticking points from SAP B1 to Business Central

The products are close in scope, which can hide real differences. These are the ones we plan for.

Account determination versus posting groups

SAP B1 can determine accounts by item group, warehouse or business partner. Business Central needs those rules expressed as posting group combinations, and missing combinations stop documents from posting.

Dimensions design

SAP B1 supports up to five distribution rule dimensions. Business Central uses global and shortcut dimensions with dimension values on masters and lines, so the reporting structure must be agreed before journals are loaded.

Item tracking and costing

Batch and serial items need item tracking codes in Business Central, and the costing method per item (FIFO, average, standard and others) must be chosen and agreed with your auditors before opening stock is posted.

Multi-company consolidation

Groups running several SAP B1 company databases, perhaps one mainland and one free zone entity, need to decide on separate Business Central companies plus consolidation, and on intercompany setup.

Approval and alert logic

SAP B1 approval procedures and alerts are replaced by Business Central approval workflows and, where needed, Power Automate flows. The authority matrix should be simplified rather than copied.

Reports built on SAP B1 queries

Saved queries and Crystal layouts do not transfer. Management reports are usually rebuilt in Business Central account schedules (financial reports) or in Power BI.

Mapping SAP Business One data to Business Central

The main objects and the Business Central setup each depends on.

Mapping SAP Business One data to Business Central
SAP B1 sourceBusiness Central targetDepends onNote
OACT chart of accountsG/L AccountsAccount categories and income/balance typeLoad before posting groups
Account determinationGeneral and VAT posting setupBusiness and product posting groupsRebuilt by rule, not imported
OCRD customersCustomersCustomer, general business and VAT business posting groupsTRN in VAT Registration No.
OCRD vendorsVendorsVendor and VAT business posting groupsPayment terms and methods mapped
OITM itemsItemsInventory, general and VAT product posting groupsCosting method set per item
OBTN / OSRNItem tracking entries via item journalItem tracking codesLot expiry carried where used
OWHS / OBINLocations and binsWarehouse setup per locationDecide on basic or advanced warehousing
OPRC distribution rulesDimensions and dimension valuesGlobal and shortcut dimension setupDefault dimensions on masters
Open A/R invoicesCustomer journal opening entriesCustomer posting groupsKeep SAP B1 document number and due date
Open A/P invoicesVendor journal opening entriesVendor posting groupsOriginal currency and rate preserved
G/L balances at cut-offGeneral journal opening balanceDimensions on balance sheet accountsReconcile to SAP B1 trial balance

Business Central data is typically loaded with configuration packages (RapidStart) and journals. Field names follow current Business Central releases.

How It Works

Our SAP B1 to Dynamics 365 migration method

Setup first, data second, so each import lands on valid posting logic.

01

Design posting and dimensions

We document how SAP B1 determines accounts today and translate it into Business Central posting group matrices and a dimension plan your finance controller approves.

02

Build the company and VAT setup

We create the Business Central company with AED as local currency, VAT posting setup for standard-rated, zero-rated, exempt and reverse-charge cases, number series and approval workflows.

03

Prepare configuration packages

SAP B1 extracts are transformed into Business Central configuration packages, validated in a sandbox environment, and rerun until they import without errors.

04

Post opening balances

Open customer and vendor documents, stock with item tracking and G/L balances are posted through journals, then reconciled against SAP B1 reports at the same cut-off.

05

Cut over and connect Microsoft tools

We go live after a SAP B1 period close, then switch on Outlook integration, Excel editing and Power BI reports so users see the benefit in the first weeks.

What the SAP B1 to Dynamics 365 project delivers

Deliverables are documented so your team or any future partner can follow them.

  • Posting group design document showing each SAP B1 account rule and its Business Central equivalent
  • Dimension plan with default dimensions on customers, vendors and items
  • Configuration packages for every master and opening balance object
  • VAT posting setup and VAT statement lines for UAE return boxes, reviewed with your tax advisor
  • Reconciliation pack for trial balance, aged receivables, aged payables and inventory valuation
  • Approval workflows replacing SAP B1 approval procedures
  • Starter Power BI or financial report set replacing key SAP B1 reports
  • Archive of SAP B1 history kept outside Business Central
Implementation Timeline

Typical timeline for SAP Business One to Business Central

Ranges for a single company on standard Business Central. Groups and advanced warehousing take longer.

Durations are typical ranges; your plan is agreed after discovery.

  1. Discovery and design

    2-3 weeks

    Process review, posting and dimension design, history scope.

  2. Setup in sandbox

    2-4 weeks

    Company, VAT, posting groups, workflows and report layouts configured.

  3. Configuration packages and trial loads

    2-4 weeks

    Repeated loads until reconciliations match SAP B1.

  4. User acceptance testing

    1-2 weeks

    End-to-end testing of sales, purchasing, stock and close.

  5. Go-live and hypercare

    2-4 weeks

    Final load into production and support through the first month-end.

Business Central fixed asset ledger entries - asset current value analysis - SAP Business One to Dynamics 365 Migration UAE
Business Central fixed asset ledger entries - asset current value analysis (real product screenshot). Image: Microsoft (Microsoft Learn documentation), CC BY 4.0 from the official product documentation.
Dashboard Preview

Migration progress in Business Central terms

We report progress by configuration package and by reconciliation check.

  • Configuration package status: records, errors and applied
  • Missing posting group combinations found during test posting
  • Opening balance differences by G/L account and dimension
  • Inventory quantity and value by location versus SAP B1
  • Readiness checklist for production cut-over
UAE Compliance Built In

UAE regulations covered in every SAP Business One to Dynamics 365 Migration UAE project

We configure the system for the rules UAE businesses report against, and test it before go-live.

General information, not tax or legal advice. Confirm current requirements with the FTA, MOHRE or your advisor. See all UAE compliance guides.

Serving the UAE

SAP Business One to Dynamics 365 Migration UAE across all seven emirates

On-site workshops in Dubai, Abu Dhabi and Sharjah, and remote or on-site delivery across the Northern Emirates and free zones.

Official sources and references

Facts on this page were checked against these sources in October 2026. Rules change, so confirm current requirements before acting.

FAQs

SAP Business One to Dynamics 365 migration FAQs

Still have a question? Our consultants are happy to help.

Ask an Expert
Business Central or Dynamics 365 Finance after SAP Business One?

Most SAP B1 users fit Business Central, which targets a similar company size. Dynamics 365 Finance and Supply Chain Management suit larger groups with complex operations. We assess this in discovery rather than assuming.

Is there a built-in tool to migrate from SAP B1 to Business Central?

Business Central offers assisted migration for some Microsoft and third-party sources, but for SAP Business One we use configuration packages and journals prepared from SAP B1 extracts. This gives a controlled, repeatable load.

Can we keep our SAP B1 chart of accounts?

You can, but it is a good moment to simplify. Business Central relies on dimensions for analysis, so many SAP B1 accounts that only existed to split costs by department or branch can be merged and replaced by dimension values.

How is UAE VAT handled in Business Central?

VAT business and product posting groups combine into a VAT posting setup for each treatment, and the VAT statement is configured to align with your return boxes. We set this up with your tax advisor and test it on sample transactions.

Does Business Central support Arabic invoices?

Report layouts can be designed to show Arabic and English text on tax invoices. We build the layout during the project and test it with your actual customer data.

How long does SAP Business One to Dynamics 365 take?

A single-company move to Business Central often runs around 10-16 weeks. Multiple companies, manufacturing or advanced warehouse management extend that, and we confirm a plan after design.

Free Consultation

Map your SAP B1 posting logic to Business Central

Call +971 55 145 3265 or email contact@uaeerpexperts.com to start with a posting group and dimension design session.

Location

Dubai, United Arab Emirates

Free consultation

Send us your requirements

  • No obligation
  • Vendor-neutral advice
  • Your data stays private
Chat with an ERP expert