Skip to main content

Bridging the Gap: Dynamics GP to Business Central Table Mapping

 


Last week, a Business Central developer asked me a simple yet important question: “What’s the customer table equivalent in Dynamics GP?” That moment sparked an idea.

As more technical professionals find themselves supporting both Dynamics GP and Business Central—or migrating entirely to the cloud—I realized how helpful a side-by-side table reference could be. 

I’ve always admired the work of Victoria Yudin, whose GP table list has been a go-to resource for the entire Dynamics GP community.  Although I’ve never met her in person (not even a photo!), her contributions have left a lasting impact on so many of us working with GP.

Inspired by her legacy, I decided to take it one step further by mapping those well-known GP tables to their Business Central equivalents. My hope is that this reference will serve as a bridge for those transitioning to Business Central

Whether you're mapping data, building reports, or just navigating unfamiliar territory, I hope this guide will make your GP-to-BC journey smoother and more insightful. Let’s dive in!

Here are the links:

System & Company Tables

General Ledger Tables

Receivables & Sales Order Processing (SOP)

Payables & Purchase Order Processing (POP)

Inventory Tables

Bank Reconciliation Tables

Fixed Assets Tables

Complete Business Central Table Information Page


Quick tutorial on how to find Dynamics GP Tables? 

Quick tutorial on how to find D365 Business Central Tables?

Comments

Popular posts from this blog

GP Assessment Tool

Migration Assessment :    Migration assessment (bcmigrationassessments.com) Microsoft official Documentation:    Migrate on-premises GP data to Business Central online overview - Business Central | Microsoft Learn

DUG Webinar: GP to Business Central - The Ultimate Beginner's Guide

  This event is produced in conjunction with Dynamics User Group (DUG) and its members. This session is designed to give you a head start in working with Business Central so you quickly feel at home in transitioning from Dynamics GP to BC without the hustle of reading through hundreds of pages of documentation. What you'll learn: Mastering the user interface of Business Central Navigating in Business Central Editing records in Business Central Creating new records in Business Central Finding records in Business Central Personalizing the user interface of Business Central Being prepared to work with Business Central on a daily basis Previous Blogs: D1: Understanding Database & Environments D2:   How to Create Environments D3: How to Create Companies D4: Overview License & Pricing D5: Overview Users & Security D6: My Home Page D7: Navigate in GP like BC? D8: My Playlist of Business Central  Microsoft Learn D9: Podcast - Navigating my Journey ...

DUG Webinar: Dynamics GP to Business Central - The Ultimate Beginner's Guide

This session is designed to give you a head start in working with Business Central so you quickly feel at home in transitioning from Dynamics GP to BC without the hustle of reading through hundreds of pages of documentation. What you'll learn: Mastering the user interface of Business Central Navigating in Business Central Editing records in Business Central Creating new records in Business Central Finding records in Business Central Personalizing the user interface of Business Central Being prepared to work with Business Central on a daily basis