Introduction

In this post I’ve created a list of Dynamics GP tables and windows along with their Dynamics 365 Business Central counterparts. I’m hoping this will give any GP user venturing into BC a greater insight into how to navigate around Business Central and also which tables store the data. (I’ve included tables because us GP folk like to have a good nosy and understanding of things under the hood:))

At the moment this only includes General Ledger, Sales and Purchase information however I may add to the list in the future.

Please note the GP Window column lists the name of the window in GP. The BC Page column is the name of equivalent page in BC. Its also how you would search for the page in BC using the “Tell me” magnifying glass in the right hand corner of the Business Central screen.

General Ledger

Description	GP Table	GP Window	BC Table	BC Page
General Ledger Codes	GL00100 / GL00105	Account Maintenance	G/L Account (15)	Chart of Accounts
Unposted GL Journals	GL10000 / GL10001	Transaction Entry	Gen. Journal Line (81)	*General Journals
Posted / Open GL Journals	GL20000	Journal Entry Enquiry	GL Entry (17)	General Ledger Entries
History GL Journals	GL30000	Journal Entry Enquiry	GL Entry (17)	General Ledger Entries

* Please note General Journals, and any other journal for that matter, can be used to post a whole manner of GL, Sales and Purchasing Transactions in Business Central.

SOP / Sales Ledger

Description	GP Table	GP Window	BC Table	BC Page
Customer Master	RM00101	Customer Maintenance	Customer (18)	Customers
* Unposted RM Transaction	RM10301	Receivables Transaction Entry	Gen. Journal Line (81)	Sales Journals
Unposted RM Cash Receipt	RM10201	Cash Receipts Entry	Gen. Journal Line (81)	Cash Receipt Journal
Posted RM Trans	RM20101	Receivables Transactions Enquiry – Document	Cust. Ledger Entry (21)	Customer Ledger Entries
History RM Trans	RM30101	Receivables Transactions Enquiry – Document	Cust. Ledger Entry (21)	Customer Ledger Entries
Unposted SOP Trans	SOP10100 / SOP10200	Sales Transaction Entry	Sales Header (36) / Sales Line (37)	Sales Orders / Sales Invoices etc
Posted SOP Transactions	SOP30200 / SOP3030	Sales Order Processing Document Enquiry	Sales Invoice Header (112) / Sales Invoice Line (113)	Posted Sales Invoices / Posted Sales Credit Memos

* These type of invoices/credits can also be entered via “Sales Invoices” in BC using GL Codes rather than items.

POP / Purchase Ledger

Description	GP Table	GP Window	BC Table	BC Page
Vendor Master	PM00200	Creditor Maintenance	Vendor (23)	Vendors
*Unposted PM Transactions	PM10000	Payables Transaction Entry	Gen. Journal Line (81)	Purchase Journal
Unposted Payment	PM10300	Edit Vendor Payment	Gen. Journal Line (81)	Payment Journal
Unposted Manual Payment	PM10400	Payables Manual Payment Entry	Gen. Journal Line (81)	Payment Journal
Posted PM Transactions	PM20000	Payables Transaction Enquiry – Document	Vendor Ledger Entry (25)	Vendor Ledger Entries
Paid History PM Transaction	PM30200	Payables Transaction Enquiry – Document	Vendor Ledger Entry (25)	Vendor Ledger Entries
Work Purchase Orders	POP10100 / POP10110	Purchase Order Processing Document Enquiry	Purchase Header (38) / Purchase Line (39)	Purchase Orders
History Purchase Orders	POP30300 / POP30310	Purchase Order Processing Document Enquiry	Purchase Header Archive (5109) / Purchase Line Archive (5110)	**Purchase Order Archives

* These can also be entered via “Purchase Invoices” using GL Codes rather than items.

** Archive Orders must be switched on for completed purchase orders to be archived.

Please note there are no equivalent summary windows in Business Central. Totalling and summary values are maintained by Flowfields in Business Central rather than separate tables. See this post for more details.

Conclusion

This is far from a comprehensive list however I’m hoping it contains enough information for someone moving from GP to BC to get started. There are also many more windows in GP and BC that hold similar information, or different ways of displaying the same information. The ones displayed above are just the ones I’ve chosen.

Thanks for reading!