• Business Scenario
• Document Objective
• Prerequisites/Assumptions
• Implementation Steps
• Journal Template Fundamentals
• Scenario 1: Journal entry and POST
• Scenario 2: Journal UNPOST
• Scenario 3: Journal Query
• Scenario 4: Journal Report
• Scenario 5: Multi Journal Entry
• Journal entry options

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.

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

• 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

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:

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

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.

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:

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.

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.

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.

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