Adjustments that should be automatically performed on the bases of input data provided to the Consolidations module
In discussions with our clients, we have identified several automatic adjustments that your system should handle:
- Automatic Cancellation of Shareholdings: Adjust for shareholdings in subsidiaries, accounting for events such as payments, subscriptions, acq...
STATUS DETAILSNew
For the consolidation process, start each year from the aggregate value of subsidiaries, do not open accounts with consolidation adjustments from previous years
According to international accounting principles, the preparation of the consolidated financial statements for the current year cannot simply be based on the previous year's consolidated financial statements. It is always necessary to start with the financial statements of the individual entit...
Dashboard to view all intercompany credits, debts, revenues and costs between subsidiaries
During our meeting with a client interested in the Consolidations module, the client suggested the addition of an intercompany dashboard. This dashboard would display all intercompany transactions between subsidiaries, facilitating necessary adjustments during the consolidation process.
Use a Weighted average exchange rate based on the covered period of the report (yearly, quarterly)
To better serve global enterprises managing multiple legal entities with different currencies, we propose an enhancement to the Consolidations module. This enhancement will focus on incorporating comprehensive IAS 21 (International Accounting Standard 21) compliance features, specifically the ...
D365 AutomaticallyConsolidation on line generation
During the analysis of the requirements for the consolidation setup in D365FO, we became aware that several standard activities are not fully covered (therefore customizations are required), or they require lengthy and manual processes that make the proce...
Ability to select Elimination GL Posting date on Consolidate online screen when using Consolidation online templates
Under 10.0.40 Consolidation online templates have been released. When setting up a template, there is a mandatory field for GL posting date under the Elimination fasttab. When using the Consolidate online process with the template, there is no ability to select a GL posting date for eliminatio...
Reporting currency amount not fully eliminated in consolidation/elimination company
The Reporting currency in elimination journal is converted from accounting currency using the end of month exchange rate and not a historical reporting currency amounts which creates a discrepancy between the elimination and source company reporting currencie...
Consolidate Online - Foreign Currency Revaluation
Currently, consolidate online does not appear to have functionality to correctly convert balance sheet accounts.
Under IAS 19 balance sheet accounts should be revalued from foreign currency at the closing date. Consolidate online revalues the movement in the period to this da...
System should not create consolidation entries if the period is put on hold.
When we put Period on hold in consolidation legal entity and consolidation online process is run first time for a given period, system is generating consolidation entries for the legal entity specified in the online consolidation form which should not happen.
Ability to drill down to individual vouchers(of other legal entities) from Consolidation legal entity.
Main account wise, day wise balances appear in consolidation legal entity upon running consolidation process. However, the back tracking to voucher posted in individual legal entity is not available, which is a pain point for reconciliation of entries posted in consolidation legal entity.
...