Merge Company Data

Hi All,

I have been assigned the task to merge two company’s data .

I have to ask how can i achieve this even after following all the validations and records having same data must not be imported ?

Does this can be achieved by using Definition Group ??

Hi Lalit,

Please use virtual company accounts. Please refer below link

http://technet.microsoft.com/en-us/library/aa834413.aspx

By using Virtual Company account,only the data will be shared . But i want to merge two company’s data into one …

How can i achieve this ??

Hi Lalit,

By writing below piece of code it mayhelp you;

table1 tabledestination,tablecopy;

select firstonly tablecopy;

changecompany(“companyname”);

{

ttsbegin;

buf2buf(tabledestination,tablecopy);

tabledestination.insert();

ttscommit;

}