Dynamics GP to Business Central - General Ledger Tables

 

The General Ledger (GL) is the financial backbone of any ERP system, and both Dynamics GP and Business Central rely heavily on structured GL tables to store core financial data. Understanding how GL tables work—and how they differ between the two systems—is essential when migrating, reconciling financial records, or building custom reports.

GP Table	GP Description	BC Table	Business Central Equivalent
Account and Segment Master Tables
GL00100	Account Master	15	G/L Account
GL00102	Account Category Master	570	G/L Account Category
GL00105	Account Index Master	n/a	Not needed in BC – uses direct account no. (No separate index)
GL40200	Segment Description Master	348 349 350 351 352 354 356 388 1002	BC uses Dimensions instead of segments. Dimension Dimension Value Dimension Combination Dimension Value Combination Default Dimension Default Dimension Priority Dim. Value per Account Dimension Translation Job Task Dimension
Budget Tables
GL00200	Budget Master Header	95	G/L Budget Name
GL00201	Budget Master Detail	95	G/L Budget Entry, with filters by account and period
General Ledger Transactions
GL10000	GL Work Header	81	Gen. Journal Line - Uses Batch Name as logical header
GL10001	GL Work Line	81	Gen. Journal Line - Each line is a separate entry
GL20000	Open Year Transactions - Posted transactions	17	G/L Entry Page: General Ledger Entries
GL30000	Historical Year - Posted transactions (closed years)	17	Same as above: G/L Entry – no separation by open/closed
Multicurrency & MDA
MC00200	Multicurrency Account Master	4	BC has Currency setup at G/L Account + Journal Level Currency (Table 4), and settings per G/L Account Card
DTA10100	MDA Groups	348	BC uses Dimensions
DTA10200	MDA Codes	349	Dimension Value
Dynamics GP Summary Views to Business Central Equivalents
GL01201 – Budget Summary Master View		95	G/L Budget Entry + Join to G/L Account (Table 15) for Description
GL11110 – Open Year Summary View		n/a	No direct table – use Account Schedule KPI Web Service, or build query from: - G/L Entry (Table 17) - G/L Account (Table 15) - Accounting Period (Table 50)
GL11111 – Historical Year Summary View		n/a	Same as above; BC does not split open/historical years. Use posting date filters