Transaction page · General ledger
Allocation journals
The journals that hold allocation transactions created from a ledger allocation rule by the Process allocation request page.
- Used by
- Accountant, Accounting manager, Accounting supervisor and 13 more roles
- Business process
- —
- Menu item
LedgerJournalTable_Allocation- Main table
LedgerJournalTable- Data entity
ExpenseJournalHeaderEntity- Setup steps
- —
Show what matters for
Everyone
1What it is and why
| What it is | The journals that hold allocation transactions created from a ledger allocation rule by the Process allocation request page. |
|---|---|
| What you do here | Used to review, optionally approve, and post the allocation lines to the general ledger. |
| Example | Run an allocation request with Proposal only, then open Allocation journals, select Lines, and post the allocation. |
Functional consultant · Solution architect
2Where it fits
| Business process | — |
|---|---|
| Menu path | General ledger › Allocations › Allocation journals |
| Set up first | Ledger allocation rules Microsoft Learn ↗Process allocation request Microsoft Learn ↗Journal names Microsoft Learn ↗ |
| Used next by | — |
| Related pages | — |
End user · Functional consultant
3How to do it
Microsoft's steps
- Go to General ledger > Allocations > Process allocation request and select the rule.
- Enter the As of date and the GL posting date.
- In the Proposal options field, select Proposal only so that the result can be reviewed first.
- Select OK.
- Go to General ledger > Allocations > Allocation journals.
- Select Lines to review the allocation lines.
- Select Post.
Source: Microsoft Learn ↗
Field guide
| Field | What it means | Worked example | Table column |
|---|---|---|---|
| — | |||
Functional consultant
4Setup decisions
| Setup step | Recommended value and why | Decision · common mistake · test |
|---|---|---|
| — No setup is made on this page. | ||
Solution architect
5Design impact
| Shared or per company | Per 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 item | LedgerJournalTable_Allocation Checked in Dynamics 365 |
|---|---|
| Form | LedgerJournalTable Checked in Dynamics 365 |
| Table | LedgerJournalTableShown as “Ledger journal table” in Record infoKey field: JournalNumChecked in Dynamics 365 |
| Data entities | ExpenseJournalHeaderEntityProject expense journal header Microsoft data model ↗VendInvoiceJournalHeaderEntityVendor invoice journal header Microsoft data model ↗VendInvoiceRegisterHeaderEntityVendor invoice register header Microsoft data model ↗VendorPaymentJournalHeaderEntityVendor payment journal header Microsoft data model ↗CustInvoiceJournalHeaderEntityCustomer invoice journal header Microsoft data model ↗CustomerPaymentJournalHeaderEntityCustomer payment journal header Microsoft data model ↗BankJournalHeaderEntityBank journal header Microsoft data model ↗AssetJournalEntityFixed asset journal Microsoft data model ↗AssetJournalHeaderEntityFixed asset journal table Microsoft data model ↗AssetJournalV2EntityFixed asset journal V2 entity Microsoft data model ↗LedgerJournalEntityGeneral journal Microsoft data model ↗LedgerJournalHeaderEntityLedger journal table Microsoft data model ↗LedgerReportingCurrencyAdjustmentJournalHeaderEntityReporting currency adjustment journal header Microsoft data model ↗SlipJournalEntitySlip journal Microsoft data model ↗RAssetJournalHeaderEntityFixed asset journal header (Russia) Microsoft data model ↗ |
| Who can open it | PrivilegesMaintain allocation journal transactions LedgerJournalTable_AllocationMaintainView allocation journal transactions LedgerJournalTable_AllocationViewDutiesMaintain journals and transactions LedgerAllocationJournalsAndTransactionsMaintainMaintain journals and transactions LedgerAllocationJournalsAndTransactionsViewInquire into general ledger reference data LedgerGeneralLedgerReferenceDataInquireInquire into journals and transaction status LedgerJournalsTransactionStatusInquireMaintain ledger journal transactions RentalLedgerJournalsAndTransMaintain16 security rolesAuditorAuditPolicyManagerBudget manager BudgetBudgetManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerTax accountant FBTaxAccountant_BRInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental manager RentalManagerAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager |
| Actions on the page | Options: Personalize, Page options, Edit, ShareChecked in Dynamics 365 |
Developer
7Developer
| Open it directly | https://<your-environment>/?mi=LedgerJournalTable_Allocation |
|---|---|
| Integrate with | ExpenseJournalHeaderEntity data entity Microsoft data model ↗ |
| Table definition | LedgerJournalTable columns and relations Microsoft data model ↗ |
Everyone
8Sources and checks
- learn.microsoft.com/dynamics365/finance/general-ledger/tasks/process-ledger-allocation-journal
- learn.microsoft.com/dynamics365/finance/general-ledger/tasks/process-ledger-allocation-journal
- learn.microsoft.com/common-data-model/schema/core/operationscommon/tables/finance/accountingfoundation/worksheetheader/ledgerjournaltable
- learn.microsoft.com/dynamics365/finance/general-ledger/ledger-journal-types
- Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.