VishalMistry
29th January 2009, 09:52
Hi all,
We have two companies (101 & 102 both are single log / single fin). I want copy an item (tiitm001) from one company to another. Can anybody help how this can be done.
It would be great if any script for the same is posted.
Thanks in advance,
Vishal
zardoz
29th January 2009, 13:25
Just select records you want, after that set the company of destination (say 101 ->102) like:
tiitm001._compnr = 102
and do an insert
Hitesh Shah
29th January 2009, 19:24
Take care of
1. dependent reference table like mcs tables,emp , supplier tables etc
2. company wide figures like inventory level, cost prices, cumulative issues etc.Need to reset the probably.
VishalMistry
30th January 2009, 05:44
Thanks a lot Mr. Zardoz. It Works perfectly.
Vishal
VishalMistry
30th January 2009, 05:45
Thanks a lot. I will keep this in mind while copying record.
Vishal
rahul.kolhe22
30th January 2009, 09:11
Hi,
Vishal I guess that the companies 101 and 102, both are belonging to same package combination.
If so I was wondering whether it would be possible, if both the companies were belong to different package combination and both the tables have the same table defination.
Thanks in advance
--Rahul
VishalMistry
31st January 2009, 08:34
Hi,
Need to be checked as i have never tried such case.
Vishal