The following tips are taken from John Cerqueira’s presentation " Improve the quality of cash flow reports using account transformation and currency translation business rules” at the Financials 2012 event, being held in Las Vegas, Nevada, March 13-16.

7 tips for using group currency cash flow reporting in SAP BusinessObjects Planning and Consolidation

• Load affiliate local currency balance sheets and income statements to SAP BusinessObjects Planning and Consolidation
• Execute Account Transformations to derive direct cash flow and indirect cash flow lines in Local Currency
• Use standard SAP BusinessObjects Planning and Consolidation reporting functionality using a direct cash flow account hierarchy for direct cash flow reporting
• Use standard SAP BusinessObjects Planning and Consolidation reporting functionality using an indirect cash flow account hierarchy for indirect cash flow reporting
• Validate Local Currency cash flow statements before executing Currency Translation
• Execute Currency Translation to post Group Currency values to Balance Sheets, Income Statement, and cash flow accounts
• Elimination will have to feature eliminations to cash flow accounts