QuoteDtl - Post-Processing BPM

Yahoo Archive
1

you will need one pre-processing and another post-processing directives.


Here they are (select the option to execute the ABL code, then paste the code below).


1) Pre-Processing:

find ttquotedtl where ttquotedtl.RowMod = "U" no-error.

if not available ttquotedtl then return.

find ttcallcontextbpmdata. 

find quotedtl no-lock where rowid(quotedtl) = to-rowid(ttquotedtl.RowIdent).

assign ttquotedtl.SysRevID = quotedtl.SysRevID

       ttcallcontextbpmdata.Checkbox10 = true.


2) Post-Processing:

find last ttquotedtl no-error.

if not available ttquotedtl then return.

find ttcallcontextbpmdata. 

if ttcallcontextbpmdata.checkbox10 = false then return.

find quotedtl exclusive-lock where rowid(quotedtl) = to-rowid(ttquotedtl.RowIdent).

assign quotedtl.SellingExpectedQty = 5

       ttquotedtl.SellingExpectedQty = 5

       ttquotedtl.SysRevID = quotedtl.SysRevID

       ttcallcontextbpmdata.checkbox10 = false.

release quotedtl.



Good luck!


cheers

2

I am trying to write a BPM to update a value in the QuoteDtl.SellingExpectedQty field.  The BPM writes the value to the field but does not update or save correctly upon refresh.  Has anyone encountered a similar situation?  Below is my BPM settings or if anyone could get the BPM to work on their end.

 

Quote.Update - Post-Processing

Condition: N/A

Action: set the QuoteDtl.SellingExpectedQty field of all rows to the 5 expression

3

Unless you are writing to the actual table quotedtl you can't generally change values in post proc.
If you are writing to the tt tables which is what describe that needs to be done in pre proc or an update post proc to the bo or actual table

On Jan 2, 2014 5:22 PM, <cchang@...> wrote:

 
<div>
  
  
  <p><p>I am trying to write a BPM to update a value in the QuoteDtl.SellingExpectedQty field.  The BPM writes the value to the field but does not update or save correctly upon refresh.  Has anyone encountered a similar situation?  Below is my BPM settings or if anyone could get the BPM to work on their end.<var></var></p>

Â

Quote.Update - Post-Processing

Condition: N/A

Action: set the QuoteDtl.SellingExpectedQty field of all rows to the 5 expression

</div>
 


<div style="color:#fff;min-height:0;"></div>
4

How do we setup a post proc to the bo or actual table using the standard BPM setup?  It only allowed me to select on the ttquotedtl table.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, January 02, 2014 6:33 PM
To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

 

 

Unless you are writing to the actual table quotedtl you can't generally change values in post proc.
If you are writing to the tt tables which is what describe that needs to be done in pre proc or an update post proc to the bo or actual table

On Jan 2, 2014 5:22 PM, <cchang@...> wrote:

 

I am trying to write a BPM to update a value in the QuoteDtl.SellingExpectedQty field.  The BPM writes the value to the field but does not update or save correctly upon refresh.  Has anyone encountered a similar situation?  Below is my BPM settings or if anyone could get the BPM to work on their end.

 

Quote.Update - Post-Processing

Condition: N/A

Action: set the QuoteDtl.SellingExpectedQty field of all rows to the 5 expression

5
You have to change the action to Run 4GL code and write the ABL for it. Are you a programmer or at least comfortable writing code?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Fri, Jan 3, 2014 at 10:00 AM, Chang, Chia <cchang@...> wrote:

 
<div>
  
  
  <p></p><div><p class="ygrps-yiv-1899643150MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">How do we setup a post proc to the bo or actual table using the standard BPM setup?  It only allowed me to select on the ttquotedtl table.<u></u><u></u></span></p>

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Thursday, January 02, 2014 6:33 PM
To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

Â

Â

Unless you are writing to the actual table quotedtl you can't generally change values in post proc.
If you are writing to the tt tables which is what describe that needs to be done in pre proc or an update post proc to the bo or actual table

On Jan 2, 2014 5:22 PM, <cchang@...> wrote:

Â

I am trying to write a BPM to update a value in the QuoteDtl.SellingExpectedQty field. The BPM writes the value to the field but does not update or save correctly upon refresh. Has anyone encountered a similar situation? Below is my BPM settings or if anyone could get the BPM to work on their end.

Â

Quote.Update - Post-Processing

Condition: N/A

Action: set the QuoteDtl.SellingExpectedQty field of all rows to the 5 expression

</div>
 


<div style="color:#fff;min-height:0;"></div>

6

No I am not a programmer.  We tried writing ABL but the system keeps resetting it after we run the process.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Friday, January 03, 2014 9:02 AM
To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

 

 

You have to change the action to Run 4GL code and write the ABL for it. Are you a programmer or at least comfortable writing code?



Jose C Gomez

Software Engineer

 


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Fri, Jan 3, 2014 at 10:00 AM, Chang, Chia <cchang@...> wrote:

 

How do we setup a post proc to the bo or actual table using the standard BPM setup?  It only allowed me to select on the ttquotedtl table.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, January 02, 2014 6:33 PM
To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

 

 

Unless you are writing to the actual table quotedtl you can't generally change values in post proc.
If you are writing to the tt tables which is what describe that needs to be done in pre proc or an update post proc to the bo or actual table

On Jan 2, 2014 5:22 PM, <cchang@...> wrote:

 

I am trying to write a BPM to update a value in the QuoteDtl.SellingExpectedQty field.  The BPM writes the value to the field but does not update or save correctly upon refresh.  Has anyone encountered a similar situation?  Below is my BPM settings or if anyone could get the BPM to work on their end.

 

Quote.Update - Post-Processing

Condition: N/A

Action: set the QuoteDtl.SellingExpectedQty field of all rows to the 5 expression

 

7
You'll need to write something which queries the DB assigns the value, and then refreshes the data store.

Are you in 9.05?

If so this might work well in a DataDirective without writing much code.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Fri, Jan 3, 2014 at 10:05 AM, Chang, Chia <cchang@...> wrote:

 
<div>
  
  
  <p></p><div><p class="ygrps-yiv-1179357522MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">No I am not a programmer.  We tried writing ABL but the system keeps resetting it after we run the process.<u></u><u></u></span></p><p class="ygrps-yiv-1179357522MsoNormal">

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Friday, January 03, 2014 9:02 AM


To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

Â

Â

You have to change the action to Run 4GL code and write the ABL for it. Are you a programmer or at least comfortable writing code?



Jose C Gomez

Software Engineer

Â


T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?

Â

On Fri, Jan 3, 2014 at 10:00 AM, Chang, Chia <cchang@...> wrote:

Â

How do we setup a post proc to the bo or actual table using the standard BPM setup? It only allowed me to select on the ttquotedtl table.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Thursday, January 02, 2014 6:33 PM
To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

Â

Â

Unless you are writing to the actual table quotedtl you can't generally change values in post proc.
If you are writing to the tt tables which is what describe that needs to be done in pre proc or an update post proc to the bo or actual table

On Jan 2, 2014 5:22 PM, <cchang@...> wrote:

Â

I am trying to write a BPM to update a value in the QuoteDtl.SellingExpectedQty field. The BPM writes the value to the field but does not update or save correctly upon refresh. Has anyone encountered a similar situation? Below is my BPM settings or if anyone could get the BPM to work on their end.

Â

Quote.Update - Post-Processing

Condition: N/A

Action: set the QuoteDtl.SellingExpectedQty field of all rows to the 5 expression

 

</div>
 


<div style="color:#fff;min-height:0;"></div>

8

Yes we are on 9.05.  How would data directive work?  From your first example, how do we get it to refresh the data store?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Friday, January 03, 2014 9:08 AM
To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

 

 

You'll need to write something which queries the DB assigns the value, and then refreshes the data store.

Are you in 9.05?

If so this might work well in a DataDirective without writing much code.



Jose C Gomez

Software Engineer

 


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Fri, Jan 3, 2014 at 10:05 AM, Chang, Chia <cchang@...> wrote:

 

No I am not a programmer.  We tried writing ABL but the system keeps resetting it after we run the process.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Friday, January 03, 2014 9:02 AM


To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

 

 

You have to change the action to Run 4GL code and write the ABL for it. Are you a programmer or at least comfortable writing code?



Jose C Gomez

Software Engineer

 


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Fri, Jan 3, 2014 at 10:00 AM, Chang, Chia <cchang@...> wrote:

 

How do we setup a post proc to the bo or actual table using the standard BPM setup?  It only allowed me to select on the ttquotedtl table.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, January 02, 2014 6:33 PM
To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

 

 

Unless you are writing to the actual table quotedtl you can't generally change values in post proc.
If you are writing to the tt tables which is what describe that needs to be done in pre proc or an update post proc to the bo or actual table

On Jan 2, 2014 5:22 PM, <cchang@...> wrote:

 

I am trying to write a BPM to update a value in the QuoteDtl.SellingExpectedQty field.  The BPM writes the value to the field but does not update or save correctly upon refresh.  Has anyone encountered a similar situation?  Below is my BPM settings or if anyone could get the BPM to work on their end.

 

Quote.Update - Post-Processing

Condition: N/A

Action: set the QuoteDtl.SellingExpectedQty field of all rows to the 5 expression

 

 

9
Well the data directive is akin to a trigger so it works during the processing so you won't have to refresh the screen to get the data over to the UI.
Simply write a DD that sets the values you want and it should work.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@…

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Fri, Jan 3, 2014 at 10:14 AM, Chang, Chia <cchang@...> wrote:

 
<div>
  
  
  <p></p><div><p class="ygrps-yiv-764000627MsoNormal"><span style="font-size:11.0pt;color:#1f497d;">Yes we are on 9.05.  How would data directive work?  From your first example, how do we get it to refresh the data store?<u></u><u></u></span></p>

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Friday, January 03, 2014 9:08 AM


To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

Â

Â

You'll need to write something which queries the DB assigns the value, and then refreshes the data store.

Are you in 9.05?

If so this might work well in a DataDirective without writing much code.



Jose C Gomez

Software Engineer

Â


T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?

Â

On Fri, Jan 3, 2014 at 10:05 AM, Chang, Chia <cchang@...> wrote:

Â

No I am not a programmer. We tried writing ABL but the system keeps resetting it after we run the process.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Friday, January 03, 2014 9:02 AM


To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

Â

Â

You have to change the action to Run 4GL code and write the ABL for it. Are you a programmer or at least comfortable writing code?



Jose C Gomez

Software Engineer

Â


T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?

Â

On Fri, Jan 3, 2014 at 10:00 AM, Chang, Chia <cchang@...> wrote:

Â

How do we setup a post proc to the bo or actual table using the standard BPM setup? It only allowed me to select on the ttquotedtl table.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Thursday, January 02, 2014 6:33 PM
To: Vantage
Subject: Re: [Vantage] QuoteDtl - Post-Processing BPM

Â

Â

Unless you are writing to the actual table quotedtl you can't generally change values in post proc.
If you are writing to the tt tables which is what describe that needs to be done in pre proc or an update post proc to the bo or actual table

On Jan 2, 2014 5:22 PM, <cchang@...> wrote:

Â

I am trying to write a BPM to update a value in the QuoteDtl.SellingExpectedQty field. The BPM writes the value to the field but does not update or save correctly upon refresh. Has anyone encountered a similar situation? Below is my BPM settings or if anyone could get the BPM to work on their end.

Â

Quote.Update - Post-Processing

Condition: N/A

Action: set the QuoteDtl.SellingExpectedQty field of all rows to the 5 expression

Â

 

</div>
 


<div style="color:#fff;min-height:0;"></div>