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.
Note: 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:
|
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:
|
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:
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. Note: 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. |