jack786
6th August 2004, 07:32
I copied some data from company 100 to 101.But in some tables company number field is there.Now in company all those field values I want to change
100 to 101.Do I need to manually? or is there any session to do this??

danielv
6th August 2004, 08:19
Need to: Update company number within tables- tflgd9004m000
Must be in company to be changed to (e.g. 101)
Also, it can take a few hours

D

rochus
6th August 2004, 17:26
is now available also for baan4,
you have to export, change compn. number, the import,
faster the tfgld9004m000

mark_h
6th August 2004, 18:26
rochus

Just for verification - do I just log into the company I am going to copy the data to and run this session? So in Jacks instance I would log into 101 run tccom0214m000 and it would convert my export files with 100 in them to 101 - Correct? Does this have to be a complete dump of all tables or just any tables I am moving between companies? I have been doing this by hand for just a few tables.

Learned something new today - thanks.

Mark

rochus
6th August 2004, 18:53
a) export these tables with delimiter "|" f.i. to new directory
b) run tccom0214m000 from source company (specify) "|"
c) import tables into dest. company

hope it helps

mark_h
6th August 2004, 20:40
Yep - that helps. I tested it. The company data is like this source>destination or in this post example it would 100>101.

Thanks

Mark