Epicor 10 BPM Blank Title 139812

Yahoo Archive
1

I knew it was something simple!


thank you sir!

2

I am sure I am missing something really simple.


I am trying to write a BPM on the business object Engineering Workbench.Update, where the BPM goes to look at the PartRev table then depending on the value of a field, it will update the ECORev table.

The field I am trying to update is an UD field that is defined as a decimal, this is where I think I am making the mistake.

When I update an Epicor field or a non-UD field, the BPM works no problem.


How do I update an UD field?


here is my code:


Erp.Tables.PartRev PartRev;

foreach (var ttECORev_iterator in ttECORev)

{
 var ttECORev_xRow = ttECORev_iterator;
  PartRev = (from PartRev_Row in Db.PartRev where
  PartRev_Row.Company == Session.CompanyID  &&
  PartRev_Row.PartNum == ttECORev_xRow.PartNum &&
  PartRev_Row.RevisionNum == ttECORev_xRow.RevisionNum &&
  PartRev_Row.AltMethod == ttECORev_xRow.AltMethod &&
  PartRev_Row.LockRev_c == true
 select PartRev_Row).FirstOrDefault();


 if ( PartRev == null )


 {

  ttECORev_xRow.BPMTrigger_c = 10;

 }
 
}

3
in the tt table you can't address custom fields as typed but rather address them by name

ttECORev_xRow["BPMTrigger_c"]=10;




Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Jan 12, 2016 at 11:21 AM, mvissuet@... [vantage] <vantage@yahoogroups.com> wrote:
 
<div>
  
  
  <p></p><p><span>I am sure I am missing something really simple.</span></p><p><span><br></span></p><p><span>I am trying to write a BPM on the business object Engineering Workbench.Update, where the BPM goes to look at the PartRev table then depending on the value of a field, it will update the ECORev table.</span></p><p><span>The field I am trying to update is an UD field that is defined as a decimal, this is where I think I am making the mistake.</span></p><p><span>When I update an Epicor field or a non-UD field, the BPM works no problem.</span></p><p><span><br></span></p><p><span>How do I update an UD field?</span></p><p><span><br></span></p><p><span>here is my code:</span></p><p><span><br></span></p><p><span>Erp.Tables.PartRev PartRev;</span></p><p><span>foreach (var ttECORev_iterator in ttECORev)</span></p><p><span>{<br> var ttECORev_xRow = ttECORev_iterator;<br>  PartRev = (from PartRev_Row in Db.PartRev where<br>  PartRev_Row.Company == Session.CompanyID  &amp;&amp;<br>  PartRev_Row.PartNum == ttECORev_xRow.PartNum &amp;&amp;<br>  PartRev_Row.RevisionNum == ttECORev_xRow.RevisionNum &amp;&amp;<br>  PartRev_Row.AltMethod == ttECORev_xRow.AltMethod &amp;&amp;<br>  PartRev_Row.LockRev_c == true<br> select PartRev_Row).FirstOrDefault();</span></p><p><span><br> if ( PartRev == null )</span></p><p><br></p><p> {</p><p>  ttECORev_xRow.BPMTrigger_c = 10;</p><p> }<br> <br>}<br></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>