Sales Tax Blank Title 72671

Yahoo Archive
1
Can anyone give me an over of how sales tax works in the system
specifically if I want to charge sales tax for some items in the part
master but not others.



Thanks!



Dale



[Non-text portions of this message have been removed]
2
We are currently restructuring some of our warehouse bin layouts and
looking to implement new bin numbers. Does anyone know if/how we can
delete, remove, or hide the old bins?

thank you in advance,

Bryan DeRuvo
3
We have never found a way. Epicor needs to add an inactive option for
bins.



Regards,





Andrew Best

Kice Industries, Inc.

P(316)744-7151

F(316)295-2412



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bderuvo
Sent: Wednesday, January 07, 2009 9:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Deleting Bins



We are currently restructuring some of our warehouse bin layouts and
looking to implement new bin numbers. Does anyone know if/how we can
delete, remove, or hide the old bins?

thank you in advance,

Bryan DeRuvo





[Non-text portions of this message have been removed]
4
We've always had to resort to renaming the bin description to something like 'Obsolete.' Of course if you're not careful the bin can (and probably will) be used at some point.




________________________________
From: Andrew Best <abest@...>
To: vantage@yahoogroups.com
Sent: Thursday, January 8, 2009 9:02:25 AM
Subject: RE: [Vantage] Deleting Bins


We have never found a way. Epicor needs to add an inactive option for
bins.

Regards,

Andrew Best

Kice Industries, Inc.

P(316)744-7151

F(316)295-2412

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of bderuvo
Sent: Wednesday, January 07, 2009 9:46 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Deleting Bins

We are currently restructuring some of our warehouse bin layouts and
looking to implement new bin numbers. Does anyone know if/how we can
delete, remove, or hide the old bins?

thank you in advance,

Bryan DeRuvo

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
5
In 8.03, the bin should be able to be deleted if it is not refereced by
anything else.

So as long as you no longer have any inventory located in it, and it is not
setup as the default location for any parts, WIP or anything else, there
shouldn't be any problem deleting a bin.


----- Original Message -----
From: "Daniel Mccarthy" <danmccarthy74@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, January 08, 2009 9:10 AM
Subject: Re: [Vantage] Deleting Bins


> We've always had to resort to renaming the bin description to something
> like 'Obsolete.' Of course if you're not careful the bin can (and
> probably will) be used at some point.
>
>
>
>
> ________________________________
> From: Andrew Best <abest@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, January 8, 2009 9:02:25 AM
> Subject: RE: [Vantage] Deleting Bins
>
>
> We have never found a way. Epicor needs to add an inactive option for
> bins.
>
> Regards,
>
> Andrew Best
>
> Kice Industries, Inc.
>
> P(316)744-7151
>
> F(316)295-2412
>
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
> Of bderuvo
> Sent: Wednesday, January 07, 2009 9:46 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Deleting Bins
>
> We are currently restructuring some of our warehouse bin layouts and
> looking to implement new bin numbers. Does anyone know if/how we can
> delete, remove, or hide the old bins?
>
> thank you in advance,
>
> Bryan DeRuvo
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------
>
> 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/.
> (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/linksYahoo! Groups Links
>
>
>
6
I agree that there shouldn't be a problem with this, but in our experience it is not possible to delete a bin if it is associated with any past inventory transactions, even if there if there is no inventory located in it and it is not set as the default for any parts. Vantage will advise "Delete not allowed, referenced by at least one inventory transaction."




________________________________
From: Ned <TechnoBabbly@...>
To: vantage@yahoogroups.com
Sent: Thursday, January 8, 2009 9:23:19 AM
Subject: Re: [Vantage] Deleting Bins


In 8.03, the bin should be able to be deleted if it is not refereced by
anything else.

So as long as you no longer have any inventory located in it, and it is not
setup as the default location for any parts, WIP or anything else, there
shouldn't be any problem deleting a bin.

----- Original Message -----
From: "Daniel Mccarthy" <danmccarthy74@ yahoo.com>
To: <vantage@yahoogroups .com>
Sent: Thursday, January 08, 2009 9:10 AM
Subject: Re: [Vantage] Deleting Bins

> We've always had to resort to renaming the bin description to something
> like 'Obsolete.' Of course if you're not careful the bin can (and
> probably will) be used at some point.
>
>
>
>
> ____________ _________ _________ __
> From: Andrew Best <abest@...>
> To: vantage@yahoogroups .com
> Sent: Thursday, January 8, 2009 9:02:25 AM
> Subject: RE: [Vantage] Deleting Bins
>
>
> We have never found a way. Epicor needs to add an inactive option for
> bins.
>
> Regards,
>
> Andrew Best
>
> Kice Industries, Inc.
>
> P(316)744-7151
>
> F(316)295-2412
>
> From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
> Of bderuvo
> Sent: Wednesday, January 07, 2009 9:46 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Deleting Bins
>
> We are currently restructuring some of our warehouse bin layouts and
> looking to implement new bin numbers. Does anyone know if/how we can
> delete, remove, or hide the old bins?
>
> thank you in advance,
>
> Bryan DeRuvo
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------ --------- --------- ------
>
> 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/.
> (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/ linksYahoo! Groups Links
>
>
>






[Non-text portions of this message have been removed]
7
> We are currently restructuring some of our warehouse bin layouts and
> looking to implement new bin numbers. Does anyone know if/how we can
> delete, remove, or hide the old bins?

Yeah, can't inactivate them... However, you can change their descriptions. I
read here on the list once that someone just but a small "z" in front so
that at least they sort to the bottom.

Mark W.
8
Daniel,

You are correct in that you cannot delete a bin if there is any
previous transaction associated with it.

In 8.03.305, you will run into trouble trying to rename a bin
as "obsolete" as the description has to be unique too...!

What a pain!

Nick

--- In vantage@yahoogroups.com, Daniel Mccarthy <danmccarthy74@...>
wrote:
>
> I agree that there shouldn't be a problem with this, but in our
experience it is not possible to delete a bin if it is associated
with any past inventory transactions, even if there if there is no
inventory located in it and it is not set as the default for any
parts. Vantage will advise "Delete not allowed, referenced by at
least one inventory transaction."
>
>
>
>
> ________________________________
> From: Ned <TechnoBabbly@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, January 8, 2009 9:23:19 AM
> Subject: Re: [Vantage] Deleting Bins
>
>
> In 8.03, the bin should be able to be deleted if it is not
refereced by
> anything else.
>
> So as long as you no longer have any inventory located in it, and
it is not
> setup as the default location for any parts, WIP or anything else,
there
> shouldn't be any problem deleting a bin.
>
> ----- Original Message -----
> From: "Daniel Mccarthy" <danmccarthy74@ yahoo.com>
> To: <vantage@yahoogroups .com>
> Sent: Thursday, January 08, 2009 9:10 AM
> Subject: Re: [Vantage] Deleting Bins
>
> > We've always had to resort to renaming the bin description to
something
> > like 'Obsolete.' Of course if you're not careful the bin can
(and
> > probably will) be used at some point.
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Andrew Best <abest@...>
> > To: vantage@yahoogroups .com
> > Sent: Thursday, January 8, 2009 9:02:25 AM
> > Subject: RE: [Vantage] Deleting Bins
> >
> >
> > We have never found a way. Epicor needs to add an inactive
option for
> > bins.
> >
> > Regards,
> >
> > Andrew Best
> >
> > Kice Industries, Inc.
> >
> > P(316)744-7151
> >
> > F(316)295-2412
> >
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com]
On Behalf
> > Of bderuvo
> > Sent: Wednesday, January 07, 2009 9:46 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Deleting Bins
> >
> > We are currently restructuring some of our warehouse bin layouts
and
> > looking to implement new bin numbers. Does anyone know if/how we
can
> > delete, remove, or hide the old bins?
> >
> > thank you in advance,
> >
> > Bryan DeRuvo
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > ------------ --------- --------- ------
> >
> > 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/.
> > (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/ linksYahoo! Groups Links
> >
> >
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
Yes, I remember running into that now. I ended having to add the bin id to the description, so for example the description for bin 10A became "Obsolete 10A." I can understand not being able to delete a bin if it's referenced in the transaction history, for database integrity reasons, but not being able to make a bin inactive is ridiculous.




________________________________
From: nmtaylor1969 <n.taylor@...>
To: vantage@yahoogroups.com
Sent: Thursday, January 8, 2009 10:19:40 AM
Subject: [Vantage] Re: Deleting Bins


Daniel,

You are correct in that you cannot delete a bin if there is any
previous transaction associated with it.

In 8.03.305, you will run into trouble trying to rename a bin
as "obsolete" as the description has to be unique too...!

What a pain!

Nick

--- In vantage@yahoogroups .com, Daniel Mccarthy <danmccarthy74@ ...>
wrote:
>
> I agree that there shouldn't be a problem with this, but in our
experience it is not possible to delete a bin if it is associated
with any past inventory transactions, even if there if there is no
inventory located in it and it is not set as the default for any
parts. Vantage will advise "Delete not allowed, referenced by at
least one inventory transaction. "
>
>
>
>
> ____________ _________ _________ __
> From: Ned <TechnoBabbly@ ...>
> To: vantage@yahoogroups .com
> Sent: Thursday, January 8, 2009 9:23:19 AM
> Subject: Re: [Vantage] Deleting Bins
>
>
> In 8.03, the bin should be able to be deleted if it is not
refereced by
> anything else.
>
> So as long as you no longer have any inventory located in it, and
it is not
> setup as the default location for any parts, WIP or anything else,
there
> shouldn't be any problem deleting a bin.
>
> ----- Original Message -----
> From: "Daniel Mccarthy" <danmccarthy74@ yahoo.com>
> To: <vantage@yahoogroup s .com>
> Sent: Thursday, January 08, 2009 9:10 AM
> Subject: Re: [Vantage] Deleting Bins
>
> > We've always had to resort to renaming the bin description to
something
> > like 'Obsolete.' Of course if you're not careful the bin can
(and
> > probably will) be used at some point.
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Andrew Best <abest@...>
> > To: vantage@yahoogroups .com
> > Sent: Thursday, January 8, 2009 9:02:25 AM
> > Subject: RE: [Vantage] Deleting Bins
> >
> >
> > We have never found a way. Epicor needs to add an inactive
option for
> > bins.
> >
> > Regards,
> >
> > Andrew Best
> >
> > Kice Industries, Inc.
> >
> > P(316)744-7151
> >
> > F(316)295-2412
> >
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com]
On Behalf
> > Of bderuvo
> > Sent: Wednesday, January 07, 2009 9:46 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Deleting Bins
> >
> > We are currently restructuring some of our warehouse bin layouts
and
> > looking to implement new bin numbers. Does anyone know if/how we
can
> > delete, remove, or hide the old bins?
> >
> > thank you in advance,
> >
> > Bryan DeRuvo
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > ------------ --------- --------- ------
> >
> > 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/.
> > (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/ linksYahoo! Groups Links
> >
> >
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
10
It is a real pain and warehouses fall into the same category. We set up our warehouse structure then had to make some changes and have this same problem.

Regards,
Â
David Watt

Mob. +44 (0) 7809 586 797
Tel. Â +44 (0) 1793 647 140
Â

________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Daniel Mccarthy
Sent: 08 January 2009 15:34
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Deleting Bins

Yes, I remember running into that now. I ended having to add the bin id to the description, so for example the description for bin 10A became "Obsolete 10A." I can understand not being able to delete a bin if it's referenced in the transaction history, for database integrity reasons, but not being able to make a bin inactive is ridiculous.

________________________________
From: nmtaylor1969 <n.taylor@...>
To: vantage@yahoogroups.com
Sent: Thursday, January 8, 2009 10:19:40 AM
Subject: [Vantage] Re: Deleting Bins

Daniel,

You are correct in that you cannot delete a bin if there is any
previous transaction associated with it.

In 8.03.305, you will run into trouble trying to rename a bin
as "obsolete" as the description has to be unique too...!

What a pain!

Nick

--- In vantage@yahoogroups .com, Daniel Mccarthy <danmccarthy74@ ...>
wrote:
>
> I agree that there shouldn't be a problem with this, but in our
experience it is not possible to delete a bin if it is associated
with any past inventory transactions, even if there if there is no
inventory located in it and it is not set as the default for any
parts. Vantage will advise "Delete not allowed, referenced by at
least one inventory transaction. "
>
>
>
>
> ____________ _________ _________ __
> From: Ned <TechnoBabbly@ ...>
> To: vantage@yahoogroups .com
> Sent: Thursday, January 8, 2009 9:23:19 AM
> Subject: Re: [Vantage] Deleting Bins
>
>
> In 8.03, the bin should be able to be deleted if it is not
refereced by
> anything else.
>
> So as long as you no longer have any inventory located in it, and
it is not
> setup as the default location for any parts, WIP or anything else,
there
> shouldn't be any problem deleting a bin.
>
> ----- Original Message -----
> From: "Daniel Mccarthy" <danmccarthy74@ yahoo.com>
> To: <vantage@yahoogroup s .com>
> Sent: Thursday, January 08, 2009 9:10 AM
> Subject: Re: [Vantage] Deleting Bins
>
> > We've always had to resort to renaming the bin description to
something
> > like 'Obsolete.' Of course if you're not careful the bin can
(and
> > probably will) be used at some point.
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Andrew Best <abest@...>
> > To: vantage@yahoogroups .com
> > Sent: Thursday, January 8, 2009 9:02:25 AM
> > Subject: RE: [Vantage] Deleting Bins
> >
> >
> > We have never found a way. Epicor needs to add an inactive
option for
> > bins.
> >
> > Regards,
> >
> > Andrew Best
> >
> > Kice Industries, Inc.
> >
> > P(316)744-7151
> >
> > F(316)295-2412
> >
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com]
On Behalf
> > Of bderuvo
> > Sent: Wednesday, January 07, 2009 9:46 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Deleting Bins
> >
> > We are currently restructuring some of our warehouse bin layouts
and
> > looking to implement new bin numbers. Does anyone know if/how we
can
> > delete, remove, or hide the old bins?
> >
> > thank you in advance,
> >
> > Bryan DeRuvo
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > ------------ --------- --------- ------
> >
> > 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/.
> > (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/ linksYahoo! Groups Links
> >
> >
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]
11
Its great isn't it...!

However, there is nothing to stop you invoking one of the user
defined logical fields within the bin data table ( sorry, I can't
remember which one it is off-hand, it might be PartBin ), and then
using this to indicate the activity state. Then you can write some
custom dasboards to only show those bins where your flag is set to
true...

Its quite easy to do...

Thanks,

Nick

--- In vantage@yahoogroups.com, Daniel Mccarthy <danmccarthy74@...>
wrote:
>
> Yes, I remember running into that now. I ended having to add the
bin id to the description, so for example the description for bin 10A
became "Obsolete 10A." I can understand not being able to delete a
bin if it's referenced in the transaction history, for database
integrity reasons, but not being able to make a bin inactive is
ridiculous.
>
>
>
>
> ________________________________
> From: nmtaylor1969 <n.taylor@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, January 8, 2009 10:19:40 AM
> Subject: [Vantage] Re: Deleting Bins
>
>
> Daniel,
>
> You are correct in that you cannot delete a bin if there is any
> previous transaction associated with it.
>
> In 8.03.305, you will run into trouble trying to rename a bin
> as "obsolete" as the description has to be unique too...!
>
> What a pain!
>
> Nick
>
> --- In vantage@yahoogroups .com, Daniel Mccarthy
<danmccarthy74@ ...>
> wrote:
> >
> > I agree that there shouldn't be a problem with this, but in our
> experience it is not possible to delete a bin if it is associated
> with any past inventory transactions, even if there if there is no
> inventory located in it and it is not set as the default for any
> parts. Vantage will advise "Delete not allowed, referenced by at
> least one inventory transaction. "
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Ned <TechnoBabbly@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Thursday, January 8, 2009 9:23:19 AM
> > Subject: Re: [Vantage] Deleting Bins
> >
> >
> > In 8.03, the bin should be able to be deleted if it is not
> refereced by
> > anything else.
> >
> > So as long as you no longer have any inventory located in it, and
> it is not
> > setup as the default location for any parts, WIP or anything
else,
> there
> > shouldn't be any problem deleting a bin.
> >
> > ----- Original Message -----
> > From: "Daniel Mccarthy" <danmccarthy74@ yahoo.com>
> > To: <vantage@yahoogroup s .com>
> > Sent: Thursday, January 08, 2009 9:10 AM
> > Subject: Re: [Vantage] Deleting Bins
> >
> > > We've always had to resort to renaming the bin description to
> something
> > > like 'Obsolete.' Of course if you're not careful the bin can
> (and
> > > probably will) be used at some point.
> > >
> > >
> > >
> > >
> > > ____________ _________ _________ __
> > > From: Andrew Best <abest@>
> > > To: vantage@yahoogroups .com
> > > Sent: Thursday, January 8, 2009 9:02:25 AM
> > > Subject: RE: [Vantage] Deleting Bins
> > >
> > >
> > > We have never found a way. Epicor needs to add an inactive
> option for
> > > bins.
> > >
> > > Regards,
> > >
> > > Andrew Best
> > >
> > > Kice Industries, Inc.
> > >
> > > P(316)744-7151
> > >
> > > F(316)295-2412
> > >
> > > From: vantage@yahoogroups .com [mailto:vantage@
yahoogroups .com]
> On Behalf
> > > Of bderuvo
> > > Sent: Wednesday, January 07, 2009 9:46 PM
> > > To: vantage@yahoogroups .com
> > > Subject: [Vantage] Deleting Bins
> > >
> > > We are currently restructuring some of our warehouse bin
layouts
> and
> > > looking to implement new bin numbers. Does anyone know if/how
we
> can
> > > delete, remove, or hide the old bins?
> > >
> > > thank you in advance,
> > >
> > > Bryan DeRuvo
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > > ------------ --------- --------- ------
> > >
> > > 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/.
> > > (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/ linksYahoo! Groups
Links
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
12
We had this same problem with bins and warehouses, but in our case we did not care about the history. We are using SQL, and the only solution I came up with which is
not recommended
was to write some queries to sort through the tables and delete the entries with the partnum, warehousecode and binnum that we wanted removed.Â
Have not had any problems except for the occasional part that was suppose to me in the warehouse that the supervisor said to delete, but I made sure to copy each table I edited to another database before I did anything so it was easy to replace the data if needed.Â

In the end I cleaned up about 3 gigs of data from the database, most of it from the parttran table. So no more warehouses named Prodiction, Pruduction, Priduction, Prodt
A dictionary is a terrible thing to waste!

Like I said, not recommended and not supported but it can be done.Â

Darren
PACE Incorporated




________________________________
From: Daniel Mccarthy <danmccarthy74@...>
To: vantage@yahoogroups.com
Sent: Thursday, January 8, 2009 10:33:46 AM
Subject: Re: [Vantage] Re: Deleting Bins


Yes, I remember running into that now. I ended having to add the bin id to the description, so for example the description for bin 10A became "Obsolete 10A." I can understand not being able to delete a bin if it's referenced in the transaction history, for database integrity reasons, but not being able to make a bin inactive is ridiculous.

____________ _________ _________ __
From: nmtaylor1969 <n.taylor@kingfield- electronics. co.uk>
To: vantage@yahoogroups .com
Sent: Thursday, January 8, 2009 10:19:40 AM
Subject: [Vantage] Re: Deleting Bins

Daniel,

You are correct in that you cannot delete a bin if there is any
previous transaction associated with it.

In 8.03.305, you will run into trouble trying to rename a bin
as "obsolete" as the description has to be unique too...!

What a pain!

Nick

--- In vantage@yahoogroups .com, Daniel Mccarthy <danmccarthy74@ ...>
wrote:
>
> I agree that there shouldn't be a problem with this, but in our
experience it is not possible to delete a bin if it is associated
with any past inventory transactions, even if there if there is no
inventory located in it and it is not set as the default for any
parts. Vantage will advise "Delete not allowed, referenced by at
least one inventory transaction. "
>
>
>
>
> ____________ _________ _________ __
> From: Ned <TechnoBabbly@ ...>
> To: vantage@yahoogroups .com
> Sent: Thursday, January 8, 2009 9:23:19 AM
> Subject: Re: [Vantage] Deleting Bins
>
>
> In 8.03, the bin should be able to be deleted if it is not
refereced by
> anything else.
>
> So as long as you no longer have any inventory located in it, and
it is not
> setup as the default location for any parts, WIP or anything else,
there
> shouldn't be any problem deleting a bin.
>
> ----- Original Message -----
> From: "Daniel Mccarthy" <danmccarthy74@ yahoo.com>
> To: <vantage@yahoogroup s .com>
> Sent: Thursday, January 08, 2009 9:10 AM
> Subject: Re: [Vantage] Deleting Bins
>
> > We've always had to resort to renaming the bin description to
something
> > like 'Obsolete.' Of course if you're not careful the bin can
(and
> > probably will) be used at some point.
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Andrew Best <abest@...>
> > To: vantage@yahoogroups .com
> > Sent: Thursday, January 8, 2009 9:02:25 AM
> > Subject: RE: [Vantage] Deleting Bins
> >
> >
> > We have never found a way. Epicor needs to add an inactive
option for
> > bins.
> >
> > Regards,
> >
> > Andrew Best
> >
> > Kice Industries, Inc.
> >
> > P(316)744-7151
> >
> > F(316)295-2412
> >
> > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com]
On Behalf
> > Of bderuvo
> > Sent: Wednesday, January 07, 2009 9:46 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Deleting Bins
> >
> > We are currently restructuring some of our warehouse bin layouts
and
> > looking to implement new bin numbers. Does anyone know if/how we
can
> > delete, remove, or hide the old bins?
> >
> > thank you in advance,
> >
> > Bryan DeRuvo
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > ------------ --------- --------- ------
> >
> > 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/.
> > (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/ linksYahoo! Groups Links
> >
> >
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
13
We just went through the same process of re-designing our WH Bins.

It's tons of work, but we created a new warehouse. Since we had to do
a transfer anyway, we just transfered to a new WH/Bin. We did not
have the primary bins set for our parts. So, we didn't have to do
double work.

I heard that in Version 9, you can inactivate bins.

--- In vantage@yahoogroups.com, Daniel Mccarthy <danmccarthy74@...> wrote:
>
> Yes, I remember running into that now. I ended having to add the
bin id to the description, so for example the description for bin 10A
became "Obsolete 10A." I can understand not being able to delete a
bin if it's referenced in the transaction history, for database
integrity reasons, but not being able to make a bin inactive is
ridiculous.
>
>
>
>
> ________________________________
> From: nmtaylor1969 <n.taylor@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, January 8, 2009 10:19:40 AM
> Subject: [Vantage] Re: Deleting Bins
>
>
> Daniel,
>
> You are correct in that you cannot delete a bin if there is any
> previous transaction associated with it.
>
> In 8.03.305, you will run into trouble trying to rename a bin
> as "obsolete" as the description has to be unique too...!
>
> What a pain!
>
> Nick
>
> --- In vantage@yahoogroups .com, Daniel Mccarthy <danmccarthy74@ ...>
> wrote:
> >
> > I agree that there shouldn't be a problem with this, but in our
> experience it is not possible to delete a bin if it is associated
> with any past inventory transactions, even if there if there is no
> inventory located in it and it is not set as the default for any
> parts. Vantage will advise "Delete not allowed, referenced by at
> least one inventory transaction. "
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: Ned <TechnoBabbly@ ...>
> > To: vantage@yahoogroups .com
> > Sent: Thursday, January 8, 2009 9:23:19 AM
> > Subject: Re: [Vantage] Deleting Bins
> >
> >
> > In 8.03, the bin should be able to be deleted if it is not
> refereced by
> > anything else.
> >
> > So as long as you no longer have any inventory located in it, and
> it is not
> > setup as the default location for any parts, WIP or anything else,
> there
> > shouldn't be any problem deleting a bin.
> >
> > ----- Original Message -----
> > From: "Daniel Mccarthy" <danmccarthy74@ yahoo.com>
> > To: <vantage@yahoogroup s .com>
> > Sent: Thursday, January 08, 2009 9:10 AM
> > Subject: Re: [Vantage] Deleting Bins
> >
> > > We've always had to resort to renaming the bin description to
> something
> > > like 'Obsolete.' Of course if you're not careful the bin can
> (and
> > > probably will) be used at some point.
> > >
> > >
> > >
> > >
> > > ____________ _________ _________ __
> > > From: Andrew Best <abest@>
> > > To: vantage@yahoogroups .com
> > > Sent: Thursday, January 8, 2009 9:02:25 AM
> > > Subject: RE: [Vantage] Deleting Bins
> > >
> > >
> > > We have never found a way. Epicor needs to add an inactive
> option for
> > > bins.
> > >
> > > Regards,
> > >
> > > Andrew Best
> > >
> > > Kice Industries, Inc.
> > >
> > > P(316)744-7151
> > >
> > > F(316)295-2412
> > >
> > > From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com]
> On Behalf
> > > Of bderuvo
> > > Sent: Wednesday, January 07, 2009 9:46 PM
> > > To: vantage@yahoogroups .com
> > > Subject: [Vantage] Deleting Bins
> > >
> > > We are currently restructuring some of our warehouse bin layouts
> and
> > > looking to implement new bin numbers. Does anyone know if/how we
> can
> > > delete, remove, or hide the old bins?
> > >
> > > thank you in advance,
> > >
> > > Bryan DeRuvo
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > > ------------ --------- --------- ------
> > >
> > > 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/.
> > > (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/ linksYahoo! Groups Links
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
14
> I heard that in Version 9, you can inactivate bins.

Checking...

Why yes you can!

The other big change in bins is for two new modules: customer managed
inventory and supplier managed inventory. A bin can be standard, customer
material, or supplier material. Transferring to and from these kinds of bins
actually perform "shipping" and "receiving" functions IIRC.

Mark W.
15
In 8.03, you cannot delete a bin if there is a transaction record
referencing it. This is also true of part numbers. The only way to
remove them is to go into the actual Progress database and remove
them.

I'm pretty computer savvy and know that I could figure this out, but
I instead had 2WTech take care of it. They were able to remove the
unwanted records and take care of it in about 45 minutes.

Matt Holmes
Precision Drawn Metals

Other great resources:
Epicor 9 Forum: http://forums.epicor.com/forum_topics.asp?FID=181
Vantage 8 Forum: http://forums.epicor.com/forum_topics.asp?FID=25
Vista 8 Forum: http://forums.epicor.com/forum_topics.asp?FID=26
Great Lakes Vista Users Group: http://www.glvistausersgroup.com




--- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@...> wrote:
>
> In 8.03, the bin should be able to be deleted if it is not
refereced by
> anything else.
>
> So as long as you no longer have any inventory located in it, and
it is not
> setup as the default location for any parts, WIP or anything else,
there
> shouldn't be any problem deleting a bin.
>
>
> ----- Original Message -----
> From: "Daniel Mccarthy" <danmccarthy74@...>
> To: <vantage@yahoogroups.com>
> Sent: Thursday, January 08, 2009 9:10 AM
> Subject: Re: [Vantage] Deleting Bins
>
>
> > We've always had to resort to renaming the bin description to
something
> > like 'Obsolete.' Of course if you're not careful the bin can
(and
> > probably will) be used at some point.
> >
> >
> >
> >
> > ________________________________
> > From: Andrew Best <abest@...>
> > To: vantage@yahoogroups.com
> > Sent: Thursday, January 8, 2009 9:02:25 AM
> > Subject: RE: [Vantage] Deleting Bins
> >
> >
> > We have never found a way. Epicor needs to add an inactive
option for
> > bins.
> >
> > Regards,
> >
> > Andrew Best
> >
> > Kice Industries, Inc.
> >
> > P(316)744-7151
> >
> > F(316)295-2412
> >
> > From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com]
On Behalf
> > Of bderuvo
> > Sent: Wednesday, January 07, 2009 9:46 PM
> > To: vantage@yahoogroups .com
> > Subject: [Vantage] Deleting Bins
> >
> > We are currently restructuring some of our warehouse bin layouts
and
> > looking to implement new bin numbers. Does anyone know if/how we
can
> > delete, remove, or hide the old bins?
> >
> > thank you in advance,
> >
> > Bryan DeRuvo
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > ------------------------------------
> >
> > 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/.
> > (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/linksYahoo! Groups Links
> >
> >
> >
>
16
Darren,
My users have just discovered the permanence of bins and are non too
pleased.
Would you mind posting what version of Epicor you are on and the SQL
statements?
Thank you,
Chris
Dorner Mfg. Corp.

--- In vantage@yahoogroups.com, Darren Giordano
<scubadoobydootoo@...> wrote:
>
> We had this same problem with bins and warehouses, but in our case
we did not care about the history. We are using SQL, and the only
solution I came up with which is
> not recommended
> was to write some queries to sort through the tables and delete the
entries with the partnum, warehousecode and binnum that we wanted
removed.Â
> Have not had any problems except for the occasional part that was
suppose to me in the warehouse that the supervisor said to
delete, but I made sure to copy each table I edited to another
database before I did anything so it was easy to replace the data if
needed.Â
>
> In the end I cleaned up about 3 gigs of data from the database,
most of it from the parttran table. So no more warehouses named
Prodiction, Pruduction, Priduction, Prodt
> A dictionary is a terrible thing to waste!
>
> Like I said, not recommended and not supported but it can be done.Â
>
> Darren
> PACE Incorporated
>
17
The Epicor response will be the standard "fixed in Epicor 9."



To be fair it is fixed in 9.



Regards,





Andrew Best

Kice Industries, Inc.

P(316)744-7151

F(316)295-2412



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of afiedt_buf
Sent: Tuesday, January 20, 2009 11:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Deleting Bins



Darren,
My users have just discovered the permanence of bins and are non too
pleased.
Would you mind posting what version of Epicor you are on and the SQL
statements?
Thank you,
Chris
Dorner Mfg. Corp.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Darren Giordano
<scubadoobydootoo@...> wrote:
>
> We had this same problem with bins and warehouses, but in our case
we did not care about the history. We are using SQL, and the only
solution I came up with which is
> not recommended
> was to write some queries to sort through the tables and delete the
entries with the partnum, warehousecode and binnum that we wanted
removed.
> Have not had any problems except for the occasional part that was
suppose to me in the warehouse that the supervisor said to
delete, but I made sure to copy each table I edited to another
database before I did anything so it was easy to replace the data if
needed.
>
> In the end I cleaned up about 3 gigs of data from the database,
most of it from the parttran table. So no more warehouses named
Prodiction, Pruduction, Priduction, Prodt
> A dictionary is a terrible thing to waste!
>
> Like I said, not recommended and not supported but it can be done.
>
> Darren
> PACE Incorporated
>





[Non-text portions of this message have been removed]