Overview

This course teaches application developers how to set up a Controller application and effectively use Controller in their organization’s consolidation process. Students will also design and generate financial reports using Controller. Through a series of lectures and hands-on exercises, students will set up a Controller application by creating the necessary structures (such as accounts and companies), and then test the application to ensure that it works properly. Students will also learn how to work with currency translation, allocations, intercompany transactions, investments in subsidiaries, advanced formula calculations, and user-defined business rules, as well as define configuration settings and user access to the application.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course. http://www.ibm.com/training/terms

Audience

Application Developers

Prerequisites

Basic knowledge of group accounting

Objective

Please refer to course overview

Course Outline

Create companies, consolidation types, and account structures
Create and organize forms for entering data into the Controller application
Generate movement accounts to show changes to data over time
Create extended dimensions to enhance data analysis
Link structures to customize end users’ access to Controller data
Define and schedule the data entry process
Test the Controller application setup
Adjust data through journal entries
Translate foreign currencies
Enable automatically created journal entries
Allocate values
Reconcile and eliminate intercompany transactions
Work with shareholdings and investments in group companies
Calculate and eliminate acquisition values
Consolidate a group’s reported values
Define security restrictions to different parts of the application
Eliminate intercompany profit
Create complex stored calculations
Customize the consolidation process using user-defined business rules (UDBRs)
Create ad hoc reports to quickly analyze and compare figures
Run standard reports to verify and analyze data for consolidation
Create custom reports using the Report Generator
Create, modify, and run reports in Excel using the Excel Link
Run multiple reports simultaneously by grouping reports into report books
Identify different consolidation models (Optional)