V8 BAM .p procedure to E10

Yahoo Archive
1

Tried that – it looks like ‘their’ queries are being used as Booleans and if the ‘AND” of all the conditional queries is true, then off it goes to perform the action.

 

I tried to replicate the query that returns data from the Unchanged() row and get nothing L

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, May 20, 2015 11:25 AM
To: Vantage
Subject: Re: [Vantage] V8 BAM .p procedure to E10.....

 




Yes you can , use the Condition field X changed from Any to X... and then go look at the code that Epicor Generates.



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Wed, May 20, 2015 at 9:11 AM, bwalker@... [vantage] <vantage@yahoogroups.com> wrote:

 

In a progress .p procedure I could perform a calculation using the OLD value in the temp table and the NEW value.

 

I cannot seem to duplicate this in the new and improved E10

 

specifically I want to send an email message (when certain conditions have been met) using the JobOper and JobHead tables. I want to include the 'transaction qty' in the message

In progress code that was easily done like this: "String(JobOper.QtyCompleted - OLDJobOper.QtyCompleted)"

 

I am presuming that both the OLD data and NEW data rows exist in an In-Transaction Data Directive and I just don't know how to access the OLD data.

 

Any hints on how to accomplish this?

 

Thanks

 

bw

 




2

In a progress .p procedure I could perform a calculation using the OLD value in the temp table and the NEW value.


I cannot seem to duplicate this in the new and improved E10


specifically I want to send an email message (when certain conditions have been met) using the JobOper and JobHead tables. I want to include the 'transaction qty' in the message

In progress code that was easily done like this: "String(JobOper.QtyCompleted - OLDJobOper.QtyCompleted)"


I am presuming that both the OLD data and NEW data rows exist in an In-Transaction Data Directive and I just don't know how to access the OLD data.


Any hints on how to accomplish this?


Thanks


bw

3
Yes you can , use the Condition field X changed from Any to X... and then go look at the code that Epicor Generates.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, May 20, 2015 at 9:11 AM, bwalker@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p><span>In a progress .p procedure I could perform a calculation using the OLD value in the temp table and the NEW value.</span></p><p><span><br></span></p><p><span>I cannot seem to duplicate this in the new and improved E10</span></p><p><span><br></span></p><p><span>specifically I want to send an email message (when certain conditions have been met) using the JobOper and JobHead tables. I want to include the &#39;transaction qty&#39; in the message</span></p><p><span>In progress code that was easily done like this: &quot;String(JobOper.QtyCompleted - OLDJobOper.QtyCompleted)&quot;</span></p><p><span><br></span></p><p><span>I am presuming that both the OLD data and NEW data rows exist in an In-Transaction Data Directive and I just don&#39;t know how to access the OLD data.</span></p><p><span><br></span></p><p><span>Any hints on how to accomplish this?</span></p><p><span><br></span></p><p><span>Thanks</span></p><p><span><br></span></p><p><span>bw</span></p><p></p>

</div>
 


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