Consolidation file format support for Dynamics 365 Finance


This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users, automatically Aug 1, 2020 Oct 1, 2020

Business value

It's not uncommon for Dynamics 365 Business Central to be used by subsidiaries that must then report financial statements for consolidation to a company that runs Dynamics 365 Finance. In such business constellations, it's a time saver when the data can be exported in the consolidation file format that Dynamics 365 Finance expects so that you don't have to transform the content.

Feature details

When you use Export Consolidation, the request page field File Format has a new option value, Dynamics 365 Finance (.txt), that will generate a file that you can import straight into Dynamics 365 Finance.

When you choose the Dynamics 365 Finance file format, the F&O Legal Entity ID field becomes required. Here, you must provide the ID of the legal entity in Dynamics 365 Finance that represents your Business Central company.

See also

Consolidating Financial Data from Multiple Companies (docs)