BeyondERP.Subscribe

Setup page · General ledger

Ledger allocation basis

Ledger allocation basis rules, which use their own source filter criteria to decide which ledger balances are the basis for an allocation.

Used by
Accountant, Accounting manager, Accounting supervisor and 9 more roles
Business process
Process ledger allocation journals in Dynamics 365 Finance
Menu item
LedgerAllocationBasisRule
Main table
LedgerAllocationBasisRule
Data entity
LedgerAllocationBasisRuleEntity
Setup steps
1 on this page
Show what matters for

Everyone

1What it is and why

What it isLedger allocation basis rules, which use their own source filter criteria to decide which ledger balances are the basis for an allocation.
What you do hereUsed with allocation rules that use the Basis method; one basis rule can be used with multiple allocation rules.
ExampleAllocate advertising expenses based on each department's sales in proportion to the total departmental sales.
Ledger allocation basis 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 processRecord financial transactions › Process allocations › Process ledger allocation journals in Dynamics 365 Finance
Menu pathGeneral ledger › Allocations › Ledger allocation basis
Set up first—
Used next byLedger allocation rules Microsoft Learn ↗
Related pagesLedger allocation rules Microsoft Learn ↗

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Ledger allocation basis2 screens

Used with allocation rules that use the Basis method; one basis rule can be used with multiple allocation rules.

  1. Screen 1

    Create the ledger allocation basis

    Go to General ledger > Allocations > Ledger allocation basis

    1. Select New (the Basis ID comes from the number sequence)
    2. Enter the Description and Effective date, and select Active
    3. Select the Date interval
    4. Select Save
    1Basis IDBEAT-000001
    DescriptionAtlas demo revenue basis
    Effective date10/1/2026
    ActiveYes
    Date intervalBEAT-CM
    Create the ledger allocation basis (zoomed on the outlined fields)
    Show the full screenCreate the ledger allocation basis
    page title tab to open what to set or check

  2. Screen 2

    Add the basis source criteria

    Go to General ledger > Allocations > Ledger allocation basis

    1. Select the basis and select Source
    2. Select New
    3. Set Field setting to Main account and enter the Source criteria
    4. Select Save
    1Source criteria410100
    CompanyBEAT
    Field settingMain account
    Add the basis source criteria (zoomed on the outlined fields)
    Show the full screenAdd the basis source criteria
    page title tab to open what to set or check

Microsoft's steps

—

Field guide

FieldWhat it meansWorked exampleTable column
Basis ID—BEAT-000001BasisId
Description—Atlas demo revenue basisDescription
Effective date—10/1/2026EffectiveStartDate
Active—YesBasisActive
Date interval—BEAT-CMDateInterval
Company—BEAT—
Field setting—Main account—
Source criteria—410100—

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
Set up Ledger allocation basis——

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model ↗
Can it be undone—
Feature or country—
If you change it later—

Technical architect

6Technical

Menu itemLedgerAllocationBasisRule Checked in Dynamics 365
FormLedgerAllocationBasisRule Checked in Dynamics 365
TableLedgerAllocationBasisRuleShown as “Ledger allocation basis” in Record infoKey field: BasisIdChecked in Dynamics 365
Data entitiesLedgerAllocationBasisRuleEntityLedger allocation basis Microsoft data model ↗
Who can open itPrivilegesMaintain ledger allocation basis LedgerAllocationBasisRuleMaintainView ledger allocation basis LedgerAllocationBasisRuleViewDutiesInquire into general ledger policies LedgerGeneralLedgerPoliciesInquireEnable general ledger process LedgerGeneralLedgerProcessEnableInquire into general ledger policies RentalLedgerGeneralLedgerPolicieInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnable
12 security rolesAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManager
Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=LedgerAllocationBasisRule
Integrate withLedgerAllocationBasisRuleEntity data entity Microsoft data model ↗
Table definitionLedgerAllocationBasisRule columns and relations Microsoft data model ↗

Everyone

8Sources and checks