If you have EpicWeb, they have answerbooks. Look up BPM under EPICOR905
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 22, 2015 1:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BPM to update OrderRel on JobHead change
This did it! Thank you so much for your help!
Do you have any good links/resources for ABL syntax? Thanks so much
You will need to get from the Job to the Order Rels through JobProd I’m assuming you are on 9 when I say that
Joshua Giese
CIO
Direct: 920.593.8299
IT Dept: 920.437.6400 Ext. 337
Site ID: 27450-E905702A-SQL64
Wisconsin Converting, Inc.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 22, 2015 11:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM to update OrderRel on JobHead change
Hi all
Looking for some guidance on how to set up a BPM. When a job is released I need to update a UD field on all order releases attached to the job. I am unsure how to make the update to the order release table through the BPM. Any guidance would be appreciated. Thank you
On Thu, Jan 22, 2015 at 1:17 PM, chad.m.terry@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>I am trying to synchronusly execute the following ABL code from the JobEntry.Update method when ttJobHead.CheckOff05 changes from False to True.</p><div><br></div><div><div>FOR EACH OrderRel WHERE OrderRel.OrderNum = ttJobProd.OrderNum and OrderRel.OrderLine = ttJobProd.OrderLine and OrderRel.OrderRelNum = ttJobProd.OrderRelNum and ttJobProd.JobNum = ttJobHead.JobNum NO-LOCK: </div><div>Run lib\UpdateTableBuffer.p(input BUFFER OrderRel:HANDLE, 'CheckBox01', TRUE). </div><div>END.</div><div><br></div><div>It is not working.</div></div><div><br></div><p></p> </div><span class="ygrps-yiv-2089878468"> <div style="color:#fff;min-height:0;"></div>
On Thu, Jan 22, 2015 at 1:57 PM, Amélie Pelletier amelie.pelletier@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>What you want is to set up orderrel.checkbox01 = True when jobhead change?<br>
*Amélie Pelletier*
*Analyste Programmeur / Program analyst*
[image: cid:image001.jpg@01CD5525.2091A820]
*230, Boulevard Nilus-Leclerc*
*L'Islet, Québec (Canada)*
*G0R 2C0*
*Téléphone: 418-247-3986 ext. 2402*
*Fax: 418-247-7925*
*amelie.pelletier@... <brigitte.savoie@...>*
*P* Est-ce nécessaire d’imprimer ce message?
*Please consider the environment before printing this email**.*
*De :* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
*Envoyé :* 22 janvier 2015 13:55
*À :* vantage@yahoogroups.com
*Objet :* [Vantage] Re: BPM to update OrderRel on JobHead change
OK thanks for the advice. Changed to this and still not working as
expected. Any other tips? Thanks!
FOR EACH ttJobProd WHERE ttJobProd.JobNum = ttJobHead.JobNum:
FOR EACH OrderRel WHERE OrderRel.OrderNum = ttJobProd.OrderNum
and OrderRel.OrderLine = ttJobProd.OrderLine and OrderRel.OrderRelNum =
ttJobProd.OrderRelNum:
Run lib\UpdateTableBuffer.p(input BUFFER
OrderRel:HANDLE, 'CheckBox01', TRUE).
END.
END.
[Non-text portions of this message have been removed]
</div> <div style="color:#fff;min-height:0;"></div>
On Thu, Jan 22, 2015 at 2:07 PM, chad.m.terry@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>OK. I guess I'm not sure why I wouldn't have a ttJobProd when I'm in the update method of JobEntry? Can you suggest the correct code please? I appreciate your help.</p> </div> <div style="color:#fff;min-height:0;"></div>
Makes sense. So grab ttJobHead, link JobProd to it then link OrderRel to that and instead of BufferUpdate use Assign
FOR EACH ttJobHead, JobProd, OrderRel:
Assign OrderRel.CheckBox01 = TRUE.
END.
Obviously abbreviated but you get the point.
Joshua Giese
CIO
Direct: 920.593.8299
IT Dept: 920.437.6400 Ext. 337
Site ID: 27450-E905702A-SQL64
Wisconsin Converting, Inc.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 22, 2015 1:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BPM to update OrderRel on JobHead change
Yes - when JobHead.CheckOff5 changes from False to True, I want the system to set OrderRel.CheckBox01 = True for every order release attached to that Job in the JobProd table.
