BeyondERP.Subscribe

Setup page · General ledger

Ledger allocation rules

Rules that automatically calculate and generate allocation journals and account entries for allocating ledger balances or fixed amounts.

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

Everyone

1What it is and why

What it isRules that automatically calculate and generate allocation journals and account entries for allocating ledger balances or fixed amounts.
What you do hereUsed to define each rule's general settings, source, destination, and offset, with the Basis, Fixed percentage, Fixed weight, or Equally allocation method.
ExampleAllocate advertising expenses so that Department A receives 70 percent and Department B receives 30 percent.
Ledger allocation rules 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 rules
Set up firstJournal names Microsoft Learn ↗Date intervals Microsoft Learn ↗Ledger allocation basis Microsoft Learn ↗
Used next byProcess allocation request Microsoft Learn ↗Allocation journals Microsoft Learn ↗
Related pagesAllocation rules definition report Microsoft Learn ↗

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Ledger allocation rules2 screens

Used to define each rule's general settings, source, destination, and offset, with the Basis, Fixed percentage, Fixed weight, or Equally allocation method.

  1. Screen 1

    Create the ledger allocation rule

    Go to General ledger > Allocations > Ledger allocation rules, General tab

    1. Select New (the Rule ID comes from the number sequence) and enter the Description and Effective date
    2. On the General tab, set Active to Yes and select the Allocation method
    3. Select the Journal name and the Date interval code
    4. Select Source and Destination to add the source account and the destination lines, then select Save
    1ActiveYes
    2Allocation methodFixed percentage
    3Journal nameBEAT-ALC
    4Date interval codeBEAT-CM
    Create the ledger allocation rule (zoomed on the outlined fields)
    Show the full screenCreate the ledger allocation rule
    page title tab to open what to set or check

  2. Screen 2

    Add the allocation destinations

    Go to General ledger > Allocations > Ledger allocation rules

    1. Select the rule and select Destination
    2. Select New and enter the Fixed percentage
    3. Select the To account
    4. Repeat for the second line until Percentage in total is 100, then select Save
    1Fixed percentage50.00
    2To account510100
    3Ledger accountAtlas cost of goods sold
    4Percentage in total100.00
    Add the allocation destinations (zoomed on the outlined fields)
    Show the full screenAdd the allocation destinations
    page title tab to open what to set or check

Microsoft's steps

  1. Go to General ledger > Allocations > Ledger allocation rules.
  2. Select New, and enter a Rule and Description.
  3. On the General tab, set Active to Yes.
  4. Select the Allocation method, the Journal name and the Date interval code.
  5. Select Source, and add the source criteria, such as the main account and dimension values.
  6. Select Destination, and add a line for each account and dimension to allocate to.
  7. Close the pages.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Allocation methodHow amounts are split: Basis, Fixed percentage, Fixed weight or Equally.Microsoft Learn ↗Fixed percentageAllocationMethod
Data sourceWhether the rule allocates ledger balances (Ledger) or fixed amounts (Fixed value).Microsoft Learn ↗—DataSource
ActiveMakes the rule available to process.Microsoft Learn ↗YesAllocationActive
Journal nameThe allocation journal name used for the generated journal.Microsoft Learn ↗BEAT-ALCJournalName
Date interval codeThe date interval used for the balances.Microsoft Learn ↗BEAT-CM—
Fixed percentage—50.00—
To account—510100—
Ledger account—Atlas cost of goods sold—
Percentage in total—100.00—

Functional consultant

4Setup decisions

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

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 laterWhen the data source is Fixed value, Source can't be used as an offset option. Microsoft Learn ↗

Technical architect

6Technical

Menu itemLedgerAllocationRule Checked in Dynamics 365
FormLedgerAllocationRule Checked in Dynamics 365
TableLedgerAllocationRuleShown as “Ledger allocation rule” in Record infoChecked in Dynamics 365
Data entitiesLedgerAllocationRuleEntityLedger allocation rule Microsoft data model ↗
Who can open itPrivilegesMaintain ledger allocation rules LedgerAllocationRuleMaintainView ledger allocation rules LedgerAllocationRuleViewDutiesInquire 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 pageButtons: Source, DestinationChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=LedgerAllocationRule
Integrate withLedgerAllocationRuleEntity data entity Microsoft data model ↗
Table definitionLedgerAllocationRule columns and relations Microsoft data model ↗

Everyone

8Sources and checks