Finance endpoints

The general ledger, chart of accounts, budgets, dimensions, posting setup, VAT groups and currencies — the basis of most financial reporting.

All URLs on this page are relative to the company URL, https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environment}/api/datawareness/endpoints/v1.0/companies({companyId})/. See Construction of the URL.

Master data

Endpoint	Description	Business key	Source table	Tier
chartOfAccountCategories	G/L account category definitions.	entryNo	G/L Account Category	Premium
chartOfAccounts	G/L accounts from the chart of accounts.	no	G/L Account	Free
countriesRegions	Country/region master data (ISO codes, EU membership, address format).	code	Country/Region	Premium
currencies	Currency master data.	code	Currency	Premium
currencyExchangeRates	Currency exchange rates by starting date.	currencyCode&&startingDate	Currency Exchange Rate	Premium
dimensions	Dimension definitions for financial analysis.	code	Dimension	Premium
dimensionSetEntries	Raw dimension set entries; one row per dimension on a dimension set.	dimensionSetId&&dimensionCode	Dimension Set Entry	Premium
dimensionValues	Values for each dimension used in analysis.	dimensionCode&&code	Dimension Value	Premium
genBusinessPostingGroups	General business posting group definitions.	code	Gen. Business Posting Group	Premium
generalPostingSetup	General posting setup with account mappings.	genBusPostingGroup&&genProdPostingGroup	General Posting Setup	Premium
glBudgets	G/L budget definitions.	name	G/L Budget Name	Premium
glSetup	General ledger setup including dimension codes and LCY.	primaryKey	General Ledger Setup	Premium
paymentTerms	Payment terms definitions.	code	Payment Terms	Premium
vatBusinessPostingGroups	VAT business posting group definitions.	code	VAT Business Posting Group	Premium
vatProductPostingGroups	VAT product posting group definitions.	code	VAT Product Posting Group	Premium

Transactional data

Endpoint	Description	Business key	Source table	Tier
glBudgetEntries	Budget entries for G/L accounts.	entryNo	G/L Budget Entry	Premium
glEntries	Posted general ledger entries.	entryNo	G/L Entry	Free
glItemLedgerRelations	G/L entry to value entry relations.	glEntryNo&&valueEntryNo	G/L - Item Ledger Relation	Premium

Example queries

G/L entries for a posting period

GET .../glEntries?$filter=postingDate ge 2026-01-01 and postingDate lt 2026-02-01
  &$select=entryNo,postingDate,documentNo,gLAccountNo,amount,dimensionSetID

Sum amount per gLAccountNo in your BI tool for a trial balance.

Chart of accounts

GET .../chartOfAccounts?$select=no,name,accountType,incomeBalance,accountCategory,totaling

Exchange rates for one currency

GET .../currencyExchangeRates?$filter=currencyCode eq 'USD'
  &$orderby=startingDate desc
  &$select=currencyCode,startingDate,exchangeRateAmount,relationalExchRateAmount

Dimension values behind G/L entries

GET .../dimensionSetEntries?$select=dimensionSetId,dimensionCode,dimensionValueCode

Join dimensionSetEntries.dimensionSetId to glEntries.dimensionSetID to get every dimension of an entry, not only the global and shortcut dimensions carried on the entry itself.

Tips

• Free tier: chartOfAccounts and glEntries are available without a Premium subscription.
• Dimensions: glSetup tells you which dimension codes are the global and shortcut dimensions 1–8, so you can label globalDimension1Code and friends. The relationships metadata carries this as a condition, for example dimensionCode=glSetup.globalDimension1Code.
• Fields: every endpoint's fields, with types, are listed by properties — see Metadata discovery. The same list is on the endpoint's page under BI Endpoints in Business Central.