Posting Journal
Return to Models Overview
The Posting Journal is a part of a Jedox application that keeps track of data in the form of a double-entry bookkeeping system. The posting journal consists of a chronological series of records called journal entries. Each journal entry represents a financial transaction and is identified by an ordinal number. A journal entry consists of a header and multiple journal entry lines.
Each journal entry has one of the following statuses. The transition from one status to another is only permitted by one of the actions shown in the diagram:
Journal entries only take effect in an OLAP cube if they are posted.
The posting journal is organized in ledgers where each journal entry belongs to one of the ledgers. Each ledger is bound to one or more slices of its corresponding OLAP cube. The binding between the fields of the posting journal and the slice in the OLAP cube is defined through the Posting Journal Configuration Dimension. Any value in these slices must be managed exclusively through the posting journal. Parts outside these slices can be controlled by data import or manual input.
The posting journal is encapsulated: It can be accessed only through dedicated web reports and defined procedures. It is not available to users for direct access. The posting journal is stored and hidden within the OLAP database. The posting journal and the posted values in the OLAP cubes will thus remain consistent when the database is backed up or restored.
Journal Entry Header
The journal entry header includes fields to identify the journal entry, information on status and validity, audit trail information.
The journal entry header consists of the following fields:
Field | Description | ||||||||||||
Journal Entry |
The ordinal number identifying the journal entry. The lowest valid value is 1. | ||||||||||||
Name |
A short free text to identify the purpose of the journal entry. |
||||||||||||
Description |
An optional long free text to explain the purpose of the journal entry. | ||||||||||||
Ledger |
The ledger the journal entry belongs to | ||||||||||||
Cube | The cube applicable to all journal entry lines | ||||||||||||
Drill Through |
Checkbox to activate drill-through to set up a request to a cube cell from the front end, in order to display the detailed data, including additional fields (e.g. Order Number, Line Item ID) | ||||||||||||
Legal Entity |
The legal entity applicable to all journal entry lines | ||||||||||||
Currency |
The currency of the journal entry which is either LC or a ISO 4217 code of valid source currency, see Setting Up the Available Source Currencies. |
||||||||||||
Version |
The version of the journal entry |
||||||||||||
Month |
The reporting period must be month in a given year in the form yyyy-MM |
||||||||||||
Dimension (1 - 5) |
Custom dimension(s) applicable to all journal entry lines. The actual dimensions as defined by the posting journal configuration for the specific ledger. | ||||||||||||
External Reference |
Free text holding an ID or reference number to an external application. | ||||||||||||
Origin ID |
ID of another journal entry from which this journal entry has been created as a copy. If this journal entry has been created from scratch this field is 0. | ||||||||||||
Automated |
Indicates if the journal entry is a result of an automated process: | ||||||||||||
Total Amount |
The total of all amounts of all journal entry lines for this journal entry. If the journal entry lines do not balance this is the total of all debt amounts of all journal entry lines for this journal entry. | ||||||||||||
Balance |
The difference between the total of all debit and the total of all credit amounts of all journal entry lines. If the journal entry balances this value is 0. | ||||||||||||
Balance Constraint |
The balance constraint of the journal entry with one of the following valid values:
|
||||||||||||
Valid |
The result of the last validation with one of the following valid values:
|
||||||||||||
Reason Invalid |
The reason why the journal entry failed. |
||||||||||||
Status |
The status of the journal entries with one of the following valid values:
|
||||||||||||
Created |
Timestamp of journal entry creation encoded in the way Microsoft Excel or the Jedox Web Spreadsheet (number of days since 1st January 1900) is stored. This field is programmatically filled and cannot be changed afterward. | ||||||||||||
Created By |
Jedox user account of the user who created the journal entry. This field is programmatically filled and cannot be changed afterward. | ||||||||||||
Modified |
Timestamp of journal entry creation encoded in the way Microsoft Excel or the Jedox Web Spreadsheet (number of days since 1st January 1900) is stored. This field is programmatically filled. If the journal entry has been modified multiple times this field refers to the last modification. Any information on previous modifications is overridden. | ||||||||||||
Modified By | Jedox user account of the user who did the most recent modification of the journal entry. This field is programmatically filled. If the journal entry has been modified multiple times this field refers to the last modification. Any information on previous modification is overridden. | ||||||||||||
Posted | Timestamp of posting of journal entry encoded in the way Microsoft Excel or the Jedox Web Spreadsheet (number of days since 1st January 1900) is stored. This field is programmatically filled on initial posting or on reposting. If the journal entry has never been posted the value is zero. If the journal entry has been reversed and reposted this field refers to the last posting. Any information on a previous posting is overridden. | ||||||||||||
Posted By | Jedox user account of the user who posted or reposted the journal entry. This field is programmatically filled. If the journal entry has never been posted the value is empty. If the journal entry has been reversed and reposted this field refers to the last posting. Any information on a previous posting is overridden. | ||||||||||||
Reversed | Timestamp of journal entry reversal encoded in the way Microsoft Excel or the Jedox Web Spreadsheet (number of days since 1st January 1900) is stored. This field is programmatically filled. If the journal entry has never been reversed the value is zero. If the journal entry has been reversed, reposted and reversed again this field refers to the last reversal. Any information on a previous reversal is overridden. | ||||||||||||
Reversed By | Jedox user account of the user who reversed the journal entry. This field is programmatically filled. If the journal entry has never been reversed the value is empty. If the journal entry has been reversed, reposted and reversed again this field refers to the last reversal. Any information on a previous reversal is overridden. | ||||||||||||
Deleted | Timestamp of journal entry deletion encoded in the way Microsoft Excel or the Jedox Web Spreadsheet (number of days since 1st January 1900) is stored. This field is programmatically filled and cannot be changed afterward. If the journal entry has not been deleted the value is zero. | ||||||||||||
Deleted By | Jedox user account of the user who deleted the journal entry. This field is programmatically filled and cannot be changed afterward. If the journal entry has not been deleted the value is empty. | ||||||||||||
Status Changed | Timestamp of the last status change action of journal entry encoded in the way Microsoft Excel or the Jedox Web Spreadsheet (number of days since 1st January 1900) is stored. This field is programmatically filled on on any status change. Any information on a previous status change is overridden. | ||||||||||||
Status Changed By | Jedox user account of the user who did the last status change. This field is programmatically filled and cannot be changed afterward. |
Journal Entry Line
The journal entry lines define the debit and credit amounts and specify all coordinates in the corresponding OLAP cubes which are not specified through the journal entry header. The journal entry line consists of the following fields:
Field | Description |
Journal Entry Line |
Identifies the journal entry line within the journal. The lowest valid value is 1. |
Line Description |
Long free text to explain the purpose of the journal entry line. |
Cube (Entry Line) |
Defines the cube applicable to the journal entry line. Valid values are defined by the posting journal configuration for the specific ledger. |
Legal Entity (Entry Line) |
Defines the legal entity applicable to the journal entry line. |
Partner Entity |
A base element of dimension Partner Entity specifying one of the coordinates in the corresponding OLAP cubes applicable to the journal entry line. |
Account |
Valid values are base elements the account dimension defined by the posting journal configuration for the specific ledger, depending on the cube |
Dimension (6 - 15) |
Custom dimension(s) applicable to the journal entry line. The actual dimensions as defined by the posting journal configuration for the specific ledger. |
Debit |
Debit amount in Currency . Must be 0 if Credit is unequal to 0. |
Credit |
Debit amount in Currency . Must be 0 if Debit is unequal to 0. |
Updated September 27, 2024