Search HansaManuals.com HansaManuals Home >> Standard ERP >> Consolidation >> Exports Previous Next Entire Chapter in Printable Form Search This text refers to program version 8.4 Consolidation This page describes the Consolidation export function in the Consolidation module.--- The Consolidation module in Standard ERP is designed so that information in Daughter Companies can be made available to certain reports in the Mother Company without the need physically to transfer any Daughter Company information to the Mother Company. This makes it very easy to produce consolidated reports, and removes the risk of error inherent in copying information from one Company to another. However, the requirement to have the Mother and Daughter Companies in the same database may not be practical in every case. Where this is so, you can use this function to export Transaction information from a Daughter Company to a text file. You can then import this text file to the Mother Company, which could be in a different database. Before you use this function in a Daughter Company, it is recommended that you produce a Consolidation Report. This will show what will be included in the text file. You should produce the export from each Daughter Company. You can then import each export file to the Mother Company using the 'Automatic' or 'Manual file search' Import options in the System module. Do not name the export files with two leading minus signs/hyphens (e.g. --Data.txt) as it is not possible to import information from files named in this way. The file produced by this function will not contain individual Transactions. Instead, it will contain a single record, with balances for each Account (or the net change over a specified period). You can import this record to the Transaction register or to the Simulation register: if you are not using the Use Preliminary Transactions option in the Transaction Settings setting, it might be advisable to import to the Simulation register for final checking. You can easily create a Transaction from the Simulation by highlighting it in the 'Simulations: Browse' window and selecting 'Create N/L Transactions' from the Operations menu (Windows/macOS) or Tools menu (iOS/Android). In the imported record, there will be a separate row for each Account balance. The balance of a Daughter Company Account in which you have specified a Consolidation Account will be posted to that Consolidation Account in the Mother Company. Otherwise, the balance will be posted to the Mother Company Account with the same Account Number as the Daughter Company Account. Any Accounts used in the export file but not present in the Mother Company will be added to the Mother Company's Account register. If you have used the Main Owner Percentage register to record the partial ownership of the Daughter Company, the balance for each Account in which you have selected the Reduce Minorities option will be reduced to the correct percentage. Any Tags/Objects used in the Daughter Company will not be included in the export file. The imported record will therefore not include any Objects, unless you specify one in the Cons. Tag/Object field in the 'Specify Consolidation Export' window. If the record does not balance when it is imported, the import routine will add a balancing posting to the end of a Transaction but not to a Simulation. This posting will use an Account created by the routine for the purpose, with an Account Code of "99999". This will most commonly occur when a Daughter Company is partially owned, but you have not selected the Reduce Minorities option in every Account. If you are using different Currencies in the Mother and Daughter Companies, you must make sure that one Currency (the "Group Currency") is used as a Base Currency in both Companies. In the Consolidation Settings in each Company, you should specify whether the Group Currency is being used as Base Currency 1 or 2 in that Company. All figures in the export file will be in the Group Currency. If you are using different Currencies and will be consolidating using this export function, it is recommended that you use the Mother Company for consolidation purposes only: it should not have any Transactions of its own.
--- Export functions in the Consolidation module:
|