BeyondERP.Subscribe

Setup page · General ledger

Main accounts

The list page of main accounts, the accounts that make up a chart of accounts.

Used by
Accountant, Accounting manager, Accounting supervisor and 8 more roles
Business process
Develop chart of accounts strategy
Menu item
MainAccountDetails
Main table
MainAccount
Data entity
DimAttributeMainAccountEntity
Setup steps
1 on this page
Show what matters for

Everyone

1What it is and why

What it isThe list page of main accounts, the accounts that make up a chart of accounts.
What you do hereUsed to add main accounts with a main account type, category, default currency, legal entity overrides, and financial reporting exchange rate settings.
ExampleAssign a main account category so that the account is used on the default financial reports and Power BI content.
Main accounts page in Dynamics 365
The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business processDefine accounting policies › Develop chart of accounts strategy
Menu pathGeneral ledger › Chart of accounts › Accounts › Main accounts
Set up firstChart of accounts Microsoft Learn ↗Main account categories Microsoft Learn ↗Exchange rate types Microsoft Learn ↗
Used next byYear end close Microsoft Learn ↗
Related pagesMain account categories Microsoft Learn ↗Balance control accounts Microsoft Learn ↗

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Main accounts1 screen

Used to add main accounts with a main account type, category, default currency, legal entity overrides, and financial reporting exchange rate settings.

  1. Screen 1

    Create the main account

    Go to General ledger > Chart of accounts > Accounts > Main accounts

    1. Select New
    2. Enter the main account number and name
    3. Set the main account type
    1Main account110100
    2NameAtlas test cash clearing
    3Main account typeAsset
    Create the main account (zoomed on the outlined fields)
    Show the full screenCreate the main account
    page title tab to open what to set or check

Microsoft's steps

  1. Go to General ledger > Chart of accounts > Accounts > Main accounts.
  2. Select New.
  3. In the Main account field, enter the account number.
  4. In the Name field, enter a name.
  5. In the Main account type field, select the type that matches the account's balance and place on financial statements.
  6. Select the main account category the account belongs to.
  7. Change the default debit or credit balance if needed.
  8. In the Default currency field, select a currency.
  9. In the Legal entity overrides section, add legal entities and select Suspended where the account must not be used.
  10. In the Financial reporting section, select the Exchange rate type and the Currency translation type.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Main account typeDecides whether the balance is carried forward as an opening balance or closed into retained earnings at year end.Microsoft Learn ↗Asset—
Main account categoryThe more detailed group the account belongs to, used by default financial reports and Power BI content.Microsoft Learn ↗——
DB/CR requirementRestricts the account to debit-only or credit-only postings, checked when journal lines are validated and posted.Microsoft Learn ↗—DebitCreditCheck
Do not allow entryStops users from entering the account by hand on a journal line.Microsoft Learn ↗——
SuspendedBlocks all postings to the account.Microsoft Learn ↗——
Legal entity overridesLists the companies where the account is suspended, its owner, and the period when it is active.Microsoft Learn ↗——
Opening accountAnother main account that receives this account's balance at year-end close, typically when the account is retired.Microsoft Learn ↗—OpeningAccount
Currency translation typeHow exchange rates are calculated for the account in financial reporting.Microsoft Learn ↗——
Main account—110100—
Name—Atlas test cash clearingName

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
Set up Main accounts——

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model ↗
Can it be undone—
Feature or country—
If you change it laterA main account can't be deleted once it has been used in a ledger account, even if those transactions are later removed; it can only be suspended or renamed. Microsoft Learn ↗

Technical architect

6Technical

Menu itemMainAccountDetails Checked in Dynamics 365
FormMainAccount Checked in Dynamics 365
TableMainAccountShown as “Main account” in Record infoKey field: RecIdChecked in Dynamics 365
Data entitiesDimAttributeMainAccountEntityMain accounts Microsoft data model ↗MainAccountCompanyEntityMain account Microsoft data model ↗MainAccountEntityMain account Microsoft data model ↗MainAccountLegalEntityViewEntityMain account legal entity Microsoft data model ↗
Who can open itPrivilegesMaintain main accounts MainAccountDetailsMaintainView main accounts MainAccountDetailsViewDutiesInquire into chart of account master LedgerChartOfAccountsInquireMaintain chart of accounts master LedgerChartOfAccountsMaintain
11 security rolesBudget clerk BudgetBudgetClerkBudget contributor BudgetBudgetContributorBudget manager BudgetBudgetManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=MainAccountDetails
Integrate withDimAttributeMainAccountEntity data entity Microsoft data model ↗
Table definitionMainAccount columns and relations Microsoft data model ↗

Everyone

8Sources and checks