Mapping tables for the Bring Balances Forward procedure
The current Bring Balances Forward procedure maps the T999 Closing transaction type from the prior reporting period always to T000 Opening of the current reporting period. All balance sheet accounts are always brought forward to the indentical acc...
Add paging in reports for Legal Entities (including the ones listed for workflow)
Sometimes, there are many Legal Entities at customers, paging function would be needed in reports: "Scope of consolidation", "Data collection", "Consolidation Manager", "Consolidated Financial Statement".
Custom source level elements in the Consolidation dimension
The Local GAAP element of the Consolidation dimension is the only element to receive original source data for the separate financial statements. This data is captured on the ~ element of the Scope dimension and shows automatically on all other sco...
Protect cube cells in the Financial Consolidation model on database level for completed workflow activities
In the current implementation workflow (including the protection of changing cell values and executing procedures) is implemented in designed web reports. Users using views, the Excel add-in or other methods to access database cells can bypass the...
As a power user of the Financial Consolidation model I want to proceed (or restart, see related idea)) multiple workflow steps at once so that I don't have to repeat this multiple times. This should be possible on any aggregated element above the ...
Provide an interface to the Integrated Financial Planning model
Provide an import interface (e.g. as an Integrator job) to import the separate financial statements of one or multiple legal entities from the Integrated Financial Planning model. The interface should map the monthly amounts to the required year-t...
Execute the Bring Balances Forward procedure for multiple reporting periods at once in the Finanical Consolidation model
Extend the bring balances forward procedure to populate the opening balances for multiple reporting periods of the same fiscal year from the same prior closing period with one execution.
Excel reporting package for the Financial Consolidation model
Provide an Excel template for collection of separate financial statements for one entity and in one reporting period. Add a self-service interface for end users to upload separate financial statements using this template.
Storage, input screens and import interface for trial balances in the Financial Consolidation model
The database should be extended by a storage of trial balances in local charts of accounts. Data should be either imported from a file in a standard format or/or captured from input screens. The input screens should cover values for ledger account...