Analyze Journal Entry

Using analyze journal entry feature, you can understand how the accounting engine evaluates the different rules, conditions, and accounting attribute assignments to derive the journal header and lines in an accounting entry.

You can view the source values and understand how a particular condition, formula got evaluated successfully between others or why a particular rule priority was evaluated successfully. This can help you diagnose any rule setup-related accounting errors or explain why the accounting entries were generated in a specific manner.

Enable Feature

Here are the steps to enable analyze journal entry feature:

From the Navigator menu, select Tools > Security Console.
Navigate to the Roles tab and click on the Create Role button.
Enter basic role information and select Role Category > Financials - Job Roles.
Navigate to the Function Security Policies train stop and add the function security policy > Review Accounting Diagnostic.
Navigate to the Users train stop and add the user to which you want to provide access to the Analyze Journal Entry page.
Navigate to Summary train stop and click on the Save and Close button.
From the Navigator menu, select Tools > Scheduled Processes.
Click on the Schedule New Process button, search and submit the process > Import User and Role Application Security Data.

Navigate to Analyze Journal Entry Page

You can navigate to the Analyze Journal Entry page in the following ways:

From View Accounting pop-up window

You can navigate to the Analyze Journal Entry page from the existing View Accounting pop-up window accessible from the Subledger Transaction pages after accounting transactions in Draft or Final status. You can select any journal line in the window and click on the Analyze Journal Entry button to view the specific journal line analysis.

Note: The View Accounting window may display journal lines of multiple event classes or event types which could pertain to different journal entries; however, the Analyze Journal Entry page is always displayed in the context of a specific journal entry. So, all journal lines displayed in the View Accounting window may not always be displayed on the Analyze Journal Entry page.
From Review Journal Entries page

You can also navigate to the Analyze Journal Entry page from the existing Review Journal Entries page, which is accessible from the Subledger Transaction or the General Accounting Journals Work area, after accounting transactions in Draft or Final status. To navigate to the Analyze Journal Entry page, query any journal entry using the search parameters and then select the record in the Search Results table. Click on the Analyze Journal Entry button in the Journal Entry Details section to view the specific journal entry analysis.
From Manage Accounting Errors page

You can also navigate to the Analyze Journal Entry page from the new Manage Accounting Errors page, which is accessible from the General Ledger Journals Work area, after accounting transactions in Draft or Final status. To navigate to the Analyze Journal Entry page, query accounting errors using the search parameters, select the appropriate record in the Search Results table and click on the Analyze Journal Entry button.

Note: You can view Journal Entry Analysis for Invalid accounting entries if a journal entry was created for the event. No details would be displayed if a journal entry creation was unsuccessful.

Subledger Journal Header Analysis

Every Subledger Journal Entry consists of a journal header and its corresponding journal lines. The Analyze Journal Entry page is divided into two tabs - The Journal Header tab and the Journal Lines tab, which render details about subledger accounting rules used in the subledger journal header vis-a-vis in the subledger journal lines region.

The Journal Header tab displays the following information about the journal entry :

Overall Information about the Subledger Journal Entry is displayed in the topmost section. It displays details of the Subledger Accounting Method, Journal Entry Rule Set, and other details for the specific Event Class and Event Type.
Subledger Accounting Rules section displays the Description Rule, and Accounting Attributes information in 2 different sub-tabs.
The Description Rule tab displays the description rule details used to generate the Journal Entry Description.
The Accounting Attributes tab displays the journal header related accounting attributes (For example: Accounting Date) along with the source values used.
Rule Details section is a child section of the Subledger Accounting Rules section displaying further details about a rule.
In a specific Description Rule, the Rule Details section displays the Priorities and Formula defined in the description rule.
You can view the evaluation status of the priorities and review the source values to understand why a specific rule priority got applied successfully.

Subledger Journal Lines Analysis

The Journal Lines tab displays details about subledger accounting rules used to generate all the journal lines for a specific journal entry. The page follows a hierarchical structure where you can select specific records in the upper sections to view the subledger accounting rules and further details in child sections.

The Journal Lines tab displays the following information :

The Journal Lines section is displayed as the topmost section, and it shows all the journal lines for the subledger journal entry being analyzed.
The Source Distribution section is a child section of the Journal Lines section. It displays all the distributions that were merged to generate a specific journal line. A single record would be displayed with line-level details for subledgers where distribution level information isn't captured
- This section has a custom implementation for Payables and Receivables (exceptions include - Bills Receivable transactions) distributions fetching the distribution details from their respective distribution tables.
- For other subledgers, a generic layout has been used to display the source distribution identifiers and distribution type, and distribution amount.
Subledger Accounting Rules section is a child section of the Source Distribution section. It displays the Journal Line Rule, Description Rule, Account and\or Segment Rules, and Supporting Reference details in different sub-tabs, which were used for a specific source distribution.
- Journal Line Rules tab displays the journal line rule details used to generate the specific journal line.
- Description Rules tab displays the description rule details, which were used to generate the Journal Line Description.
- The Account Rules tab displays all the account and\or segment rules, generating the account combination on the journal line.
- The Supporting References tab displays the supporting reference details along with the source value used.
Special Cases \ Exceptions:
- For business flow based accounting entries, since the account or description may be based on a related accounting entry from the upstream transaction, no subledger accounting rules would be displayed.
- For reversal accounting entries where the subledger uses a transaction or line reversal, a message will be displayed indicating the entry was generated due to reversal.
- For certain other cases (Multi-period Accounting, Account Override, Intercompany or Intracompany Balancing, Entered Currency, Balancing, and so on) where the accounting entry is system generated and no subledger accounting rules are used in the process, a message will be displayed indicating the same.
Rule Details section is a child section of the Subledger Accounting Rules section displaying further details about any specific rule.
- In the context of a specific Journal Line Rule, the Rule Details section displays the Condition, Advanced Options, Accounting Attributes, and Formula defined in the journal line rule.
- In a specific Description Rule, the Rule Details section displays the Priorities and Formula defined in the description rule.
- In a specific Account or Segment Rule, the Rule Details section displays the Priorities and Formula defined in the account or segment rule.
- In the Supporting References tab, the Rule Details section displays the formula defined in the supporting references.
- You can view the evaluation status of the priorities, review the source values to understand why a specific rule priority or condition got applied successfully.