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!
The Dynamics Explorer 