Jose,
Thanks for the "concise" response :) Although, that is exactly why I thought it might be easy for someone to create a script to change the Company ID...
for each table in Epicor905
{
UPDATE [table] SET Company = 'KC' WHERE Company = 'KCO'
}
Although I would guess that Company ID is also referenced some other places that may not be so easy to find and update. Trust me, I won't be trying it. I agree that it's not real important to change this. But I figured if there was a way, this group would know. We just got our financials set up in our Pilot database, so we are a little beyond the point that we could create a new Company and start over.
Thank you,
Greg Bakker
Kooima Company
Rock Valley, IA
Thanks for the "concise" response :) Although, that is exactly why I thought it might be easy for someone to create a script to change the Company ID...
for each table in Epicor905
{
UPDATE [table] SET Company = 'KC' WHERE Company = 'KCO'
}
Although I would guess that Company ID is also referenced some other places that may not be so easy to find and update. Trust me, I won't be trying it. I agree that it's not real important to change this. But I figured if there was a way, this group would know. We just got our financials set up in our Pilot database, so we are a little beyond the point that we could create a new Company and start over.
Thank you,
Greg Bakker
Kooima Company
Rock Valley, IA
--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Short answer? Hell NO!
> That ID is on Every table in Epicor I mean every single last table. You are
> stuck my friend unless you want to start over.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Fri, Aug 24, 2012 at 9:58 AM, Greg Bakker <greg.bakker@...> wrote:
>
> > **
> >
> >
> > Does anyone know if there happens to be a way to change the Company ID for
> > a
> > company in Epicor 9.05.700A? Is there some sort of script or utility that
> > could change this? We are part-way into a new implementation. Our Epicor
> > installer initially told us that the Company ID had to be at least three
> > characters long. Is that really the case? It is currently set to "KCO",
> > but we would rather have it set to "KC".
> >
> > Thanks,
> >
> > Greg Bakker
> >
> > Kooima Company
> >
> > Rock Valley, IA
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>