ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Consolidating locations
http://www.istechforum.com/YaBB.pl?num=1149708691

Message started by GasGiant on 06/07/06 at 11:31:31

Title: Consolidating locations
Post by GasGiant on 06/07/06 at 11:31:31

At the end of June I am going to be consolidating 21 DBA locations into 6. I need to find a comprehensive list of every table that has location information in it. Where would I go to look this kind of thing up?

Or would it just be easier to merge all locations into one and then recreate the locations that I want?

Title: Re: Consolidating locations
Post by JNAPIER on 06/07/06 at 12:56:08

I am having similar thoughts on reconfiguring my LOCATION scheme. I tried UT-K-E in my test files. It all transfered fine but I had issues with some serialized units. When you went to release them on an SO, it would error saying something about a location record and would not release it. The serial showed up in that location though? I also see an issue with the locations no longer needed. We need some sort of utility to do some house cleaning. If you manually MDB remove them, they will be recreated when you run recon inventory. I really do not want a bunch of locations that are not used in the list. Maybe Mr. Wizard (NZ) has some thoughts on this ::)

John