Services
Education
SAP Delivery Framework
SAP Implementation
SAP BPC Implementation
SAP BOBJ Implementation
SAP BW/BI Implementation
SAP ABAP Implementation
SAP FICO Implementation
Hyperion Implementation
 
Events Registration
Contact us for you're On Job/ Remote Support
 
Journal End-To-End Implementation in SAP BPC NW 7.5
Journal in Consolidated BS and P&L
A SAP BPC NW 7.5 Solutions
 
Table of Contents


 

Business Scenario

Journal entries play an important part in a Business's consolidation process. They are utilized to manage reporting inconsistencies arising out of currency conversion on inter- company transactions, to carry forward balances into a new year and other consolidation operations.

The consolidation process includes the collection of data from the underlying Systems which will usually include ECC. (ERP Central Component). After the data is collected, it is prepared by carrying out manual adjustments, reclassifications, and currency translations. Validation can be run at any time in the overall process. Eliminations are the last part of the process where inter unit activities as well as consolidation of investments are performed.

Using BPC administration console and BPC for Excel, business users can create, post, UN post, repost and manage journals. As a onetime effort, users need to setup a journal template using BPC administration console and perform the journal operations using the BPC for Excel interface.

 

Back to top
Document Objective

This guide will provide all the steps necessary to create a journal template and perform different journal operations. Three journal scenarios are explained in this guide. There are other scenarios not covered by this guide. They can be explored once the fundamentals given in this guide are understood.

Following scenarios are covered by this guide:

  • Journal operations
  • Journal Template Creation
  • Journal Enter Creation
  • Journal Entry Posting, Un-Posting , Re-Posting
  • Journal Reporting
  • Journal Multi Entry

 

Back to top
Prerequisites/Assumptions
  • Model your business scenarios in BPC (Ex : Balance Sheet Modeling)
    • Model Includes
      • Application Set
      • Application
        • Reporting
          • Financial
        • Non Reporting
          • Rate
      • Dimensions
        • Category
        • Account
        • Time
        • Entity
        • Data Source
        • Inter Company
        • Report Currency
      • Dimensions Properties
      • Dimensions Members
  • Configure Appropriate security settings
  • Application Data for Balance Sheet
  • Application Data for P&L
  • Reports
    • Balance Sheet
    • P&L
  • Input Schedules

 

Sample Journal Entries for Consolidated Balance Sheet:
 

SAP BPC NW 7.5 Journal Architecture:
 

Back to top
Implementation Steps

Steps listed below apply to all the scenarios with minimal adjustments.

  • Step # 1- Balance Sheet verification report using EVFDRE report of application data before Journal operation
  • Step # 2- Create Journal Templates
  • Step # 3- Create and Save Journal Entry
  • Step # 4- Post , Un-Post , Re-Post Journal Entry
  • Step # 5- Balance Sheet verification report using EVFDRE report of application data before Journal operation

 

Log into BPC Admin and BPC Excel:

All the exercises in the guide are performed via BPC Administration Console and BPC Excel. See below the screenshots on how to log in. There is more than one way to log in:

a) Login to BPC Admin (For Journal template creation)
 

b) Login to BPC Admin (For Journal template creation)
 

Back to top
Journal Template Fundamentals

Journal template is used for entering Journal data for consolidation purposes. An application can have one Journal template defined on it. Journal templates are created using BPC Administration console and required Journal operations are completed using BPC for Excel.

See the screenshots in order below for navigation to access/create a Journal template in the BPC Administration Console:

c) Create Journal Template though Journal Wizard
  a. Navigation Path : BPC Admin Application Journal Wizard
 

d) Create Journal Template though Journal Wizard , Define Journal Template Header and Summary Details
  a. Navigation Path : BPC Admin Application Journal Wizard
 

The Journal Wizard guides the user through the creation of the Journal template by asking for the header and detail dimensions and their order.
 
e) Create Journal Template though Journal Wizard , Define Journal Template Header and Summary Details
  a. Navigation Path : BPC Admin Application Journal Wizard
 
 

The header dimensions appear at the top (header) of the Journal template once specified. Please note the Detail dimensions specified - here only one dimension specified.

 
f) Create Journal Template though Journal Wizard , Define Journal Template Header and Summary Details
  a. Navigation Path : BPC Admin Application Journal Wizard
 

g) Create Journal Template though Journal Wizard , Define Journal Template Header and Summary Details
  a. Navigation Path : BPC Admin Application Journal Wizard
 

After the Journal entry parameters are specified for the template, summary is displayed and is saved.

h) Create Journal Template though Journal Wizard , Define Journal Template Header and Summary Details
  a. Navigation Path : BPC Admin Application Journal Wizard
 

i) Create Journal Template though Journal Wizard , Define Journal Template Header and Summary Details
  a. Navigation Path : BPC Admin Application Journal Wizard
 

Back to top
Scenario 1: Journal entry and Posting
Journal Entry in Excel for BPC
 

Enter Data in Journal Template or Create Journal Entry
 
Journal entry screen appears as shown below. Please note the highlighted input areas for this particular Journal template.
 

Dimension Member Selection for Creating Journal Entry:
 

When a field is selected, you can see the members of the dimension with a right click.

Debit and Credit Entry for Creating Journal Entry:
 

Validate Journal Entry for Selected a Data Region:
 

Save Journal Entry:
 

Post Journal Entry:
 

Review Journal posting through validation report - BPC for Excel:
 

In this example, the EVDRE () is reviewed using high level members for INTCO and P_CC. As there was no data in the application, $1000 will be displayed for all Inter companies under all cost centers as entered by the earlier Journal entry (DEBIT $1000)

Journal posting - CREDIT
 

In this example, a Credit is posted to a different Intercompany and Cost center

Review Journal posting through validation report - BPC for Excel:
 

The EVDRE () report showing $1000 for the US Inter Company for Advertising costs.

In this example, the EVDRE () report shows the collective result of the CREDIT and DEBIT Journal entries for all Inter Companies transactions.

Back to top
Scenario 2: Journal UNPOST
Search Journal's for Un-Posting:
 
Use 'Manage Journals' from Action Pane to bring up a specific Journal to screen
 

Use the Un-post Journal option in the Journal Options to Un-post the selected Journal

Un-Post Journal:
 

Use EVDRE() in BPC for Excel to query the results of the UNPOST operation

Review Journal posting through validation report - BPC for Excel:
 

Back to top
Scenario 3: Journal Query
Existing journals can be queried using the Excel for BPC tool. Select Journals from the Action Pane.
 

Open an Existing Journal:
 
Select 'Open an existing journal' option
 

Journal query screen entry can be used to query for an existing journal

Search and Query Journal Entries:
 

Journals can be queried using multiple parameters like Id, APP, Description, Created By, Modified By, Posted By, Posted Status, Entry Date. In this example, Journal Id is used to query the existing journal. Journal status can be chosen as Posted, Un-posted, Deleted or All.

Select Journal Entries:
 
The queried journal appears that can be selected to be opened.
 
 
After selection, the Open option opens the selected Journal.
 

Back to top
Scenario 4: Journal Report
To create Journal reports, select the 'Report on Journals' from the action pane.
 

Users can create HTML or Excel report from existing journal entries.

Note: The Excel report format is available only for Office XP 2003 version.

Back to top
Scenario 5: Multi Journal Entry
In a multi journal entry scenario, different entries (Credit & Debit) are entered into the same Journal screen. In the following example, the Consulting cost for US entity is entered as a sequence of credits and debits.
 

After the entries are completed, the Post journal option is selected for posting the entries. A dialog box asks for confirmation to save the journal. The journal status now appears as 'Updated'.
 
 

 

The dialogue box confirms that Multiple entry journal has been posted.

Back to top
Journal entry options
Journal Operation Function
UNPOST The original entry to the application is reversed
REPOST Journal values are reentered to the InfoCube if the data was deleted.
DELETE Journal entries that are posted or un-posted are changed to delete status. When these journals are saved, they are deleted permanently.
REOPEN Reopens one or more Journal entries into a new Journal in the subsequent period
Advance Operations Please feel free to contact us directly
Business Alignment Please feel free to contact us directly
 
Journal Advanced Options and Business Alignment:
 
  • This document has been created as a "Jump Starting" guide for business users/SAP BPC technical consultants to better understand SAP BPC NW 7.5 journal implementation steps "end-to-end".
  • This document may or may not provide enough functional and technical details for Journals Advanced Options and also Business Alignment with Journals for such details please feel free to call or mail us.
  • Please feel free to contact us for any deeper detailed discussion around Journals implementation in SAP BPC
 
Disclaimer:

These materials strictly discuss our implementation expertise, and sample coding used our implementation or other information that does not include us official interfaces and therefore is not supported by us. Changes made based on this information are not supported and can be overwritten during an upgrade.

We will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document, and anyone using these methods does so at his/her own risk.

We offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or code sample, including any liability resulting from incompatibility between the content within this document and the materials and services offered by us. You agree that you will not hold, or seek to hold, we responsible or liable with respect to the content of this