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

D365 Business Central - Table Information Page

Whether you're a Business Central power user, consultant, or developer, sometimes you just want a quick look under the hood of your environment. That’s where Table Information comes in—a hidden gem in Business Central that gives you insight into what’s happening behind the scenes. Why Use the Table Information Page? Understanding what tables are being used, how large they are, and how many records they contain is especially helpful when: Diagnosing performance issues Cleaning up test or training environments Estimating storage impact Reviewing customizations or ISV extensions Step-by-Step: How to Access Table Information Here’s how you can view detailed info about every table in your current company: Go to “Tell Me” Search Press Alt + Q or click the magnifying glass 🔍 in the upper-right corner. Type: “Table Information” Select the Table Information page from the search results. Explore the Page You’ll see a list of all tables...

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

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

Cecile's D365 Business Central Online Blog

Search This Blog