Change method of consolidation online functionality
Consolidation method
- Current D365 FO: Consolidate data by period movement (from date.. to date) -> Elim by period movement -> Gain/loss by movement -> Consolidation transactions are summarized by “Original Date + Ledger (account+findim)” -> Run foreign currency revaluation to update...
STATUS DETAILSNew
Option to Consolidation with Transaction Currency
Right now consolidation can be done with Accounting currency and Reporting currency. Some companies have requirement to
- revaluate their source company accounts on Exchange rate type 1
- revaluate their consolidation company accounts on exchange rate type 2
Allow users to edit Consolidation - Elimination journal lines
Consolidations>Elimination Journal>Create new>>Lines>Proposals>Elimination proposal
- users are unable update, edit or add/delete lines on the created Elimination journal
Customer is seeing the need to edit when debits/credits are not balanced. Thus, proposing to have t...
Consolidation - Elimination journal should post exchange rate difference automatically
Consolidation is done for several companies with different currency. During the process, all intercompany accounts must be eliminated. But the actual elimination rules process is not optimal. Elimination transactions are retrieved with original company currency. Elimination journal is balanced...
Ability to select posting layers which needs to be included in consolidation process of D365
When online consolidation process is run, it sum up balances for all the posting layer. An option to select posting layer would help business include required set of transactions to sum up in consolidation legal entity. Example - Many a times we get client requirements to post internal revenue sh...
Consolidation - transactions history kept
When doing consolidations on same dates and same companies, but with different groups of consolidation, previous transactions are emptied when calculating a new one. It could be useful to keep historical transactions as previous versions, specially when groups of consolidation are different. (re...
Ability to include or exclude posting layers in Online consolidation
Ability to include or exclude posting layers in Online consolidation
consolidation Export company balance should have option to export opening transactions
Consolidation Export company balance should have option to export opening transactions So far only Operating transaction can be exported. Meaning that this export feature can only be used for system like dynamics. if a company would like to export for dynamics to import on third party tool and ...
Consolidation for statutory Chart of accounts
Currently, when an account is not mapped in the Additional consolidation accounts, the Consolidation on line creates the account from source company in consolidation company, and completes consolidation. It polutes the CoA in the consolidation company. There should be a parameter in the Consol...
Consolidation period control for modification
When consolidation process is run twice on same period, there is no control or indication that new transactions have been transferred.
Period statut does not work on consolidation company so no blocking can be done.
The idea will be to have some warning or control before process ...