BPM to pull QuoteHed.QuoteComment field intoOrderHed.OrderCommen

Yahoo Archive
1
I am also interested in this feature and we have a couple users complaining
about this problem. I put this code in and a post processing directive and
it didn't do anything. Didn't seem to get any errors or anything, just
nothing happened.


-----Original Message-----
From: Waffqle <waffqle@... <mailto:waffqle%40gmail.com> >
Sender: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Wed, 9 Mar 2011 11:06:31
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Reply-To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: BPM to pull QuoteHed.QuoteComment field into
OrderHed.OrderComment filed Vantage

FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
Run lib/UpdateTableBuffer.p(input BUFFER OrderHed:HANDLE, `OrderComment',
ttQuoteHed.QuoteComment).
END.

That should do the trick. If it fails, let me know what it gives you and
we'll see what we can figure out.

On Wed, Mar 9, 2011 at 10:54 AM, Richard <rgraf@...
<mailto:rgraf%40abapgt.com> > wrote:

>
>
> Thanks Waffqle. With help I'll get this figured out.
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Waffqle <waffqle@...> wrote:
> >
> > You're going to need some ABL code for this, but nothing complicated.
> > Try the following as a post processing directive on Quote.CreateOrder.
> >
> > FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
> > ASSIGN OrderHed.OrderComment = ttQuoteHed.QuoteComment.
> > END.
> >
> >
> >
> > On Tue, Mar 8, 2011 at 4:26 PM, Richard <rgraf@...> wrote:
> >
> > >
> > >
> > > Hi Folks,
> > >
> > > I'm trying to write my first BPM is to pull text from the Quote Head
> > > Comment into the Sales Order Head Comment whenever a new sales order
is
> > > created. Being a complete newbie to BPM's I'm not sure how to go about
> it.
> > > The pre-programmed actions don't seem to cover this. It looks like I
> could
> > > set the BPM to put whatever I specify in the comments field when a new
> order
> > > is created but I don't see any way to tell it to get the text from an
> > > existing field.
> > >
> > > Any ideas? Thanks in advance for all suggestions.
> > >
> > > Rick
> > >
> > >
> > >
> >
> >
> > [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]
2
Hi Folks,

I'm trying to write my first BPM is to pull text from the Quote Head Comment into the Sales Order Head Comment whenever a new sales order is created. Being a complete newbie to BPM's I'm not sure how to go about it. The pre-programmed actions don't seem to cover this. It looks like I could set the BPM to put whatever I specify in the comments field when a new order is created but I don't see any way to tell it to get the text from an existing field.

Any ideas? Thanks in advance for all suggestions.

Rick
3
You're going to need some ABL code for this, but nothing complicated.
Try the following as a post processing directive on Quote.CreateOrder.

FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
ASSIGN OrderHed.OrderComment = ttQuoteHed.QuoteComment.
END.



On Tue, Mar 8, 2011 at 4:26 PM, Richard <rgraf@...> wrote:

>
>
> Hi Folks,
>
> I'm trying to write my first BPM is to pull text from the Quote Head
> Comment into the Sales Order Head Comment whenever a new sales order is
> created. Being a complete newbie to BPM's I'm not sure how to go about it.
> The pre-programmed actions don't seem to cover this. It looks like I could
> set the BPM to put whatever I specify in the comments field when a new order
> is created but I don't see any way to tell it to get the text from an
> existing field.
>
> Any ideas? Thanks in advance for all suggestions.
>
> Rick
>
>
>


[Non-text portions of this message have been removed]
4
The "Assign" operator targeting anything other than a Temp Table typically is restricted and will throw errors.

You'll likely need to use the following after your "FOR EACH..." instead:

Run lib\UpdateTableBuffer.p(input BUFFER OrderHed:HANDLE, 'OrderComment', ttQuoteHed.QuoteComment).

**Double check the Table.Field names - I just ran with what was already in the thread here and didn't go back and look to make sure they're accurate.

NB


--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> You're going to need some ABL code for this, but nothing complicated.
> Try the following as a post processing directive on Quote.CreateOrder.
>
> FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
> ASSIGN OrderHed.OrderComment = ttQuoteHed.QuoteComment.
> END.
>
>
>
> On Tue, Mar 8, 2011 at 4:26 PM, Richard <rgraf@...> wrote:
>
> >
> >
> > Hi Folks,
> >
> > I'm trying to write my first BPM is to pull text from the Quote Head
> > Comment into the Sales Order Head Comment whenever a new sales order is
> > created. Being a complete newbie to BPM's I'm not sure how to go about it.
> > The pre-programmed actions don't seem to cover this. It looks like I could
> > set the BPM to put whatever I specify in the comments field when a new order
> > is created but I don't see any way to tell it to get the text from an
> > existing field.
> >
> > Any ideas? Thanks in advance for all suggestions.
> >
> > Rick
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
5
Thanks. I'll give it a try but I want to make sure I understand. Is this the code you're recommending (assuming Table.Fields are accurate)?

FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum. Run lib/UpdateTableBuffer.p(input BUFFER OrderHed:HANDLE, `OrderComment', ttQuoteHed.QuoteComment). END

--- In vantage@yahoogroups.com, "Nathan" <bonner.nathan@...> wrote:
>
>
> The "Assign" operator targeting anything other than a Temp Table typically is restricted and will throw errors.
>
> You'll likely need to use the following after your "FOR EACH..." instead:
>
> Run lib\UpdateTableBuffer.p(input BUFFER OrderHed:HANDLE, 'OrderComment', ttQuoteHed.QuoteComment).
>
> **Double check the Table.Field names - I just ran with what was already in the thread here and didn't go back and look to make sure they're accurate.
>
> NB
>
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> >
> > You're going to need some ABL code for this, but nothing complicated.
> > Try the following as a post processing directive on Quote.CreateOrder.
> >
> > FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
> > ASSIGN OrderHed.OrderComment = ttQuoteHed.QuoteComment.
> > END.
> >
> >
> >
> > On Tue, Mar 8, 2011 at 4:26 PM, Richard <rgraf@> wrote:
> >
> > >
> > >
> > > Hi Folks,
> > >
> > > I'm trying to write my first BPM is to pull text from the Quote Head
> > > Comment into the Sales Order Head Comment whenever a new sales order is
> > > created. Being a complete newbie to BPM's I'm not sure how to go about it.
> > > The pre-programmed actions don't seem to cover this. It looks like I could
> > > set the BPM to put whatever I specify in the comments field when a new order
> > > is created but I don't see any way to tell it to get the text from an
> > > existing field.
> > >
> > > Any ideas? Thanks in advance for all suggestions.
> > >
> > > Rick
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
6
Thanks Waffqle. With help I'll get this figured out.


--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> You're going to need some ABL code for this, but nothing complicated.
> Try the following as a post processing directive on Quote.CreateOrder.
>
> FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
> ASSIGN OrderHed.OrderComment = ttQuoteHed.QuoteComment.
> END.
>
>
>
> On Tue, Mar 8, 2011 at 4:26 PM, Richard <rgraf@...> wrote:
>
> >
> >
> > Hi Folks,
> >
> > I'm trying to write my first BPM is to pull text from the Quote Head
> > Comment into the Sales Order Head Comment whenever a new sales order is
> > created. Being a complete newbie to BPM's I'm not sure how to go about it.
> > The pre-programmed actions don't seem to cover this. It looks like I could
> > set the BPM to put whatever I specify in the comments field when a new order
> > is created but I don't see any way to tell it to get the text from an
> > existing field.
> >
> > Any ideas? Thanks in advance for all suggestions.
> >
> > Rick
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
7
FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
Run lib/UpdateTableBuffer.p(input BUFFER OrderHed:HANDLE, `OrderComment',
ttQuoteHed.QuoteComment).
END.

That should do the trick. If it fails, let me know what it gives you and
we'll see what we can figure out.

On Wed, Mar 9, 2011 at 10:54 AM, Richard <rgraf@...> wrote:

>
>
> Thanks Waffqle. With help I'll get this figured out.
>
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
> >
> > You're going to need some ABL code for this, but nothing complicated.
> > Try the following as a post processing directive on Quote.CreateOrder.
> >
> > FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
> > ASSIGN OrderHed.OrderComment = ttQuoteHed.QuoteComment.
> > END.
> >
> >
> >
> > On Tue, Mar 8, 2011 at 4:26 PM, Richard <rgraf@...> wrote:
> >
> > >
> > >
> > > Hi Folks,
> > >
> > > I'm trying to write my first BPM is to pull text from the Quote Head
> > > Comment into the Sales Order Head Comment whenever a new sales order is
> > > created. Being a complete newbie to BPM's I'm not sure how to go about
> it.
> > > The pre-programmed actions don't seem to cover this. It looks like I
> could
> > > set the BPM to put whatever I specify in the comments field when a new
> order
> > > is created but I don't see any way to tell it to get the text from an
> > > existing field.
> > >
> > > Any ideas? Thanks in advance for all suggestions.
> > >
> > > Rick
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
8
If you still need help let me know.

I have a BPM updating some fields from quote to order entry and it works fine.
You have to make sure to put the code in 2 places since you can create the order from quote entry or from order entry and its 2 different BO calls.

Ephraim.
Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: Waffqle <waffqle@...>
Sender: vantage@yahoogroups.com
Date: Wed, 9 Mar 2011 11:06:31
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BPM to pull QuoteHed.QuoteComment field into
OrderHed.OrderComment filed Vantage

FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
Run lib/UpdateTableBuffer.p(input BUFFER OrderHed:HANDLE, `OrderComment',
ttQuoteHed.QuoteComment).
END.

That should do the trick. If it fails, let me know what it gives you and
we'll see what we can figure out.

On Wed, Mar 9, 2011 at 10:54 AM, Richard <rgraf@...> wrote:

>
>
> Thanks Waffqle. With help I'll get this figured out.
>
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
> >
> > You're going to need some ABL code for this, but nothing complicated.
> > Try the following as a post processing directive on Quote.CreateOrder.
> >
> > FOR EACH OrderHed WHERE OrderHed.OrderNum = orderNum.
> > ASSIGN OrderHed.OrderComment = ttQuoteHed.QuoteComment.
> > END.
> >
> >
> >
> > On Tue, Mar 8, 2011 at 4:26 PM, Richard <rgraf@...> wrote:
> >
> > >
> > >
> > > Hi Folks,
> > >
> > > I'm trying to write my first BPM is to pull text from the Quote Head
> > > Comment into the Sales Order Head Comment whenever a new sales order is
> > > created. Being a complete newbie to BPM's I'm not sure how to go about
> it.
> > > The pre-programmed actions don't seem to cover this. It looks like I
> could
> > > set the BPM to put whatever I specify in the comments field when a new
> order
> > > is created but I don't see any way to tell it to get the text from an
> > > existing field.
> > >
> > > Any ideas? Thanks in advance for all suggestions.
> > >
> > > Rick
> > >
> > >
> > >
> >
> >
> > [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