Reviewing Journal Entry Adjustments

The Show Adjustments app can be used to analyze an intersection in a report or app to view the underlying Journal Entries. Show underlying adjustments can be used to review Journal Entries for an area defined by a cell in a report or data area.

Accessing the Show Adjustments App

Depending on the configuration of your app or report you may have access to review underlying adjustments.

For more information on adding the Show Adjustments app to reports and apps, see “Show Underlying Adjustments” in the Solutions Developer Guide.

To access Show Adjustments from within an App

From within the Longview Client, launch the App that contains a data grid.
Right-click on a cell.
Select Show Underlying Adjustments. The Show Adjustments table appears.

To access Show Adjustments from within a Report

From within the Longview Client, launch the report.
Right-click on a cell.
Select Show Underlying Adjustments. The Show Adjustments table appears.

Viewing the Show Adjustments table

The Show Adjustments table appears within a tab that displays the journal entries that exist within the intersection selected. If there is any unadjusted data in the intersection selected, an additional row will appear at the end of the table that will display the unadjusted amount.

Note:

In the case where a cell contains parent symbols, all Journal Entries recorded against any of the symbols’ descendants will be displayed.
To view translated journal entry details for standard journal entries, the system attribute SFXJE - Translate Journal Entry Details must be set to TRUE. It is recommended to set SFXJE to TRUE if Show Underlying Adjustments will be used.

The table contains these columns:

Columns	Description
JE ID	The JE Identifier. Note: The JE ID is unique by category and creation period.
Creation Period	The period the Journal Entry was created in
Category	The category of the Journal Entry. This can be one of the following: Standard Elimination
Subcategory	The subcategory of the Journal Entry.
Description	The description of the Journal Entry.
Type	The type of Journal Entry. This can be one of the following: Current Period Restatement PPA (Prior Period Adjustment) Future Period
Line Number	The line number within the Journal Entry.
Post Period	The period the Journal Entry was posted to.
Account	The account corresponding to the Journal Entry line of detail.
Account Description	The account description corresponding to the Journal Entry line of detail.
Currency	The currency selected. This can be either: A leaf currency (i.e.: USD) A translated currency (i.e.: USDFX) Note: A total reporting currency (i.e.: USDT) You cannot use Show Adjustments on a parent currency that contains multiple different parent currency structures beneath it. For example, CURRENCIES_All. When viewing adjustments in reporting currencies on accounts translated at historical rates, the sum of the adjustments may not match the actual value displayed as the adjustment details are shown translated at the current exchange rate.
Value	The value of the Journal Entry adjustment in the currency selected.
Source Currency	The source currency related to the Journal Entry line of detail of the currency selected. Note: This column will only be visible if the selected currency is either a translated currency of a total reporting currency.
Source Value	The source currency value related to the Journal Entry line of detail of the currency selected. Note: This column will only be visible if the selected currency is either a translated currency of a total reporting currency.
Dimension Name(s)	A column will be displayed showing the corresponding symbol name in all other dimensions related to the Journal Entry line of detail.
Dimension Description(s)	A column will be displayed showing the corresponding symbol description in all other dimensions related to the Journal Entry line of detail.

Published: May 07, 2024 20:36

Reviewing Journal Entry Adjustments

Accessing the Show Adjustments App

Depending on the configuration of your app or report you may have access to review underlying adjustments.

For more information on adding the Show Adjustments app to reports and apps, see “Show Underlying Adjustments” in the Solutions Developer Guide.

To access Show Adjustments from within an App

From within the Longview Client, launch the App that contains a data grid.
Right-click on a cell.
Select Show Underlying Adjustments. The Show Adjustments table appears.

To access Show Adjustments from within a Report

From within the Longview Client, launch the report.
Right-click on a cell.
Select Show Underlying Adjustments. The Show Adjustments table appears.

Viewing the Show Adjustments table

Note:

In the case where a cell contains parent symbols, all Journal Entries recorded against any of the symbols’ descendants will be displayed.
To view translated journal entry details for standard journal entries, the system attribute SFXJE - Translate Journal Entry Details must be set to TRUE. It is recommended to set SFXJE to TRUE if Show Underlying Adjustments will be used.

The table contains these columns:

Columns	Description
JE ID	The JE Identifier. Note: The JE ID is unique by category and creation period.
Creation Period	The period the Journal Entry was created in
Category	The category of the Journal Entry. This can be one of the following: Standard Elimination
Subcategory	The subcategory of the Journal Entry.
Description	The description of the Journal Entry.
Type	The type of Journal Entry. This can be one of the following: Current Period Restatement PPA (Prior Period Adjustment) Future Period
Line Number	The line number within the Journal Entry.
Post Period	The period the Journal Entry was posted to.
Account	The account corresponding to the Journal Entry line of detail.
Account Description	The account description corresponding to the Journal Entry line of detail.
Currency	The currency selected. This can be either: A leaf currency (i.e.: USD) A translated currency (i.e.: USDFX) Note: A total reporting currency (i.e.: USDT) You cannot use Show Adjustments on a parent currency that contains multiple different parent currency structures beneath it. For example, CURRENCIES_All. When viewing adjustments in reporting currencies on accounts translated at historical rates, the sum of the adjustments may not match the actual value displayed as the adjustment details are shown translated at the current exchange rate.
Value	The value of the Journal Entry adjustment in the currency selected.
Source Currency	The source currency related to the Journal Entry line of detail of the currency selected. Note: This column will only be visible if the selected currency is either a translated currency of a total reporting currency.
Source Value	The source currency value related to the Journal Entry line of detail of the currency selected. Note: This column will only be visible if the selected currency is either a translated currency of a total reporting currency.
Dimension Name(s)	A column will be displayed showing the corresponding symbol name in all other dimensions related to the Journal Entry line of detail.
Dimension Description(s)	A column will be displayed showing the corresponding symbol description in all other dimensions related to the Journal Entry line of detail.

26537533688333

Reviewing Journal Entry Adjustments

Accessing the Show Adjustments App

Viewing the Show Adjustments table

Reviewing Journal Entry Adjustments

Accessing the Show Adjustments App

Viewing the Show Adjustments table

For an optimal Community experience, Please view on Desktop