Search HansaManuals.com HansaManuals Home >> Standard ERP >> Consolidation >> Exports Previous Next Entire Chapter in Printable Form Search This text refers to program version 4.2 Consolidation Hansa's Consolidation module 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 'Automatic manual file search' Import options in the System module. The file produced by this function will not contain individual Transactions. Instead, it will contain a single record, with balances for each Account. You can import this record to the Transaction register or to the Simulation register: if you are not using the Preliminary Transactions feature, it might be advisable to import to the Simulation register for final checking. You can easily convert the Simulation into a Transaction using the 'Transactions' function on the Operations menu of the 'Simulations: Browse' window. The imported record will have a separate row for each Account balance. The balance of a Daughter Company Account that has a Consolidation Account specified 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 Code 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 partial ownership of the Daughter Company, the balance for each Account whose Reduce Minorities box has been checked will be reduced to the correct percentage. Any Objects used in the Daughter Company will not be included in the export file. The imported record will not have any Objects, unless you specify one in the Cons. 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 the Transaction or Simulation. This posting will use an Account created by the routine for the purpose, with an Account Code of "9999". This will most commonly occur when the Reduce Minorities box has been checked for some Accounts only. 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.
|