BPM: Updating OrderDtl requires refresh in Order Entry

Yahoo Archive
1
I tried to do it on the preprocessing but the UI was throwing the
"modified by other user" message right away.

I moved it to a postprocessing directive and now it doesn't throw the
message until the next update is triggered.



My code is directly updating OrderDtl because the update on the UI is
taking place on OrderHed and it appears that the BPM's dataset does not
contain rows in ttOrderDtl unless there are changed rows.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kevin Simon
Sent: Monday, May 09, 2011 6:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM: Updating OrderDtl requires refresh in Order
Entry





Joe,

I assume by "does not always contain the rows for OrderDtl and
OrderRel",
you mean that the "tt" rows are not there. Since you're updating the
"ttOrderDtl", could you have code in the preprocessing that does this:

For each ttOrderDtl where ttOrderDtl.RowMod = "U" and (Whatever
conditions
you specify):

For each OrderRel where OrderRel.company = ... (get the orderrel for
the orderdtl, note that this is not ttOrderRel)

(process your updates to each OrderRel)

End.

(process your updates to ttOrderDtl)

End.

I wonder if that would work. Since it's preprocessing, after the base
updates OrderDtl from the ttOrderDtl changes you made, I believe it will
send back the updated OrderRel as part of the dataset it returns.

I'm not positive this will work, but it seems like it should. It's worth
testing.

Kevin

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Joe Rojas
Sent: Monday, May 09, 2011 11:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BPM: Updating OrderDtl requires refresh in Order
Entry

Thanks Jose.
The problem with doing it in the pre-processing is that the Sales Order
dataset does not always contain the rows for OrderDtl and OrderRel.
I think in one of Epicor's attempts to speed up Order Entry they
conditionally send the line information.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the
named addressee you should not disseminate, distribute or copy this
e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in
this
email are solely those of the author and do not necessarily represent
those
of the company.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----


From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Jose Gomez
Sent: Monday, May 09, 2011 11:06 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BPM: Updating OrderDtl requires refresh in Order
Entry

If you are doing this in post processing you'll get this problem. Do it
in pre-processing.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
<mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*

On Mon, May 9, 2011 at 10:50 AM, Joe Rojas <jrojas@...
<mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> > wrote:

>
>
> Hello,
>
> I have a BPM that sets the value on every line of a Sales Order if a
> value changes on the order header.
>
> The BPM works correctly but each time it triggers, it requires the
> user to refresh the sales order in Order Entry or else they will get
> the "Record modified by other user" error if they make another change
> to the order.
>
> I understand why this happens but I was wondering if anyone found a
> way to handle it or is it just a matter of training users to hit
refresh?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and

> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not

> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
>
>

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

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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




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



I have a BPM that sets the value on every line of a Sales Order if a
value changes on the order header.

The BPM works correctly but each time it triggers, it requires the user
to refresh the sales order in Order Entry or else they will get the
"Record modified by other user" error if they make another change to the
order.



I understand why this happens but I was wondering if anyone found a way
to handle it or is it just a matter of training users to hit refresh?










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
Do u have any customization like epidataview on orderdtl or ordered table?

Sent from my iPhone

On 2011-05-09, at 10:50 AM, Joe Rojas <jrojas@...> wrote:

> Hello,
>
> I have a BPM that sets the value on every line of a Sales Order if a
> value changes on the order header.
>
> The BPM works correctly but each time it triggers, it requires the user
> to refresh the sales order in Order Entry or else they will get the
> "Record modified by other user" error if they make another change to the
> order.
>
> I understand why this happens but I was wondering if anyone found a way
> to handle it or is it just a matter of training users to hit refresh?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
>


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

I have an epidataview for orderhed, orderdtl, and orderrel.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of anithayedavalli@...
Sent: Monday, May 09, 2011 10:53 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM: Updating OrderDtl requires refresh in Order Entry





Do u have any customization like epidataview on orderdtl or ordered table?

Sent from my iPhone

On 2011-05-09, at 10:50 AM, Joe Rojas <jrojas@... <mailto:jrojas%40matsinc.com> > wrote:

> Hello,
>
> I have a BPM that sets the value on every line of a Sales Order if a
> value changes on the order header.
>
> The BPM works correctly but each time it triggers, it requires the user
> to refresh the sales order in Order Entry or else they will get the
> "Record modified by other user" error if they make another change to the
> order.
>
> I understand why this happens but I was wondering if anyone found a way
> to handle it or is it just a matter of training users to hit refresh?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
>

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












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
5
If you are doing this in post processing you'll get this problem. Do it in
pre-processing.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Mon, May 9, 2011 at 10:50 AM, Joe Rojas <jrojas@...> wrote:

>
>
> Hello,
>
> I have a BPM that sets the value on every line of a Sales Order if a
> value changes on the order header.
>
> The BPM works correctly but each time it triggers, it requires the user
> to refresh the sales order in Order Entry or else they will get the
> "Record modified by other user" error if they make another change to the
> order.
>
> I understand why this happens but I was wondering if anyone found a way
> to handle it or is it just a matter of training users to hit refresh?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not the
> named addressee you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake. Please note that any views or opinions presented in this
> email are solely those of the author and do not necessarily represent those
> of the company.
>
> [Non-text portions of this message have been removed]
>
>
>


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



I've usually handled this type of situation by capturing in the UI code when
I know the BPM will trigger, allowing the BPM to do its thing, then issuing
a oTrans.Refresh() from the code in the AfterUpdate adapter.



Kevin



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Monday, May 09, 2011 10:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM: Updating OrderDtl requires refresh in Order Entry





Hello,

I have a BPM that sets the value on every line of a Sales Order if a
value changes on the order header.

The BPM works correctly but each time it triggers, it requires the user
to refresh the sales order in Order Entry or else they will get the
"Record modified by other user" error if they make another change to the
order.

I understand why this happens but I was wondering if anyone found a way
to handle it or is it just a matter of training users to hit refresh?







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent those
of the company.

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





[Non-text portions of this message have been removed]
7
Thanks Kevin.

I might try that. My only hesitation is that we have a lot of customized
code for order entry (as you know) that is triggered on EpiViewNotify
events.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kevin Simon
Sent: Monday, May 09, 2011 11:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM: Updating OrderDtl requires refresh in Order
Entry





Joe,

I've usually handled this type of situation by capturing in the UI code
when
I know the BPM will trigger, allowing the BPM to do its thing, then
issuing
a oTrans.Refresh() from the code in the AfterUpdate adapter.

Kevin

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Joe Rojas
Sent: Monday, May 09, 2011 10:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BPM: Updating OrderDtl requires refresh in Order
Entry

Hello,

I have a BPM that sets the value on every line of a Sales Order if a
value changes on the order header.

The BPM works correctly but each time it triggers, it requires the user
to refresh the sales order in Order Entry or else they will get the
"Record modified by other user" error if they make another change to the
order.

I understand why this happens but I was wondering if anyone found a way
to handle it or is it just a matter of training users to hit refresh?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the
named addressee you should not disseminate, distribute or copy this
e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in
this
email are solely those of the author and do not necessarily represent
those
of the company.

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

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












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
8
Thanks Jose.
The problem with doing it in the pre-processing is that the Sales Order
dataset does not always contain the rows for OrderDtl and OrderRel.
I think in one of Epicor's attempts to speed up Order Entry they
conditionally send the line information.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Monday, May 09, 2011 11:06 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM: Updating OrderDtl requires refresh in Order
Entry

If you are doing this in post processing you'll get this problem. Do it
in pre-processing.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Mon, May 9, 2011 at 10:50 AM, Joe Rojas <jrojas@...> wrote:

>
>
> Hello,
>
> I have a BPM that sets the value on every line of a Sales Order if a
> value changes on the order header.
>
> The BPM works correctly but each time it triggers, it requires the
> user to refresh the sales order in Order Entry or else they will get
> the "Record modified by other user" error if they make another change
> to the order.
>
> I understand why this happens but I was wondering if anyone found a
> way to handle it or is it just a matter of training users to hit
refresh?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and

> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not

> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [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
9
Joe,



I assume by "does not always contain the rows for OrderDtl and OrderRel",
you mean that the "tt" rows are not there. Since you're updating the
"ttOrderDtl", could you have code in the preprocessing that does this:



For each ttOrderDtl where ttOrderDtl.RowMod = "U" and (Whatever conditions
you specify):

For each OrderRel where OrderRel.company = ... (get the orderrel for
the orderdtl, note that this is not ttOrderRel)

(process your updates to each OrderRel)

End.

(process your updates to ttOrderDtl)

End.



I wonder if that would work. Since it's preprocessing, after the base
updates OrderDtl from the ttOrderDtl changes you made, I believe it will
send back the updated OrderRel as part of the dataset it returns.



I'm not positive this will work, but it seems like it should. It's worth
testing.



Kevin



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Monday, May 09, 2011 11:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM: Updating OrderDtl requires refresh in Order
Entry





Thanks Jose.
The problem with doing it in the pre-processing is that the Sales Order
dataset does not always contain the rows for OrderDtl and OrderRel.
I think in one of Epicor's attempts to speed up Order Entry they
conditionally send the line information.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent those
of the company.

-----Original Message-----

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Jose Gomez
Sent: Monday, May 09, 2011 11:06 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] BPM: Updating OrderDtl requires refresh in Order
Entry

If you are doing this in post processing you'll get this problem. Do it
in pre-processing.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*

On Mon, May 9, 2011 at 10:50 AM, Joe Rojas <jrojas@...
<mailto:jrojas%40matsinc.com> > wrote:

>
>
> Hello,
>
> I have a BPM that sets the value on every line of a Sales Order if a
> value changes on the order header.
>
> The BPM works correctly but each time it triggers, it requires the
> user to refresh the sales order in Order Entry or else they will get
> the "Record modified by other user" error if they make another change
> to the order.
>
> I understand why this happens but I was wondering if anyone found a
> way to handle it or is it just a matter of training users to hit
refresh?
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and

> beautiful matting and flooring
>
> This message is intended only for the individual named. If you are not

> the named addressee you should not disseminate, distribute or copy
this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
>
> [Non-text portions of this message have been removed]
>
>
>

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

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





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