Preventing Overshipments

EpiDataViews are used as part of the .NET client framework, and are Epicor extensions of the Microsoft .NET data access framework that Vantage is built on top of. DataViews exist only in the context of the client, and can have additional properties (fields) than the actual underlying database tables. If you go into client customization you'll have to select DataViews to do various things, and you'll see DataViews that have nothing to do with any Vantage tables.

-bws

--
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 howco22
Sent: Wednesday, February 17, 2010 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Preventing Overshipments

Hi Brian,

Can you explain this a little more? if the fields are not in the OrderDtl table, how would you be able to pull them into the "Dataview"?


--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> This would have to be done via a client customization. OurStockShippedQty and OurJobShippedQty are not fields in OrderDtl, but are properties of the DataView exposed by the client program.
>
> -bws
>
> --
> 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 Sean McDaniel
> Sent: Wednesday, February 17, 2010 7:51 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Preventing Overshipments
>
> Hi Brian,
>
> This might be simpler than you think. If you're shipping against a release
> then you'd look at:
>
> Ship Qty > (OurReqQty - OurStockShippedQty - OurJobShippedQty) then throw
> error
>
> --Sean
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Brian W. Spolarich
> Sent: Tuesday, February 16, 2010 4:34 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Preventing Overshipments
>
>
>
>
>
> One of my divisions is looking to implement a rule that would prevent
> an operator from shipping more product to a customer than was requested
> for a given release (don't ask me why, but that's what they want).
>
> This turns out to be moderately complex, since one would potentially
> need to add up any partial shipments against a given release.
>
> I just tried doing a dumb pre-processing BPM on CustShip.Update() with
> this simple query and it didn't do anything:
>
> for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
> OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
> ttShipDtl.OrderLine = OrderDtl.OrderLine and
> ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@... <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
> [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
>




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

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
Anyone have a BPM example that addresses the problem of overshipments?
I have a request and don't want to reinvent the wheel.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
Brian, I had asked the same question a week ago and received one from Rob Bucek. I am updating that one for shipments from stock and as soon as I am done with it can send it to you if not one else responds

--- On Wed, 10/28/09, Brian W. Spolarich <bspolarich@...> wrote:


From: Brian W. Spolarich <bspolarich@...>
Subject: [Vantage] Preventing Overshipments
To: vantage@yahoogroups.com
Date: Wednesday, October 28, 2009, 12:01 PM


Â



Anyone have a BPM example that addresses the problem of overshipments?
I have a request and don't want to reinvent the wheel.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced photonix. com
<mailto:bspolarich@advanced photonix. com> ~ 734-864-5618 ~
www.advancedphotoni x.com <http://www.advanced photonix. com>

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



















[Non-text portions of this message have been removed]
Thanks. I suspect the ideal rule would be to check to see if the inventory + job shipment quantities together are greater than the remaining amount on the release being shipped against, but I'll take what I can get.

--
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 Mark Wagner
Sent: Wednesday, October 28, 2009 2:15 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Preventing Overshipments

Brian, I had asked the same question a week ago and received one from Rob Bucek. I am updating that one for shipments from stock and as soon as I am done with it can send it to you if not one else responds

--- On Wed, 10/28/09, Brian W. Spolarich <bspolarich@...> wrote:


From: Brian W. Spolarich <bspolarich@...>
Subject: [Vantage] Preventing Overshipments
To: vantage@yahoogroups.com
Date: Wednesday, October 28, 2009, 12:01 PM


Â



Anyone have a BPM example that addresses the problem of overshipments?
I have a request and don't want to reinvent the wheel.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced photonix. com
<mailto:bspolarich@advanced photonix. com> ~ 734-864-5618 ~
www.advancedphotoni x.com <http://www.advanced photonix. com>

[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
One of my divisions is looking to implement a rule that would prevent
an operator from shipping more product to a customer than was requested
for a given release (don't ask me why, but that's what they want).



This turns out to be moderately complex, since one would potentially
need to add up any partial shipments against a given release.



I just tried doing a dumb pre-processing BPM on CustShip.Update() with
this simple query and it didn't do anything:



for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
ttShipDtl.OrderLine = OrderDtl.OrderLine and
ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





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

This might be simpler than you think. If you're shipping against a release
then you'd look at:

Ship Qty > (OurReqQty - OurStockShippedQty - OurJobShippedQty) then throw
error

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, February 16, 2010 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Preventing Overshipments





One of my divisions is looking to implement a rule that would prevent
an operator from shipping more product to a customer than was requested
for a given release (don't ask me why, but that's what they want).

This turns out to be moderately complex, since one would potentially
need to add up any partial shipments against a given release.

I just tried doing a dumb pre-processing BPM on CustShip.Update() with
this simple query and it didn't do anything:

for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
ttShipDtl.OrderLine = OrderDtl.OrderLine and
ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... <mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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





[Non-text portions of this message have been removed]
This would have to be done via a client customization. OurStockShippedQty and OurJobShippedQty are not fields in OrderDtl, but are properties of the DataView exposed by the client program.

-bws

--
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 Sean McDaniel
Sent: Wednesday, February 17, 2010 7:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

Hi Brian,

This might be simpler than you think. If you're shipping against a release
then you'd look at:

Ship Qty > (OurReqQty - OurStockShippedQty - OurJobShippedQty) then throw
error

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, February 16, 2010 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Preventing Overshipments





One of my divisions is looking to implement a rule that would prevent
an operator from shipping more product to a customer than was requested
for a given release (don't ask me why, but that's what they want).

This turns out to be moderately complex, since one would potentially
need to add up any partial shipments against a given release.

I just tried doing a dumb pre-processing BPM on CustShip.Update() with
this simple query and it didn't do anything:

for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
ttShipDtl.OrderLine = OrderDtl.OrderLine and
ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... <mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[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
They are fields in the OrderRel table.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Wednesday, February 17, 2010 8:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

This would have to be done via a client customization. OurStockShippedQty
and OurJobShippedQty are not fields in OrderDtl, but are properties of the
DataView exposed by the client program.

-bws

--
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
Sean McDaniel
Sent: Wednesday, February 17, 2010 7:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

Hi Brian,

This might be simpler than you think. If you're shipping against a release
then you'd look at:

Ship Qty > (OurReqQty - OurStockShippedQty - OurJobShippedQty) then throw
error

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, February 16, 2010 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Preventing Overshipments





One of my divisions is looking to implement a rule that would prevent
an operator from shipping more product to a customer than was requested
for a given release (don't ask me why, but that's what they want).

This turns out to be moderately complex, since one would potentially
need to add up any partial shipments against a given release.

I just tried doing a dumb pre-processing BPM on CustShip.Update() with
this simple query and it didn't do anything:

for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
ttShipDtl.OrderLine = OrderDtl.OrderLine and
ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... <mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[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





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

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
Doh. I swear I looked.

--
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 Ross Hughes
Sent: Wednesday, February 17, 2010 9:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

They are fields in the OrderRel table.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Wednesday, February 17, 2010 8:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

This would have to be done via a client customization. OurStockShippedQty
and OurJobShippedQty are not fields in OrderDtl, but are properties of the
DataView exposed by the client program.

-bws

--
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
Sean McDaniel
Sent: Wednesday, February 17, 2010 7:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

Hi Brian,

This might be simpler than you think. If you're shipping against a release
then you'd look at:

Ship Qty > (OurReqQty - OurStockShippedQty - OurJobShippedQty) then throw
error

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, February 16, 2010 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Preventing Overshipments





One of my divisions is looking to implement a rule that would prevent
an operator from shipping more product to a customer than was requested
for a given release (don't ask me why, but that's what they want).

This turns out to be moderately complex, since one would potentially
need to add up any partial shipments against a given release.

I just tried doing a dumb pre-processing BPM on CustShip.Update() with
this simple query and it didn't do anything:

for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
ttShipDtl.OrderLine = OrderDtl.OrderLine and
ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... <mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[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





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

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





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

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
Hi Brian,

Can you explain this a little more? if the fields are not in the OrderDtl table, how would you be able to pull them into the "Dataview"?


--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> This would have to be done via a client customization. OurStockShippedQty and OurJobShippedQty are not fields in OrderDtl, but are properties of the DataView exposed by the client program.
>
> -bws
>
> --
> 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 Sean McDaniel
> Sent: Wednesday, February 17, 2010 7:51 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Preventing Overshipments
>
> Hi Brian,
>
> This might be simpler than you think. If you're shipping against a release
> then you'd look at:
>
> Ship Qty > (OurReqQty - OurStockShippedQty - OurJobShippedQty) then throw
> error
>
> --Sean
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Brian W. Spolarich
> Sent: Tuesday, February 16, 2010 4:34 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Preventing Overshipments
>
>
>
>
>
> One of my divisions is looking to implement a rule that would prevent
> an operator from shipping more product to a customer than was requested
> for a given release (don't ask me why, but that's what they want).
>
> This turns out to be moderately complex, since one would potentially
> need to add up any partial shipments against a given release.
>
> I just tried doing a dumb pre-processing BPM on CustShip.Update() with
> this simple query and it didn't do anything:
>
> for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
> OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
> ttShipDtl.OrderLine = OrderDtl.OrderLine and
> ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@... <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
> [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
>
Brian,



I have a working BPM that prevents shipping more than is in stock, and
more than has been completed from the job. It does take into account
previous shipments I do believe..



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Tuesday, February 16, 2010 3:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Preventing Overshipments





One of my divisions is looking to implement a rule that would prevent
an operator from shipping more product to a customer than was requested
for a given release (don't ask me why, but that's what they want).

This turns out to be moderately complex, since one would potentially
need to add up any partial shipments against a given release.

I just tried doing a dumb pre-processing BPM on CustShip.Update() with
this simple query and it didn't do anything:

for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
ttShipDtl.OrderLine = OrderDtl.OrderLine and
ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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





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

I have a similar request from one of my departments. WHat happens is that if you ship a job for more than was requested e.g. twice you actually incur the cost twice if the inventory WIP process was not ran in between shipments. Rob, could I also get a look at that BPM it seems like something I can definately use. My email address is pbennett@....

Thanks in advance

Paul

--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> Brian,
>
>
>
> I have a working BPM that prevents shipping more than is in stock, and
> more than has been completed from the job. It does take into account
> previous shipments I do believe..
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Brian W. Spolarich
> Sent: Tuesday, February 16, 2010 3:34 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Preventing Overshipments
>
>
>
>
>
> One of my divisions is looking to implement a rule that would prevent
> an operator from shipping more product to a customer than was requested
> for a given release (don't ask me why, but that's what they want).
>
> This turns out to be moderately complex, since one would potentially
> need to add up any partial shipments against a given release.
>
> I just tried doing a dumb pre-processing BPM on CustShip.Update() with
> this simple query and it didn't do anything:
>
> for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
> OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
> ttShipDtl.OrderLine = OrderDtl.OrderLine and
> ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com>
> <mailto:bspolarich@...
> <mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I did a 4GL action like the code listed below. I couldn't get a query to work in the query designer (I was just trying to join ttShipDtl to OrderRel like I do below but could never get a match even when I added a condition like "1=1").

define variable infomsg as character no-undo.

for each ttshipdtl where (ttshipdtl.rowmod = 'u' or ttshipdtl.rowmod = 'a').

infomsg = "packnum " + string(ttshipdtl.packnum) + " packline " + string(ttshipdtl.PackLine).
message infomsg.

find first OrderRel where
OrderRel.Company = ttShipDtl.Company
and OrderRel.OrderNum = ttShipDtl.OrderNum
and OrderRel.OrderLine = ttShipDtl.OrderLine
and OrderRel.OrderRelNum = ttShipDtl.OrderRelNum
no-lock no-error.

if available OrderRel then do:
if ttShipDtl.OurInventoryShipQty > ( OrderRel.OurReqQty - OrderRel.OurStockShippedQty - OrderRel.OurJobShippedQty ) then do:
infomsg = "Shipment quantity exceeds remaining requested quantity for this release. This is not permitted.".
{lib/PublishEx.i &ExMsg = infomsg}.
message infomsg.
end.
end.
end.

-bws

--
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 Ross Hughes
Sent: Wednesday, February 17, 2010 9:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

They are fields in the OrderRel table.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Wednesday, February 17, 2010 8:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

This would have to be done via a client customization. OurStockShippedQty
and OurJobShippedQty are not fields in OrderDtl, but are properties of the
DataView exposed by the client program.

-bws

--
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
Sean McDaniel
Sent: Wednesday, February 17, 2010 7:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Preventing Overshipments

Hi Brian,

This might be simpler than you think. If you're shipping against a release
then you'd look at:

Ship Qty > (OurReqQty - OurStockShippedQty - OurJobShippedQty) then throw
error

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, February 16, 2010 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Preventing Overshipments





One of my divisions is looking to implement a rule that would prevent
an operator from shipping more product to a customer than was requested
for a given release (don't ask me why, but that's what they want).

This turns out to be moderately complex, since one would potentially
need to add up any partial shipments against a given release.

I just tried doing a dumb pre-processing BPM on CustShip.Update() with
this simple query and it didn't do anything:

for each ttShipDtl , each OrderDtl where ttShipDtl.Company =
OrderDtl.Company and ttShipDtl.OrderNum = OrderDtl.OrderNum and
ttShipDtl.OrderLine = OrderDtl.OrderLine and
ttShipDtl.OurInventoryShipQty > OrderDtl.OrderQty no-lock

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... <mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[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





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

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





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

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