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 December 9, 2024