Just as an FYI, the LockQty is a DB field, it's just not on the PORel table.
The values come from the ComXRef table, where field File is "PORel_Mapping";
field Key1 is the PO number in quotes; Key 2 is the line number in quotes;
and field Key3 is the release number in quotes. The fields that you want to
see are foreignkey1, for the lock-date value, and foreignkey2, for the
lock-quantity value.
In other words, it's right where you'd expect it to be. Haha.
Kevin Simon
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Miguel Santillan
Sent: Tuesday, June 26, 2012 12:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BPM Checkbox set to true
Thanks.
Miguel A. Santillan
Compass Components, Inc.
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Jose Gomez
Sent: Tuesday, June 26, 2012 9:07 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: BPM Checkbox set to true
All right I got this working here is how you do it.
On PO Update put a preprocessing directive which captures in BPMData table
the number of the new line that is going to be created.
Condition:
the PODetail.RowMod field of the changed row is equal to the 'A' expression
Action:
Syncronously Excecute ABL:
FOR EACH ttPODetail WHERE ttPODetail.RowMod='A', EACH ttCallContextBpmData:
FIND LAST PODetail WHERE PODetail.PONUM=ttPODetail.PONUM NO-LOCK NO-ERROR.
IF AVAILABLE PODetail THEN DO:
Assign ttCallContextBPMData.Number01=PODetail.POLine + 1.
END.
ELSE
Assign ttCallContextBPMData.Number01=1.
END.
And Enable Dependent Post Processing Directive.
On the Post Processing Directive:
Condition:
this directive has been enabled from the PORelLockQty directive
Action:
Sync Exec ABL:
DEFINE VARIABLE hPO AS HANDLE NO-UNDO.
RUN bo/PO/PO.p PERSISTENT SET hPO.
FOR FIRST ttPORel:
RUN GetByID IN hPO(INPUT ttPORel.PONum,OUTPUT DataSet PODataSet).
END.
FOR EACH ttCallContextBpmData, EACH ttPORel WHERE
ttPORel.POLine=ttCallContextBpmData.Number01:
Assign ttPORel.LockQty=true
ttPORel.RowMod='U'.
Run Update In hPO(INPUT-OUTPUT DataSet PODataSet).
END.
DELETE OBJECT hPO.
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Tue, Jun 26, 2012 at 11:16 AM, Jose Gomez <jose@...
<mailto:jose%40josecgomez.com> > wrote:
------------------------------------
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/.
<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
[Non-text portions of this message have been removed]
The values come from the ComXRef table, where field File is "PORel_Mapping";
field Key1 is the PO number in quotes; Key 2 is the line number in quotes;
and field Key3 is the release number in quotes. The fields that you want to
see are foreignkey1, for the lock-date value, and foreignkey2, for the
lock-quantity value.
In other words, it's right where you'd expect it to be. Haha.
Kevin Simon
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Miguel Santillan
Sent: Tuesday, June 26, 2012 12:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BPM Checkbox set to true
Thanks.
Miguel A. Santillan
Compass Components, Inc.
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Jose Gomez
Sent: Tuesday, June 26, 2012 9:07 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: BPM Checkbox set to true
All right I got this working here is how you do it.
On PO Update put a preprocessing directive which captures in BPMData table
the number of the new line that is going to be created.
Condition:
the PODetail.RowMod field of the changed row is equal to the 'A' expression
Action:
Syncronously Excecute ABL:
FOR EACH ttPODetail WHERE ttPODetail.RowMod='A', EACH ttCallContextBpmData:
FIND LAST PODetail WHERE PODetail.PONUM=ttPODetail.PONUM NO-LOCK NO-ERROR.
IF AVAILABLE PODetail THEN DO:
Assign ttCallContextBPMData.Number01=PODetail.POLine + 1.
END.
ELSE
Assign ttCallContextBPMData.Number01=1.
END.
And Enable Dependent Post Processing Directive.
On the Post Processing Directive:
Condition:
this directive has been enabled from the PORelLockQty directive
Action:
Sync Exec ABL:
DEFINE VARIABLE hPO AS HANDLE NO-UNDO.
RUN bo/PO/PO.p PERSISTENT SET hPO.
FOR FIRST ttPORel:
RUN GetByID IN hPO(INPUT ttPORel.PONum,OUTPUT DataSet PODataSet).
END.
FOR EACH ttCallContextBpmData, EACH ttPORel WHERE
ttPORel.POLine=ttCallContextBpmData.Number01:
Assign ttPORel.LockQty=true
ttPORel.RowMod='U'.
Run Update In hPO(INPUT-OUTPUT DataSet PODataSet).
END.
DELETE OBJECT hPO.
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Tue, Jun 26, 2012 at 11:16 AM, Jose Gomez <jose@...
<mailto:jose%40josecgomez.com> > wrote:
> I just looked and it is not a DB field, you can do it with a simple<http://www.facebook.com/josegomez>
> customization and a clever hack.
> In a DataDirective set CheckBox01 = true
>
> Then on a customization on Notify for PORel checkBox01 and if true
> then set LockQty =true.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@... <mailto:jose%40josecgomez.com>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85><http://www.josecgomez.com/feed/>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.usdoingstuff.com><mailto:jose%40josecgomez.com> > wrote:
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Tue, Jun 26, 2012 at 11:12 AM, Jose Gomez <jose@...
><http://www.facebook.com/josegomez>
>> Is LockQty a DB Field? If so look into Data Directive.
>>
>> *Jose C Gomez*
>> *Software Engineer*
>> *
>> *
>> *checkout my new blog <http://www.usdoingstuff.com> *
>> *
>> *T: 904.469.1524 mobile
>> E: jose@... <mailto:jose%40josecgomez.com>
>> http://www.josecgomez.com
>> <http://www.linkedin.com/in/josecgomez>
>> <http://www.google.com/profiles/jose.gomez><http://www.twitter.com/joc85>
>> <http://www.josecgomez.com/professional-resume/><http://www.josecgomez.com/feed/>
>> <http://www.usdoingstuff.com>[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
>>
>> *Quis custodiet ipsos custodes?*
>>
>>
>>
>> On Tue, Jun 26, 2012 at 10:42 AM, Miguel Santillan
>> <msantillan@... <mailto:msantillan%40ccicms.com>
>> > wrote:
>>
>>> **
>>>
>>>
>>> I thought it was straight forward. I did the post and pre on the
>>> Update and a post and pre on the GetNewPoRel as well.
>>>
>>> Does anyone know if this can be done during a FormLoad? I really
>>> want the default setting to be true on the load.
>>>
>>> Miguel A. Santillan
>>> Compass Components, Inc.
>>>
>>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>> Behalf Of Rob Bucek<mailto:1.234354861%40web65412.mail.ac4.yahoo.com> <mailto:
>>> Sent: Monday, June 25, 2012 6:37 PM
>>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>> Subject: RE: [Vantage] Re: BPM Checkbox set to true
>>>
>>>
>>> Perhaps you could find it on a post processing, but more than likely
>>> only on an update method if that...
>>>
>>> Rob Bucek
>>> Production Control Manager
>>> PH: (715) 284-5376 ext 311
>>> Mobile: (715)896-0590
>>> FAX: (715)284-4084
>>> [Description: cid:1.234354861@...
>>> 1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/><mailto:vantage%40yahoogroups.com> [mailto:
>>>
>>> (Click the logo to view our site)<http://www.dsmfg.com/>
>>>
>>> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>> vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
>>> Of bw2868bond<mailto:vantage%40yahoogroups.com>
>>>
>>> Sent: Monday, June 25, 2012 6:56 PM
>>> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>><mailto:vantage%40yahoogroups.com><mailto:
>>> Subject: [Vantage] Re: BPM Checkbox set to true
>>>
>>> The problem is when you add a line to a PO, the first release is
>>> automagically created back in server code and is not available for a
>>> BPM to act upon.....
>>>
>>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
>>> vantage%40yahoogroups.com>, Miguel Santillan <msantillan@...<mailto:msantillan@...%3cmailto:%0b> <mailto:
>>> msantillan@...>> wrote:[Non-text portions of this message have been removed]
>>> >
>>> > Can PORel.LockQty be set to true if it is not stored in a DB Table.
>>> >
>>> >
>>> > FROM Jose G post.
>>> >
>>> > I want to set this checkbox to True. Or would it be easier to set
>>> > it
>>> to True on a customization through a Form Load Event?
>>> >
>>> > FOR EACH ttPOREL WHERE ttPoREL.RowMod='U' OR ttPOREL.RowMod='A':
>>> > Assign ttPOREL.LockQty =true.
>>> > END.
>>> >
>>> > Regards,
>>> >
>>> > Miguel A. Santillan
>>> >
>>> >
>>> > [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]
>>>
>>>
>>>
>>
>>
>
------------------------------------
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/.
<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
[Non-text portions of this message have been removed]