Partbin On hand quantity

YES!

That would be great!
Thanks,
Jasper

-----Original Message-----
From: jeremyrleonard@... [mailto:jeremyrleonard@...]
Sent: Monday, February 28, 2005 11:03 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Partbin On hand quantity



I ran into the same issue. At one site, we used boxes as bins. We would
often ship these boxes to customers and know the box/bin was never coming back.
I wrote an Access program that deletes all bins with 0 qty. The shipping
department runs it every now and then to clean them out.

On the other hand, I am glad that it doesn't delete them. The company I am
currently at uses shelves as bins so that although the bin has a qty of 0, it
doesn't go away.

If you like, I can send you the access application.

It would also be easy to turn it into 4gl code.

Thanks
Jeremy


[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/links
Yahoo! Groups Links
According to the PartBin table definition, if the Partbin quantity on hand goes to zero, the record is deleted and there should never be any record with a quantity on hand equal to zero.

My problem is that I have about 300 parts that have a zero on hand quantity but still show up in the Partbin table. How is this possible?

Thanks,
Jasper




[Non-text portions of this message have been removed]
I think if you made the bin the primary bin for that part it will show as
zero. That's my guess because that happens all the time for us.

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, February 28, 2005 9:42 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Partbin On hand quantity


According to the PartBin table definition, if the Partbin quantity on hand
goes to zero, the record is deleted and there should never be any record
with a quantity on hand equal to zero.

My problem is that I have about 300 parts that have a zero on hand
quantity but still show up in the Partbin table. How is this possible?

Thanks,
Jasper




[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/links


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I have cleared the primary bin setting but it still shows up.

Any ideas?
Thanks,
Jasper

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Monday, February 28, 2005 10:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Partbin On hand quantity



I think if you made the bin the primary bin for that part it will show as
zero. That's my guess because that happens all the time for us.

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, February 28, 2005 9:42 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Partbin On hand quantity


According to the PartBin table definition, if the Partbin quantity on hand
goes to zero, the record is deleted and there should never be any record
with a quantity on hand equal to zero.

My problem is that I have about 300 parts that have a zero on hand
quantity but still show up in the Partbin table. How is this possible?

Thanks,
Jasper




[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/links


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[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/links
Yahoo! Groups Links
Jasper,

One way is to have a positive qty in one bin and negative in another netting
out a zero. You can also do this if you use lot tracking. Have a neg amount
for a lot in a bin and a positive quantity for the same amount on another
lot netting out a zero. Third, check the Database Conversion programs.


Patrick Winter


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, February 28, 2005 9:42 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Partbin On hand quantity


According to the PartBin table definition, if the Partbin quantity on hand
goes to zero, the record is deleted and there should never be any record
with a quantity on hand equal to zero.

My problem is that I have about 300 parts that have a zero on hand quantity
but still show up in the Partbin table. How is this possible?

Thanks,
Jasper




[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/links
Yahoo! Groups Links
I ran into the same issue. At one site, we used boxes as bins. We would
often ship these boxes to customers and know the box/bin was never coming back.
I wrote an Access program that deletes all bins with 0 qty. The shipping
department runs it every now and then to clean them out.

On the other hand, I am glad that it doesn't delete them. The company I am
currently at uses shelves as bins so that although the bin has a qty of 0, it
doesn't go away.

If you like, I can send you the access application.

It would also be easy to turn it into 4gl code.

Thanks
Jeremy


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