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 procedure inefficient.

We ask for support and advice about how to manage these standard consolidation procedures not covered by the consolidation online form in D365FO, requested by our client:

- Aggregation transactions from consolidated companies

- Print the consolidation BS and P&L

- In the foreign legal entities, for the P&L main accounts, use a weighted average exchange rate based on the covered period of the report (yearly, quarterly)

- Manage rounding currency translations in the reporting

- Manage rounding due to different percentages of shareholdings of subsidiaries

- Import the transactions from a subsidiary not in D365FO

- Create specific adjustments on the accounts in the consolidation chart of accounts

- Have a dashboard to view credits, debts, revenues, and costs between subsidiaries

- Automatic cancellation of shareholdings in the subsidiaries

- Automatic adjustments for the allocation of the goodwill and the depreciations based on the goodwill

- Automatic capital gain/loss adjustments for intercompany sales of fixed assets

- Automatic adjustment of dividends

- Automatic procedure for the aggregation of equity items for elimination

- Automatic entries for determining third-party equity

- Automatic entries for determining third-party profit and loss

- Automatic intercompany adjustments

- For the consolidation process, start each year from the aggregate value of subsidiaries; do not open accounts with consolidation adjustments from previous years