BPM Problem Blank Title 106246

Yes I use the assign command.


Ephraim Feldman

-----Original Message-----
From: "nustepvantage" <dpfiester@...>
Sender: vantage@yahoogroups.com
Date: Thu, 22 Dec 2011 16:07:46
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Problem

Hi Ephraim,

This may be a dumb question, but what do you mean by a direct update? Do you mean using the Assign command?

Thanks,
David Pfiester


--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> Why is the update table buffer needed at all ?
> I always do a direct update.
>
>
> Ephraim Feldman
>
> -----Original Message-----
> From: Jose Gomez <jose@...>
> Sender: vantage@yahoogroups.com
> Date: Thu, 22 Dec 2011 09:46:19
> To: <vantage@yahoogroups.com>
> Reply-To: vantage@yahoogroups.com
> Subject: Re: [Vantage] BPM Problem
>
> Try move it to Post Proc and see if it helps, also I beleive on 9.05 u
> don't need Update Table Buffer anymore, that may or may not be your issue.
>
> For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
> ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
> OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.
>
> Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.
>
> run lib/UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE,'NeedByDate',
> ttOrderHed.Date06).
>
> End.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Dec 22, 2011 at 9:32 AM, nustepvantage <dpfiester@...> wrote:
>
> > **
> >
> >
> > Hello All,
> >
> > I have a BPM using a pre-processing SalesOrder.Update method in Epicor
> > 9.05 that I need help trouble shooting. When a UDF field is filled in the
> > BPM changes the OrderHed.NeedBydate to the same date as in the UDF and also
> > changes the OrderDtl.NeedByDate in all sales order lines. Below is my code:
> >
> > For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
> > ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
> > OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.
> >
> > Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.
> >
> > run lib/UpdateTableBuffer.p(input BUFFER
> > OrderDtl:HANDLE,'NeedByDate',ttOrderHed.Date06).
> >
> > End.
> >
> > When the BPM runs it generates a 'Row has been modified by another user
> > and couldn't be updated." message. The OrderDtl.NeedByDate fields update
> > fine, but the OrderHed.NeedByDate does not. The error detail refrences the
> > table OrderHed. The Row as 0x000000000092b40e, and the Field as SysRevID.
> > Would anyone have an idea on what I am doing wrong in this BPM?
> >
> > Thanks,
> > David Pfiester
> > NuStep, Inc.
> > 734-418-1850
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>





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

I have a BPM using a pre-processing SalesOrder.Update method in Epicor 9.05 that I need help trouble shooting. When a UDF field is filled in the BPM changes the OrderHed.NeedBydate to the same date as in the UDF and also changes the OrderDtl.NeedByDate in all sales order lines. Below is my code:

For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <> ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.

Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.

run lib/UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE,'NeedByDate',ttOrderHed.Date06).

End.

When the BPM runs it generates a 'Row has been modified by another user and couldn't be updated." message. The OrderDtl.NeedByDate fields update fine, but the OrderHed.NeedByDate does not. The error detail refrences the table OrderHed. The Row as 0x000000000092b40e, and the Field as SysRevID. Would anyone have an idea on what I am doing wrong in this BPM?

Thanks,
David Pfiester
NuStep, Inc.
734-418-1850
Try move it to Post Proc and see if it helps, also I beleive on 9.05 u
don't need Update Table Buffer anymore, that may or may not be your issue.

For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.

Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.

run lib/UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE,'NeedByDate',
ttOrderHed.Date06).

End.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Thu, Dec 22, 2011 at 9:32 AM, nustepvantage <dpfiester@...> wrote:

> **
>
>
> Hello All,
>
> I have a BPM using a pre-processing SalesOrder.Update method in Epicor
> 9.05 that I need help trouble shooting. When a UDF field is filled in the
> BPM changes the OrderHed.NeedBydate to the same date as in the UDF and also
> changes the OrderDtl.NeedByDate in all sales order lines. Below is my code:
>
> For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
> ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
> OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.
>
> Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.
>
> run lib/UpdateTableBuffer.p(input BUFFER
> OrderDtl:HANDLE,'NeedByDate',ttOrderHed.Date06).
>
> End.
>
> When the BPM runs it generates a 'Row has been modified by another user
> and couldn't be updated." message. The OrderDtl.NeedByDate fields update
> fine, but the OrderHed.NeedByDate does not. The error detail refrences the
> table OrderHed. The Row as 0x000000000092b40e, and the Field as SysRevID.
> Would anyone have an idea on what I am doing wrong in this BPM?
>
> Thanks,
> David Pfiester
> NuStep, Inc.
> 734-418-1850
>
>
>


[Non-text portions of this message have been removed]
Why is the update table buffer needed at all ?
I always do a direct update.


Ephraim Feldman

-----Original Message-----
From: Jose Gomez <jose@...>
Sender: vantage@yahoogroups.com
Date: Thu, 22 Dec 2011 09:46:19
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Problem

Try move it to Post Proc and see if it helps, also I beleive on 9.05 u
don't need Update Table Buffer anymore, that may or may not be your issue.

For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.

Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.

run lib/UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE,'NeedByDate',
ttOrderHed.Date06).

End.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Thu, Dec 22, 2011 at 9:32 AM, nustepvantage <dpfiester@...> wrote:

> **
>
>
> Hello All,
>
> I have a BPM using a pre-processing SalesOrder.Update method in Epicor
> 9.05 that I need help trouble shooting. When a UDF field is filled in the
> BPM changes the OrderHed.NeedBydate to the same date as in the UDF and also
> changes the OrderDtl.NeedByDate in all sales order lines. Below is my code:
>
> For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
> ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
> OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.
>
> Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.
>
> run lib/UpdateTableBuffer.p(input BUFFER
> OrderDtl:HANDLE,'NeedByDate',ttOrderHed.Date06).
>
> End.
>
> When the BPM runs it generates a 'Row has been modified by another user
> and couldn't be updated." message. The OrderDtl.NeedByDate fields update
> fine, but the OrderHed.NeedByDate does not. The error detail refrences the
> table OrderHed. The Row as 0x000000000092b40e, and the Field as SysRevID.
> Would anyone have an idea on what I am doing wrong in this BPM?
>
> Thanks,
> David Pfiester
> NuStep, Inc.
> 734-418-1850
>
>
>


[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
Hi Ephraim,

This may be a dumb question, but what do you mean by a direct update? Do you mean using the Assign command?

Thanks,
David Pfiester


--- In vantage@yahoogroups.com, effgroups@... wrote:
>
> Why is the update table buffer needed at all ?
> I always do a direct update.
>
>
> Ephraim Feldman
>
> -----Original Message-----
> From: Jose Gomez <jose@...>
> Sender: vantage@yahoogroups.com
> Date: Thu, 22 Dec 2011 09:46:19
> To: <vantage@yahoogroups.com>
> Reply-To: vantage@yahoogroups.com
> Subject: Re: [Vantage] BPM Problem
>
> Try move it to Post Proc and see if it helps, also I beleive on 9.05 u
> don't need Update Table Buffer anymore, that may or may not be your issue.
>
> For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
> ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
> OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.
>
> Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.
>
> run lib/UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE,'NeedByDate',
> ttOrderHed.Date06).
>
> End.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Dec 22, 2011 at 9:32 AM, nustepvantage <dpfiester@...> wrote:
>
> > **
> >
> >
> > Hello All,
> >
> > I have a BPM using a pre-processing SalesOrder.Update method in Epicor
> > 9.05 that I need help trouble shooting. When a UDF field is filled in the
> > BPM changes the OrderHed.NeedBydate to the same date as in the UDF and also
> > changes the OrderDtl.NeedByDate in all sales order lines. Below is my code:
> >
> > For each ttOrderHed Where ttOrderHed.RowMod='U' And ttOrderHed.Date06 <>
> > ?,Each OrderDtl Where OrderDtl.Company = ttOrderHed.Company And
> > OrderDtl.OrderNum = ttOrderHed.OrderNum No-Lock.
> >
> > Assign ttOrderHed.NeedByDate = ttOrderHed.Date06.
> >
> > run lib/UpdateTableBuffer.p(input BUFFER
> > OrderDtl:HANDLE,'NeedByDate',ttOrderHed.Date06).
> >
> > End.
> >
> > When the BPM runs it generates a 'Row has been modified by another user
> > and couldn't be updated." message. The OrderDtl.NeedByDate fields update
> > fine, but the OrderHed.NeedByDate does not. The error detail refrences the
> > table OrderHed. The Row as 0x000000000092b40e, and the Field as SysRevID.
> > Would anyone have an idea on what I am doing wrong in this BPM?
> >
> > Thanks,
> > David Pfiester
> > NuStep, Inc.
> > 734-418-1850
> >
> >
> >
>
>
> [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
>