Blogs

Journals in SAP BPC Consolidation

INTRODUCTION

Journals are used to make necessary data adjustments in the database. Posting of Journals is performed at Month-end/Quarter End. A Journal is used to Identify the Transactions. Journals are also called a running list of business Transactions. For each Journal, there are two entries i.e., Debit and Credit.

The following Steps will explain details about Journals.

  1. Creation of Journals Template
  2. Setting the Journals Parameters
  3. Creating, Posting, and Copying Journals using Advanced Query by Balance Option
  4. Creating, Posting, and Reopening Journals using Reopen Option.

1. Creation of Journals Template

  1. To create Journal Template Login to Web Administration and Navigate to Administration tab, select Journals under Features as below,

Figure: 1 Navigation to Journals Tab

  1. Select required Consolidation Model and Click on Create Template,

Figure: 2 Selecting Model

  1. Once click upon following Screen will open which contains Header Dimensions, Detail Dimensions, Balance by the entity, Balance by Currency, Additional Properties, and Reopen rules.
  • Header Dimension: The header dimension displays the Context for selection.
  • Detail Dimension: Detail dimension displays the selection of details.
  • Balance by Entity: If it is checked entity dimension should balance for crediting and debiting Transactions.
  • Balance by Currency: If it is checked Accounts/Entity respective Currency should be equal.
  • Additional Properties: These are required to maintain Properties other than which are available in Model.

Figure: 3 Performing Dimensions and Properties

  • Reopen rules: It is used to open the rules for other Periods/ other Dimensions. Perform required selections and Save the Template.

Figure: 4 Performing Reopen rules

2. Setting Journal Parameters:

Once the Journal Template is saved, Select the created Journal Template and Click on Journal Parameters as below,

Figure: 5 Setting Journal Parameter

Below pop will open once after clicking the Journal Parameters, Perform required selections click on Ok.

Figure: 6 Performing Journal Parameter selections

  • Enforce Balanced Journals: By Selecting this Debit and credit amount should equal.
  • Allow Journals to be reopened: By selecting this Journals can be reopened based on selection criteria.
  • Restrict the number of displayed Journals to: By entering the range Journals can see under Consolidation.

3. Creating, Posting, and Copying Journals using Advanced Query/Copy to by Balance Option:

Using this Journals can be entered, posted, and performing Copy of Journals by using Advanced Query with Balance Option.

  1. To Enter Journals, Navigate to Consolidation Tab, Select the Journals Tab.

Figure: 7 Navigation to Journals Tab from Consolidation

  1. Select the required Model, Template and Click on New Journal as below,

Figure: 8 Performing required selections

  1. Perform required Context selections as required and select balanced against settings and enter the Debit and Credit Balance against dimensions as below Save and Post the Journals.

Figure: 9 Performing required Context selections and data entry against dimensions

  1. Once the Journals are Saved, double click on Journals Id to View the details of Journals.

Figure: 10 Details of Journals

  1. To Copy the Journals, select the required Posted Journal and Click on Copy as shown below,

Figure: 11 performing Copy of Journals

  1. Once Copied Journal is clicked following Pop up appears for selecting Dimensions to be copied to Post, click on Ok.

Figure: 12 Performing selections for Copying Journals.

  1. Copying Journals also performed using the Advanced Query, Select the Advanced Query under the Context Tab as below,

Figure: 13 Selecting advanced Query through Context Tab.

  1. Perform the required selection in Advanced Query to copy the Journal, then click on Ok.

Figure: 14 Performing Copy of Journals through Context by using advanced query

  1. To View the Posted Journals in Journals Table, Open the SAP GUI enter T-code as SE38, enter program name as “UJ0_GET_GEN_TABNAME” execute, select environment and Model click on execute, Copy the Journal Table name and Navigate to T-CODE SE16 and enter the Journal table name click on Table Contents.

Observe the Posted Journals by using the ID of the Journal.

Figure: 15 Details of Journals in Journal Table

4. Creating, Posting, and Reopening Journals using Reopen Option.

Once the Journals are Created and Posted, by using the reopen Option Journals will open to performing any modifications. Once the required Modifications are completed Journals can be posted.

  1. To Enter Journals, Navigate to Consolidation Tab, Select the Journals Tab.

Figure: 16 Navigation to Journals Tab from Consolidation

  1. Select the required Model, Template and Click on New Journal as below,

Figure: 17 Performing required selections

  1. Perform required Context selections as required and select balanced, Re-open against settings, and enter the Debit and Credit Balance against dimensions as below Save and Post the Journals.

Figure: 18 Performing required Context selections and data entry against dimensions

  1. Once the Journals are Saved, double click on Journals Id to View the details of Journals.

Figure: 19 Details of Journals

  1. To Reopen the Journals, select the required Posted Journal and Click on Reopen as shown below,

Figure: 20 performing required Context selections and data entry against dimensions

  1. Once the Reopen button is clicked, following Pop up appears to select Journals which to be reopened to be posted to destination and click on Ok and Post Journals.

Figure: 21 performing required selections which to be reopened.

  1. Once reopened Journal is Clicked following Pop up appears for Posting the reopened Journals click on Ok.

Figure: 22 posting reopened Journals.

  1. Observe the Reopened Journals in Panel as below,

Figure: 23 reopened Journals

  1. To View the Posted Journals in Journals Table, Open the SAP GUI enter T-code as SE38, enter program name as “UJ0_GET_GEN_TABNAME” execute, select environment and Model click on Execute, Copy the Journal Table name and Navigate to T-CODE SE16 and enter the Journal table name click on Table Contents.

Figure: 24 details of reopened Journals.

Note: Reopen function will works if we enable settings in Journals Parameters.

  1. Creating, Posting Journals using Multiple Journal Options

Using this Journals can be created and Posted for Multiple periods with a single Journal. Below are the steps used to create and post multiple Journals a single entry.

  1. To Enter Journals, Navigate to Consolidation Tab, Select the Journals Tab.

Figure: 25 Navigation to Journals Tab from Consolidation

  1. Select the required Model, Template and Click on New Journal as below,

Figure: 26 performing required selections

  1. Perform required Context selections as required, select the New Journal and Navigate to Multiple posting as shown below,

Figure: 27 Posting Multiple Journals

  1. Check multiple headers and values tab and select the required dimension and members, enter the credit and debit amount as required.

Figure: 28 Multiple Journals

  1. Once the balances are entered click on Save and Post, then review the Posted Journals.

Figure: 29 Multiple Journals

  1. To View the Posted Journals in Journals Table, Open the SAP GUI enter T-code as SE38, enter program name as “UJ0_GET_GEN_TABNAME” execute, select environment and Model click on Execute, Copy the Journal Table name and Navigate to T-CODE SE16 and enter the Journal table name click on Table Contents.

Figure: 30 Multiple Journals in Journal Table.

Purpose of the article: This article gives the details of how to create set Parameters and create Journals templates to Post, Copy, reopen using Advanced Query and reopen option.

Intended Audience: Background of SAP-EPM Members (BPC)

Keywords:

** APPLY YTD

** Intercompany, Scope

References / Sources of the information referred:

https://www.slideshare.net/Cloneskills/sap-bpc-nw-100-knowledgebase-balance-carry-forward

Which MOURI Tech service, this article relates to-

** https://www.mouritech.com/services/enterprise-performance-management

Ravali RACHAMADUGU
Analyst – Analytics (EPM)
MOURI Tech

Leave A Comment

Related Post

WordPress REST APIs

Purpose of the Article: To Learn about WordPress Rest APIs Intended Audience: PHP Developers Tools and Technology: WordPress Keywords: WordPress Rest API What Is API?

Read More »

Secure Browsing

Purpose of the Article: How to Browse the Internet safely? Intended Audience: Whoever uses the Internet. Tools and Technology: Cyber Security Keywords: Cyber Security, Data

Read More »