Easiest way would be through a BPM
On OrderUpdate
something like
for each ttOrderDtl where RowMod ='A' or RowMod = 'u'
each Part where Part.PartNum = ttOrderDtl.PartNum and Part.Company =
ttOrderDtl.Company
assign ttOrderDtl.Number01=Part.Number01
*dont' take that query literaly as I wrote it here in my email and its
probably syntactically incorrect but it should give you the idea.
*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 OrderUpdate
something like
for each ttOrderDtl where RowMod ='A' or RowMod = 'u'
each Part where Part.PartNum = ttOrderDtl.PartNum and Part.Company =
ttOrderDtl.Company
assign ttOrderDtl.Number01=Part.Number01
*dont' take that query literaly as I wrote it here in my email and its
probably syntactically incorrect but it should give you the idea.
*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 Fri, Apr 1, 2011 at 10:52 AM, Anitha <anithayedavalli@...> wrote:
>
>
> Is there a way in epicor where I can assign number01 of Part table to
> number01 of orderdtl table?
> I want to get all values of part.number01 to orderdtl.number01.
>
>
>
[Non-text portions of this message have been removed]