Welcome, Guest. Please Login.
05/14/25 at 11:47:56
News:
Home Help Search Login


Pages: 1
Send Topic Print
Consolidating locations (Read 341 times)
GasGiant
Administrator
*****


How can I help?

Posts: 1517
Gender: male
Consolidating locations
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?
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Consolidating locations
Reply #1 - 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 Roll Eyes
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
Pages: 1
Send Topic Print