BPM Help Blank Title 73304

We shoot anyone caught with excess inventory on the spot.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[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]
Sent: Thursday, June 19, 2014 3:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM Help



I know you didn't ask, but you are just trading one problem for another. If they over-produce and can't report it you will end up with excess inventory that you don't know about. I find it easier to a) train them to key correctly and b) monitor the negative stock status report and job completion exceptions to find and correct key errors.
Georgia



[Non-text portions of this message have been removed]
I need to write a BPM to stop shipping from being able to cut a packing
slip for Sales Orders that are on HOLD. Although the SO shows up as on
hold when shipping brings it up there is no warning message or anything
before the packing slip is cut.



When cutting a packing slip I want shipping to get a message saying they
have to contact Customer Service to have the Hold removed before they
can proceed.



I would appreciate any assistance, I would think that someone has
already done this.



Thanks!



Paul E. Pachniak

Accounting Manager

Ace Precision Machining Corporation

W146 N5714 Enterprise Avenue

Menomonee Falls, WI 53051

Phone: 262-252-4003 Ext. 1114

Fax: 262-252-4974

Email: paul.pachniak@...

WWW: http://www.aceprecision.com





NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL INFORMATION OF ACE PRECISION MACHINING CORP. If you are an unintended recipient, immediately (1) delete all copies of this message and any attachments, and (2) contact the sender. If you are an intended recipient, you are prohibited from deleting or obstructing this or any other Ace Precision Machining Corp. proprietary or confidentiality designation that appears on this message or any attachments. All recipients are prohibited from reproducing, publishing or disclosing the contents of this message and any attachments to others, unless you first request and receive written permission from Ace Precision Machining Corp.

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

Add a Pre-processing directive against the CustShip.Update BO.

Add a condition: number of rows in the <query> is equal to 1.
The query is:
for each ttShipHead, each OrderHed where ttShipHead.Company =
OrderHed.Company and ttShipHead.OrderNum = OrderHed.OrderNum and
OrderHed.OrderHeld = true no-lock

Then add an action: raise an exception based on the <template>. Enter
whatever message you like in the template.

As always, there's possibly a more elegent way of doing it, but the
above works for me. There is a field "OrderHold" in the ttShipHead
table which could be used for a much simpler condition but this field
doesn't seem to relate to the OrderHead.OrderHeld field.


HTH,

Nigel.



--- In vantage@yahoogroups.com, "Paul Pachniak" <paul.pachniak@...>
wrote:
>
>
> I need to write a BPM to stop shipping from being able to cut a
packing
> slip for Sales Orders that are on HOLD. Although the SO shows up
as on
> hold when shipping brings it up there is no warning message or
anything
> before the packing slip is cut.
>
>
>
> When cutting a packing slip I want shipping to get a message saying
they
> have to contact Customer Service to have the Hold removed before
they
> can proceed.
>
>
>
> I would appreciate any assistance, I would think that someone has
> already done this.
>
>
>
> Thanks!
>
>
>
> Paul E. Pachniak
>
> Accounting Manager
>
> Ace Precision Machining Corporation
>
> W146 N5714 Enterprise Avenue
>
> Menomonee Falls, WI 53051
>
> Phone: 262-252-4003 Ext. 1114
>
> Fax: 262-252-4974
>
> Email: paul.pachniak@...
>
> WWW: http://www.aceprecision.com
>
>
>
>
>
> NOTICE: THIS MESSAGE CONTAINS THE PROPRIETARY AND CONFIDENTIAL
INFORMATION OF ACE PRECISION MACHINING CORP. If you are an
unintended recipient, immediately (1) delete all copies of this
message and any attachments, and (2) contact the sender. If you are
an intended recipient, you are prohibited from deleting or
obstructing this or any other Ace Precision Machining Corp.
proprietary or confidentiality designation that appears on this
message or any attachments. All recipients are prohibited from
reproducing, publishing or disclosing the contents of this message
and any attachments to others, unless you first request and receive
written permission from Ace Precision Machining Corp.
>
> [Non-text portions of this message have been removed]
>
We're in the process of deploying Epicor 9.04.504B at our company. A bit bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to Character10. That all works fine. Next, I'd like to pull that Character10 field into the Description for Quote Line Detail when a part number is added or changed.

I've tried a number of things including a Method Directive for ChangePartNum.Quote. I just can't seem to get the Description field to change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements





[Non-text portions of this message have been removed]
Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked


for each ttQuoteDtl where (ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.


-----Original Message----- .
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@yahoogroups.com> vantage@yahoogroups.com
Subject: [Vantage] BPM Help




We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum.Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

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







[Non-text portions of this message have been removed]
Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company". (247)
** D:\EPICOR904\EPICORWORK\17954151171141992022521586190841881696219.p Line 10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@




________________________________
From: "advantage@..." <advantage@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help


Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked


for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.


-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]
nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Help




Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company". (247)
** D:\EPICOR904\EPICORWORK\17954151171141992022521586190841881696219.p Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

________________________________
From: "advantage@wcoil. <mailto:advantage%40wcoil.com> com"
<advantage@wcoil. <mailto:advantage%40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]







[Non-text portions of this message have been removed]
Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@




________________________________
From: "advantage@..." <advantage@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help


nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

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







[Non-text portions of this message have been removed]
I amnot ABL/4Gl savvy either; have just learned as a power user. I uploaded
the BPM on the site. Don't know why you would be getting the error? Check
it out Let me know

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Help




Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

________________________________
From: "advantage@wcoil. <mailto:advantage%40wcoil.com> com"
<advantage@wcoil. <mailto:advantage%40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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]
I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@




________________________________
From: "advantage@..." <advantage@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help


nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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
that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.

mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM Help




I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

________________________________
From: "advantage@wcoil. <mailto:advantage%40wcoil.com> com"
<advantage@wcoil. <mailto:advantage%40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups.yahoo.com/group/vantage/files/.>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links







[Non-text portions of this message have been removed]
I think you need to specify the Parts table before using the fields.



I use code similar to this on the Quote form, copying
Parts.PartsPerContainer to QuoteDtl.Number01. My code is as follows:



for each ttQuoteDtl where ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A'
no-lock,

each Part where Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.



ttQuoteDtl.Number01= Part.PartsPerContainer.



End.











From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage@...
Sent: Tuesday, September 29, 2009 2:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM Help





that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.

mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BPM Help

I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

________________________________
From: "advantage@wcoil. <mailto:advantage%40wcoil.com> com"
<advantage@wcoil. <mailto:advantage%40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/> >
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

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





[Non-text portions of this message have been removed]
The BPM that works is in the BPM folder on the Vantage Yahoo User's Group
files...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Gerry Loranger
Sent: Tuesday, September 29, 2009 3:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM Help




I think you need to specify the Parts table before using the fields.

I use code similar to this on the Quote form, copying
Parts.PartsPerContainer to QuoteDtl.Number01. My code is as follows:

for each ttQuoteDtl where ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A'
no-lock,

each Part where Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.

ttQuoteDtl.Number01= Part.PartsPerContainer.

End.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
advantage@wcoil. <mailto:advantage%40wcoil.com> com
Sent: Tuesday, September 29, 2009 2:13 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BPM Help

that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.

mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BPM Help

I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

________________________________
From: "advantage@wcoil. <mailto:advantage%40wcoil.com> com"
<advantage@wcoil. <mailto:advantage%40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups. <http://groups.yahoo.com/group/vantage/files/.>
yahoo.com/group/vantage/files/.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/> >
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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]
Thank you all for your help. I'm mostly where I'd like to be. The part description on the quote line detail is 'updating' from character10...when I hit Save. I'd like it to change as soon as I tab out of the Part Number field.

I ran a trace and I do see ChangePartNum getting called. No matter what I do, I can't seem to get the part description field to change (except when I hit Save).

How do I verify that a BPM is executing? Is there a way to pop up a message box? Some other way to "debug" ABL? Are "A" and "U" the only valid fields for RowMod?

TIA,
@






________________________________
From: "advantage@..." <advantage@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 29, 2009 3:28:16 PM
Subject: RE: [Vantage] BPM Help


The BPM that works is in the BPM folder on the Vantage Yahoo User's Group
files...


-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Gerry Loranger
Sent: Tuesday, September 29, 2009 3:17 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BPM Help

I think you need to specify the Parts table before using the fields.

I use code similar to this on the Quote form, copying
Parts.PartsPerConta iner to QuoteDtl.Number01. My code is as follows:

for each ttQuoteDtl where ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A'
no-lock,

each Part where Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.

ttQuoteDtl.Number01 = Part.PartsPerContai ner.

End.

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
advantage@wcoil. <mailto:advantage% 40wcoil.com> com
Sent: Tuesday, September 29, 2009 2:13 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: RE: [Vantage] BPM Help

that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.

mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BPM Help

I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich% 40advancedphoton ix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/.>
yahoo.com/group/ vantage/files/ .
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/>
yahoo.com/group/ vantage/files/ > >
yahoo.com/group/ vantage/files/ .
(2) To search through old msg's goto: http://groups.
<http://groups. <http://groups. yahoo.com/ group/vantage/ messages>
yahoo.com/group/ vantage/messages >
yahoo.com/group/ vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. yahoo.com/ group/vantage/ linksYahoo>
yahoo.com/group/ vantage/linksYah oo>
yahoo.com/group/ vantage/linksYah oo! Groups Links

[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]







[Non-text portions of this message have been removed]
Yes execute an informational message on pre and post processing and use he
field query (right Click field query) in the message box to to see what
fields are getting hit.


On ChangePartNum you might want to try that code on PostProcessing


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 4:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Help




Thank you all for your help. I'm mostly where I'd like to be. The part
description on the quote line detail is 'updating' from character10...when I
hit Save. I'd like it to change as soon as I tab out of the Part Number
field.

I ran a trace and I do see ChangePartNum getting called. No matter what I
do, I can't seem to get the part description field to change (except when I
hit Save).

How do I verify that a BPM is executing? Is there a way to pop up a message
box? Some other way to "debug" ABL? Are "A" and "U" the only valid fields
for RowMod?

TIA,
@

________________________________
From: "advantage@wcoil. <mailto:advantage%40wcoil.com> com"
<advantage@wcoil. <mailto:advantage%40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, September 29, 2009 3:28:16 PM
Subject: RE: [Vantage] BPM Help

The BPM that works is in the BPM folder on the Vantage Yahoo User's Group
files...

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Gerry Loranger
Sent: Tuesday, September 29, 2009 3:17 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BPM Help

I think you need to specify the Parts table before using the fields.

I use code similar to this on the Quote form, copying
Parts.PartsPerConta iner to QuoteDtl.Number01. My code is as follows:

for each ttQuoteDtl where ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A'
no-lock,

each Part where Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.

ttQuoteDtl.Number01 = Part.PartsPerContai ner.

End.

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
advantage@wcoil. <mailto:advantage% 40wcoil.com> com
Sent: Tuesday, September 29, 2009 2:13 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: RE: [Vantage] BPM Help

that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.

mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BPM Help

I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich% 40advancedphoton ix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/.>
yahoo.com/group/ vantage/files/ .
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/>
yahoo.com/group/ vantage/files/ > >
yahoo.com/group/ vantage/files/ .
(2) To search through old msg's goto: http://groups.
<http://groups. <http://groups. yahoo.com/ group/vantage/ messages>
yahoo.com/group/ vantage/messages >
yahoo.com/group/ vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. yahoo.com/ group/vantage/ linksYahoo>
yahoo.com/group/ vantage/linksYah oo>
yahoo.com/group/ vantage/linksYah oo! Groups Links

[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]

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







[Non-text portions of this message have been removed]
That's what you're going to get with a BPM.

That's part of the semi-SOA approach of Vantage. The client and server are somewhat loosely-coupled. The client does a bunch of stuff locally and then when you hit save sends a big bundle of data back to the server for processing. I wouldn't expect that BPM to fire just by tabbing out of a field unless the client is wired to call Quote.Update() when that happens.

To accomplish this you would need to add an event handler as a client-side customization where you'd call Quote.Update() when you lost the field focus. I find this part of Vantage customization to be even more opaque than 4GL but maybe that's just me.

You could also write an event handler on the client that captured the field-lost-focus event, and constructed a PartAdapter connection to get the PartDataSet containing the field you want and modify the client-side DataView. Maybe someone here would post a similar example. I understand the theory but we lack a cookbook for this stuff.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 4:58 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Help

Thank you all for your help. I'm mostly where I'd like to be. The part description on the quote line detail is 'updating' from character10...when I hit Save. I'd like it to change as soon as I tab out of the Part Number field.

I ran a trace and I do see ChangePartNum getting called. No matter what I do, I can't seem to get the part description field to change (except when I hit Save).

How do I verify that a BPM is executing? Is there a way to pop up a message box? Some other way to "debug" ABL? Are "A" and "U" the only valid fields for RowMod?

TIA,
@






________________________________
From: "advantage@..." <advantage@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 29, 2009 3:28:16 PM
Subject: RE: [Vantage] BPM Help


The BPM that works is in the BPM folder on the Vantage Yahoo User's Group
files...


-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Gerry Loranger
Sent: Tuesday, September 29, 2009 3:17 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BPM Help

I think you need to specify the Parts table before using the fields.

I use code similar to this on the Quote form, copying
Parts.PartsPerConta iner to QuoteDtl.Number01. My code is as follows:

for each ttQuoteDtl where ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A'
no-lock,

each Part where Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.

ttQuoteDtl.Number01 = Part.PartsPerContai ner.

End.

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
advantage@wcoil. <mailto:advantage% 40wcoil.com> com
Sent: Tuesday, September 29, 2009 2:13 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: RE: [Vantage] BPM Help

that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.

mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BPM Help

I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich% 40advancedphoton ix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/.>
yahoo.com/group/ vantage/files/ .
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/>
yahoo.com/group/ vantage/files/ > >
yahoo.com/group/ vantage/files/ .
(2) To search through old msg's goto: http://groups.
<http://groups. <http://groups. yahoo.com/ group/vantage/ messages>
yahoo.com/group/ vantage/messages >
yahoo.com/group/ vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. yahoo.com/ group/vantage/ linksYahoo>
yahoo.com/group/ vantage/linksYah oo>
yahoo.com/group/ vantage/linksYah oo! Groups Links

[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]







[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
Based on the input from you and Brian, I've got it working. A few well placed if statements and everything is cool.

Thank you very much for your time and attention.

@




________________________________
From: "advantage@..." <advantage@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 29, 2009 5:02:22 PM
Subject: RE: [Vantage] BPM Help


Yes execute an informational message on pre and post processing and use he
field query (right Click field query) in the message box to to see what
fields are getting hit.

On ChangePartNum you might want to try that code on PostProcessing


-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 4:58 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thank you all for your help. I'm mostly where I'd like to be. The part
description on the quote line detail is 'updating' from character10. ..when I
hit Save. I'd like it to change as soon as I tab out of the Part Number
field.

I ran a trace and I do see ChangePartNum getting called. No matter what I
do, I can't seem to get the part description field to change (except when I
hit Save).

How do I verify that a BPM is executing? Is there a way to pop up a message
box? Some other way to "debug" ABL? Are "A" and "U" the only valid fields
for RowMod?

TIA,
@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 3:28:16 PM
Subject: RE: [Vantage] BPM Help

The BPM that works is in the BPM folder on the Vantage Yahoo User's Group
files...

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Gerry Loranger
Sent: Tuesday, September 29, 2009 3:17 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BPM Help

I think you need to specify the Parts table before using the fields.

I use code similar to this on the Quote form, copying
Parts.PartsPerConta iner to QuoteDtl.Number01. My code is as follows:

for each ttQuoteDtl where ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A'
no-lock,

each Part where Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.

ttQuoteDtl.Number01 = Part.PartsPerContai ner.

End.

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
advantage@wcoil. <mailto:advantage% 40wcoil.com> com
Sent: Tuesday, September 29, 2009 2:13 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: RE: [Vantage] BPM Help

that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.

mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BPM Help

I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich% 40advancedphoton ix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/.>
yahoo.com/group/ vantage/files/ .
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/>
yahoo.com/group/ vantage/files/ > >
yahoo.com/group/ vantage/files/ .
(2) To search through old msg's goto: http://groups.
<http://groups. <http://groups. yahoo.com/ group/vantage/ messages>
yahoo.com/group/ vantage/messages >
yahoo.com/group/ vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. yahoo.com/ group/vantage/ linksYahoo>
yahoo.com/group/ vantage/linksYah oo>
yahoo.com/group/ vantage/linksYah oo! Groups Links

[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]

[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]
Did you get it to fire on changepartnum? I d like to see that
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Aaron M Clements <aaronmclements@...>

Date: Wed, 30 Sep 2009 06:59:51
To: <vantage@yahoogroups.com>
Subject: Re: [Vantage] BPM Help


Based on the input from you and Brian, I've got it working. A few well placed if statements and everything is cool.

Thank you very much for your time and attention.

@




________________________________
From: "advantage@..." <advantage@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 29, 2009 5:02:22 PM
Subject: RE: [Vantage] BPM Help


Yes execute an informational message on pre and post processing and use he
field query (right Click field query) in the message box to to see what
fields are getting hit.

On ChangePartNum you might want to try that code on PostProcessing


-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 4:58 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thank you all for your help. I'm mostly where I'd like to be. The part
description on the quote line detail is 'updating' from character10. ..when I
hit Save. I'd like it to change as soon as I tab out of the Part Number
field.

I ran a trace and I do see ChangePartNum getting called. No matter what I
do, I can't seem to get the part description field to change (except when I
hit Save).

How do I verify that a BPM is executing? Is there a way to pop up a message
box? Some other way to "debug" ABL? Are "A" and "U" the only valid fields
for RowMod?

TIA,
@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 3:28:16 PM
Subject: RE: [Vantage] BPM Help

The BPM that works is in the BPM folder on the Vantage Yahoo User's Group
files...

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Gerry Loranger
Sent: Tuesday, September 29, 2009 3:17 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BPM Help

I think you need to specify the Parts table before using the fields.

I use code similar to this on the Quote form, copying
Parts.PartsPerConta iner to QuoteDtl.Number01. My code is as follows:

for each ttQuoteDtl where ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A'
no-lock,

each Part where Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.

ttQuoteDtl.Number01 = Part.PartsPerContai ner.

End.

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
advantage@wcoil. <mailto:advantage% 40wcoil.com> com
Sent: Tuesday, September 29, 2009 2:13 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: RE: [Vantage] BPM Help

that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.

mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BPM Help

I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.



Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich% 40advancedphoton ix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it
worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added
or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/.>
yahoo.com/group/ vantage/files/ .
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/>
yahoo.com/group/ vantage/files/ > >
yahoo.com/group/ vantage/files/ .
(2) To search through old msg's goto: http://groups.
<http://groups. <http://groups. yahoo.com/ group/vantage/ messages>
yahoo.com/group/ vantage/messages >
yahoo.com/group/ vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. yahoo.com/ group/vantage/ linksYahoo>
yahoo.com/group/ vantage/linksYah oo>
yahoo.com/group/ vantage/linksYah oo! Groups Links

[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]

[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]




[Non-text portions of this message have been removed]
No. I triggered off of Quote.Update with the following code:

for each ttQuoteDtl, each Part where (ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and Part.PartNum = ttQuoteDtl.PartNum no-lock.

if ttQuoteDtl.LineDesc = Part.PartDescription then do:
if Part.Character10 <> "" then do:
ttQuoteDtl.LineDesc = Part.Character10.
End.
End.

End.


I've presented the solution to Sales and they love it. It carries through to Sales Orders and printed forms (thank God, I don't have to modify the Crystal).

@


________________________________
From: "advantage@..." <advantage@...>
To: vantage@yahoogroups.com
Sent: Wednesday, September 30, 2009 10:21:02 AM
Subject: Re: [Vantage] BPM Help


Did you get it to fire on changepartnum? I d like to see that
Sent from my Verizon Wireless BlackBerry

___




[Non-text portions of this message have been removed]
You can add a pop up message box using PublishInfoMsg. Here is an example:



{lib/PublishInfoMsg.i &InfoMsg = "'This is my message'"}.



Gerry


-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 4:58 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thank you all for your help. I'm mostly where I'd like to be. The part
description on the quote line detail is 'updating' from character10. ..when
I
hit Save. I'd like it to change as soon as I tab out of the Part Number
field.

I ran a trace and I do see ChangePartNum getting called. No matter what I
do, I can't seem to get the part description field to change (except when I
hit Save).

How do I verify that a BPM is executing? Is there a way to pop up a message
box? Some other way to "debug" ABL? Are "A" and "U" the only valid fields
for RowMod?

TIA,
@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 3:28:16 PM
Subject: RE: [Vantage] BPM Help

The BPM that works is in the BPM folder on the Vantage Yahoo User's Group
files...

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Gerry Loranger
Sent: Tuesday, September 29, 2009 3:17 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] BPM Help

I think you need to specify the Parts table before using the fields.

I use code similar to this on the Quote form, copying
Parts.PartsPerConta iner to QuoteDtl.Number01. My code is as follows:

for each ttQuoteDtl where ttQuoteDtl.RowMod = 'U' or ttQuoteDtl.RowMod = 'A'

no-lock,

each Part where Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.

ttQuoteDtl.Number01 = Part.PartsPerContai ner.

End.

From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of
advantage@wcoil. <mailto:advantage% 40wcoil.com> com
Sent: Tuesday, September 29, 2009 2:13 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: RE: [Vantage] BPM Help

that's what I said, oops, I typed it wrong in this email...each instead of
and...it is right in the BPM I put out on Vantage Yahoo User's Groups Files.


mine:
for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

yours, Brian....
for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, September 29, 2009 2:08 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
<mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] BPM Help

I would think the 4GL statement would be:

for each ttQuoteDtl, each Part where (ttQuoteDtl. RowMod = 'U' or
ttQuoteDtl.RowMod = 'A') and Part.Company = ttQuoteDtl.Company and
Part.PartNum = ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich% 40advancedphoton ix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
[mailto:vantage@ yahoogroups <mailto:vantage% 40yahoogroups. com> .com] On
Behalf Of Aaron M Clements
Sent: Tuesday, September 29, 2009 1:51 PM
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Subject: Re: [Vantage] BPM Help

Ah! That's excellent. I just assumed I needed a condition. Nice, thank you.

Unfortunately, I'm getting the same error. Something after Part.Company
isn't good. It looks good to me, but I'm not ABL/4GL savvy.

I'll add that to my list of things to get smart on.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 1:37:08 PM
Subject: RE: [Vantage] BPM Help

nope no condition; just Action and I just clicked on the Advanced button;
and keyed in the code

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 1:30 PM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] BPM Help

Thanks for your attention. Let's see if I'm on the right track...

Method directive -> Quote.Update (Makes sense vs. ChangePartNum, thank you)

PreProcessing
Condition -> There is at least one updated row in the ttQuoteDtl table
Action -> Synchronously execute ABL code record nothing

Add your snippet from below.

Doing the above, I get the following error when I try to validate the code:
** Unable to understand after -- "Part.Company" . (247)
** D:\EPICOR904\ EPICORWORK\ 1795415117114199 2022521586190841 881696219. p
Line
10 --Invalid FOR, DO, REPEAT, or EDITING statement. (194)

Thanks again. I do appreciate your time.

@

____________ _________ _________ __
From: "advantage@wcoil. <mailto:advantage% 40wcoil.com> com"
<advantage@wcoil. <mailto:advantage% 40wcoil.com> com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Tuesday, September 29, 2009 12:56:09 PM
Subject: RE: [Vantage] BPM Help

Creating the BPM on the BO ChangePartNumQuote indicates that you need to
CHANGE the part number to get the Part.Character01 to dump into the
QuoteDtl.LineDesc field

Quite simply, I just did it on a PreProcessing Action on Quote.Update and it

worked

for each ttQuoteDtl where (ttQuoteDtl. RowMod = 'U' or ttQuoteDtl.RowMod =
'A'), each Part.Company = ttQuoteDtl.Company and Part.PartNum =
ttQuoteDtl.PartNum no-lock.
ttQuoteDtl.LineDesc = Part.Character10.
End.

-----Original Message----- .
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of
Aaron M Clements
Sent: Tuesday, September 29, 2009 11:58 AM
To: <mailto:vantage@ yahoogroups .com> vantage@yahoogroups .com
Subject: [Vantage] BPM Help

We're in the process of deploying Epicor 9.04.504B at our company. A bit
bumpy but overall going well.

In Part I've put a customization for a 'Sales Description' and bound it to
Character10. That all works fine. Next, I'd like to pull that Character10
field into the Description for Quote Line Detail when a part number is added

or changed.

I've tried a number of things including a Method Directive for
ChangePartNum. Quote. I just can't seem to get the Description field to
change.

We're all new to Epicor here, so speak slowly. ;-)

Aaron Clements

[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]

[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.
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/.>
yahoo.com/group/ vantage/files/ .
<http://groups. <http://groups. yahoo.com/ group/vantage/ files/>
yahoo.com/group/ vantage/files/ > >
yahoo.com/group/ vantage/files/ .
(2) To search through old msg's goto: http://groups.
<http://groups. <http://groups. yahoo.com/ group/vantage/ messages>
yahoo.com/group/ vantage/messages >
yahoo.com/group/ vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. yahoo.com/ group/vantage/ linksYahoo>
yahoo.com/group/ vantage/linksYah oo>
yahoo.com/group/ vantage/linksYah oo! Groups Links

[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]

[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]



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





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