You set up the consolidated company in the same way that you set up other companies. The chart of accounts is independent of the chart of accounts in the other business units, and the chart of accounts in the individual business units may differ from one another. You set up a list of companies to consolidate, verify the accounting data before consolidating, import from files or databases, and generate consolidation reports.
For more information, see Set Up Company Consolidation. Consolidating financial data may especially be relevant in connection with intercompany processes. For more information, see Managing Intercompany Transactions.
If you have more than one company in Business Central, the Consolidated Trial Balance report can give you an overview of the financial health of your overall business.
The report combines general ledger entries from each of your companies in a new company that you create to contain the consolidated data. This company is typically referred to as the "consolidated company". The consolidated company is just a container for the consolidated data, and does not have any live business data.
The companies that you include in the consolidated company become Business Units in the report. The process of transferring the figures from the business units to the consolidated company is the actual consolidation. Before you do this, it is a good idea to check whether there are differences between the basic information in the business units and in the consolidated company. There are two reports that you can use to test the database and file. You can test your data before you transfer it to the consolidated company.
Business Central looks for differences in the information in the business units and the consolidated company. For example, whether account numbers or dimension codes are different. You must correct errors before you can run the report. You can test the database or, if you are importing data from an XML file, you can test the file. For more information, see Set up a subsidiary legal entity for consolidation. If the same criteria apply to several subsidiaries that are in the same database, you can transfer data from those subsidiaries to separate export files by using a single operation.
On the Financial dimensions tab, specify the financial dimension information that is transferred from the transactions in the subsidiary accounts to the transactions in the consolidated legal entity.
On the Legal entities tab, create a line for each subsidiary legal entity whose accounts will be exported to files. These files will be imported into the consolidated legal entity later. For each subsidiary, enter the subsidiary name and the name of the export file that will be created during the export job.
Click Batch to set up the consolidation to run as a batch job at a specific time, or click OK to run the consolidation immediately. When the export is completed, a message displays the number of records that were saved in each file. You can then import the files into the consolidated legal entity. Use the Consolidate [ Import ] form to prepare the transfer of subsidiary data from the export files to the consolidated legal entity.
If the same criteria apply to several subsidiaries, you can transfer data from those subsidiaries to the consolidated legal entity by using a single operation. On the Legal entities tab, create a line for each subsidiary legal entity whose data will be imported into the consolidated legal entity.
Notify me of new posts via email. Create a free website or blog at WordPress. Enough chitchat let us go through the steps in how to do it: 1. Download Consolidated.
KML file 4. Share this: Share Facebook Email. Like this: Like Loading Leave a comment Trackbacks 2 Comments Roba April 25, at am. Andrix April 26, at am. Mesh April 26, at pm. Jeremy April 26, at pm. Meshx86 April 27, at am. Hello Jermey, the error you posted, it belongs to iPhone Backup Extractor, this tool used just to extract the.
Kimzter April 27, at am. Mikl April 27, at am. It would be great to get time-linked points to view track, not only places. Andrew April 30, at pm. Kimzter May 9, at pm. Bill July 27, at pm. Tom August 18, at pm. Charity December 20, at pm.
Meshx86 December 20, at pm. Frederik October 20, at pm. Hey there — is this working with IO6 — I have some problems with it. Meshx86 February 28, at am.
0コメント