V6.1 - Old Warehouse Locations

Yahoo Archive
1
I have posted an issue with Vantage on this. It drives me nuts that we
can't do this, as I occasionally get accidental transactions against
these defunct bins. Maybe others can sign up to this issue.



Thanks,





Bruce





Message: 2

Date: Tue, 26 Jul 2005 13:29:46 -0000

From: "j_milbrath" <jeffrey.milbrath@...>

Subject: Re: v6.1 - Old Warehouse Locations



I have not found a way to delete these old warehouses and bin

locations. Don't think that is possible because of transaction

history. But, it sure would be nice if you could flag them

as "inactive" (as you can with part numbers) to prevent their

further use. The best solution I have come up with is to change the

description for the warehouse or bin to "**DO NOT USE**" in hope

that people will read it and realize something is wrong.



Jeff Milbrath

Controller

Hartford Finishing, Inc.







[Non-text portions of this message have been removed]
2
Is there any way to remove a reference to an old warehouse in the Part
File Maintence? We have restructured the way some parts are handled,
but are unable to delete the old warehouse reference because there are
inventory transactions against it. We are using the primary, but I
would like to completely remove it. All indications are that this is
not possible, but it is at least worth asking.

Michael Randolph
Purchasing Manager
American Magnetics, Inc.
3
As far as I know, anything with a transaction cannot be deleted. Part
numbers, warehouses, bins, etc.



Mike

Flexial - 6.1



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ami_miker
Sent: Monday, July 25, 2005 2:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] v6.1 - Old Warehouse Locations



Is there any way to remove a reference to an old warehouse in the Part
File Maintence? We have restructured the way some parts are handled,
but are unable to delete the old warehouse reference because there are
inventory transactions against it. We are using the primary, but I
would like to completely remove it. All indications are that this is
not possible, but it is at least worth asking.

Michael Randolph
Purchasing Manager
American Magnetics, Inc.




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS


Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&
w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+databas
e+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOKk1Yg
> support

Vantage
<http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Vantage
&w3=Database&w4=Database+management+software&w5=Membership+database+software
&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw>

Database
<http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Vantag
e&w3=Database&w4=Database+management+software&w5=Membership+database+softwar
e&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>


Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Technic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx-Yh-
u9MWSh0_-hA> management software

Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Technic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQZ8LT
26M5TzRGQlg> database software

Church
<http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technical+s
upport&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+
database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7Qnq6
ys_yZxg> database software



_____

YAHOO! GROUPS LINKS



* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



[Non-text portions of this message have been removed]
4
I have not found a way to delete these old warehouses and bin
locations. Don't think that is possible because of transaction
history. But, it sure would be nice if you could flag them
as "inactive" (as you can with part numbers) to prevent their
further use. The best solution I have come up with is to change the
description for the warehouse or bin to "**DO NOT USE**" in hope
that people will read it and realize something is wrong.

Jeff Milbrath
Controller
Hartford Finishing, Inc.

--- In vantage@yahoogroups.com, "ami_miker" <michael.randolph@a...>
wrote:
> Is there any way to remove a reference to an old warehouse in the
Part
> File Maintence? We have restructured the way some parts are
handled,
> but are unable to delete the old warehouse reference because there
are
> inventory transactions against it. We are using the primary, but
I
> would like to completely remove it. All indications are that this
is
> not possible, but it is at least worth asking.
>
> Michael Randolph
> Purchasing Manager
> American Magnetics, Inc.
5
At 09:29 AM 7/26/2005, you wrote:
>Is there any way to remove a reference to an old warehouse in the
>Part File Maintenance? ..... are unable to delete the old warehouse
>reference because there are inventory transactions against it.

If you have ProVision or some other way to write to the database, you
can get rid of that sort of stuff. What I've done is create one
warehouse / work center / whatever titled something like "Obsolete /
Changed". Then overwrite the field in the transactions to point to
the new one. The old or erroneous warehouse can then be
deleted. Understand that by doing this you're clobbering historical
data and leaving no audit trail. But you can clean up all the old
junk, or at least consolidate it so it's all pointing at just one item.


-Wayne Cox
Twenty Three, Inc. -- Information Technology Consulting
828-685-2338