BPM code Blank Title 105326

Yahoo Archive
1
Thanks Mark. I was able to use JobPart and not have to sum the Part-Tran
table.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
markbetts66
Sent: Wednesday, November 09, 2011 12:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM code





The jobpart table does tell you how many have been:
* made
* receipted to stock
* shipped

made and receipted to stock will only hold true if comparing the final op.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Bethany
Rye" <brye@...> wrote:
>
> What Mike is trying to achieve is comparing the number that has been
> received to stock to the number completed on the operation. We can get the
> number completed on the operation, but he is trying to figure out the
logic
> to sum up the receipts and then compare that number to the number
completed.
> Any ideas?
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
> Email: <mailto:brye@...> brye@...
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> markbetts66
> Sent: Wednesday, November 09, 2011 11:37 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BPM code
>
>
>
>
>
> You may not need to sum anything. The jobpart table holds a sum of the
> quantity complete as does the joboper for each operation.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "mike.numbers" <mnumbers@> wrote:
> >
> > I am learning how to use BPMs by examples and the Epicor ICE Tools User
> Guide. I am trying to create a BPM that prevents receiving to stock more
> than what has been completed. I am using the number of rows condition and
> trying to figure out how I can sum the previous receipts from Part-Tran,
add
> this number to the current receipt and then compare that to the number
> completed on JobHead and end up with either 0 or 1 rows so I can create an
> action. Can someone give me an example of the code I would need to use to
do
> this? Thanks in advance.
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
I am learning how to use BPMs by examples and the Epicor ICE Tools User Guide. I am trying to create a BPM that prevents receiving to stock more than what has been completed. I am using the number of rows condition and trying to figure out how I can sum the previous receipts from Part-Tran, add this number to the current receipt and then compare that to the number completed on JobHead and end up with either 0 or 1 rows so I can create an action. Can someone give me an example of the code I would need to use to do this? Thanks in advance.
3
You may not need to sum anything. The jobpart table holds a sum of the quantity complete as does the joboper for each operation.


--- In vantage@yahoogroups.com, "mike.numbers" <mnumbers@...> wrote:
>
> I am learning how to use BPMs by examples and the Epicor ICE Tools User Guide. I am trying to create a BPM that prevents receiving to stock more than what has been completed. I am using the number of rows condition and trying to figure out how I can sum the previous receipts from Part-Tran, add this number to the current receipt and then compare that to the number completed on JobHead and end up with either 0 or 1 rows so I can create an action. Can someone give me an example of the code I would need to use to do this? Thanks in advance.
>
4
What Mike is trying to achieve is comparing the number that has been
received to stock to the number completed on the operation. We can get the
number completed on the operation, but he is trying to figure out the logic
to sum up the receipts and then compare that number to the number completed.
Any ideas?



Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...> brye@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
markbetts66
Sent: Wednesday, November 09, 2011 11:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM code





You may not need to sum anything. The jobpart table holds a sum of the
quantity complete as does the joboper for each operation.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"mike.numbers" <mnumbers@...> wrote:
>
> I am learning how to use BPMs by examples and the Epicor ICE Tools User
Guide. I am trying to create a BPM that prevents receiving to stock more
than what has been completed. I am using the number of rows condition and
trying to figure out how I can sum the previous receipts from Part-Tran, add
this number to the current receipt and then compare that to the number
completed on JobHead and end up with either 0 or 1 rows so I can create an
action. Can someone give me an example of the code I would need to use to do
this? Thanks in advance.
>





[Non-text portions of this message have been removed]
5
The jobpart table does tell you how many have been:
* made
* receipted to stock
* shipped

made and receipted to stock will only hold true if comparing the final op.

--- In vantage@yahoogroups.com, "Bethany Rye" <brye@...> wrote:
>
> What Mike is trying to achieve is comparing the number that has been
> received to stock to the number completed on the operation. We can get the
> number completed on the operation, but he is trying to figure out the logic
> to sum up the receipts and then compare that number to the number completed.
> Any ideas?
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
> Email: <mailto:brye@...> brye@...
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> markbetts66
> Sent: Wednesday, November 09, 2011 11:37 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM code
>
>
>
>
>
> You may not need to sum anything. The jobpart table holds a sum of the
> quantity complete as does the joboper for each operation.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "mike.numbers" <mnumbers@> wrote:
> >
> > I am learning how to use BPMs by examples and the Epicor ICE Tools User
> Guide. I am trying to create a BPM that prevents receiving to stock more
> than what has been completed. I am using the number of rows condition and
> trying to figure out how I can sum the previous receipts from Part-Tran, add
> this number to the current receipt and then compare that to the number
> completed on JobHead and end up with either 0 or 1 rows so I can create an
> action. Can someone give me an example of the code I would need to use to do
> this? Thanks in advance.
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Thanks for the help, Mark! We are going to look at that table and try it.



Beth Rye

IT Director

CIGNYS
68 Williamson Street
Saginaw, Michigan 48601

Phone: (989) 753-1411 ext. 1114

Direct Line: (989) 393-0108

Fax: (989) 393-0208

Email: <mailto:brye@...> brye@...



***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
markbetts66
Sent: Wednesday, November 09, 2011 12:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM code





The jobpart table does tell you how many have been:
* made
* receipted to stock
* shipped

made and receipted to stock will only hold true if comparing the final op.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Bethany
Rye" <brye@...> wrote:
>
> What Mike is trying to achieve is comparing the number that has been
> received to stock to the number completed on the operation. We can get the
> number completed on the operation, but he is trying to figure out the
logic
> to sum up the receipts and then compare that number to the number
completed.
> Any ideas?
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
> Email: <mailto:brye@...> brye@...
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> markbetts66
> Sent: Wednesday, November 09, 2011 11:37 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BPM code
>
>
>
>
>
> You may not need to sum anything. The jobpart table holds a sum of the
> quantity complete as does the joboper for each operation.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "mike.numbers" <mnumbers@> wrote:
> >
> > I am learning how to use BPMs by examples and the Epicor ICE Tools User
> Guide. I am trying to create a BPM that prevents receiving to stock more
> than what has been completed. I am using the number of rows condition and
> trying to figure out how I can sum the previous receipts from Part-Tran,
add
> this number to the current receipt and then compare that to the number
> completed on JobHead and end up with either 0 or 1 rows so I can create an
> action. Can someone give me an example of the code I would need to use to
do
> this? Thanks in advance.
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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