9.05.700B - Part Maintenance

Jose, thank you very much. Time to let the user test it.

I have a user that would like to display the current rev as the first item In Part Maintenance on the Part tab, Revisions tab, Detail Tab (instead of showing simply by alphanumeric order).


For example: a part has Rev A, B, and C. Rev B is the current approved revision. He would like Rev B to be the first one to appear on the Details tab.


Any suggestions?


Thanks for your help in advance.

Monte

Post Processing BPM on Get BY ID you can change the soort of the ttPartRev recordÂ


Like thisÂ

DEFINE TEMP-TABLE ttTarget LIKE ttUD101a.

DEFINE VARIABLE httSource AS HANDLE NO-UNDO.
DEFINE VARIABLE httTarget AS HANDLE NO-UNDO.

Assign
httSource = TEMP-TABLE ttUD101a:HANDLE
httTarget = TEMP-TABLE ttTarget:HANDLE.

FOR EACH ttUD101A BY ttUD101A.ShortChar01:
CREATE ttTarget.
BUFFER-COPY ttUD101A to ttTarget.

END.

httSource:COPY-TEMP-TABLE(httTarget,?,?,?,?).



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Wed, Jun 4, 2014 at 3:00 PM, mtisland@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p></p><p><span>I have a user that would like to display the current rev as the first item In Part Maintenance on the Part tab, Revisions tab, Detail Tab (instead of showing simply by alphanumeric order). </span></p>


For example: a part has Rev A, B, and C. Rev B is the current approved revision. He would like Rev B to be the first one to appear on the Details tab.


Any suggestions?


Thanks for your help in advance.

Monte

</div>
 


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

Thanks Jose.


I have this attached to Part.GetByID


Now I get this error:

Compilation error:You cannot define a TEMP-TABLE inside an internal procedure. (3355)


** D:\Epicor\Epicor905\bpmExec\TestBPM\bo\Part\Part.p Could not understand line 133. (196)


Here is my BPM:

/* BPM PartRev Sort   */
DEFINE TEMP-TABLE ttTarget LIKE ttPartRev.
DEFINE VARIABLE httSource AS HANDLE NO-UNDO.
DEFINE VARIABLE httTarget AS HANDLE NO-UNDO.

ASSIGN httSource = TEMP-TABLE ttPartRev:HANDLE
httTarget = TEMP-TABLE ttTarget:HANDLE.

FOR EACH ttPartRev BY ttPartRev.Approved DESCENDING BY ttPartRev.RevisionNum:

 CREATE ttTarget.
 BUFFER-COPY ttPartRev to ttTarget.

END.

httSource:COPY-TEMP-TABLE(httTarget,?,?,?,?).


Any more suggestions? Thanks again.

Mode the Define portion to the "Declaration Section" in the BPM. Click the button and move that there.



Jose C Gomez
Software Engineer



T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Thu, Jun 5, 2014 at 9:09 AM, mtisland@... [vantage] <vantage@yahoogroups.com> wrote:
Â
<div>
  
  
  <p></p><p>Thanks Jose. </p><p><br></p><p>I have this attached to Part.GetByID</p><p><br></p><p>Now I get this error:</p><font size="1"><p>Compilation error:You cannot define a TEMP-TABLE inside an internal procedure. (3355)</p>


** D:\Epicor\Epicor905\bpmExec\TestBPM\bo\Part\Part.p Could not understand line 133. (196)


Here is my BPM:

/* BPM PartRev Sort  */
DEFINE TEMP-TABLE ttTarget LIKE ttPartRev.


DEFINE VARIABLE httSource AS HANDLE NO-UNDO.
DEFINE VARIABLE httTarget AS HANDLE NO-UNDO.

ASSIGN httSource = TEMP-TABLE ttPartRev:HANDLE

httTarget = TEMP-TABLE ttTarget:HANDLE.

FOR EACH ttPartRev BY ttPartRev.Approved DESCENDING BY ttPartRev.RevisionNum:

 CREATE ttTarget.
 BUFFER-COPY ttPartRev to ttTarget.

END.

httSource:COPY-TEMP-TABLE(httTarget,?,?,?,?).


Any more suggestions? Thanks again.

</div><div class="ygrps-yiv-39942569">
 


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