Skip to main content

Dynamics GP to Business Central - Receivables & SOP Tables

 

When transitioning from Dynamics GP to Dynamics 365 Business Central, it’s crucial to understand how Receivables Management (RM) and Sales Order Processing (SOP) tables translate between the systems. These modules handle critical business processes such as customer invoicing, payments, and order fulfillment. Knowing the structure of these tables allows for accurate data migration, financial reconciliation, and report rebuilding.


RECEIVABLES TABLES

GP TableDescriptionBC TableBusiness Central Equivalent
RM00101Customer Master18Customer
RM00102Customer Addresses18
222		Customer Address
Ship-to Address List
RM00103Customer Master Summaryn/aBC calculates dynamically via ledger entries
RM00104Customer Period Summaryn/aNo direct table – use Customer Ledger Entry with date filters
RM00106Statement Email Addressesn/aDocument Sending Profile + Email Scenario
RM00201Customer Class Master1381Customer Template
RM00301Salesperson Master13Salesperson/Purchaser
RM00401RM Key File (doc index)n/aNo exact match – key logic is in Cust. Ledger Entry & Posted Sales Invoices
RM10101RM Distribution Work & Open37Sales Journal Line (open), or Sales Line in unposted docs
RM10201Work/Unposted Cash Receipts81Cash Receipt Journal Line or Gen. Journal Line
RM10301Work/Unposted Sales Trans36
37		Sales Header
Sales Line
RM10501Commissions Workn/aNo direct table – must be customized or handled via Job/Dim
RM20101Open Transactions21Cust. Ledger Entry – Open = TRUE
RM20201Open Transactions Apply379Cust. Ledger Entry + Detailed Cust. Ledg. Entry
RM30101Historical Transactions21Cust. Ledger Entry – Open = FALSE
RM30201Historical Transactions Apply379Detailed Cust. Ledg. Entry
RM30301Distribution History21Cust. Ledger Entry + Dimensions
RM30501Commissions Historyn/aNo out-of-box equivalent – requires customization
MC020102
Multicurrency Receivables Transactions
Cust. Ledger Entry with Currency Code / Currency Ledger Entry

SOP TABLES

GP TableDescriptionBC TableBusiness Central Equivalent
SOP10100Unposted Sales Transactions – Header36Sales Header
SOP10200Unposted Sales Transactions – Line Detail37Sales Line
SOP10101Commissions Work/Historyn/aNo direct match – requires customization or ISV
SOP10102GL Distributions250
92		Gen. Business Posting Group
Customer Posting Group
SOP10103Customer Payment Work/History81
21		Gen. Journal Line (Cash Receipt Journals)
Cust. Ledger Entry (History)
SOP10104Process Holdsn/aSales Document Status, Release Status – not stored in separate table
SOP10105


Sales Taxes


316
318
319
320
321
322
325
326		Tax Area Translation
Tax Area
Tax Area Line
Tax Jurisdiction
Tax Group
Tax Detail
VAT Posting Setup
Tax Setup
SOP10106User Defined Fields / Comments37Sales Comment Line (no user defined fields)
SOP10107Tracking Numbers111
6502		Item Tracking Line
Item Tracking Code
SOP10201Serial/Lot Numbers308Number Series for Serial/Lot Numbers
SOP10202Line Comments37Sales Comment Line – attached by line
SOP30200Posted Sales Transactions – Header21Customer Ledger Entry
SOP30300Posted Sales Transactions – Line21Customer Ledger Entry
SOP60100

SOP-POP Link


37
38
39		Drop Shipment Link (Create PO from Sales Order)
Sales Header
Sales Line
Purchase Line
SOP60300Customer Item Numbersn/aNo extra step to assign item numbers to customers
Item Cross Reference (Table 5717)


Labels:

Comments

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

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 t...
Post a Comment
Read more

Dynamics GP to BC - Migration Assessment

  Ready to Move from GP to BC?  Start Your Cloud Migration Journey Today https://bcmigrationassessments.com/ This website  is the online home for Microsoft’s Dynamics GP-to-Business Central Migration Assessment Tool . This tool is designed specifically to help organizations planning their move from Microsoft Dynamics GP (Great Plains) to Dynamics 365 Business Central in the cloud. 🔍 What It Does: Migration Readiness Scan: The tool connects to your existing GP SQL database to assess the data, modules, customizations, ISVs, and overall setup of your system. Risk & Complexity Insights: It analyzes the structure and identifies potential migration issues—such as unsupported customizations or problematic data formats—and offers suggestions to address them early. Migration Roadmap: You receive a personalized report outlining which companies/modules are ready to move, what data tables to migrate, and what steps (like testing or cleanup) will help ensure a smooth cloud ...
Post a Comment
Read more