Blogs

Here's a listing of the IBM Controller Proven Practices documents for your reference.

Application settings:

• Guidelines to using change tables:

http://www.ibm.com/support/docview.wss?uid=swg21999354.

• Guidelines to using Z consolidation method:

http://www.ibm.com/support/docview.wss?uid=swg21999351.

• Guidelines to using company and group journals:

http://www.ibm.com/support/docview.wss?uid=swg21999349.

• Guidelines to using Calculation accounts

http://www.ibm.com/support/docview.wss?uid=swg21999352

Consolidation settings:

• Guidelines to currency translation

http://www.ibm.com/support/docview.wss?uid=swg21998446 .

• Guidelines to using historical rates

http://www.ibm.com/support/docview.wss?uid=swg21998450.

• Guidelines to general configuration, account structure and automatic journals

http://www.ibm.com/support/docview.wss?uid=swg21998442 .

• Guidelines to configuring intercompany profit

http://www.ibm.com/support/docview.wss?uid=swg21998386.

• Guidelines and examples of allocations

http://www.ibm.com/support/docview.wss?uid=swg21999091

• Guidelines to eliminating gain or loss on sales of fixed assets

http://www.ibm.com/support/docview.wss?uid=swg21999090 .

• Investment elimination using currency conversion method 2

http://www.ibm.com/support/docview.wss?uid=swg21999093.

Import and export:

• Guidelines to importing structures:

http://www.ibm.com/support/docview.wss?uid=swg21999355

• Guidelines to importing structures using staging tables and SQL server

http://www.ibm.com/support/docview.wss?uid=swg22000747.

• Guidelines to importing data:

http://www.ibm.com/support/docview.wss?uid=swg21998671

• Guidelines to importing data using IIF function:

http://www.ibm.com/support/docview.wss?uid=swg22000744.

• Guidelines to setting up and using look-up tables

http://www.ibm.com/support/docview.wss?uid=swg22000741.

• Guidelines to importing data using lookup splits:

http://www.ibm.com/support/docview.wss?uid=swg22000728.

• Guidelines to loading non-cumulative monthly data

http://www.ibm.com/support/docview.wss?uid=swg22000752.

• Guidelines on handling intercompany balances when the counter company is the actual general ledger account number.

http://www.ibm.com/support/docview.wss?uid=swg21999092.

• Guidelines to importing journals

http://www.ibm.com/support/docview.wss?uid=swg22000745.

• Guidelines to importing data from TM1

http://www.ibm.com/support/docview.wss?uid=swg22000757.

Financial reporting:

• Building notes to financial statements

http://www-01.ibm.com/support/docview.wss?uid=swg21998444

• Guidelines to designing efficient report in excel link

http://www-01.ibm.com/support/docview.wss?uid=swg22000900

Other:

• How to improve performance

http://www-01.ibm.com/support/docview.wss?uid=swg21690080

• How to maintain and optimize Controller SQL database

http://www-01.ibm.com/support/docview.wss?uid=swg21396973

• How to reduce the size of a Controller database by deleting data from XDBTRICKLE

http://www-01.ibm.com/support/docview.wss?uid=swg21624409