Reset Filters

Microsoft Dynamics GP to Business Central

Simplify your move from Dynamics GP to Dynamics 365

Switching ERPs is hard, but eOne simplifies your Dynamics GP migration to Dynamics 365 Business Central. Our powerful migration tools provide a comprehensive data strategy, making the process easier and more cost-effective.

GP to BC Migration Hero

Migration-ready tools for all your data

01

Archive GP history, SmartLists, and Attachments

02

Map and move Master Data and Open Balances

03

Access Dynamics GP data in Dynamics 365 Business Central

04

Unlock full “SmartList” functionality + more in Dynamics 365 Business Central

See how eOne’s no-code toolset enables you to deliver GP cloud migrations on-time and on-budget.

Migrate to Microsoft Dynamics 365
Business Central with confidence.
Import Master Data
Integrate in Work-in-Progress Data
Archive & Access Historical Data

The GP “Master” tables

  • Customers
  • Contacts
  • Vendors
  • Items
  • Employees
  • Fixed Assets
  • Projects
  • Dirty Data That Needs Cleansing: Legacy Dynamics GP systems often contain old, inactive, or expired data that requires cleanup before migration.
  • Custom Extender or Add-On Data: Third-party tables used for custom Extender or Add-on data may be complicated to migrate.
  • Account Segments to Dimensions: Account segments in Dynamics GP transition to Dimensions in Dynamics 365 Business Central, requiring adjustments to how they link to master record cards.
  • Limitations of Microsoft’s Configuration Packages: These packages are difficult to customize and offer limited error-handling capabilities, making them challenging for complex migrations.
  • Standard Templates: Begin with a template that serves as a starting point and can be tailored to meet your unique requirements.
  • User-Friendly Review and Import: Empower users to extract all Dynamics GP data, review, and import data effortlessly, ensuring only required data is migrated.
  • Comprehensive Data Handling: eOne’s tools excel at managing the details, including bulk imports to multiple tables in Dynamics 365 Business Central, while ensuring relationships, lookups, and data transformations are handled seamlessly.
  • Error Management Made Simple: Easily view and fix errors, then reprocess failed imports in real time, ensuring a smooth migration experience.
  • Customers
  • Contacts
  • Vendors
  • Items
  • Employees
  • Fixed Assets
  • Projects
  • Dirty Data That Needs Cleansing: Legacy Dynamics GP systems often contain old, inactive, or expired data that requires cleanup before migration.
  • Custom Extender or Add-On Data: Third-party tables used for custom Extender or Add-on data may be complicated to migrate.
  • Account Segments to Dimensions: Account segments in Dynamics GP transition to Dimensions in Dynamics 365 Business Central, requiring adjustments to how they link to master record cards.
  • Limitations of Microsoft’s Configuration Packages: These packages are difficult to customize and offer limited error-handling capabilities, making them challenging for complex migrations.
  • Standard Templates: Begin with a template that serves as a starting point and can be tailored to meet your unique requirements.
  • User-Friendly Review and Import: Empower users to extract all Dynamics GP data, review, and import data effortlessly, ensuring only required data is migrated.
  • Comprehensive Data Handling: eOne’s tools excel at managing the details, including bulk imports to multiple tables in Dynamics 365 Business Central, while ensuring relationships, lookups, and data transformations are handled seamlessly.
  • Error Management Made Simple: Easily view and fix errors, then reprocess failed imports in real time, ensuring a smooth migration experience.

The GP “Unposted/Work” tables

  • Open sales transactions
  • Open payables transactions
  • Unreconciled bank transactions
  • Items in transit
  • GL beginning balance/net change
  • Partially Processed Transactions: Some transactional data may be incomplete during migration, such as orders that have been shipped but remain unpaid under payment terms.
  • Changes to Related Master Data: Master data, such as customer or vendor records, may require updated identifiers to align with Dynamics 365 Business Central’s structure.
  • Allocation Adjustments: Dynamics GP’s distributions need to be transitioned into General Ledger (GL) lines in Dynamics 365 Business Central, which may involve reconfiguring allocation rules.
  • Phased Migration Approach: Migrating all GP companies simultaneously may not always be feasible, requiring a phased approach to transition one company at a time while minimizing disruption.
  • Standardized Import Approach: Streamline your process with a consistent method to handle all imports efficiently.
  • Controlled Data Migration: Migrate only the data you need, such as open transactions, to start fresh in Dynamics 365 Business Central without unnecessary bulk.
  • Simple Relationship Maintenance: Join Dynamics GP tables ensuring relationships between records are preserved, when importing to Dynamics 365 Business Central.
  • Multi-Company Data Management: Easily migrate, consolidate, or split companies during the transition process.
  • Error Handling Made Easy: When errors occur, use an intuitive interface to view, resolve, and reprocess them immediately, keeping your migration on track.
  • Open sales transactions
  • Open payables transactions
  • Unreconciled bank transactions
  • Items in transit
  • GL beginning balance/net change
  • Partially Processed Transactions: Some transactional data may be incomplete during migration, such as orders that have been shipped but remain unpaid under payment terms.
  • Changes to Related Master Data: Master data, such as customer or vendor records, may require updated identifiers to align with Dynamics 365 Business Central’s structure.
  • Allocation Adjustments: Dynamics GP’s distributions need to be transitioned into General Ledger (GL) lines in Dynamics 365 Business Central, which may involve reconfiguring allocation rules.
  • Phased Migration Approach: Migrating all GP companies simultaneously may not always be feasible, requiring a phased approach to transition one company at a time while minimizing disruption.
  • Standardized Import Approach: Streamline your process with a consistent method to handle all imports efficiently.
  • Controlled Data Migration: Migrate only the data you need, such as open transactions, to start fresh in Dynamics 365 Business Central without unnecessary bulk.
  • Simple Relationship Maintenance: Join Dynamics GP tables ensuring relationships between records are preserved, when importing to Dynamics 365 Business Central.
  • Multi-Company Data Management: Easily migrate, consolidate, or split companies during the transition process.
  • Error Handling Made Easy: When errors occur, use an intuitive interface to view, resolve, and reprocess them immediately, keeping your migration on track.

The GP “Posted/History” tables

  • General Ledger (GL) transaction history
  • Time/Expense transaction history
  • Historical/Paid transactions
  • Serial/Lot history
  • Notes
  • Document Attachments
  • High Costs of Migrating All History: Moving all Dynamics GP historical data to Dynamics 365 Business Central is costly and not typically recommended.
  • Decreased User Productivity: Switching between multiple applications to access historical data is inefficient and increases costs.
  • Reporting Complexities: Consolidating reports between Dynamics GP history tables and Dynamics 365 Business Central posted transaction tables is challenging and time-consuming.
  • Add-On Compatibility Issues: Not all of Dynamics GP Add-ons have equivalent Business Central Extensions, leading to inconsistent data structures.
  • Security and Compliance Risks: Dynamics GP will become unsupported by Microsoft in 2029.
  • Secure and Cost-Effective Archiving: Archive all historical Dynamics GP data and attachments in a secure, cost-effective data lake, eliminating the need for expensive on-premise server maintenance.
  • Seamless Data Access: Access your Dynamics GP data and SmartLists directly from a Dynamics 365 Business Central Role Center or card page, keeping historical information at your fingertips.
  • Eliminate Legacy Infrastructure: Retire outdated servers and related technology, saying goodbye to the infrastructure of the past.
  • Consolidated Reporting Made Easy: Empower power users to create consolidated SmartLists that combine Dynamics GP and Business Central data in a single, unified list.
  • Audit Compliance Simplified: Ensure audit compliance with full historical data access and easy Excel exports for reporting and verification.
  • General Ledger (GL) transaction history
  • Time/Expense transaction history
  • Historical/Paid transactions
  • Serial/Lot history
  • Notes
  • Document Attachments
  • High Costs of Migrating All History: Moving all Dynamics GP historical data to Dynamics 365 Business Central is costly and not typically recommended.
  • Decreased User Productivity: Switching between multiple applications to access historical data is inefficient and increases costs.
  • Reporting Complexities: Consolidating reports between Dynamics GP history tables and Dynamics 365 Business Central posted transaction tables is challenging and time-consuming.
  • Add-On Compatibility Issues: Not all of Dynamics GP Add-ons have equivalent Business Central Extensions, leading to inconsistent data structures.
  • Security and Compliance Risks: Dynamics GP will become unsupported by Microsoft in 2029.
  • Secure and Cost-Effective Archiving: Archive all historical Dynamics GP data and attachments in a secure, cost-effective data lake, eliminating the need for expensive on-premise server maintenance.
  • Seamless Data Access: Access your Dynamics GP data and SmartLists directly from a Dynamics 365 Business Central Role Center or card page, keeping historical information at your fingertips.
  • Eliminate Legacy Infrastructure: Retire outdated servers and related technology, saying goodbye to the infrastructure of the past.
  • Consolidated Reporting Made Easy: Empower power users to create consolidated SmartLists that combine Dynamics GP and Business Central data in a single, unified list.
  • Audit Compliance Simplified: Ensure audit compliance with full historical data access and easy Excel exports for reporting and verification.

Data migration requires more depth.
See how we’re different and cover more.

Feature

eOne’s iPaaS

Microsoft’s Configuration Packages

Microsoft’s Cloud Migration Tool

View errors, fix and retry

Checked
Checked
Checked

Historical GP snapshot data 

Access to view and drill-down into GP history tables

Checked
unchecked
Checked

Simple point-click, flexible mapping

Checked
Checked
unchecked

Support for customizations

Including custom and 3rd-party add-ons in both Dynamics GP and Dynamics 365 Business Central

Checked
Checked
unchecked

Pre-migration data cleansing option

Allow users to manipulate data in Excel before migrating it into Dynamics 365 Business Central

Checked
Checked
unchecked

Support for multiple ERPs

Multiple Dynamics GP environments or other ERP databases

Checked
Checked
unchecked

No firewall configuration required

A self-hosted Integration Runtime requires externally facing service for Azure Data Factory access

Checked
Checked
unchecked

Full backup of GP database

Every standard and custom table in the Dynamics and company databases

Checked
unchecked
unchecked

Real-time error reports

Checked
unchecked
unchecked

Files & attachments

Checked
unchecked
unchecked

Life-to-date reports

View all historical and new data from a single list

Checked
unchecked
unchecked

Essential support plan

Checked
unchecked
unchecked

eOne’s iPaaS

View errors, fix and retry

Checked

Historical GP snapshot data 

Access to view and drill-down into GP history tables

Checked

Simple point-click, flexible mapping

Checked

Support for customizations

Including custom and 3rd-party add-ons in both Dynamics GP and Dynamics 365 Business Central

Checked

Pre-migration data cleansing option

Allow users to manipulate data in Excel before migrating it into Dynamics 365 Business Central

Checked

Support for multiple ERPs

Multiple Dynamics GP environments or other ERP databases

Checked

No firewall configuration required

A self-hosted Integration Runtime requires externally facing service for Azure Data Factory access

Checked

Full backup of GP database

Every standard and custom table in the Dynamics and company databases

Checked

Real-time error reports

Checked

Files & attachments

Checked

Life-to-date reports

View all historical and new data from a single list

Checked

Essential support plan

Checked

Microsoft’s Configuration Packages

View errors, fix and retry

Checked

Historical GP snapshot data 

Access to view and drill-down into GP history tables

unchecked

Simple point-click, flexible mapping

Checked

Support for customizations

Including custom and 3rd-party add-ons in both Dynamics GP and Dynamics 365 Business Central

Checked

Pre-migration data cleansing option

Allow users to manipulate data in Excel before migrating it into Dynamics 365 Business Central

Checked

Support for multiple ERPs

Multiple Dynamics GP environments or other ERP databases

Checked

No firewall configuration required

A self-hosted Integration Runtime requires externally facing service for Azure Data Factory access

Checked

Full backup of GP database

Every standard and custom table in the Dynamics and company databases

unchecked

Real-time error reports

unchecked

Files & attachments

unchecked

Life-to-date reports

View all historical and new data from a single list

unchecked

Essential support plan

unchecked

Microsoft’s Cloud Migration Tool

View errors, fix and retry

Checked

Historical GP snapshot data 

Access to view and drill-down into GP history tables

Checked

Simple point-click, flexible mapping

unchecked

Support for customizations

Including custom and 3rd-party add-ons in both Dynamics GP and Dynamics 365 Business Central

unchecked

Pre-migration data cleansing option

Allow users to manipulate data in Excel before migrating it into Dynamics 365 Business Central

unchecked

Support for multiple ERPs

Multiple Dynamics GP environments or other ERP databases

unchecked

No firewall configuration required

A self-hosted Integration Runtime requires externally facing service for Azure Data Factory access

unchecked

Full backup of GP database

Every standard and custom table in the Dynamics and company databases

unchecked

Real-time error reports

unchecked

Files & attachments

unchecked

Life-to-date reports

View all historical and new data from a single list

unchecked

Essential support plan

unchecked

Maximize user adoption in
Dynamics 365 Business Central.

Modern SmartList Functionality

Keep existing SmartLists and build even more with Dynamics 365 Business Central

Access your existing Dynamics GP SmartLists and create new ones effortlessly with Popdock’s intuitive web interface. Take advantage of advanced filtering, cross-company reporting, and dimensional segmentation. Users can build and run ad-hoc reports across all your Dynamics data with ease.

BC query builder graphic

Embedded GP Data

Access Dynamics GP data where your team works

Keep your team focused without the need to switch tabs or systems. Popdock enables you to embed Dynamics GP data (and more) directly within Dynamics 365 Business Central FastTabs and FactBoxes, delivering context sensitive information without the need for manually filtering.

BC data can be viewed in other systems

Virtual Integration

Unite teams by sharing SmartLists with non-Dynamics Business Central users

Break down operational data silos by sharing SmartLists with users outside Dynamics 365 Business Central. Popdock empowers sales and help desk teams with a real-time view of Business Central transactions, complete with related details, drill-downs, and actionable insights. This seamless access ensures your entire organization stays informed.

GP data embedded on a BC page

Custom Integration-Ready Tools

Say “Yes” to ongoing integrations

Migrating to a new ERP means new integration opportunities. The SmartConnect low-code platform, a trusted solution for Dynamics GP integration, continues to deliver. Use the same powerful tool to connect your new Dynamics 365 Business Central with your CRM, eCommerce platforms, expense management systems, and third-party APIs effortlessly.

Say yes to BC integrations

Transform your migration strategy and scale faster with eOne today