Transaction Code GL Entries hold the definitions for GL Postings that should automatically be created by the system when Transactions are being entered.
Transaction Code GL Entries Features
Transaction Code GL Entries are the core configuration for how GL Postings are automatically created when entering Transactions.
GL Postings can still be manually created as required by a user [See Transaction Codes for more information on configuring this] where required, this controls automatic entries.
Transaction Code GL Entries can be setup both against an individual Transaction Type Value (Indicating these GL Postings should be created whenever this Value is used in a Transaction) and Transaction Codes (Indicating these GL Postings should be created whenever using this Code in a Transaction) depending on your requirements.
GL Postings are only created when a Transaction has a Status of Committed or more (See here for more information). In Progress Transactions don't automatically create GL Posting entries.
Transaction Code GL Entries Properties
Transaction Code GL Entries have the following properties:
Name
Description
GL Account
The GL Account you want to automatically debit or credit
Ledger
The Ledger to specifically use for this GL Posting entry. This can be explicitly set to be different than the Ledger of the parent Transaction. If left blank the GL Posting will automatically be in the same Ledger as the Transaction.
Date
The date to automatically calculate the Financial Date for the GL Posting with.
Trade Will take the Financial Date from the Transaction if they have the same Entity, or calculate from the Transaction Date otherwise
Settlement Will calculate the Financial Date from the Settlement Date of the Transaction
Formula Will leave the date to be calculated by a provided formula
Entry
The values that are to be taken from the Transaction values, or calculated from currency exchange rates.
Local
Functional
Reporting
LocalFunctional
LocalReporting
FunctionalReporting
LocalFunctionalReporting
LocalFunctionalReporting indicates the GL Posting will be populated by the values from the Transaction completely and nothing will be calculated. Typically the default when the Entity this GL Posting is against is the same as the Transaction Entity. Even if another is selected the calculation from the exchange rates should resolve to the same values as the Transaction anyway.
Transaction Type Value
The Value from the Transaction the system should use to populate this GL Posting automatically with.
If this is against a Transaction Code you can pick from the Values this Transaction Code has configured to use.
If this is against a Transaction Type Value already this column will be hidden and will always just take the Value from that field anyway
DebitCredit
Indicates if the amount taken from the Transaction Value should be debited or credited to this GL Account
Commands
A Transaction Code GL Entry has the standard set of commands and functions when being viewed from a grid. See our standard grid functionality.
Transaction Code GL Entries also have the following custom commands:
Local Value Formula
Functional Value Formula
Reporting Value Formula
Entity Formula
Date Formula
All these formulas override the selections in the grid and specify a custom formula to be evaluated to dynamically determine the correct value. This can allow complicated automatic GL Postings such as splitting an amount up by the number of months left in the year and dating them as such. It can also allow specifying other Entities involved in the Transaction to cater for taking care of inter-company journals automatically.
