BPM To Stop Unapproved Revision in Quote

Yahoo Archive
1
Then do it in the post-processing method using the built in error handler that will halt the change.

Michael Brown
Master Scheduler / Programmer
D&S Manufacturing
715-284-5376 Ext. 344

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of gabelebron07
Sent: Tuesday, February 26, 2013 1:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM To Stop Unapproved Revision in Quote



not sure what you mean. the condition I made is a pre-proccessing that looks at QuoteDtl.RevisionNum field to make sure its not blank only issue is it looks at it before it has a change to populate if there is a approved rev

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Mike Brown wrote:
>
> You would need a pre-processing request as well looking to see if the correct revision is populated. If not then proceed to the post processing error.
>
> Michael Brown
> Master Scheduler / Programmer
> D&S Manufacturing
> 715-284-5376 Ext. 344
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of gabelebron07
> Sent: Tuesday, February 26, 2013 11:40 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] BPM To Stop Unapproved Revision in Quote
>
>
>
> Ok I Started a BPM to restrict from quoting a part with no unapproved
> rev.
>
> I am having a little trouble trying to find what Method to use. Right
> now I am trying to use
>
> Epicor.Mfg.BO.Quote
> Update
>
> because it seems to follow right after I add the part
>
> I am using the conditions that's only seems to be available in pre
> or base not in post
>
> the specified field of the changed row is equal to the specified
> expression
>
> (the QuoteDtl.RevisionNum field of the changed row is equal to the
> String ("") expression)
>
> Now even if I have a part with an approved Rev it still seems to still
> error out because it seems to see it blank before the system has time to
> populate it with the unapproved rev. But I can't seem to find a way
> to right a condition in post processing or find a method after the fact.
>
> [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]
2
Ok I Started a BPM to restrict from quoting a part with no unapproved
rev.

I am having a little trouble trying to find what Method to use. Right
now I am trying to use

<businessObject>Epicor.Mfg.BO.Quote</businessObject>
<methodName>Update</methodName>

because it seems to follow right after I add the part

I am using the conditions that's only seems to be available in pre
or base not in post

the specified field of the changed row is equal to the specified
expression

(the QuoteDtl.RevisionNum field of the changed row is equal to the
String ("") expression)

Now even if I have a part with an approved Rev it still seems to still
error out because it seems to see it blank before the system has time to
populate it with the unapproved rev. But I can't seem to find a way
to right a condition in post processing or find a method after the fact.







[Non-text portions of this message have been removed]
3
You would need a pre-processing request as well looking to see if the correct revision is populated. If not then proceed to the post processing error.

Michael Brown
Master Scheduler / Programmer
D&S Manufacturing
715-284-5376 Ext. 344

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of gabelebron07
Sent: Tuesday, February 26, 2013 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM To Stop Unapproved Revision in Quote



Ok I Started a BPM to restrict from quoting a part with no unapproved
rev.

I am having a little trouble trying to find what Method to use. Right
now I am trying to use

Epicor.Mfg.BO.Quote
Update

because it seems to follow right after I add the part

I am using the conditions that's only seems to be available in pre
or base not in post

the specified field of the changed row is equal to the specified
expression

(the QuoteDtl.RevisionNum field of the changed row is equal to the
String ("") expression)

Now even if I have a part with an approved Rev it still seems to still
error out because it seems to see it blank before the system has time to
populate it with the unapproved rev. But I can't seem to find a way
to right a condition in post processing or find a method after the fact.

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



[Non-text portions of this message have been removed]
4
not sure what you mean. the condition I made is a pre-proccessing that looks at QuoteDtl.RevisionNum field to make sure its not blank only issue is it looks at it before it has a change to populate if there is a approved rev

--- In vantage@yahoogroups.com, Mike Brown <mbrown@...> wrote:
>
> You would need a pre-processing request as well looking to see if the correct revision is populated. If not then proceed to the post processing error.
>
> Michael Brown
> Master Scheduler / Programmer
> D&S Manufacturing
> 715-284-5376 Ext. 344
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of gabelebron07
> Sent: Tuesday, February 26, 2013 11:40 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BPM To Stop Unapproved Revision in Quote
>
>
>
> Ok I Started a BPM to restrict from quoting a part with no unapproved
> rev.
>
> I am having a little trouble trying to find what Method to use. Right
> now I am trying to use
>
> Epicor.Mfg.BO.Quote
> Update
>
> because it seems to follow right after I add the part
>
> I am using the conditions that's only seems to be available in pre
> or base not in post
>
> the specified field of the changed row is equal to the specified
> expression
>
> (the QuoteDtl.RevisionNum field of the changed row is equal to the
> String ("") expression)
>
> Now even if I have a part with an approved Rev it still seems to still
> error out because it seems to see it blank before the system has time to
> populate it with the unapproved rev. But I can't seem to find a way
> to right a condition in post processing or find a method after the fact.
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
5
We had to use ABl code due to the fact we sometimes sell purchased parts without revisions and we also allow parts on the fly to not have a revision. Here is the code if you want tot ry it
Â
Â
Â
Â
Â
Â
Â
/* informational message for missing revision. */
for each ttorderdtl:
 if (ttorderdtl.revisionnum = ? or ttorderdtl.revisionnum = " ") and (ttorderdtl.orderline > 0) then do:
  for each part where part.Company = ttorderdtl.company and part.PartNum = ttorderdtl.PartNum and Part.TypeCode = "M" no-lock.
  find orderdtl where orderdtl.company = ttorderdtl.company and orderdtl.OrderNum = ttorderdtl.ordernum and orderdtl.OrderLine = ttorderdtl.orderline no-lock no-error.
  if not avail(orderdtl) then do:
  End.
   for each orderdtl where orderdtl.company = ttorderdtl.company and orderdtl.OrderNum = ttorderdtl.ordernum and orderdtl.OrderLine = ttorderdtl.orderline no-lock.
    if orderdtl.PartNum <> ttorderdtl.partNum then do:
     define variable body2 as character no-undo.
     assign body2 = "Manufactured part " + ttorderdtl.partnum + " is missing revision. ".
  Â
     {lib/PublishInfoMsg.i &InfoMsg = body2
          &InfoSeverity  = {&MESSAGE_INFO}
          &BOName        = "'SalesOrder'"
          &BOMethod  = "'Update'"
          &UserIdent  = DCD-USERID
          &Company  = CUR-COMP
          &Plant  = CUR-PLANT
          &DisplayMode  = {&MESSAGE_DISP_ALONE}}
    End.
   End.
  End. /* end for each part */
 End. /*end for if ttorderdtl.*/
 if (ttorderdtl.revisionnum = ? or ttorderdtl.revisionnum = " ") and (ttorderdtl.orderline = 0) then do:
  for each part where part.Company = ttorderdtl.company and part.PartNum = ttorderdtl.PartNum and Part.TypeCode = "M" no-lock.
     define variable body3 as character no-undo.
     assign body3 = "Manufactured part " + ttorderdtl.partnum + " is missing revision. ".
  Â
     {lib/PublishInfoMsg.i &InfoMsg = body3
          &InfoSeverity  = {&MESSAGE_INFO}
          &BOName        = "'SalesOrder'"
          &BOMethod  = "'Update'"
          &UserIdent  = DCD-USERID
          &Company  = CUR-COMP
          &Plant  = CUR-PLANT
          &DisplayMode  = {&MESSAGE_DISP_ALONE}}
  End. /* end for each part */
 End. /*end for if ttorderdtl.*/

end. /* end for each buffer */




________________________________
From: gabelebron07 <gabe.lebron@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 26, 2013 2:21 PM
Subject: [Vantage] Re: BPM To Stop Unapproved Revision in Quote


Â

not sure what you mean. the condition I made is a pre-proccessing that looks at QuoteDtl.RevisionNum field to make sure its not blank only issue is it looks at it before it has a change to populate if there is a approved rev

--- In mailto:vantage%40yahoogroups.com, Mike Brown wrote:
>
> You would need a pre-processing request as well looking to see if the correct revision is populated. If not then proceed to the post processing error.
>
> Michael Brown
> Master Scheduler / Programmer
> D&S Manufacturing
> 715-284-5376 Ext. 344
>
> From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of gabelebron07
> Sent: Tuesday, February 26, 2013 11:40 AM
> To: mailto:vantage%40yahoogroups.com
> Subject: [Vantage] BPM To Stop Unapproved Revision in Quote
>
>
>
> Ok I Started a BPM to restrict from quoting a part with no unapproved
> rev.
>
> I am having a little trouble trying to find what Method to use. Right
> now I am trying to use
>
> Epicor.Mfg.BO.Quote
> Update
>
> because it seems to follow right after I add the part
>
> I am using the conditions that's only seems to be available in pre
> or base not in post
>
> the specified field of the changed row is equal to the specified
> expression
>
> (the QuoteDtl.RevisionNum field of the changed row is equal to the
> String ("") expression)
>
> Now even if I have a part with an approved Rev it still seems to still
> error out because it seems to see it blank before the system has time to
> populate it with the unapproved rev. But I can't seem to find a way
> to right a condition in post processing or find a method after the fact.
>
> [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]