Today I want to continue discussing new features in Dynamics 365 Business Central 2020 Release Wave 2 (BC17).
Consolidation file format support for Dynamics 365 Finance
This feature is for Dynamic 365 Finance and Supply Chain Management (FO). Let’s look at the description of the feature.
It is 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 or Dynamics 365 Supply Chain Management. In such business constellations, it’s a time saver when the data can be exported in the consolidation file format that Finance and Supply Chain Management expect so that you don’t have to transform the content.
The file format options for a business unit in Business Central will include an option for Finance and Operations.
OK, when the subsidiaries use Dynamics 365 Business Central and the head office uses Dynamics 365 Finance or Dynamics 365 Supply Chain Management, the subsidiaries can quickly export data to the head office.
Log in to Business Central to test this feature.
Search “Export Consolidation” in Tell Me.
A report will open.
You can first choose the File Format of exported file.
Then Enter the following fields.
File Name, Starting Date, Ending Date, F&O Legal Entity ID.
The downloaded file.
The format of the exported file.
Please note the following errors:
If you want to use this feature, you need to set these two fields on the G/L Account Card.
Consol. Debit Acc.: Specifies the number of the account in a consolidated company to which to transfer debit balances on this account.
Consol. Credit Acc.: Specifies the number of the account in a consolidated company to which to transfer credit balances on this account.
I hope this will be help.