Chart of Accounts Table

Dynamics 365 Business Central/NAV Developers Forum
1

Hi,

I am very new to Navision (NAV 5.0 SP1) and am trying to extract the Chart of Accounts via the ODBC link to the SQL tables. Can anyone tell me what table I need to look at. ? I can see in the G/L Entry table all the G/L Codes that are used but need to be able to build the COA hierarcy.

Any help appreciated.

Thanks

Tom

2

Look for the G/L Account table. In SQL all Navision table names will have the company name as the first part of their name so ex:

“CRONUS International Ltd_$G_L Account”