Jamie,
If you have the ProVision tool and if you take your time and think through
what tables you need ... yes this can be done.
You can export the tables ... import them into access ... mass change the
company ID ... delete the records you don't want ... and then import the
tables back into your existing DB under the different company ID.
I've did this about 2 years ago and it can be done. Do I even need to say -
TEST TEST TEST TEST and backup your DB before you do this ?
The operative word in your email is "SOME" ... would there be any logical
pattern to that statement ?
Note that if you export / import the tables you need into access and then
link them when you delete the items the routings, etc will go with them.
It took me about 40 hours to figure this out and do it over the course of
several weeks. Keying in the items and routings from scratch would have
taken 800-1000 hours.
If you would like to chat about this give me a call ...
Todd Anderson
J. Rubin & Co.
815-489-7052
-----Original Message-----
From: Copsey, Jamie [mailto:
jcopsey@...]
Sent: Thursday, October 26, 2000 11:36 AM
To: '
vantage@egroups.com'
Subject: [Vantage] Question - Setting up another company
Hello,
My company is in the process of setting up another company in our database
for a new facility. All of the parts made at this new facility were at one
point made here, so we have the part master files and the methods set up.
My question is: Is there a way to copy over SOME of the part files
(manufactured and purchased) from our current company over to the new
company? Setting up all the part files again would take forever, and so
far, Epicor has told us we can only copy over the entire set of files. Is
it possible even to just make backups of the part files, cost adjustments,
etc. and load this backup into the new company?
Thanks in advance for any advice.
Jamie
--
Jamie Copsey
Information Systems Coordinator
Accurate Metal Fabricators, Inc.
1011 Seal Beach Blvd
Seal Beach, CA 90704
(562) 596-4740 x138
jcopsey@...
eGroups Sponsor
<
http://click.egroups.com/1/9661/13/_/411782/_/972578285/>
<
http://adimg.egroups.com/img/9661/13/_/411782/_/972578285/WarningHome468x60
2E.gif>
We no longer allow attachments to files. To access/share Report Files,
please go to the following link:
http://www.egroups.com/files/vantage/
<
http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)