What's New: Cross-Environment Consolidations (2023 release wave 2)

Overview

The session explains what consolidation is, reviews setup and financial reporting for traditional consolidation, then shows the new cross-environment option. Until now consolidation worked for companies in the same environment. Business units can now be set up with an API type endpoint so companies in a different environment can be consolidated too.

The demo covers the new consolidate action with its wizard, setting up business units for cross-environment, copying the endpoint from the consolidation setup page in the subsidiary company, and authenticating. It closes with tips and implementation notes.

Key points

• Cross-environment consolidation uses API endpoints to reach business units in other environments, instead of file export/import.
• In the subsidiary company, toggle the company as a subsidiary before consolidation setup. This enables data import and can be disabled at any time to stop extraction.
• Copy the environment endpoint from the consolidation setup page in the subsidiary and use it when setting up the business unit with an API type endpoint.
• You must authenticate with a user in the other company and select which company in the remote environment to set up.
• The new consolidate action on the business units page opens a wizard where you choose start date, end date and consolidation document number, then pick business units. If consolidations have not been run recently, you use the Grant access action to authenticate.
• The earlier consolidation report still exists and won’t be deprecated. The procedures that run consolidation are internal and not exposed, but the wizard can be run from AL code.
• Consolidation supports currency mapping (subsidiary or holding company rates, optional additional reporting currency), chart of accounts mapping, minority interest percentages below 100, and a trial balance for consolidation.

Features

AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

• page “business units” at 4:51
• page 243 “Consolidation Setup” at 7:20
• report “consolidation per business unit” at 3:27

Not found in BC28-30: page “business units”, report “consolidation per business unit”.

Quotes

• 1:01 “consolidation is when you need to uh import or consolidate your financial statements from multiple uh business entities”
• 4:00 “so up until now it worked with within environment companies so these two that are in the same environment I could just hit the”
• 7:00 “when you do this then you can consolidate across environment it doesn’t necessarily need to be in this same environment”
• 7:41 “after this you will be required to authenticate in that company so in this page you have to authenticate with the user in the”
• 8:01 “before doing this consolidation setup you have to enable this company a subsidiary so when you toggle this you can import data”
• 8:21 “so now you can consolidate uh companies that are either in the same environment or in a completely different environment”
• 8:42 “this new consolidate action and that has this wizard you may have been familiar with the report that we had before the report still”
• 9:02 “we don’t expose them right now but you can run this wizard from your Al code”

Presenters (as heard): Brian Nelson, Joshua.