Hi,

I need to join two companies. Can anybody give me a clue how this can be done? What steps to follow? Some doc's maybe?
BaaN version is IVc3/AIX multilogistic/monofinancial.
More precise:
Logistic companies: 101, 102, 103, 104
Financial company:100
I want to join companies 101 and 103

Thank you.

What exactly are you trying to do ?
a)
Do you mean to share a set of tables between two baan companies ? Setting up Logical Tables will allow this.

b)
Write Baan code that will process data from multiple companies ?
There are standard Baan programing functions for this

c)
Move data between companies as a one time ?
Baan Exchange.

Please provide more detailed information about your specific problem.

I have not had the occasion to try this, but as per the manual, it is possible to use the tablename._compnr field.

For example, assuming that you want to report data from 101 and 103 as if they were in a single table, you could try:


select ttmmmnnn.*
from ttmmmnnn
where {all your required conditions}
and (ttmmmnnn._compnr = 101 OR ttmmmnnn._compnr = 103)
...



This will give records from both the companies together.

Hope this helps.

Hi,

No, this is not the point. Sorry for the confusion.
What I want is to join all the data from two companies into one single company keeping all the relations with the financial company.
So, I have two logistic companies 101 and 102, and one finacial company 100. I want to "move" all the date from 101 and 102 to company 103 witch must be linked to financial company 100.

Thank you.

I've gone through this exercise and it is a quite extensive task. The general steps were:

1. Archiving and deleting as much data out of both companies as possible.
2. Writing a program to compare the tables in both companies and print out the records with the same key fields in both companies (e.g. same order numbers, text numbers etc.)
3. Deciding table by table, how to consolidate the data in one company.
3. Changing the records, which existed in both companies with the help of exchange schemes and programs (e.g. writing a program that creates new text numbers)
4. Importing the data of both companies into one new company.
5. Running the tfgld900X sessions to change the company numbers to the new company number

There are of course a lot of small steps inbetween. The whole thing needs carefull analysis and planning.