Job Closing BPM

Thanks for the input.  I had thought of updating the JobEntry object
but when I googled around I found that the information indicating
you need to reference the JobClosing object (at least in previous
versions).  I have the following code which runs but something is
missing because the CloseJob method does not appear to be closing
anything.  Any additional help is appreciated.<br>
<br>
Thanks,<br>
Tanner<br>
<br>
var messageTextBuilder = new System.Text.StringBuilder();<br>
string mymsg = string.Empty;<br>
bool ftime = true;<br>
bool needinput = false;<br>
<br>
var jobsclose = ttResults.Where(row =&gt; !row.Unchanged()
&amp;&amp; row.Calculated_CloseJob == true);<br>
foreach(var job in jobsclose)<br>
{<br>
    var jobclosesvc =

Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.JobClosingSvcContract>(Db);

   var thisds = new Erp.Tablesets.JobClosingTableset();

  Â

  Â
messageTextBuilder.Append(string.Format("Job={0}",job.StockJobsDBD_JobNum));

   jobclosesvc.GetNewJobClosing(ref thisds);

   jobclosesvc.OnChangeJobNum(job.StockJobsDBD_JobNum,ref
thisds,out mymsg);

   if (mymsg != "")

   {

     Â
messageTextBuilder.Append(string.Format("\rMessage={0}",mymsg));

   }

   else

   {

      jobclosesvc.OnChangeJobCompletion(ref thisds);

      jobclosesvc.OnChangeJobClosed(ref thisds);

      jobclosesvc.PreCloseJob(ref thisds,out needinput);

  Â

    if (needinput == true) {

         messageTextBuilder.Append(string.Format("\rNEEDS
INPUT",mymsg));

    } Â

    else

      {

      jobclosesvc.CloseJob(ref thisds,out mymsg);

      }

   }

   thisds = null;

   jobclosesvc = null;

}





var messageText = messageTextBuilder.ToString();

this.PublishInfoMessage(messageText,
Ice.Common.BusinessObjectMessageType.Information,
Ice.Bpm.InfoMessageDisplayMode.Individual, "JobClosingDashboard",
"Update");





On 1/26/2016 1:49 PM, Greg Payne
gpayne@… [vantage] wrote:


<blockquote

type=“cite”> Â

      <div id="ygrps-yiv-1776584805ygrp-text">
        <p>
        </p>
        <div class="ygrps-yiv-1776584805WordSection1">
          <p class="ygrps-yiv-1776584805MsoNormal"><span

style=“font-size:11.0pt;color:#1F497D;”>I think you
could use the job entry object and the generated bpm
and update the closed checkbox and that would run the
normal processes.


Â


Be sure add
all of the key fields for all of the tables to be
updated and should work.


Â




From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]


Sent: Tuesday, January 26, 2016 2:25 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Job Closing BPM




Â


Â





I am trying to create an updatable dashboard to
close jobs and running into issues with an
advanced BPM. I have looked through the
JobClosing DLLs and cannot locate syntax that
builds the JobClosing.DataSet I need to pass into
the CloseJob method. Can anyone help point me in
the right direction or have syntax they would be
willing to share?



Thanks,

Tanner













CONFIDENTIALITY NOTICE



The information contained in this communication,
including attachments, is privileged and confidential.
It is intended only for the exclusive use of the
addressee. If the reader of this message is not the
intended recipient, or the employee or agent
responsible for delivering it to the intended
recipient, you are hereby notified that any
dissemination, distribution or copying of this
communication is strictly prohibited. If you have
received this communication in error, please notify us
at 727-578-6240 and immediately delete the
communication.



"This (document/presentation) may contain technical
data as defined in the International Traffic In Arms
Regulations (ITAR) 22 CFR 120.10. Export of this
material is restricted by the Arms Export Control Act
(22 U.S.C. 2751 et seq.) and may not be exported to
foreign persons without prior approval form the U.S.
Department of State."




</blockquote>
<br>

Trying to create a BPM to stop the process if certain elements aren't complete. Starting initially with a stop if all materials aren't issued complete.

Tried a Pre-Process query of to see if the number of rows is greater than zero:
for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty and JobMtl.JobNum = '%JobNum%'

Which doesn't fire. I did debug and removed the query and the BPM does fire and stop, so somehow this simple query isn't good. Anyone see the problem with this simple thing which somehow isn't simple?
You'll need to use the temp-tables instead. Your query isn't returning anything since its ttJobMtl, etc. that contains the record that is to be processed using whatever BO is firing.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbparker
Sent: Monday, September 14, 2009 12:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Closing BPM

Trying to create a BPM to stop the process if certain elements aren't complete. Starting initially with a stop if all materials aren't issued complete.

Tried a Pre-Process query of to see if the number of rows is greater than zero:
for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty and JobMtl.JobNum = '%JobNum%'

Which doesn't fire. I did debug and removed the query and the BPM does fire and stop, so somehow this simple query isn't good. Anyone see the problem with this simple thing which somehow isn't simple?



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Yeah, I had tried that too. I tried all temp tables and got nothing either. I even tried cross referencing the ttJobMtl to the ttJobClosing.

for each ttJobMtl no-lock where ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'


--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> You'll need to use the temp-tables instead. Your query isn't returning anything since its ttJobMtl, etc. that contains the record that is to be processed using whatever BO is firing.
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbparker
> Sent: Monday, September 14, 2009 12:38 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Job Closing BPM
>
> Trying to create a BPM to stop the process if certain elements aren't complete. Starting initially with a stop if all materials aren't issued complete.
>
> Tried a Pre-Process query of to see if the number of rows is greater than zero:
> for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty and JobMtl.JobNum = '%JobNum%'
>
> Which doesn't fire. I did debug and removed the query and the BPM does fire and stop, so somehow this simple query isn't good. Anyone see the problem with this simple thing which somehow isn't simple?
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
The percents aren't going to do anything, unless I'm confused.

I would try it this way:

For each ttJobClosing, each ttJobMtl where ttJobClosing.Company = ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty

Of course I don't know what BO method you're doing this against. I'm guessing JobClosing.CloseJob().

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbparker
Sent: Monday, September 14, 2009 2:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job Closing BPM

Yeah, I had tried that too. I tried all temp tables and got nothing either. I even tried cross referencing the ttJobMtl to the ttJobClosing.

for each ttJobMtl no-lock where ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'


--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> You'll need to use the temp-tables instead. Your query isn't returning anything since its ttJobMtl, etc. that contains the record that is to be processed using whatever BO is firing.
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbparker
> Sent: Monday, September 14, 2009 12:38 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Job Closing BPM
>
> Trying to create a BPM to stop the process if certain elements aren't complete. Starting initially with a stop if all materials aren't issued complete.
>
> Tried a Pre-Process query of to see if the number of rows is greater than zero:
> for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty and JobMtl.JobNum = '%JobNum%'
>
> Which doesn't fire. I did debug and removed the query and the BPM does fire and stop, so somehow this simple query isn't good. Anyone see the problem with this simple thing which somehow isn't simple?
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
You're correct on which BO method I'm trying to use, and no that query didn't work either. I really wish there was some sort of debugger that would allow me to step through this thing, yeesh.

This is basically how most of my BPM attempts go, run into the wall attempting to get the correct query.

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> The percents aren't going to do anything, unless I'm confused.
>
> I would try it this way:
>
> For each ttJobClosing, each ttJobMtl where ttJobClosing.Company = ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
>
> Of course I don't know what BO method you're doing this against. I'm guessing JobClosing.CloseJob().
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbparker
> Sent: Monday, September 14, 2009 2:04 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Job Closing BPM
>
> Yeah, I had tried that too. I tried all temp tables and got nothing either. I even tried cross referencing the ttJobMtl to the ttJobClosing.
>
> for each ttJobMtl no-lock where ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'
>
>
> --- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@> wrote:
> >
> > You'll need to use the temp-tables instead. Your query isn't returning anything since its ttJobMtl, etc. that contains the record that is to be processed using whatever BO is firing.
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> > Â Â Â Â bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbparker
> > Sent: Monday, September 14, 2009 12:38 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Job Closing BPM
> >
> > Trying to create a BPM to stop the process if certain elements aren't complete. Starting initially with a stop if all materials aren't issued complete.
> >
> > Tried a Pre-Process query of to see if the number of rows is greater than zero:
> > for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty and JobMtl.JobNum = '%JobNum%'
> >
> > Which doesn't fire. I did debug and removed the query and the BPM does fire and stop, so somehow this simple query isn't good. Anyone see the problem with this simple thing which somehow isn't simple?
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
Why don't you put some "message" statements in you bpm, they will show
up in the server log. You may have some info there now if it didn't
work.



To add a message statement to your bpm code, just add a line as follows:



Message "Job Number " ttJobMtl.JobNum.



Or you can even add something like:

Message "GOT HERE".



(don't forget the period at the end).



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of pbparker
Sent: Monday, September 14, 2009 4:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job Closing BPM





You're correct on which BO method I'm trying to use, and no that query
didn't work either. I really wish there was some sort of debugger that
would allow me to step through this thing, yeesh.

This is basically how most of my BPM attempts go, run into the wall
attempting to get the correct query.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian W. Spolarich " <bspolarich@...> wrote:
>
> The percents aren't going to do anything, unless I'm confused.
>
> I would try it this way:
>
> For each ttJobClosing, each ttJobMtl where ttJobClosing.Company =
ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and
ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
>
> Of course I don't know what BO method you're doing this against. I'm
guessing JobClosing.CloseJob().
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
/ Picometrix
> bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of pbparker
> Sent: Monday, September 14, 2009 2:04 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Job Closing BPM
>
> Yeah, I had tried that too. I tried all temp tables and got nothing
either. I even tried cross referencing the ttJobMtl to the ttJobClosing.
>
> for each ttJobMtl no-lock where ttJobMtl.RequiredQty <>
ttJobMtl.IssuedQty and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian W. Spolarich " <bspolarich@> wrote:
> >
> > You'll need to use the temp-tables instead. Your query isn't
returning anything since its ttJobMtl, etc. that contains the record
that is to be processed using whatever BO is firing.
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced
Photonix / Picometrix
> > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of pbparker
> > Sent: Monday, September 14, 2009 12:38 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Job Closing BPM
> >
> > Trying to create a BPM to stop the process if certain elements
aren't complete. Starting initially with a stop if all materials aren't
issued complete.
> >
> > Tried a Pre-Process query of to see if the number of rows is greater
than zero:
> > for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty
and JobMtl.JobNum = '%JobNum%'
> >
> > Which doesn't fire. I did debug and removed the query and the BPM
does fire and stop, so somehow this simple query isn't good. Anyone see
the problem with this simple thing which somehow isn't simple?
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
> > (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
>





[Non-text portions of this message have been removed]
You are correct in knowing that you have to get the job number from the
ttJobClosing table, but the comparison needs to be against the actual JobMtl
table. Try this:



For each ttJobClosing, each JobMtl where ttJobClosing.Company =
JobMtl.Company and ttJobClosing.JobNum = JobMtl.JobNum and
JobMtl.RequiredQty <> JobMtl.IssuedQty no-lock.



Terry S. Ellis

Tri Gem Co.

<http://trigemco.com/images/3diamonds.jpg>
http://TriGemCo.com/images/3diamonds-150x115.jpg

Phone: (914) 827-5665

Fax: (914) 827-5640

Mobile: (716) 983-8827

TSE@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
pbparker
Sent: Monday, September 14, 2009 3:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job Closing BPM





You're correct on which BO method I'm trying to use, and no that query
didn't work either. I really wish there was some sort of debugger that would
allow me to step through this thing, yeesh.

This is basically how most of my BPM attempts go, run into the wall
attempting to get the correct query.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brian
W. Spolarich " <bspolarich@...> wrote:
>
> The percents aren't going to do anything, unless I'm confused.
>
> I would try it this way:
>
> For each ttJobClosing, each ttJobMtl where ttJobClosing.Company =
ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and
ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
>
> Of course I don't know what BO method you're doing this against. I'm
guessing JobClosing.CloseJob().
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
> bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of pbparker
> Sent: Monday, September 14, 2009 2:04 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Job Closing BPM
>
> Yeah, I had tried that too. I tried all temp tables and got nothing
either. I even tried cross referencing the ttJobMtl to the ttJobClosing.
>
> for each ttJobMtl no-lock where ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brian
W. Spolarich " <bspolarich@> wrote:
> >
> > You'll need to use the temp-tables instead. Your query isn't returning
anything since its ttJobMtl, etc. that contains the record that is to be
processed using whatever BO is firing.
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
> > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of pbparker
> > Sent: Monday, September 14, 2009 12:38 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Job Closing BPM
> >
> > Trying to create a BPM to stop the process if certain elements aren't
complete. Starting initially with a stop if all materials aren't issued
complete.
> >
> > Tried a Pre-Process query of to see if the number of rows is greater
than zero:
> > for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty and
JobMtl.JobNum = '%JobNum%'
> >
> > Which doesn't fire. I did debug and removed the query and the BPM does
fire and stop, so somehow this simple query isn't good. Anyone see the
problem with this simple thing which somehow isn't simple?
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>





[Non-text portions of this message have been removed]
Hmmm, I just looked in my methods for actions and I don't see the option to execute 4GL code any longer in Epicor 9. Did that change?

I would guess that's where I could put some message statements to at least debug what values are floating around inside the BPM execution.

--- In vantage@yahoogroups.com, "Mike Anstey" <manstey@...> wrote:
>
> Why don't you put some "message" statements in you bpm, they will show
> up in the server log. You may have some info there now if it didn't
> work.
>
>
>
> To add a message statement to your bpm code, just add a line as follows:
>
>
>
> Message "Job Number " ttJobMtl.JobNum.
>
>
>
> Or you can even add something like:
>
> Message "GOT HERE".
>
>
>
> (don't forget the period at the end).
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of pbparker
> Sent: Monday, September 14, 2009 4:09 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Job Closing BPM
>
>
>
>
>
> You're correct on which BO method I'm trying to use, and no that query
> didn't work either. I really wish there was some sort of debugger that
> would allow me to step through this thing, yeesh.
>
> This is basically how most of my BPM attempts go, run into the wall
> attempting to get the correct query.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Brian W. Spolarich " <bspolarich@> wrote:
> >
> > The percents aren't going to do anything, unless I'm confused.
> >
> > I would try it this way:
> >
> > For each ttJobClosing, each ttJobMtl where ttJobClosing.Company =
> ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and
> ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
> >
> > Of course I don't know what BO method you're doing this against. I'm
> guessing JobClosing.CloseJob().
> >
> > -bws
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
> / Picometrix
> > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of pbparker
> > Sent: Monday, September 14, 2009 2:04 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Job Closing BPM
> >
> > Yeah, I had tried that too. I tried all temp tables and got nothing
> either. I even tried cross referencing the ttJobMtl to the ttJobClosing.
> >
> > for each ttJobMtl no-lock where ttJobMtl.RequiredQty <>
> ttJobMtl.IssuedQty and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Brian W. Spolarich " <bspolarich@> wrote:
> > >
> > > You'll need to use the temp-tables instead. Your query isn't
> returning anything since its ttJobMtl, etc. that contains the record
> that is to be processed using whatever BO is firing.
> > >
> > > --
> > > Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix / Picometrix
> > > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of pbparker
> > > Sent: Monday, September 14, 2009 12:38 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Job Closing BPM
> > >
> > > Trying to create a BPM to stop the process if certain elements
> aren't complete. Starting initially with a stop if all materials aren't
> issued complete.
> > >
> > > Tried a Pre-Process query of to see if the number of rows is greater
> than zero:
> > > for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty
> and JobMtl.JobNum = '%JobNum%'
> > >
> > > Which doesn't fire. I did debug and removed the query and the BPM
> does fire and stop, so somehow this simple query isn't good. Anyone see
> the problem with this simple thing which somehow isn't simple?
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> > > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo
> <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo
> <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
YES!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

We have a winner.. that was it. Many many thanks. I knew it was some combination of the tt and live tables, but without debugging every value inside the BPM execution it's hard to tell which to use.

I guess I need to find some way of dumping varaiables out to a text file in the future to see what's going on in the background.

Thanks again.

--- In vantage@yahoogroups.com, "Terry S. Ellis" <tse@...> wrote:
>
> You are correct in knowing that you have to get the job number from the
> ttJobClosing table, but the comparison needs to be against the actual JobMtl
> table. Try this:
>
>
>
> For each ttJobClosing, each JobMtl where ttJobClosing.Company =
> JobMtl.Company and ttJobClosing.JobNum = JobMtl.JobNum and
> JobMtl.RequiredQty <> JobMtl.IssuedQty no-lock.
>
>
>
> Terry S. Ellis
>
> Tri Gem Co.
>
> <http://trigemco.com/images/3diamonds.jpg>
> http://TriGemCo.com/images/3diamonds-150x115.jpg
>
> Phone: (914) 827-5665
>
> Fax: (914) 827-5640
>
> Mobile: (716) 983-8827
>
> TSE@...
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> pbparker
> Sent: Monday, September 14, 2009 3:09 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Job Closing BPM
>
>
>
>
>
> You're correct on which BO method I'm trying to use, and no that query
> didn't work either. I really wish there was some sort of debugger that would
> allow me to step through this thing, yeesh.
>
> This is basically how most of my BPM attempts go, run into the wall
> attempting to get the correct query.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brian
> W. Spolarich " <bspolarich@> wrote:
> >
> > The percents aren't going to do anything, unless I'm confused.
> >
> > I would try it this way:
> >
> > For each ttJobClosing, each ttJobMtl where ttJobClosing.Company =
> ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and
> ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
> >
> > Of course I don't know what BO method you're doing this against. I'm
> guessing JobClosing.CloseJob().
> >
> > -bws
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
> > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of pbparker
> > Sent: Monday, September 14, 2009 2:04 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Job Closing BPM
> >
> > Yeah, I had tried that too. I tried all temp tables and got nothing
> either. I even tried cross referencing the ttJobMtl to the ttJobClosing.
> >
> > for each ttJobMtl no-lock where ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
> and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Brian
> W. Spolarich " <bspolarich@> wrote:
> > >
> > > You'll need to use the temp-tables instead. Your query isn't returning
> anything since its ttJobMtl, etc. that contains the record that is to be
> processed using whatever BO is firing.
> > >
> > > --
> > > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
> > > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of pbparker
> > > Sent: Monday, September 14, 2009 12:38 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Job Closing BPM
> > >
> > > Trying to create a BPM to stop the process if certain elements aren't
> complete. Starting initially with a stop if all materials aren't issued
> complete.
> > >
> > > Tried a Pre-Process query of to see if the number of rows is greater
> than zero:
> > > for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty and
> JobMtl.JobNum = '%JobNum%'
> > >
> > > Which doesn't fire. I did debug and removed the query and the BPM does
> fire and stop, so somehow this simple query isn't good. Anyone see the
> problem with this simple thing which somehow isn't simple?
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Execute ABL code
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "pbparker" <scrumbus@...>

Date: Mon, 14 Sep 2009 20:42:04
To: <vantage@yahoogroups.com>
Subject: [Vantage] Re: Job Closing BPM


Hmmm, I just looked in my methods for actions and I don't see the option to execute 4GL code any longer in Epicor 9. Did that change?

I would guess that's where I could put some message statements to at least debug what values are floating around inside the BPM execution.

--- In vantage@yahoogroups.com, "Mike Anstey" <manstey@...> wrote:
>
> Why don't you put some "message" statements in you bpm, they will show
> up in the server log. You may have some info there now if it didn't
> work.
>
>
>
> To add a message statement to your bpm code, just add a line as follows:
>
>
>
> Message "Job Number " ttJobMtl.JobNum.
>
>
>
> Or you can even add something like:
>
> Message "GOT HERE".
>
>
>
> (don't forget the period at the end).
>
>
>
>________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of pbparker
> Sent: Monday, September 14, 2009 4:09 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Job Closing BPM
>
>
>
>
>
> You're correct on which BO method I'm trying to use, and no that query
> didn't work either. I really wish there was some sort of debugger that
> would allow me to step through this thing, yeesh.
>
> This is basically how most of my BPM attempts go, run into the wall
> attempting to get the correct query.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Brian W. Spolarich " <bspolarich@> wrote:
> >
> > The percents aren't going to do anything, unless I'm confused.
> >
> > I would try it this way:
> >
> > For each ttJobClosing, each ttJobMtl where ttJobClosing.Company =
> ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and
> ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
> >
> > Of course I don't know what BO method you're doing this against. I'm
> guessing JobClosing.CloseJob().
> >
> > -bws
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
> / Picometrix
> > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of pbparker
> > Sent: Monday, September 14, 2009 2:04 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Job Closing BPM
> >
> > Yeah, I had tried that too. I tried all temp tables and got nothing
> either. I even tried cross referencing the ttJobMtl to the ttJobClosing.
> >
> > for each ttJobMtl no-lock where ttJobMtl.RequiredQty <>
> ttJobMtl.IssuedQty and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Brian W. Spolarich " <bspolarich@> wrote:
> > >
> > > You'll need to use the temp-tables instead. Your query isn't
> returning anything since its ttJobMtl, etc. that contains the record
> that is to be processed using whatever BO is firing.
> > >
> > > --
> > > Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> Photonix / Picometrix
> > > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of pbparker
> > > Sent: Monday, September 14, 2009 12:38 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Job Closing BPM
> > >
> > > Trying to create a BPM to stop the process if certain elements
> aren't complete. Starting initially with a stop if all materials aren't
> issued complete.
> > >
> > > Tried a Pre-Process query of to see if the number of rows is greater
> than zero:
> > > for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty
> and JobMtl.JobNum = '%JobNum%'
> > >
> > > Which doesn't fire. I did debug and removed the query and the BPM
> does fire and stop, so somehow this simple query isn't good. Anyone see
> the problem with this simple thing which somehow isn't simple?
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to enable
> access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> > > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo
> <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo
> <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
Yup found it now. In Epicor 9 it's apparently hidden now by default for everyone and you have to go into the user security and enable "Advanced BPM User" to now see those options.

--- In vantage@yahoogroups.com, advantage@... wrote:
>
> Execute ABL code
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "pbparker" <scrumbus@...>
>
> Date: Mon, 14 Sep 2009 20:42:04
> To: <vantage@yahoogroups.com>
> Subject: [Vantage] Re: Job Closing BPM
>
>
> Hmmm, I just looked in my methods for actions and I don't see the option to execute 4GL code any longer in Epicor 9. Did that change?
>
> I would guess that's where I could put some message statements to at least debug what values are floating around inside the BPM execution.
>
> --- In vantage@yahoogroups.com, "Mike Anstey" <manstey@> wrote:
> >
> > Why don't you put some "message" statements in you bpm, they will show
> > up in the server log. You may have some info there now if it didn't
> > work.
> >
> >
> >
> > To add a message statement to your bpm code, just add a line as follows:
> >
> >
> >
> > Message "Job Number " ttJobMtl.JobNum.
> >
> >
> >
> > Or you can even add something like:
> >
> > Message "GOT HERE".
> >
> >
> >
> > (don't forget the period at the end).
> >
> >
> >
> >________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of pbparker
> > Sent: Monday, September 14, 2009 4:09 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Job Closing BPM
> >
> >
> >
> >
> >
> > You're correct on which BO method I'm trying to use, and no that query
> > didn't work either. I really wish there was some sort of debugger that
> > would allow me to step through this thing, yeesh.
> >
> > This is basically how most of my BPM attempts go, run into the wall
> > attempting to get the correct query.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Brian W. Spolarich " <bspolarich@> wrote:
> > >
> > > The percents aren't going to do anything, unless I'm confused.
> > >
> > > I would try it this way:
> > >
> > > For each ttJobClosing, each ttJobMtl where ttJobClosing.Company =
> > ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and
> > ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
> > >
> > > Of course I don't know what BO method you're doing this against. I'm
> > guessing JobClosing.CloseJob().
> > >
> > > -bws
> > >
> > > --
> > > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
> > / Picometrix
> > > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of pbparker
> > > Sent: Monday, September 14, 2009 2:04 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Job Closing BPM
> > >
> > > Yeah, I had tried that too. I tried all temp tables and got nothing
> > either. I even tried cross referencing the ttJobMtl to the ttJobClosing.
> > >
> > > for each ttJobMtl no-lock where ttJobMtl.RequiredQty <>
> > ttJobMtl.IssuedQty and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'
> > >
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Brian W. Spolarich " <bspolarich@> wrote:
> > > >
> > > > You'll need to use the temp-tables instead. Your query isn't
> > returning anything since its ttJobMtl, etc. that contains the record
> > that is to be processed using whatever BO is firing.
> > > >
> > > > --
> > > > Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> > Photonix / Picometrix
> > > > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of pbparker
> > > > Sent: Monday, September 14, 2009 12:38 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Job Closing BPM
> > > >
> > > > Trying to create a BPM to stop the process if certain elements
> > aren't complete. Starting initially with a stop if all materials aren't
> > issued complete.
> > > >
> > > > Tried a Pre-Process query of to see if the number of rows is greater
> > than zero:
> > > > for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty
> > and JobMtl.JobNum = '%JobNum%'
> > > >
> > > > Which doesn't fire. I did debug and removed the query and the BPM
> > does fire and stop, so somehow this simple query isn't good. Anyone see
> > the problem with this simple thing which somehow isn't simple?
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
> > access. )
> > > > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > > > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <http://groups.yahoo.com/group/vantage/messages>
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo
> > <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <http://groups.yahoo.com/group/vantage/messages>
> > > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo
> > <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
That too but that's how it was in 8. Its called ABL now instead of 4GL
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "pbparker" <scrumbus@...>

Date: Mon, 14 Sep 2009 21:43:30
To: <vantage@yahoogroups.com>
Subject: [Vantage] Re: Job Closing BPM


Yup found it now. In Epicor 9 it's apparently hidden now by default for everyone and you have to go into the user security and enable "Advanced BPM User" to now see those options.

--- In vantage@yahoogroups.com, advantage@... wrote:
>
> Execute ABL code
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "pbparker" <scrumbus@...>
>
> Date: Mon, 14 Sep 2009 20:42:04
> To: <vantage@yahoogroups.com>
> Subject: [Vantage] Re: Job Closing BPM
>
>
> Hmmm, I just looked in my methods for actions and I don't see the option to execute 4GL code any longer in Epicor 9. Did that change?
>
> I would guess that's where I could put some message statements to at least debug what values are floating around inside the BPM execution.
>
> --- In vantage@yahoogroups.com, "Mike Anstey" <manstey@> wrote:
> >
> > Why don't you put some "message" statements in you bpm, they will show
> > up in the server log. You may have some info there now if it didn't
> > work.
> >
> >
> >
> > To add a message statement to your bpm code, just add a line as follows:
> >
> >
> >
> > Message "Job Number " ttJobMtl.JobNum.
> >
> >
> >
> > Or you can even add something like:
> >
> > Message "GOT HERE".
> >
> >
> >
> > (don't forget the period at the end).
> >
> >
> >
> >________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of pbparker
> > Sent: Monday, September 14, 2009 4:09 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Job Closing BPM
> >
> >
> >
> >
> >
> > You're correct on which BO method I'm trying to use, and no that query
> > didn't work either. I really wish there was some sort of debugger that
> > would allow me to step through this thing, yeesh.
> >
> > This is basically how most of my BPM attempts go, run into the wall
> > attempting to get the correct query.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Brian W. Spolarich " <bspolarich@> wrote:
> > >
> > > The percents aren't going to do anything, unless I'm confused.
> > >
> > > I would try it this way:
> > >
> > > For each ttJobClosing, each ttJobMtl where ttJobClosing.Company =
> > ttJobMtl.Company and ttJobClosing.JobNum = ttJobMtl.JobNum and
> > ttJobMtl.RequiredQty <> ttJobMtl.IssuedQty
> > >
> > > Of course I don't know what BO method you're doing this against. I'm
> > guessing JobClosing.CloseJob().
> > >
> > > -bws
> > >
> > > --
> > > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
> > / Picometrix
> > > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of pbparker
> > > Sent: Monday, September 14, 2009 2:04 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Job Closing BPM
> > >
> > > Yeah, I had tried that too. I tried all temp tables and got nothing
> > either. I even tried cross referencing the ttJobMtl to the ttJobClosing.
> > >
> > > for each ttJobMtl no-lock where ttJobMtl.RequiredQty <>
> > ttJobMtl.IssuedQty and ttJobMtl.JobNum = '%ttJobClosing.JobNum%'
> > >
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Brian W. Spolarich " <bspolarich@> wrote:
> > > >
> > > > You'll need to use the temp-tables instead. Your query isn't
> > returning anything since its ttJobMtl, etc. that contains the record
> > that is to be processed using whatever BO is firing.
> > > >
> > > > --
> > > > Brian W. Spolarich ~ Manager, Information Services ~ Advanced
> > Photonix / Picometrix
> > > > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of pbparker
> > > > Sent: Monday, September 14, 2009 12:38 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Job Closing BPM
> > > >
> > > > Trying to create a BPM to stop the process if certain elements
> > aren't complete. Starting initially with a stop if all materials aren't
> > issued complete.
> > > >
> > > > Tried a Pre-Process query of to see if the number of rows is greater
> > than zero:
> > > > for each JobMtl no-lock where JobMtl.RequiredQty <> JobMtl.IssuedQty
> > and JobMtl.JobNum = '%JobNum%'
> > > >
> > > > Which doesn't fire. I did debug and removed the query and the BPM
> > does fire and stop, so somehow this simple query isn't good. Anyone see
> > the problem with this simple thing which somehow isn't simple?
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to enable
> > access. )
> > > > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > > > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <http://groups.yahoo.com/group/vantage/messages>
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo
> > <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <http://groups.yahoo.com/group/vantage/messages>
> > > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo
> > <http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I am trying to create an updatable dashboard to close jobs and running into issues with an advanced BPM.  I have looked through the JobClosing DLLs and cannot locate syntax that builds the JobClosing.DataSet I need to pass into the CloseJob method.  Can anyone help point me in the right direction or have syntax they would be willing to share?

Thanks,
Tanner

I think you could use the job entry object and the generated bpm and update the closed checkbox and that would run the normal processes.

 

Be sure add all of the key fields for all of the tables to be updated and should work.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, January 26, 2016 2:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Closing BPM

 

 

I am trying to create an updatable dashboard to close jobs and running into issues with an advanced BPM.  I have looked through the JobClosing DLLs and cannot locate syntax that builds the JobClosing.DataSet I need to pass into the CloseJob method.  Can anyone help point me in the right direction or have syntax they would be willing to share?

Thanks,
Tanner




CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6240 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."