Hi Everyone, How do I consolidate three Databases on Customer and Vendor Accounts. How do I do this?. Consolidation in navision is it only done on G/L accounts. That is what I observed. Thanks Alofokhai
What do you mean by consolidate. In accounting this implies being able to report consolidated numbers. Do you want something like that e.g. consolidated sales $ for the three companies? If so, can’t you do that through the G/L?
plS. On the Consolidated Database we want to see all transaction from the three (3) Databases that make up the Consolidate Database of a particular Customer or vendor. As it is in navision now we can only see conslidate G/L Accounts Thanks, waiting for your respond. Alofokhai
There are different options, that depend on your requirements - I understand that you have 3 companies within a single database, or do you have 3 seperate databases??? Assuming it’s having 3 companies within a singe db: 1) Report - just printing, filling temporary records with the necessary information from the 3 companies… using CHANGECOMPANY to obtain the data from the different companies. 2) Data Consolidation - develop proceses that put together the information on a consolidated basis… watch out for entry no. and customer/vendor nos. Navision standard only has financial consolidation, if you need to consolidate other information, then you’ll have to develop something on your own or look for a possible available add on. Saludos Nils
Pls. I have three (3) different Databases. Does that mean it is not possible to consolidate these 3 databases on Customer and Vendor basis. Alofokhai
quote:
Does that mean it is not possible to consolidate these 3 databases on Customer and Vendor basis.
No, but depending on the circumstances there are different approached possible… In that case, I would develop something similar to the standard consolidation. Create dataports to export the necessary information, from the information you provide, it should be sufficient with ledger entries, and use the same dataports, with some additional validations and primary key adjustments, to import these data into a new company. Like this, you will be able to use your standard report on these data. You might also include vendor/customer information to have the consolidated company up to date with this data. Saludos Nils
quote:
Pls. I have three (3) different Databases. Does that mean it is not possible to consolidate these 3 databases on Customer and Vendor basis. Alofokhai
Originally posted by Alofokhai - 2006 Feb 23 : 17:29:25
What is the objective of the consolidation?