General ledger distribution (GL distribution) defines the rules used when generating journal entries from source transactions in the various sub-ledgers.
Configure GL distribution in the GL Distribution tab or section for the source transaction (as opposed to configurations which are single-select GL accounts). See below for information that applies when configuring any GL distribution.
GL Distribution Type
When configuring GL distribution, you must select a value from the GL Distribution Type column. The GL Distribution Type column controls the type of transaction that generates the journal entry and whether you are defining the GL account for the debit (DR) or credit (CR) side of the journal entry.
Some transactions only require you to configure one side of the journal entry (debit or credit) in the GL Distribution tab/section because the other is defined at another source. For example, for most cash transactions, the other side of the transaction is the determined from the bank account GL account.
Refer to the articles in Specific Configuration Articles for explanations of the various GL Distribution Types for each transaction type.
Sequence
It is possible to have different GL accounts that relate to the same GL Distribution Type. You may want to do this to split the journal entry by percentage/amount or to split the journal entry based on certain criteria (See Available Criteria for GL Distribution Rows below for more information. This is option is only available with the Advanced Accounting package).
When you have multiple GL accounts defined for the same GL Distribution Type, the system needs to know what order to look in to determine which distribution to use. You control this order using the Sequence column. The system looks at each GL distribution row for a particular GL Distribution Type in order of lowest sequence to highest sequence (alphanumeric sorting) until it has allocated 100% of the transaction amount based on the rows with criteria which match the source transaction.
Available Criteria for GL Distribution Rows
Defining the criteria for a GL distribution row is only available if you have the Advanced Accounting package. If you would like to use this feature and do not have the Advanced Accounting package, contact your Customer Success Manager or Account Manager to learn more about purchasing an upgrade.
You can use the following criteria to assign the relevant GL account and related fields on the journal entry:
- Event Category
- Event Class
- Event Type
- Function Usage
- Order Department
- A/R Control (for the account)
- Inventory Space
- Space GL Distrib 2
- Space GL Distrib 6
- Book Control
- Core Dimension 1
- Core Dimension 2
Not all criteria is available for all transaction sources. For example, Inventory Space is only available when configuring inventory GL distributions. See the articles in Specific Configuration Articles for the available criteria for each transaction.
Fields Based on GL Distribution Rows
The following fields are assigned to the generated journal entry based on the value set in the selected GL distribution row:
- GL Account / Main GL Account
- Management Report Code
- Destination Organization
The value set in the GL distribution rows do not override any value on the source transaction. For example, if a service order item is assigned a management report code, this takes priority over the management report code in the GL distribution row.
Specific Configuration Articles
Revenue/Cost Distribution for Resources
Receivable Transaction Types
Fixed Asset Journal Entries
Inventory Journal Entries
Purchase Order Accruals
Intercompany Distribution
Comments
0 comments
Please sign in to leave a comment.