Inventory moves greater than quantity available issue

Yahoo Archive
1
MaterialQueue.Update



We are controlling MFG-STK transactions because all too often our
inventory was being evaluated by receiving jobs to stock that didn't
have operations finished, materials issued etc etc...we don't like
variance accounts, and at the speed stuff moves through our plant, using
average costing, those parts were all too often shipped and the normal
on hand value being zero our costs were always hosed. This has been
hugely successful for us. The process actually looks for a user defined
checkbox on the jobheader before it allows the move to inventory (which
got there from another BPM that monitors the job completion/closing
form).



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ed Garbowski
Sent: Friday, July 10, 2009 11:10 AM
To: 'vantage@yahoogroups.com'
Subject: RE: RE: [Vantage] Re: Inventory moves greater than quantity
available issue





If it is not too much to ask, would you mind sharing what you did and
what method you tied it to?

Thanks,
Ed
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Rob Bucek
Sent: Friday, July 10, 2009 10:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Inventory moves greater than quantity
available issue

I have BPM controlling inventory transactions in our AMM module and that
all driven by handhelds here in our facility.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Ed Garbowski
Sent: Friday, July 10, 2009 9:57 AM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Re: Inventory moves greater than quantity
available issue

Does that work even when the inventory move is accomplished using a
handheld?

Thanks,
Ed
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Ernie
Sent: Friday, July 10, 2009 7:01 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Inventory moves greater than quantity available
issue

Ed,

We wrote a BPM to accomplish this, but it demands very accurate data
entry in order to work properly (we're also using Lot Tracking). We have
the BPM on the Part.Update business object, and if the
PartBinInfo.OnHandQty field goes negative, the transaction stops.

Ernie

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "Ed Garbowski" <egarbowski@...>
wrote:
>
> Is there a way to display a message or even stop inventory movement
that exceeds the lot quantity available in a location? We have the Stop
set on the part class, but that only displays if the quantity exceeds
the on-hand quantity.
> Thanks,
> Ed
>

________________________________
The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.

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

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

________________________________
The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.

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





[Non-text portions of this message have been removed]
2
Is there a way to display a message or even stop inventory movement that exceeds the lot quantity available in a location? We have the Stop set on the part class, but that only displays if the quantity exceeds the on-hand quantity.
Thanks,
Ed
3
Sounds like a candidate for a BPM or set of BPMs.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ed Garbowski
Sent: Thursday, July 09, 2009 12:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Inventory moves greater than quantity available issue

Is there a way to display a message or even stop inventory movement that exceeds the lot quantity available in a location? We have the Stop set on the part class, but that only displays if the quantity exceeds the on-hand quantity.
Thanks,
Ed



------------------------------------

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
4
Ed,

We wrote a BPM to accomplish this, but it demands very accurate data entry in order to work properly (we're also using Lot Tracking). We have the BPM on the Part.Update business object, and if the PartBinInfo.OnHandQty field goes negative, the transaction stops.

Ernie

--- In vantage@yahoogroups.com, "Ed Garbowski" <egarbowski@...> wrote:
>
> Is there a way to display a message or even stop inventory movement that exceeds the lot quantity available in a location? We have the Stop set on the part class, but that only displays if the quantity exceeds the on-hand quantity.
> Thanks,
> Ed
>
5
Does that work even when the inventory move is accomplished using a handheld?

Thanks,
Ed
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ernie
Sent: Friday, July 10, 2009 7:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Inventory moves greater than quantity available issue





Ed,

We wrote a BPM to accomplish this, but it demands very accurate data entry in order to work properly (we're also using Lot Tracking). We have the BPM on the Part.Update business object, and if the PartBinInfo.OnHandQty field goes negative, the transaction stops.

Ernie

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Ed Garbowski" <egarbowski@...> wrote:
>
> Is there a way to display a message or even stop inventory movement that exceeds the lot quantity available in a location? We have the Stop set on the part class, but that only displays if the quantity exceeds the on-hand quantity.
> Thanks,
> Ed
>


________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.


[Non-text portions of this message have been removed]
6
I have BPM controlling inventory transactions in our AMM module and that
all driven by handhelds here in our facility.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ed Garbowski
Sent: Friday, July 10, 2009 9:57 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Inventory moves greater than quantity
available issue





Does that work even when the inventory move is accomplished using a
handheld?

Thanks,
Ed
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Ernie
Sent: Friday, July 10, 2009 7:01 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Inventory moves greater than quantity available
issue

Ed,

We wrote a BPM to accomplish this, but it demands very accurate data
entry in order to work properly (we're also using Lot Tracking). We have
the BPM on the Part.Update business object, and if the
PartBinInfo.OnHandQty field goes negative, the transaction stops.

Ernie

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "Ed Garbowski" <egarbowski@...>
wrote:
>
> Is there a way to display a message or even stop inventory movement
that exceeds the lot quantity available in a location? We have the Stop
set on the part class, but that only displays if the quantity exceeds
the on-hand quantity.
> Thanks,
> Ed
>

________________________________
The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.

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





[Non-text portions of this message have been removed]
7
If it is not too much to ask, would you mind sharing what you did and what method you tied it to?

Thanks,
Ed
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Friday, July 10, 2009 10:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Inventory moves greater than quantity available issue





I have BPM controlling inventory transactions in our AMM module and that
all driven by handhelds here in our facility.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Ed Garbowski
Sent: Friday, July 10, 2009 9:57 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Re: Inventory moves greater than quantity
available issue

Does that work even when the inventory move is accomplished using a
handheld?

Thanks,
Ed
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Ernie
Sent: Friday, July 10, 2009 7:01 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Inventory moves greater than quantity available
issue

Ed,

We wrote a BPM to accomplish this, but it demands very accurate data
entry in order to work properly (we're also using Lot Tracking). We have
the BPM on the Part.Update business object, and if the
PartBinInfo.OnHandQty field goes negative, the transaction stops.

Ernie

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "Ed Garbowski" <egarbowski@...>
wrote:
>
> Is there a way to display a message or even stop inventory movement
that exceeds the lot quantity available in a location? We have the Stop
set on the part class, but that only displays if the quantity exceeds
the on-hand quantity.
> Thanks,
> Ed
>

________________________________
The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.

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

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


________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.


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