What's new: Ledger and subledger lines and distributions

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Accounting distributions and subledger journal entries are the foundation of the new accounting framework. Accounting distributions let a user define how amounts on a source document affect account balances, such as ledger accounts in General ledger or projects. A subledger journal entry is the accounting entry that is created for a source document. The subledger journal entry remains in the subledger and can be previewed before a source document is journalized.

The addition of subledger journal entries means that additional performance optimization and summarization rules can be defined for the transfer of subledger journal entries to General ledger. The transfer process can be defined so that it occurs synchronously or asynchronously. During the transfer process, a user has the option to summarize the subledger journal entries for similar source documents to reduce the amount of data in General ledger.

Overview

Item

Description

Required

Optional. You might not use this feature, depending on how you run your business. The functionality is always enabled, but if your business requires no modifications to default ledger accounts, you do not have to use the functionality.

Feature areas affected

Accounts payable

Accounts receivable

Travel and expense

Procurement and sourcing

Stakeholders

Business decision makers

Technical decision makers

Implementation team members

Independent software vendors (ISVs)/developers

Partners

New functionality

Before you journalize a source document, you can preview the accounting entry to verify that the amounts are being journalized to the correct ledger accounts. This view of the accounting entry is known as a subledger journal entry.

You cannot modify subledger journal entries directly. To modify subledger journal entries, you must correct the accounting distributions, posting profile, or posting definitions. Accounting distributions are used to define how an amount is accounted for. For example, an accounting distribution specifies the revenue or expense ledger account that an amount is posted to in General ledger. The primary information about an accounting distribution is the amount on the source document line and the ledger account for which that amount is distributed.

When there are common patterns that you use to distribute amounts on a source document line, you can use a template that contains combinations of percentage and dimension values. The information in the template is used to create the accounting distributions for amounts on a source document line.

Special considerations

  • You cannot split accounting distributions for stocked items or fixed assets.

  • Existing posting profiles are used, so that additional setup is not required.

  • You can set up asynchronous and summarization options.

  • New terminology is used in Microsoft Dynamics AX 2012, as the following table shows.

Microsoft Dynamics AX 2009

AX 2012

Definition

Post

Journalize

To record a documented business event in the subledger journal.

Post

To record the monetary value of an economic event in a specific account, or to summarize and reclassify general and subsidiary journal account entries into general and subsidiary ledger account entries.

Transaction

Source document

An original record that provides evidence that one or more business events occurred.

Journal entry

A record of a business event.

Transaction

A social or physical economic exchange action.

Comparison with AX 2009

The functionality for accounting distributions and subledger journal entries is new in AX 2012. This functionality has been implemented in the following source documents:

  • Purchase requisitions

  • Purchase orders

  • Product receipts (previously known as PO packing slips)

  • Vendor invoices

  • Free text invoices

  • Travel requisitions

  • Expense reports

Functionality

What can you do?

AX 2009

AX 2012

Why is this important?

Preview the accounting entry of a source document before you journalize the entry in the subledger and transfer it to General ledger.

Users had limited visibility of what was actually journalized and transferred to General ledger.

The full accounting entry is displayed in all currencies before the entry is journalized and transferred to General ledger.

The requirement for period-end adjustments that use a general journal is minimized.

Use a template to define accounting distributions.

Not available

Templates can be created for financial dimension values, but not for the main account, to create accounting distributions.

Data entry is simplified.

Distribute an amount by using various allocation factors.

Not available

An amount can be distributed by amount, by percentage, by quantity, or equally.

A user can define the allocation factor that is used to distribute an amount.

Have the flexibility to define a batch for each source document type, so that you can transfer to General ledger.

Batches were available but had to be manually assigned to each source document.

Batches are automatically created or defined by a user, and are automatically assigned to a source document type.

Processing is postponed to maximize responsiveness, and to minimize the time and effort that are required for data entry.

Define how the amount on one source document line can be accounted to more than one ledger account.

Not available

Users do not have to enter a separate source document line for each operating unit. Instead, one line is created, and the accounting distribution is split.

The amount of data entry is reduced, because operations, not accounting, determine how a source document is recorded.

Define accounting distributions on an upstream source document.

Not available

Accounting distributions that are defined on a purchase requisition are used to determine the accounting distributions for all downstream source documents (purchase orders, product receipts, and vendor invoices).

Accounting consistency and accuracy are improved across the life cycle of the business event.

Support accounting for intercompany transactions.

Accounting for intercompany transactions was available only in journals.

If a source document supports intercompany transactions, the appropriate due to/due from account entries are created in the subledger journal entry.

The appropriate intercompany accounting entries are consistently created for any source document that supports intercompany transactions.

Integrate accounting distributions and project accounting.

Not available

Source documents that support project accounting can use the accounting distributions to define how the amount is distributed to projects.

Operations, not project accounting, determine how a source document is recorded.

Validate and reserve budget, based on the accounting distribution information.

Not available

A user can define budget control rules, and then use those rules when he or she enters source documents.

You can make sure that purchases are within budget.

More information

For more information, see the following topics: