PO Approver BPM

Yahoo Archive
1
We do have a task setup for BPM processing (BPM Action Process), not sure it's required for e-mails only? It's setup on a 15 second interval I believe?


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of McMullen, Travis
Sent: Thursday, January 12, 2012 3:41 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: PO Approver BPM

Do you need to setup a task in the task agent for send the e-mails? If so, what interval do you use?

Travis L. McMullen
ERP Specialist
ComSonics, Inc.
Harrisonburg, VA 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...


On Thu, Jan 12, 2012 at 5:34 PM, Ken Williams < kwilliams@...> wrote:

> **
>
>
> I would suggest using asynchronous. Synchronously pauses the client
> while the server creates and sends the e-mail, asynchronous allows the
> client to continue working and the e-mail be sent in the background.
> We use asynchronous everywhere and find it works great.
>
> Ken
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of McMullen, Travis
> Sent: Thursday, January 12, 2012 3:33 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: PO Approver BPM
>
> Send e-mail synchronously based on the designed template.
>
> Travis L. McMullen
> ERP Specialist
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@...
>
> On Thu, Jan 12, 2012 at 5:28 PM, epicoruser11
> <epicorusereleven@...
> >wrote:
>
> > **
>
> >
> >
> > What will the action be for the PO.Update Method?
> >
> >
> > --- In vantage@yahoogroups.com, "McMullen, Travis" <tmcmullen@...>
> wrote:
> > >
> > > The code that I posted goes in the Post-Processing for the
> > > PO.ChangeApproveSwitch. Under Actions, use "synchronously execute
> > > 4GL code".
> > >
> > > For the PO.Update, you will need a condition of "the specified
> > > field has been changed from any to any" where the field will be
> > > ttPOHeader.ApprovalStatus and the first 'any' will be 'U' and the
> > > second 'any' will be 'P'.
> > >
> > > Travis L. McMullen
> > > ERP Specialist
> > > ComSonics, Inc.
> > > Harrisonburg, VA 22801
> > > Phone: 540-434-5965 x1274
> > > Toll Free: 1-800-336-9681 x1274
> > > Mobile: 540-435-1920
> > > Fax: 540-434-9847
> > > E-Mail: tmcmullen@...
> >
> > >
> > >
> > > On Thu, Jan 12, 2012 at 4:53 PM, McMullen, Travis
> > > <tmcmullen@...>wrote:
> >
> > >
> > > > I had to do this as well. We have the e-mail address of the
> > > > approver listed in Buyer Maintenance, so created a
> > > > Post-Processing 4GL code on
> > the
> > > > PO.ChangeApproveSwitch methond that found the buyer record of
> > > > the PO,
> > and
> > > > then found the approvers record to retrieve the e-mail address
> > > > and put
> > it
> > > > into a UDField in the POHeader. I then sent the e-mail on the
> > > > PO.Update method of the POHeader.ApprovalStatus = 'P'. The code
> > > > for the 4GL
> > portion
> > > > is below. Feel free to contact me offline with questions.
> > > >
> > > > find first ttPOHeader where ttPOHeader.RowMod = "A":U or
> > ttPOHeader.RowMod
> > > > = "U":U
> > > > no-lock no-error.
> > > > if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
> > > > find PurAgent where PurAgent.Company = CUR-COMP and
> > > > PurAgent.BuyerID = ttPOHeader.BuyerID no-lock no-error.
> > > > if available PurAgent then
> > > > define variable AppPerson as character.
> > > > AppPerson = PurAgent.ApprovalPerson.
> > > > find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
> > > > PurAgent.BuyerID no-lock no-error.
> > > > if available PurAgent then ttPOHeader.ShortChar02 =
> > PurAgent.EMailAddress.
> > > > end.
> > > >
> > > > Travis L. McMullen
> > > > ERP Specialist
> > > > ComSonics, Inc.
> > > > Harrisonburg, VA 22801
> > > > Phone: 540-434-5965 x1274
> > > > Toll Free: 1-800-336-9681 x1274
> > > > Mobile: 540-435-1920
> > > > Fax: 540-434-9847
> > > > E-Mail: tmcmullen@...
> > > >
> > > >
> > > >
> > > > On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@...> wrote:
> > > >
> > > >> **
> >
> > > >>
> > > >>
> > > >> I believe youd be getting into a 4GL action there... basically
> > > >> you
> > would
> > > >> have to query to an area where you store your system user
> > > >> emails (user maintenance perhaps). Your path would be the
> > > >> ttPOdataset to the buyermaintenance dataset (I don't recall
> > > >> which tables) and ultimately linking the approval person to the
> > > >> user maintenance table. You'd have
> > to
> > > >> then code the bpm using 4gl (there are a ton of coded examples
> > > >> for
> > that on
> > > >> the group, do a search) to send an email at that point. If you
> > > >> really struggle with the query, msg me offline and I'll try and
> > > >> help you
> > flesh
> > > >> that out.
> > > >>
> > > >> Rob Bucek
> > > >> Production Control Manager
> > > >> PH: (715) 284-5376 ext 311
> > > >> Mobile: (715)896-0590
> > > >> FAX: (715)284-4084
> > > >> [Description: cid:1.234354861@...]<
> >
> > > >> 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 epicoruser11
> > > >> Sent: Thursday, January 12, 2012 3:35 PM
> > > >> To: vantage@yahoogroups.com
> > > >> Subject: [Vantage] PO Approver BPM
> > > >>
> > > >>
> > > >> SO I have a BPM setup that works just fine for sending an email
> > > >> when
> > a PO
> > > >> needs approval. Issue I'm running into is how I can have it
> > > >> email a
> > user
> > > >> based on who the approver should be.
> > > >>
> > > >> This is what i have setup.
> > > >>
> > > >> Method Directive setup on PO.Update Pre-Processing
> > > >>
> > > >> Condition: the POHeader.Approve field of the changed row is
> > > >> equel to
> > the
> > > >> True expression
> > > >>
> > > >> Action: send email synchronously based on the EmailPOApprover
> > > >> template
> > > >>
> > > >> How can I get this to send to the approver email address of the PO?
> > > >>
> > > >> [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/.
> (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]



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

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
2
SO I have a BPM setup that works just fine for sending an email when a PO needs approval. Issue I'm running into is how I can have it email a user based on who the approver should be.

This is what i have setup.

Method Directive setup on PO.Update Pre-Processing

Condition: the POHeader.Approve field of the changed row is equel to the True expression


Action: send email synchronously based on the EmailPOApprover template

How can I get this to send to the approver email address of the PO?
3
I believe youd be getting into a 4GL action there... basically you would have to query to an area where you store your system user emails (user maintenance perhaps). Your path would be the ttPOdataset to the buyermaintenance dataset (I don't recall which tables) and ultimately linking the approval person to the user maintenance table. You'd have to then code the bpm using 4gl (there are a ton of coded examples for that on the group, do a search) to send an email at that point. If you really struggle with the query, msg me offline and I'll try and help you flesh that out.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<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 epicoruser11
Sent: Thursday, January 12, 2012 3:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] PO Approver BPM



SO I have a BPM setup that works just fine for sending an email when a PO needs approval. Issue I'm running into is how I can have it email a user based on who the approver should be.

This is what i have setup.

Method Directive setup on PO.Update Pre-Processing

Condition: the POHeader.Approve field of the changed row is equel to the True expression

Action: send email synchronously based on the EmailPOApprover template

How can I get this to send to the approver email address of the PO?



[Non-text portions of this message have been removed]
4
I had to do this as well. We have the e-mail address of the approver
listed in Buyer Maintenance, so created a Post-Processing 4GL code on the
PO.ChangeApproveSwitch methond that found the buyer record of the PO, and
then found the approvers record to retrieve the e-mail address and put it
into a UDField in the POHeader. I then sent the e-mail on the PO.Update
method of the POHeader.ApprovalStatus = 'P'. The code for the 4GL portion
is below. Feel free to contact me offline with questions.

find first ttPOHeader where ttPOHeader.RowMod = "A":U or ttPOHeader.RowMod
= "U":U
no-lock no-error.
if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
find PurAgent where PurAgent.Company = CUR-COMP and PurAgent.BuyerID =
ttPOHeader.BuyerID
no-lock no-error.
if available PurAgent then
define variable AppPerson as character.
AppPerson = PurAgent.ApprovalPerson.
find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
PurAgent.BuyerID
no-lock no-error.
if available PurAgent then ttPOHeader.ShortChar02 = PurAgent.EMailAddress.
end.

Travis L. McMullen
ERP Specialist
ComSonics, Inc.
Harrisonburg, VA 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...


On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@...> wrote:

> **
>
>
> I believe youd be getting into a 4GL action there... basically you would
> have to query to an area where you store your system user emails (user
> maintenance perhaps). Your path would be the ttPOdataset to the
> buyermaintenance dataset (I don't recall which tables) and ultimately
> linking the approval person to the user maintenance table. You'd have to
> then code the bpm using 4gl (there are a ton of coded examples for that on
> the group, do a search) to send an email at that point. If you really
> struggle with the query, msg me offline and I'll try and help you flesh
> that out.
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-0590
> FAX: (715)284-4084
> [Description: cid:1.234354861@...]<
> 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 epicoruser11
> Sent: Thursday, January 12, 2012 3:35 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] PO Approver BPM
>
>
> SO I have a BPM setup that works just fine for sending an email when a PO
> needs approval. Issue I'm running into is how I can have it email a user
> based on who the approver should be.
>
> This is what i have setup.
>
> Method Directive setup on PO.Update Pre-Processing
>
> Condition: the POHeader.Approve field of the changed row is equel to the
> True expression
>
> Action: send email synchronously based on the EmailPOApprover template
>
> How can I get this to send to the approver email address of the PO?
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
5
Sounds like exactly what I need to do. What is the 4GL code that you used for the PO.ChangeApproveSwitch?

--- In vantage@yahoogroups.com, "McMullen, Travis" <tmcmullen@...> wrote:
>
> I had to do this as well. We have the e-mail address of the approver
> listed in Buyer Maintenance, so created a Post-Processing 4GL code on the
> PO.ChangeApproveSwitch methond that found the buyer record of the PO, and
> then found the approvers record to retrieve the e-mail address and put it
> into a UDField in the POHeader. I then sent the e-mail on the PO.Update
> method of the POHeader.ApprovalStatus = 'P'. The code for the 4GL portion
> is below. Feel free to contact me offline with questions.
>
> find first ttPOHeader where ttPOHeader.RowMod = "A":U or ttPOHeader.RowMod
> = "U":U
> no-lock no-error.
> if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
> find PurAgent where PurAgent.Company = CUR-COMP and PurAgent.BuyerID =
> ttPOHeader.BuyerID
> no-lock no-error.
> if available PurAgent then
> define variable AppPerson as character.
> AppPerson = PurAgent.ApprovalPerson.
> find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
> PurAgent.BuyerID
> no-lock no-error.
> if available PurAgent then ttPOHeader.ShortChar02 = PurAgent.EMailAddress.
> end.
>
> Travis L. McMullen
> ERP Specialist
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@...
>
>
> On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@...> wrote:
>
> > **
> >
> >
> > I believe youd be getting into a 4GL action there... basically you would
> > have to query to an area where you store your system user emails (user
> > maintenance perhaps). Your path would be the ttPOdataset to the
> > buyermaintenance dataset (I don't recall which tables) and ultimately
> > linking the approval person to the user maintenance table. You'd have to
> > then code the bpm using 4gl (there are a ton of coded examples for that on
> > the group, do a search) to send an email at that point. If you really
> > struggle with the query, msg me offline and I'll try and help you flesh
> > that out.
> >
> > Rob Bucek
> > Production Control Manager
> > PH: (715) 284-5376 ext 311
> > Mobile: (715)896-0590
> > FAX: (715)284-4084
> > [Description: cid:1.234354861@...]<
> > 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 epicoruser11
> > Sent: Thursday, January 12, 2012 3:35 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] PO Approver BPM
> >
> >
> > SO I have a BPM setup that works just fine for sending an email when a PO
> > needs approval. Issue I'm running into is how I can have it email a user
> > based on who the approver should be.
> >
> > This is what i have setup.
> >
> > Method Directive setup on PO.Update Pre-Processing
> >
> > Condition: the POHeader.Approve field of the changed row is equel to the
> > True expression
> >
> > Action: send email synchronously based on the EmailPOApprover template
> >
> > How can I get this to send to the approver email address of the PO?
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
6
The code that I posted goes in the Post-Processing for the
PO.ChangeApproveSwitch. Under Actions, use "synchronously execute 4GL
code".

For the PO.Update, you will need a condition of "the specified field has
been changed from any to any" where the field will be
ttPOHeader.ApprovalStatus and the first 'any' will be 'U' and the second
'any' will be 'P'.

Travis L. McMullen
ERP Specialist
ComSonics, Inc.
Harrisonburg, VA 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...


On Thu, Jan 12, 2012 at 4:53 PM, McMullen, Travis
<tmcmullen@...>wrote:

> I had to do this as well. We have the e-mail address of the approver
> listed in Buyer Maintenance, so created a Post-Processing 4GL code on the
> PO.ChangeApproveSwitch methond that found the buyer record of the PO, and
> then found the approvers record to retrieve the e-mail address and put it
> into a UDField in the POHeader. I then sent the e-mail on the PO.Update
> method of the POHeader.ApprovalStatus = 'P'. The code for the 4GL portion
> is below. Feel free to contact me offline with questions.
>
> find first ttPOHeader where ttPOHeader.RowMod = "A":U or ttPOHeader.RowMod
> = "U":U
> no-lock no-error.
> if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
> find PurAgent where PurAgent.Company = CUR-COMP and PurAgent.BuyerID =
> ttPOHeader.BuyerID
> no-lock no-error.
> if available PurAgent then
> define variable AppPerson as character.
> AppPerson = PurAgent.ApprovalPerson.
> find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
> PurAgent.BuyerID
> no-lock no-error.
> if available PurAgent then ttPOHeader.ShortChar02 = PurAgent.EMailAddress.
> end.
>
> Travis L. McMullen
> ERP Specialist
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@...
>
>
>
> On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@...> wrote:
>
>> **
>>
>>
>> I believe youd be getting into a 4GL action there... basically you would
>> have to query to an area where you store your system user emails (user
>> maintenance perhaps). Your path would be the ttPOdataset to the
>> buyermaintenance dataset (I don't recall which tables) and ultimately
>> linking the approval person to the user maintenance table. You'd have to
>> then code the bpm using 4gl (there are a ton of coded examples for that on
>> the group, do a search) to send an email at that point. If you really
>> struggle with the query, msg me offline and I'll try and help you flesh
>> that out.
>>
>> Rob Bucek
>> Production Control Manager
>> PH: (715) 284-5376 ext 311
>> Mobile: (715)896-0590
>> FAX: (715)284-4084
>> [Description: cid:1.234354861@...]<
>> 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 epicoruser11
>> Sent: Thursday, January 12, 2012 3:35 PM
>> To: vantage@yahoogroups.com
>> Subject: [Vantage] PO Approver BPM
>>
>>
>> SO I have a BPM setup that works just fine for sending an email when a PO
>> needs approval. Issue I'm running into is how I can have it email a user
>> based on who the approver should be.
>>
>> This is what i have setup.
>>
>> Method Directive setup on PO.Update Pre-Processing
>>
>> Condition: the POHeader.Approve field of the changed row is equel to the
>> True expression
>>
>> Action: send email synchronously based on the EmailPOApprover template
>>
>> How can I get this to send to the approver email address of the PO?
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>
>


[Non-text portions of this message have been removed]
7
What will the action be for the PO.Update Method?

--- In vantage@yahoogroups.com, "McMullen, Travis" <tmcmullen@...> wrote:
>
> The code that I posted goes in the Post-Processing for the
> PO.ChangeApproveSwitch. Under Actions, use "synchronously execute 4GL
> code".
>
> For the PO.Update, you will need a condition of "the specified field has
> been changed from any to any" where the field will be
> ttPOHeader.ApprovalStatus and the first 'any' will be 'U' and the second
> 'any' will be 'P'.
>
> Travis L. McMullen
> ERP Specialist
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@...
>
>
> On Thu, Jan 12, 2012 at 4:53 PM, McMullen, Travis
> <tmcmullen@...>wrote:
>
> > I had to do this as well. We have the e-mail address of the approver
> > listed in Buyer Maintenance, so created a Post-Processing 4GL code on the
> > PO.ChangeApproveSwitch methond that found the buyer record of the PO, and
> > then found the approvers record to retrieve the e-mail address and put it
> > into a UDField in the POHeader. I then sent the e-mail on the PO.Update
> > method of the POHeader.ApprovalStatus = 'P'. The code for the 4GL portion
> > is below. Feel free to contact me offline with questions.
> >
> > find first ttPOHeader where ttPOHeader.RowMod = "A":U or ttPOHeader.RowMod
> > = "U":U
> > no-lock no-error.
> > if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
> > find PurAgent where PurAgent.Company = CUR-COMP and PurAgent.BuyerID =
> > ttPOHeader.BuyerID
> > no-lock no-error.
> > if available PurAgent then
> > define variable AppPerson as character.
> > AppPerson = PurAgent.ApprovalPerson.
> > find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
> > PurAgent.BuyerID
> > no-lock no-error.
> > if available PurAgent then ttPOHeader.ShortChar02 = PurAgent.EMailAddress.
> > end.
> >
> > Travis L. McMullen
> > ERP Specialist
> > ComSonics, Inc.
> > Harrisonburg, VA 22801
> > Phone: 540-434-5965 x1274
> > Toll Free: 1-800-336-9681 x1274
> > Mobile: 540-435-1920
> > Fax: 540-434-9847
> > E-Mail: tmcmullen@...
> >
> >
> >
> > On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@...> wrote:
> >
> >> **
> >>
> >>
> >> I believe youd be getting into a 4GL action there... basically you would
> >> have to query to an area where you store your system user emails (user
> >> maintenance perhaps). Your path would be the ttPOdataset to the
> >> buyermaintenance dataset (I don't recall which tables) and ultimately
> >> linking the approval person to the user maintenance table. You'd have to
> >> then code the bpm using 4gl (there are a ton of coded examples for that on
> >> the group, do a search) to send an email at that point. If you really
> >> struggle with the query, msg me offline and I'll try and help you flesh
> >> that out.
> >>
> >> Rob Bucek
> >> Production Control Manager
> >> PH: (715) 284-5376 ext 311
> >> Mobile: (715)896-0590
> >> FAX: (715)284-4084
> >> [Description: cid:1.234354861@...]<
> >> 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 epicoruser11
> >> Sent: Thursday, January 12, 2012 3:35 PM
> >> To: vantage@yahoogroups.com
> >> Subject: [Vantage] PO Approver BPM
> >>
> >>
> >> SO I have a BPM setup that works just fine for sending an email when a PO
> >> needs approval. Issue I'm running into is how I can have it email a user
> >> based on who the approver should be.
> >>
> >> This is what i have setup.
> >>
> >> Method Directive setup on PO.Update Pre-Processing
> >>
> >> Condition: the POHeader.Approve field of the changed row is equel to the
> >> True expression
> >>
> >> Action: send email synchronously based on the EmailPOApprover template
> >>
> >> How can I get this to send to the approver email address of the PO?
> >>
> >> [Non-text portions of this message have been removed]
> >>
> >>
> >>
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
8
Send e-mail synchronously based on the designed template.

Travis L. McMullen
ERP Specialist
ComSonics, Inc.
Harrisonburg, VA 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...


On Thu, Jan 12, 2012 at 5:28 PM, epicoruser11 <epicorusereleven@...>wrote:

> **
>
>
> What will the action be for the PO.Update Method?
>
>
> --- In vantage@yahoogroups.com, "McMullen, Travis" <tmcmullen@...> wrote:
> >
> > The code that I posted goes in the Post-Processing for the
> > PO.ChangeApproveSwitch. Under Actions, use "synchronously execute 4GL
> > code".
> >
> > For the PO.Update, you will need a condition of "the specified field has
> > been changed from any to any" where the field will be
> > ttPOHeader.ApprovalStatus and the first 'any' will be 'U' and the second
> > 'any' will be 'P'.
> >
> > Travis L. McMullen
> > ERP Specialist
> > ComSonics, Inc.
> > Harrisonburg, VA 22801
> > Phone: 540-434-5965 x1274
> > Toll Free: 1-800-336-9681 x1274
> > Mobile: 540-435-1920
> > Fax: 540-434-9847
> > E-Mail: tmcmullen@...
>
> >
> >
> > On Thu, Jan 12, 2012 at 4:53 PM, McMullen, Travis
> > <tmcmullen@...>wrote:
>
> >
> > > I had to do this as well. We have the e-mail address of the approver
> > > listed in Buyer Maintenance, so created a Post-Processing 4GL code on
> the
> > > PO.ChangeApproveSwitch methond that found the buyer record of the PO,
> and
> > > then found the approvers record to retrieve the e-mail address and put
> it
> > > into a UDField in the POHeader. I then sent the e-mail on the PO.Update
> > > method of the POHeader.ApprovalStatus = 'P'. The code for the 4GL
> portion
> > > is below. Feel free to contact me offline with questions.
> > >
> > > find first ttPOHeader where ttPOHeader.RowMod = "A":U or
> ttPOHeader.RowMod
> > > = "U":U
> > > no-lock no-error.
> > > if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
> > > find PurAgent where PurAgent.Company = CUR-COMP and PurAgent.BuyerID =
> > > ttPOHeader.BuyerID
> > > no-lock no-error.
> > > if available PurAgent then
> > > define variable AppPerson as character.
> > > AppPerson = PurAgent.ApprovalPerson.
> > > find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
> > > PurAgent.BuyerID
> > > no-lock no-error.
> > > if available PurAgent then ttPOHeader.ShortChar02 =
> PurAgent.EMailAddress.
> > > end.
> > >
> > > Travis L. McMullen
> > > ERP Specialist
> > > ComSonics, Inc.
> > > Harrisonburg, VA 22801
> > > Phone: 540-434-5965 x1274
> > > Toll Free: 1-800-336-9681 x1274
> > > Mobile: 540-435-1920
> > > Fax: 540-434-9847
> > > E-Mail: tmcmullen@...
> > >
> > >
> > >
> > > On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@...> wrote:
> > >
> > >> **
>
> > >>
> > >>
> > >> I believe youd be getting into a 4GL action there... basically you
> would
> > >> have to query to an area where you store your system user emails (user
> > >> maintenance perhaps). Your path would be the ttPOdataset to the
> > >> buyermaintenance dataset (I don't recall which tables) and ultimately
> > >> linking the approval person to the user maintenance table. You'd have
> to
> > >> then code the bpm using 4gl (there are a ton of coded examples for
> that on
> > >> the group, do a search) to send an email at that point. If you really
> > >> struggle with the query, msg me offline and I'll try and help you
> flesh
> > >> that out.
> > >>
> > >> Rob Bucek
> > >> Production Control Manager
> > >> PH: (715) 284-5376 ext 311
> > >> Mobile: (715)896-0590
> > >> FAX: (715)284-4084
> > >> [Description: cid:1.234354861@...]<
>
> > >> 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 epicoruser11
> > >> Sent: Thursday, January 12, 2012 3:35 PM
> > >> To: vantage@yahoogroups.com
> > >> Subject: [Vantage] PO Approver BPM
> > >>
> > >>
> > >> SO I have a BPM setup that works just fine for sending an email when
> a PO
> > >> needs approval. Issue I'm running into is how I can have it email a
> user
> > >> based on who the approver should be.
> > >>
> > >> This is what i have setup.
> > >>
> > >> Method Directive setup on PO.Update Pre-Processing
> > >>
> > >> Condition: the POHeader.Approve field of the changed row is equel to
> the
> > >> True expression
> > >>
> > >> Action: send email synchronously based on the EmailPOApprover template
> > >>
> > >> How can I get this to send to the approver email address of the PO?
> > >>
> > >> [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]
9
I would suggest using asynchronous. Synchronously pauses the client while the server creates and sends the e-mail, asynchronous allows the client to continue working and the e-mail be sent in the background. We use asynchronous everywhere and find it works great.

Ken

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of McMullen, Travis
Sent: Thursday, January 12, 2012 3:33 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: PO Approver BPM

Send e-mail synchronously based on the designed template.

Travis L. McMullen
ERP Specialist
ComSonics, Inc.
Harrisonburg, VA 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...


On Thu, Jan 12, 2012 at 5:28 PM, epicoruser11 <epicorusereleven@...>wrote:

> **
>
>
> What will the action be for the PO.Update Method?
>
>
> --- In vantage@yahoogroups.com, "McMullen, Travis" <tmcmullen@...> wrote:
> >
> > The code that I posted goes in the Post-Processing for the
> > PO.ChangeApproveSwitch. Under Actions, use "synchronously execute
> > 4GL code".
> >
> > For the PO.Update, you will need a condition of "the specified field
> > has been changed from any to any" where the field will be
> > ttPOHeader.ApprovalStatus and the first 'any' will be 'U' and the
> > second 'any' will be 'P'.
> >
> > Travis L. McMullen
> > ERP Specialist
> > ComSonics, Inc.
> > Harrisonburg, VA 22801
> > Phone: 540-434-5965 x1274
> > Toll Free: 1-800-336-9681 x1274
> > Mobile: 540-435-1920
> > Fax: 540-434-9847
> > E-Mail: tmcmullen@...
>
> >
> >
> > On Thu, Jan 12, 2012 at 4:53 PM, McMullen, Travis
> > <tmcmullen@...>wrote:
>
> >
> > > I had to do this as well. We have the e-mail address of the
> > > approver listed in Buyer Maintenance, so created a Post-Processing
> > > 4GL code on
> the
> > > PO.ChangeApproveSwitch methond that found the buyer record of the
> > > PO,
> and
> > > then found the approvers record to retrieve the e-mail address and
> > > put
> it
> > > into a UDField in the POHeader. I then sent the e-mail on the
> > > PO.Update method of the POHeader.ApprovalStatus = 'P'. The code
> > > for the 4GL
> portion
> > > is below. Feel free to contact me offline with questions.
> > >
> > > find first ttPOHeader where ttPOHeader.RowMod = "A":U or
> ttPOHeader.RowMod
> > > = "U":U
> > > no-lock no-error.
> > > if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
> > > find PurAgent where PurAgent.Company = CUR-COMP and
> > > PurAgent.BuyerID = ttPOHeader.BuyerID no-lock no-error.
> > > if available PurAgent then
> > > define variable AppPerson as character.
> > > AppPerson = PurAgent.ApprovalPerson.
> > > find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
> > > PurAgent.BuyerID no-lock no-error.
> > > if available PurAgent then ttPOHeader.ShortChar02 =
> PurAgent.EMailAddress.
> > > end.
> > >
> > > Travis L. McMullen
> > > ERP Specialist
> > > ComSonics, Inc.
> > > Harrisonburg, VA 22801
> > > Phone: 540-434-5965 x1274
> > > Toll Free: 1-800-336-9681 x1274
> > > Mobile: 540-435-1920
> > > Fax: 540-434-9847
> > > E-Mail: tmcmullen@...
> > >
> > >
> > >
> > > On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@...> wrote:
> > >
> > >> **
>
> > >>
> > >>
> > >> I believe youd be getting into a 4GL action there... basically
> > >> you
> would
> > >> have to query to an area where you store your system user emails
> > >> (user maintenance perhaps). Your path would be the ttPOdataset to
> > >> the buyermaintenance dataset (I don't recall which tables) and
> > >> ultimately linking the approval person to the user maintenance
> > >> table. You'd have
> to
> > >> then code the bpm using 4gl (there are a ton of coded examples
> > >> for
> that on
> > >> the group, do a search) to send an email at that point. If you
> > >> really struggle with the query, msg me offline and I'll try and
> > >> help you
> flesh
> > >> that out.
> > >>
> > >> Rob Bucek
> > >> Production Control Manager
> > >> PH: (715) 284-5376 ext 311
> > >> Mobile: (715)896-0590
> > >> FAX: (715)284-4084
> > >> [Description: cid:1.234354861@...]<
>
> > >> 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 epicoruser11
> > >> Sent: Thursday, January 12, 2012 3:35 PM
> > >> To: vantage@yahoogroups.com
> > >> Subject: [Vantage] PO Approver BPM
> > >>
> > >>
> > >> SO I have a BPM setup that works just fine for sending an email
> > >> when
> a PO
> > >> needs approval. Issue I'm running into is how I can have it email
> > >> a
> user
> > >> based on who the approver should be.
> > >>
> > >> This is what i have setup.
> > >>
> > >> Method Directive setup on PO.Update Pre-Processing
> > >>
> > >> Condition: the POHeader.Approve field of the changed row is equel
> > >> to
> the
> > >> True expression
> > >>
> > >> Action: send email synchronously based on the EmailPOApprover
> > >> template
> > >>
> > >> How can I get this to send to the approver email address of the PO?
> > >>
> > >> [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/.
(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
10
Do you need to setup a task in the task agent for send the e-mails? If so,
what interval do you use?

Travis L. McMullen
ERP Specialist
ComSonics, Inc.
Harrisonburg, VA 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...


On Thu, Jan 12, 2012 at 5:34 PM, Ken Williams <
kwilliams@...> wrote:

> **
>
>
> I would suggest using asynchronous. Synchronously pauses the client while
> the server creates and sends the e-mail, asynchronous allows the client to
> continue working and the e-mail be sent in the background. We use
> asynchronous everywhere and find it works great.
>
> Ken
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of McMullen, Travis
> Sent: Thursday, January 12, 2012 3:33 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: PO Approver BPM
>
> Send e-mail synchronously based on the designed template.
>
> Travis L. McMullen
> ERP Specialist
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@...
>
> On Thu, Jan 12, 2012 at 5:28 PM, epicoruser11 <epicorusereleven@...
> >wrote:
>
> > **
>
> >
> >
> > What will the action be for the PO.Update Method?
> >
> >
> > --- In vantage@yahoogroups.com, "McMullen, Travis" <tmcmullen@...>
> wrote:
> > >
> > > The code that I posted goes in the Post-Processing for the
> > > PO.ChangeApproveSwitch. Under Actions, use "synchronously execute
> > > 4GL code".
> > >
> > > For the PO.Update, you will need a condition of "the specified field
> > > has been changed from any to any" where the field will be
> > > ttPOHeader.ApprovalStatus and the first 'any' will be 'U' and the
> > > second 'any' will be 'P'.
> > >
> > > Travis L. McMullen
> > > ERP Specialist
> > > ComSonics, Inc.
> > > Harrisonburg, VA 22801
> > > Phone: 540-434-5965 x1274
> > > Toll Free: 1-800-336-9681 x1274
> > > Mobile: 540-435-1920
> > > Fax: 540-434-9847
> > > E-Mail: tmcmullen@...
> >
> > >
> > >
> > > On Thu, Jan 12, 2012 at 4:53 PM, McMullen, Travis
> > > <tmcmullen@...>wrote:
> >
> > >
> > > > I had to do this as well. We have the e-mail address of the
> > > > approver listed in Buyer Maintenance, so created a Post-Processing
> > > > 4GL code on
> > the
> > > > PO.ChangeApproveSwitch methond that found the buyer record of the
> > > > PO,
> > and
> > > > then found the approvers record to retrieve the e-mail address and
> > > > put
> > it
> > > > into a UDField in the POHeader. I then sent the e-mail on the
> > > > PO.Update method of the POHeader.ApprovalStatus = 'P'. The code
> > > > for the 4GL
> > portion
> > > > is below. Feel free to contact me offline with questions.
> > > >
> > > > find first ttPOHeader where ttPOHeader.RowMod = "A":U or
> > ttPOHeader.RowMod
> > > > = "U":U
> > > > no-lock no-error.
> > > > if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
> > > > find PurAgent where PurAgent.Company = CUR-COMP and
> > > > PurAgent.BuyerID = ttPOHeader.BuyerID no-lock no-error.
> > > > if available PurAgent then
> > > > define variable AppPerson as character.
> > > > AppPerson = PurAgent.ApprovalPerson.
> > > > find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
> > > > PurAgent.BuyerID no-lock no-error.
> > > > if available PurAgent then ttPOHeader.ShortChar02 =
> > PurAgent.EMailAddress.
> > > > end.
> > > >
> > > > Travis L. McMullen
> > > > ERP Specialist
> > > > ComSonics, Inc.
> > > > Harrisonburg, VA 22801
> > > > Phone: 540-434-5965 x1274
> > > > Toll Free: 1-800-336-9681 x1274
> > > > Mobile: 540-435-1920
> > > > Fax: 540-434-9847
> > > > E-Mail: tmcmullen@...
> > > >
> > > >
> > > >
> > > > On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@...> wrote:
> > > >
> > > >> **
> >
> > > >>
> > > >>
> > > >> I believe youd be getting into a 4GL action there... basically
> > > >> you
> > would
> > > >> have to query to an area where you store your system user emails
> > > >> (user maintenance perhaps). Your path would be the ttPOdataset to
> > > >> the buyermaintenance dataset (I don't recall which tables) and
> > > >> ultimately linking the approval person to the user maintenance
> > > >> table. You'd have
> > to
> > > >> then code the bpm using 4gl (there are a ton of coded examples
> > > >> for
> > that on
> > > >> the group, do a search) to send an email at that point. If you
> > > >> really struggle with the query, msg me offline and I'll try and
> > > >> help you
> > flesh
> > > >> that out.
> > > >>
> > > >> Rob Bucek
> > > >> Production Control Manager
> > > >> PH: (715) 284-5376 ext 311
> > > >> Mobile: (715)896-0590
> > > >> FAX: (715)284-4084
> > > >> [Description: cid:1.234354861@...]<
> >
> > > >> 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 epicoruser11
> > > >> Sent: Thursday, January 12, 2012 3:35 PM
> > > >> To: vantage@yahoogroups.com
> > > >> Subject: [Vantage] PO Approver BPM
> > > >>
> > > >>
> > > >> SO I have a BPM setup that works just fine for sending an email
> > > >> when
> > a PO
> > > >> needs approval. Issue I'm running into is how I can have it email
> > > >> a
> > user
> > > >> based on who the approver should be.
> > > >>
> > > >> This is what i have setup.
> > > >>
> > > >> Method Directive setup on PO.Update Pre-Processing
> > > >>
> > > >> Condition: the POHeader.Approve field of the changed row is equel
> > > >> to
> > the
> > > >> True expression
> > > >>
> > > >> Action: send email synchronously based on the EmailPOApprover
> > > >> template
> > > >>
> > > >> How can I get this to send to the approver email address of the PO?
> > > >>
> > > >> [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/.
> (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]
11
Thanks for your help with this I was able to get it working!
--- In vantage@yahoogroups.com, Ken Williams <kwilliams@...> wrote:
>
> I would suggest using asynchronous. Synchronously pauses the client while the server creates and sends the e-mail, asynchronous allows the client to continue working and the e-mail be sent in the background. We use asynchronous everywhere and find it works great.
>
> Ken
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of McMullen, Travis
> Sent: Thursday, January 12, 2012 3:33 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: PO Approver BPM
>
> Send e-mail synchronously based on the designed template.
>
> Travis L. McMullen
> ERP Specialist
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@...
>
>
> On Thu, Jan 12, 2012 at 5:28 PM, epicoruser11 <epicorusereleven@...>wrote:
>
> > **
> >
> >
> > What will the action be for the PO.Update Method?
> >
> >
> > --- In vantage@yahoogroups.com, "McMullen, Travis" <tmcmullen@> wrote:
> > >
> > > The code that I posted goes in the Post-Processing for the
> > > PO.ChangeApproveSwitch. Under Actions, use "synchronously execute
> > > 4GL code".
> > >
> > > For the PO.Update, you will need a condition of "the specified field
> > > has been changed from any to any" where the field will be
> > > ttPOHeader.ApprovalStatus and the first 'any' will be 'U' and the
> > > second 'any' will be 'P'.
> > >
> > > Travis L. McMullen
> > > ERP Specialist
> > > ComSonics, Inc.
> > > Harrisonburg, VA 22801
> > > Phone: 540-434-5965 x1274
> > > Toll Free: 1-800-336-9681 x1274
> > > Mobile: 540-435-1920
> > > Fax: 540-434-9847
> > > E-Mail: tmcmullen@
> >
> > >
> > >
> > > On Thu, Jan 12, 2012 at 4:53 PM, McMullen, Travis
> > > <tmcmullen@>wrote:
> >
> > >
> > > > I had to do this as well. We have the e-mail address of the
> > > > approver listed in Buyer Maintenance, so created a Post-Processing
> > > > 4GL code on
> > the
> > > > PO.ChangeApproveSwitch methond that found the buyer record of the
> > > > PO,
> > and
> > > > then found the approvers record to retrieve the e-mail address and
> > > > put
> > it
> > > > into a UDField in the POHeader. I then sent the e-mail on the
> > > > PO.Update method of the POHeader.ApprovalStatus = 'P'. The code
> > > > for the 4GL
> > portion
> > > > is below. Feel free to contact me offline with questions.
> > > >
> > > > find first ttPOHeader where ttPOHeader.RowMod = "A":U or
> > ttPOHeader.RowMod
> > > > = "U":U
> > > > no-lock no-error.
> > > > if available ttPOHeader and ttPOHeader.ApprovalStatus = "P" then do:
> > > > find PurAgent where PurAgent.Company = CUR-COMP and
> > > > PurAgent.BuyerID = ttPOHeader.BuyerID no-lock no-error.
> > > > if available PurAgent then
> > > > define variable AppPerson as character.
> > > > AppPerson = PurAgent.ApprovalPerson.
> > > > find PurAgent where PurAgent.Company = CUR-COMP and AppPerson =
> > > > PurAgent.BuyerID no-lock no-error.
> > > > if available PurAgent then ttPOHeader.ShortChar02 =
> > PurAgent.EMailAddress.
> > > > end.
> > > >
> > > > Travis L. McMullen
> > > > ERP Specialist
> > > > ComSonics, Inc.
> > > > Harrisonburg, VA 22801
> > > > Phone: 540-434-5965 x1274
> > > > Toll Free: 1-800-336-9681 x1274
> > > > Mobile: 540-435-1920
> > > > Fax: 540-434-9847
> > > > E-Mail: tmcmullen@
> > > >
> > > >
> > > >
> > > > On Thu, Jan 12, 2012 at 4:46 PM, Rob Bucek <rbucek@> wrote:
> > > >
> > > >> **
> >
> > > >>
> > > >>
> > > >> I believe youd be getting into a 4GL action there... basically
> > > >> you
> > would
> > > >> have to query to an area where you store your system user emails
> > > >> (user maintenance perhaps). Your path would be the ttPOdataset to
> > > >> the buyermaintenance dataset (I don't recall which tables) and
> > > >> ultimately linking the approval person to the user maintenance
> > > >> table. You'd have
> > to
> > > >> then code the bpm using 4gl (there are a ton of coded examples
> > > >> for
> > that on
> > > >> the group, do a search) to send an email at that point. If you
> > > >> really struggle with the query, msg me offline and I'll try and
> > > >> help you
> > flesh
> > > >> that out.
> > > >>
> > > >> Rob Bucek
> > > >> Production Control Manager
> > > >> PH: (715) 284-5376 ext 311
> > > >> Mobile: (715)896-0590
> > > >> FAX: (715)284-4084
> > > >> [Description: cid:1.234354861@]<
> >
> > > >> 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 epicoruser11
> > > >> Sent: Thursday, January 12, 2012 3:35 PM
> > > >> To: vantage@yahoogroups.com
> > > >> Subject: [Vantage] PO Approver BPM
> > > >>
> > > >>
> > > >> SO I have a BPM setup that works just fine for sending an email
> > > >> when
> > a PO
> > > >> needs approval. Issue I'm running into is how I can have it email
> > > >> a
> > user
> > > >> based on who the approver should be.
> > > >>
> > > >> This is what i have setup.
> > > >>
> > > >> Method Directive setup on PO.Update Pre-Processing
> > > >>
> > > >> Condition: the POHeader.Approve field of the changed row is equel
> > > >> to
> > the
> > > >> True expression
> > > >>
> > > >> Action: send email synchronously based on the EmailPOApprover
> > > >> template
> > > >>
> > > >> How can I get this to send to the approver email address of the PO?
> > > >>
> > > >> [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/.
> (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
>