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:

Value

Description
Legal Entity This is the default option. The debit and credit amounts from all journal entry lines with the same Legal Entity (Entry Line) must balance. (Note that this implies that the total journal balances, too.
Journal Entry The debit and credit amounts from all journal entry lines must balance. Please note that this may result in an unbalanced balance sheet on company level. Such journal entries should not be placed on adjustments or transitions of financial statements from subsidiaries. They may, however, be required during and after the consolidation of the group. This option must not be selected if Currency is set toLC unless all affected legal entities use the same local currency.
None The debit and credit amounts from all journal entry lines do not need to balance. Such journal entries should not be placed on adjustments or transitions of financial statements from subsidiaries. They may however, be required during and after the consolidation of the group.

Valid

The result of the last validation with one of the following valid values:

Value

Description

Not validated

This journal entry has never been validated.

Valid

This journal entry has successfully passed the validation procedure.

Invalid

This journal entry failed the validation procedure. The reason for the failure is stored in the field Reason Invalid.

Reason Invalid

The reason why the journal entry failed.

Status

The status of the journal entries with one of the following valid values:

Value

Description

Undefined

This value is not valid. It may only occur for a very short time during the creation procedure and may be used for technical reasons to validate the creation process.

Saved

The journal entry has been created and saved. The user may or may not have manual changes to the journal entry. The fields Created, Created By, Modified and Modified By contain audit trail information.

Posted

The journal entry has been posted. The fields Posted and Posted By contain audit trail information.

Reversed

The journal entry has reversed after being posted. The fields Reversed and Reversed By contain audit trail information.

Deleted

The journal entry has been finally deleted. The fields Deleted and Deleted By contain audit trail information.

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