最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Perform an online consolidation

网络文摘 William 1630浏览 0评论

You use the Consolidate online process if you want to consolidate multiple companies in Microsoft Dynamics 365 for Operations. Before you can process the consolidation, you must verify that the Use for financial consolidation process option is set to Yes in the legal entity setup for the company that you’re in.

The Consolidate online page has several tabs that you can complete, depending on the requirements of your process. This topic describes each tab.

Criteria

You use the Criteria tab to specify the name of the consolidation, the type of data to consolidate, and the accounts to consolidate that data to. The following fields are available:

  • Description – Enter a description of the consolidation that you’re processing.
  • Main account – To consolidate a specific range of accounts, select the first account in the From field and the last account in the To field. By default, both fields are blank. If you leave them blank, all accounts that have balances will be consolidated.
  • Use consolidation account – If you select this option, you must choose whether to use the account that is defined on the Main account page or a consolidation account group to consolidate the accounts. If you select Consolidation account group, select the group in the list. If you don’t select the Use consolidation account option, all accounts from all the source companies will be created in the consolidation company.
  • Consolidation period – Choose the start and end dates that the consolidation should include the balances for.
  • Actual and budget amounts – Select whether to include actual amounts, budget amounts, or both amounts. If you include budget amounts, you must also select the budget models and budget rate type. If you must consolidate data from Budget planning, you must use Financial reporting.
  • Rebuild balances during consolidation – If you select Yes, all balances for dimension sets will be recalculated during consolidation. If your consolidation process runs for a long time, it might be a good idea to rebuild your balances as a separate step.

Financial dimensions

Use the Financial dimensions tab to select the dimensions to consolidate. If you want to include a financial dimension, select how it should be transferred to the consolidation company. The following options are available:

  • None – The financial dimension isn’t transferred to the consolidation company.
  • Dimension – The financial dimension is transferred as a financial dimension.
  • Group dimension – The financial dimension is transferred as a group dimension.
  • Company account – Use the company as a financial dimension.
  • Account – Use the main account as a financial dimension.

You must also specify the order in which the dimensions will appear in the consolidation company. Enter the order in the Segment order column. The number that you enter is the order of financial dimensions after the main account.

Legal entities

Use the Legal entities tab to select the legal entities to include in the consolidation process. To consolidate only a percentage of the company, enter the percentage in the Share field.

Elimination

Use the Elimination tab to select whether to run the elimination rules as part of the consolidation process. If you prefer to run the elimination rules after the consolidation process is completed, so that you have a two-step process, ignore this tab. If you run the elimination rules during the consolidation process, select whether a proposal should be created. You can review this proposal before posting, or it can be posted as part of the process.

Currency translation

Use the Currency translation tab to define how the balances should be translated during the consolidation process. If the accounting currency of the source company differs from the accounting currency of the consolidation company, you must complete this tab. You can enter different account ranges, and select different exchange rate types and rate types, to follow the appropriate generally accepted accounting policies (GAAP). For example, you can select a range of liquid asset accounts and a rate type that contains a month-end rate, or spot rate. You can then have a second line that has Profit & Loss accounts and select a rate type that contains an average exchange rate.

Additional consolidation accounts

The Apply exchange rate from field has three options:

  • Consolidation date – The exchange rate is selected from the exchange rate type, based on the date of the consolidation.
  • Transaction date – The appropriate exchange rate is selected for each transaction date. This option is typically used for fixed asset accounts.
  • User defined rate – If you select this option, you can enter an exchange rate.

After you’ve completed the various tabs, you can process the consolidation by clicking OK. Alternatively, you can run the consolidation in a batch. When the process is completed, you can view the balances by day and company on the Consolidation transactions inquiry page.

转载请注明:ww12345678 的部落格 | AX Helper » Perform an online consolidation

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址