Projected Balance Sheet Posting Journal

image_pdfimage_print

Return to Projected Balance Sheet Model Overview

This report shows as well as allows you to create and edit journal entries that are stored in the posting journal. Journal entries are organized in ledgers which define which part of a particular cube is affected by posted journal entries. Journal entries can either be created manually or automated (i.e. as a result of a batch procedure).

Report Heading

The screenshot below points out the heading area of the Projected Balance Sheet Posting Journal. The logo can be changed in Administration; see Configuring Design Elements for more on report design.

Point of View (PoV) Options

The list of journal entries shown on this report can be restricted using the PoV options.

The available options are described below: 

PoV Option

Description

Journal Entry (text fields)

Restricts the range of journal entries to be displayed. Enter 1 – 999999 for unrestricted results.
Ledger (combobox) Restricts the ledger of journal entries. Select All Ledgers to show journal entries for any ledger.
Version (combobox) Restrict the Version of journal entries.

Month (combobox)

Restrict the reporting period of journal entries (can be a year, or a month in a given year).

Legal Entity (combobox)

Select one single legal entity or any consolidated element.

Journal Entry Status (combobox)

Select the status of the journal entries you would like to review with one of the following valid values: Undefined, Saved, Posted, Reversed, Deleted.
Name (text field) Search for a phrase contained in the short text that identifies the journal entry. Leave the field empty for unrestricted results.
Description (text field) Search for a phrase contained in the long text that describes the purpose of the journal entry. Leave the field empty for unrestricted results.
Status Changed (two date pickers) Select the date range to query for the most recent status change of the journal entry.
Status Changed By (text field) Search for a user that did the latest change on the journal entry. Leave the field empty for unrestricted results.
Automated (checkbox)  Check to show journal entries that were created with an automated batch procedure. Leave it unchecked for manual journal entries. Toggle to both for unrestricted results.
Posting Journal Details (link to report) Link to the Posting Journal Details report to inspect and export the raw data of the journal entries

 

Report Columns

The columns displayed in the report depend on the selections made in the PoV area. 

Below are descriptions of the columns in the Projected Balance Sheet Posting Journal Report.

Column Description

Journal Entry 

Displays the journal entry number and name

Opens the Projected Balance Sheet Posting Journal Entry input screen

Speech bubble icon

Shows an information icon if the journal entry has a description. Hover over this icon to show the description as a tooltip.

Version

Displays the Version of the journal entry

Month

Displays the reporting period of the journal entry.

Total Amount

Total of all amounts of all journal entry lines for this journal entry.
Automated Symbol (Checkbox) Displays whether journal entries were created with an automated process

Currency

Displays the currency type of the journal entry.

Status

Displays the status of the journal entries you would like to review with one of the following valid values: Undefined, Saved, Posted, Reversed, Deleted.

Status Changed

Displays the date of the most recent status change of the journal entry.

Status Changed By

Displays the name of the last user that changed the journal entry.

Valid

Displays the result of the last validation.

Create New (button)

Opens up the Projected Balance Sheet Journal Entry_new form to manually create a new entry.

 

Below are descriptions of the buttons that are displayed when one or more journal entries are selected.

Column Description

Copy and Relocate (button)

Opens up the Projected Balance Sheet Journal Entries_relocate form to create new journal entries as copies of existing ones in a new location. Only visible if one or more journal entries are selected.

Invert (button)

Creates inverse entries for the selected journal entries. Only visible if one or more automated journal entries are selected
Duplicate (button) Creates duplicates entries for the selected journal entries. Only visible if one or more journal entries are selected
Copy Forward (button) Creates duplicates entries on the next reporting period for the selected journal entries. Only visible if one or more journal entries are selected
Repost (button) Posts selected reversed journal entries again. Only visible if one or more reversed journal entries are selected.
Delete (button) Deletes selected saved journal entries. Only visible if one or more saved journal entries are selected.

 

Projected Balance Sheet Journal Entry_new

This form allows users to define the header fields and manually create a new journal entry in the posting journal.

The input fields and options are explained below:

Field

Description

Ledger (combobox)

 Ledger of the new journal entry. The ledger defines which of the subsequent fields are valid

Cube

 Displays the cube on which all journal entry lines apply. Only shown for ledgers using the same cube for all journal entry lines.

Version (combobox)

Select the version

Month (combobox)

Select a reporting period. Must be a specific month in a year

Legal Entity (combobox) 

Select one single legal entity. Only shown for ledgers using the same legal entity for all journal entry lines.

Currency (combobox)

The currency of the journal entry.

Name (text field) 

Search for phrases or keywords in the short text that identifies the journal entry.

Description (text field) 

Search for phrases or keywords in the long text that describes the purpose of the journal entry.

Create New (button)

Creates the new journal entry

 

Projected Balance Sheet Journal Entry_relocate

This form allows users to create new journal entries as copies of existing ones in a new location.

The input options are explained below:

Field

Description

Journal Entry 

Displays the number of the journal entry to be copied

Ledger 

 Ledger of the new journal entry. The ledger defines which of the subsequent fields are valid

Version (combobox)

Select the version

Month (combobox)

Select a reporting period. Must be a specific month in a year

Legal Entity (combobox) 

Select one single legal entity. Only shown for ledgers using the same legal entity for all journal entry lines.

 

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...

Leave A Comment?