Setup page · General ledger
Ledger
The ledger captures a legal entity's main accounts in a defined structure and represents its general ledger.
- Used by
- Accountant, Accounting manager, Accounting supervisor and 6 more roles
- Business process
- Configure the ledger for a single company in Dynamics 365 Finance
- Menu item
Ledger- Main table
Ledger- Data entity
VendPaymentBIAccountingToSystemExchRate- Setup steps
- 1 on this page
Show what matters for
Everyone
1What it is and why
| What it is | The ledger captures a legal entity's main accounts in a defined structure and represents its general ledger. |
|---|---|
| What you do here | Used to configure each legal entity's ledger: chart of accounts and account structures, fiscal calendar, and accounting and reporting currencies. |
| Example | For example, a legal entity whose ledger uses US dollars as the accounting currency and euros as the reporting currency can still enter transactions in Canadian dollars. |
Functional consultant · Solution architect
2Where it fits
End user · Functional consultant
3How to do it
Step by step, with screenshots
Set up Ledger1 screen
Used to configure each legal entity's ledger: chart of accounts and account structures, fiscal calendar, and accounting and reporting currencies.
Screen 1
Set up the ledger
Go to General ledger > Ledger setup > Ledger
- Select Edit and choose the chart of accounts
- On the Account structures FastTab, select Add and choose the account structure
- On the Currency FastTab, set the accounting currency
1Chart of accounts BEAT 2Accounting currency USD 3Account structure BEAT-MAIN 
Show the full screen
page title tab to open what to set or check
Microsoft's steps
- Go to General ledger > Ledger setup > Ledger.
- Select the chart of accounts for the legal entity.
- In the Account structures section, select Add, choose an active account structure, and then select Select.
- Select the fiscal calendar.
- Enter the accounting currency, and a reporting currency if you need one.
- Select the Accounting currency exchange rate type, and the reporting currency and budget exchange rate types if they are used.
- On the Accounts for currency revaluation FastTab, enter the realized and unrealized gain and loss accounts.
- Optionally, select a balancing financial dimension.
Source: Microsoft Learn ↗
Field guide
| Field | What it means | Worked example | Table column |
|---|---|---|---|
| Accounting currency | The legal entity's main currency, shown in the general ledger on every voucher.Microsoft Learn ↗ | USD | AccountingCurrency |
| Reporting currency | An optional second currency in which every transaction is also recorded.Microsoft Learn ↗ | — | ReportingCurrency |
| Accounting currency exchange rate type | The rate type used to convert transaction amounts into the accounting currency.Microsoft Learn ↗ | — | — |
| Budget exchange rate type | The rate type used to convert budget transactions between currencies.Microsoft Learn ↗ | — | BudgetExchangeRateType |
| Fiscal calendar | The calendar the legal entity posts in; without one, transactions can't be posted.Microsoft Learn ↗ | — | FiscalCalendar |
| Accounts for currency revaluation | The default realized and unrealized gain and loss accounts, used when no account is set for the currency.Microsoft Learn ↗ | — | — |
| Balancing financial dimension | An optional dimension that must balance in every entry; it must exist in all the ledger's account structures.Microsoft Learn ↗ | — | — |
| Chart of accounts | — | BEAT | ChartOfAccounts |
| Account structure | — | BEAT-MAIN | — |
Functional consultant
4Setup decisions
| Setup step | Recommended value and why | Decision · common mistake · test |
|---|---|---|
| Set up Ledger | — | — |
Solution architect
5Design impact
| Shared or per company | — |
|---|---|
| Can it be undone | — |
| Feature or country | — |
| If you change it later | The chart of accounts can't be changed once transactions are posted in the legal entity. Adding or changing account structures updates all unposted transactions, and changing the fiscal calendar after posting requires Recalculate ledger periods. Microsoft Learn ↗ |
Technical architect
6Technical
| Menu item | Ledger Checked in Dynamics 365 |
|---|---|
| Form | Ledger Checked in Dynamics 365 |
| Table | LedgerShown as “Ledger” in Record infoKey field: NameChecked in Dynamics 365 |
| Data entities | VendPaymentBIAccountingToSystemExchRateVendor accounting to system currency exchange rates Microsoft data model ↗LedgerEntityLedger Microsoft data model ↗ |
| Who can open it | PrivilegesMaintain calendars for use with ledgers, fixed assets, and budgets LedgerMaintainaccount reference -ViewLedgerShowReferences: LedgerViewDutiesEnable budget process BudgetBudgetProcessEnableEnable general ledger process LedgerGeneralLedgerProcessEnableInquire into general ledger reference data LedgerGeneralLedgerReferenceDataInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnable9 security rolesBudget managerBudgetBudgetManagerChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManager |
| Actions on the page | Buttons: Ledger calendar, Recalculate ledger periods, Change chart of accountsChecked in Dynamics 365 |
Developer
7Developer
| Open it directly | https://<your-environment>/?mi=Ledger |
|---|---|
| Integrate with | VendPaymentBIAccountingToSystemExchRate data entity Microsoft data model ↗ |
| Table definition | Ledger columns and relations Microsoft data model ↗ |
Everyone
8Sources and checks
- learn.microsoft.com/dynamics365/finance/general-ledger/ledger-subledger
- learn.microsoft.com/dynamics365/finance/general-ledger/configure-ledger
- learn.microsoft.com/dynamics365/finance/general-ledger/plan-chart-of-accounts
- Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page, the demo records and the values in the screenshots.