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)


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