BPM Help Blank Title 73304

system · March 9, 2010, 6:57pm

I have a workflow that calls a cub workflow that iterates through SO entry.
I want to be able to check the contents of field in the prior row. How could
I go about doing this?

~Charlie

[Non-text portions of this message have been removed]

system · March 10, 2010, 6:28am

Took a different route that I think is working never mind.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Tuesday, March 09, 2010 6:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM Help

I have a workflow that calls a cub workflow that iterates through SO entry.
I want to be able to check the contents of field in the prior row. How could
I go about doing this?

~Charlie

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · April 27, 2010, 12:43pm

9.04.505C
SQL

I'm writing a BPM that fires on the change of a part number on the
sales order line.

As part of the condition logic, I want the BPM to refer to the
reservation priority code on the order header but I cant seem to make
it work. I turned on the trace and the reservation priority code is
there - is it because its on the header and not the line?

Thanks in advance

Gavin

system · September 21, 2010, 6:16pm

I want to require theÂ Receiving Inspectors to choose one of four fault codes for
rejected DMR material and then not allow the DMR to be closed. I created the
following condition on post-processing:

for each DMRHeadÂ
whereÂ (DMRHead.CheckBox01 = FALSE ANDÂ
Â Â Â Â Â Â Â DMRHead.CheckBox02 = FALSE AND
Â Â Â Â Â Â Â DMRHead.CheckBox03 = FALSE AND
Â Â Â Â Â Â Â DMRHead.CheckBox04 = FALSE AND
Â Â Â Â Â Â Â DMRHead.OpenDMRÂ Â Â = FALSE) no-lock ,
Â
each DMRActnÂ
where (Â DMRActn.ActionType = 'R') and
Â Â Â Â Â (DMRHead.Company = DMRActn.Company and
Â Â Â Â Â Â DMRHead.DMRNum = DMRActn.DMRNum) no-lock .

The action to be taken was to issue a message and turn the OpenDMR flag back on.
This is necessary because if the amount rejected is equal to the amount DMR'd,
Vantage automatically considers the DMR 'closed'. The 4GL was:
Run lib\UpdateTableBuffer.p(input BUFFER DMRHead:HANDLE, 'OpenDMR', TRUE).

Still the DMR is automatically closed! Anyone seen this and have any thoughts on
a solution?

Thanks -Karl

[Non-text portions of this message have been removed]

system · April 20, 2011, 1:52pm

If I want a check box to be default everytime a new job is created which condition would i pick in the Method Directives screen. I know it should be a pre-processing directive. I am trying to make the Job Template checkbox on by default when a new job is created.

Thanks for the help,
Brad

system · April 20, 2011, 2:29pm

Hi Brad,

> If I want a check box to be default everytime a new job is created which condition would i pick in the Method Directives screen.
>I know it should be a pre-processing directive. I am trying to make the Job Template checkbox on by default when a new job is created.

For default values, I use a Post-Processing Directive to override the
default of the Base Process. I use Pre-Processing directives to check
things before updates.

Mark W.

system · April 20, 2011, 2:35pm

Yeah, I found that out quick when I actually tried to make it work. I got
another checkbox to work correctly, but I cannot find what field the
template is called. When I look in developer mode, it says
"JobHead.InCopyList", but I can't find this field to use it in the BPM.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Wednesday, April 20, 2011 2:29 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Help

Hi Brad,

> If I want a check box to be default everytime a new job is created which

condition would i pick in the Method Directives screen.

>I know it should be a pre-processing directive. I am trying to make the Job

Template checkbox on by default when a new job is created.

For default values, I use a Post-Processing Directive to override the
default of the Base Process. I use Pre-Processing directives to check
things before updates.

Mark W.

[Non-text portions of this message have been removed]

system · April 20, 2011, 2:37pm

Wow, nevermind. I'm just blind. Went back and looked for it again and there
it is.

I got it working now..

Thanks for the help

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Wednesday, April 20, 2011 2:29 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Help

Hi Brad,

> If I want a check box to be default everytime a new job is created which

condition would i pick in the Method Directives screen.

>I know it should be a pre-processing directive. I am trying to make the Job

Template checkbox on by default when a new job is created.

For default values, I use a Post-Processing Directive to override the
default of the Base Process. I use Pre-Processing directives to check
things before updates.

Mark W.

[Non-text portions of this message have been removed]

system · June 22, 2011, 1:16pm

I want to create a BPM that will allow me to fill in a user-defined field in Part Entry and when a Sales Order for that part is created, the data from that user defined field is carried over to the sales order.

Anyone have ideas on how this is done?

Thanks,
Brad

system · June 22, 2011, 1:47pm

You'll need to hook up to order.update, you should be able to safely run
this asynchronously.

The following code should get you pointed in the right direction.
Essentially you just need to look up the orderline, find the matching part
and dump the data in the field.

FOR EACH ttOrderDtl WHERE ttOrderDtl.RowMod = 'A' OR ttOrderDtl.RowMod =
'U'.
FIND FIRST Part WHERE Part.PartNum = ttOrderDtl.PartNum.
IF AVAILABLE Part THEN DO:
ASSIGN Part.<YourField> = ttOrderDtl.<YourOtherField>.
END.
END.

On Wed, Jun 22, 2011 at 1:16 PM, <bebright@...> wrote:

> **
>
>
> I want to create a BPM that will allow me to fill in a user-defined field
> in Part Entry and when a Sales Order for that part is created, the data from
> that user defined field is carried over to the sales order.
>
> Anyone have ideas on how this is done?
>
> Thanks,
> Brad
>
>
>

--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*

[Non-text portions of this message have been removed]

system · June 22, 2011, 2:33pm

Although actually, the ASSIGN statement is in the wrong direction. It
sounded like you wanted:
ASSIGN ttOrderDtl.<YourField> = Part.<YourOtherField>.

Also, you should include the company on your FIND statement (where
Part.Company = ttOrderDtl.Company AND ...), and you'll want a NO-LOCK
NO-ERROR clause on the FIND as well.

Finished code:
FOR EACH ttOrderDtl WHERE ttOrderDtl.RowMod = 'A' OR ttOrderDtl.RowMod =
'U':
FIND FIRST Part WHERE Part.Company = ttOrderDtl.Company
AND Part.PartNum = ttOrderDtl.PartNum NO-LOCK NO-ERROR.
IF AVAILABLE Part THEN DO:
ASSIGN ttOrderDtl.<YourField> = Part.<YourOtherField>.
END.
END.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Waffqle
Sent: Wednesday, June 22, 2011 1:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM Help

You'll need to hook up to order.update, you should be able to safely run
this asynchronously.

The following code should get you pointed in the right direction.
Essentially you just need to look up the orderline, find the matching part
and dump the data in the field.

FOR EACH ttOrderDtl WHERE ttOrderDtl.RowMod = 'A' OR ttOrderDtl.RowMod =
'U'.
FIND FIRST Part WHERE Part.PartNum = ttOrderDtl.PartNum.
IF AVAILABLE Part THEN DO:
ASSIGN Part.<YourField> = ttOrderDtl.<YourOtherField>.
END.
END.

On Wed, Jun 22, 2011 at 1:16 PM, <bebright@...> wrote:

> **
>
>
> I want to create a BPM that will allow me to fill in a user-defined field
> in Part Entry and when a Sales Order for that part is created, the data
from
> that user defined field is carried over to the sales order.
>
> Anyone have ideas on how this is done?
>
> Thanks,
> Brad
>
>
>

--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*

[Non-text portions of this message have been removed]

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

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

system · September 20, 2011, 2:00pm

I am having some difficulty getting data from a temp table to be saved to the JobMtl table. I have wrote some ABL code that I am trying to execute with a bpm and also tried using a BPM action with no success. The BPM action I have is: set the JobMtl.Character01 field of the changed row to the ttJobMtlAttch.JobNum expression. The ABL code I have is:

/*For each ttJobMtlAttch where ttJobMtlAttch.RowMod = 'a' no-lock. */
Find ttJobMtlAttch where ttJobMtlAttch.Company = ttJobMtl.Company and ttJobMtlAttch.JobNum = ttJobMtl.JobNum.
If available ttJobMtlAttch then do:
Assign ttJobMtl.Character01 = String(ttJobMtlAttch.JobNum)
ttJobMtl.Character02 = String(ttJobMtlAttch.AssemblySeq)
ttJobMtl.Character03 = String(ttJobMtlAttch.MtlSeq)
ttJobMtl.Character04 = String(ttJobMtlAttch.FileName).
End.
/*End. */

I have commented out some of the code because I am not very confident in writing ABL code yet. If I show an informational message or raise an exception window, the fields I add to those templates displays, so I know it is getting the right data. Just not sure how to get it into the JobMtl table. I am using the BPM during the pre-processing of the JobEntry Update method.

Thanks in advance for any help,
Ted

system · December 19, 2011, 12:50pm

Simple BPM to prevent changes in Sales Order if Orderhed.checkbox04 is true. I tried several but nothing seems to work. Any help will be appreciated. Thank you.

system · December 19, 2011, 12:56pm

Condition

1. If Number Of Rows IN Design Query is > 0

Query
For EACH ttOrderHed WHERE ttOrderHed.CheckBox04=true;

OR
2. If Number Of Rows IN Design Query is > 0
Query
FOR EACH ttOrderDtl, each OrderHed where OrderHed.COmpany =
ttORderDtl.Company and OrderHed.OrderNum = ttOrderNum.OrderNum and
ORderHed.CheckBox04=true

Action
Raise Exception Based on Designed Template

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Mon, Dec 19, 2011 at 12:50 PM, mobilevox <juy@...> wrote:

> **
>
>
> Simple BPM to prevent changes in Sales Order if Orderhed.checkbox04 is
> true. I tried several but nothing seems to work. Any help will be
> appreciated. Thank you.
>
>
>

[Non-text portions of this message have been removed]

system · December 20, 2011, 11:04am

Thanks Jose. I used option 2 since option 1 doesn't seem to work. Thanks again for the help.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Condition
>
> 1. If Number Of Rows IN Design Query is > 0
>
> Query
> For EACH ttOrderHed WHERE ttOrderHed.CheckBox04=true;
>
> OR
> 2. If Number Of Rows IN Design Query is > 0
> Query
> FOR EACH ttOrderDtl, each OrderHed where OrderHed.COmpany =
> ttORderDtl.Company and OrderHed.OrderNum = ttOrderNum.OrderNum and
> ORderHed.CheckBox04=true
>
>
>
>
>
> Action
> Raise Exception Based on Designed Template
>
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Mon, Dec 19, 2011 at 12:50 PM, mobilevox <juy@...> wrote:
>
> > **
> >
> >
> > Simple BPM to prevent changes in Sales Order if Orderhed.checkbox04 is
> > true. I tried several but nothing seems to work. Any help will be
> > appreciated. Thank you.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

system · December 20, 2011, 11:16am

Glad I could help, however you proably want to use both conditions with an
OR statement 1 and 2

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Tue, Dec 20, 2011 at 11:04 AM, mobilevox <juy@...> wrote:

> **
>
>
> Thanks Jose. I used option 2 since option 1 doesn't seem to work. Thanks
> again for the help.
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Condition
> >
> > 1. If Number Of Rows IN Design Query is > 0
> >
> > Query
> > For EACH ttOrderHed WHERE ttOrderHed.CheckBox04=true;
> >
> > OR
> > 2. If Number Of Rows IN Design Query is > 0
> > Query
> > FOR EACH ttOrderDtl, each OrderHed where OrderHed.COmpany =
> > ttORderDtl.Company and OrderHed.OrderNum = ttOrderNum.OrderNum and
> > ORderHed.CheckBox04=true
> >
> >
> >
> >
> >
> > Action
> > Raise Exception Based on Designed Template
> >
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Mon, Dec 19, 2011 at 12:50 PM, mobilevox <juy@...> wrote:
> >
> > > **
>
> > >
> > >
> > > Simple BPM to prevent changes in Sales Order if Orderhed.checkbox04 is
> > > true. I tried several but nothing seems to work. Any help will be
> > > appreciated. Thank you.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>

[Non-text portions of this message have been removed]

system · May 29, 2012, 3:52pm

Can someone please, please, please help me make a BPM. I neeed this..
When a Subcontract Packing Slip is recieved it receives the material to our Subcontract Hold Warehouse. I need the BPM to automatically move the material from Subcontract Hold Warehouse to the Part Master Primary Warehouse. Please and Thanks for your help!

system · October 26, 2012, 7:36am

We are looking to stop receipt transactions for POs where the POHeader.ApprovalStatus <> "A". I am assuming a BPM is the solution, but have not been able to get anything working. I ran a trace log on the receipt process, but have not been able to isolate the correct business object to stop the receipts. It doesn't look like the POHeader table is referenced anywhere directly in these business objects.

Does anyone have something similar to this in place that might be willing to share the solution?

Thank you,

Lauren Hellings
Business Analyst
Office: 281-207-4613
Cell: 832-472-1736
Email: Lauren.Hellings@...<mailto:Lauren.Hellings@...>
www.c-p-i.com<http://www.c-p-i.com/>

----------Legal Disclaimer----------

The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.

[Non-text portions of this message have been removed]

system · October 26, 2012, 9:49am

Lauren,
I have one on the update method of the Dropshipment that does this

Define variable msg as character no-undo.
For each ttdropshiphead:
FIND FIRST poheader where POheader.ponum = ttdropshiphead.PONum and POHeader.company = CUR-COMP No-lock no-error.
If available(poheader) then do:
If poheader.ApprovalStatus <> 'A' then do:
ASSIGN msg = 'Purchase Order must be approved before you can dropship'.
{lib/PublishEx.i &ExMsg = msg}.
End.
End.
End.

You will have to write a Pre-Processing on the Update method on the receipt buisiness object and this will work.

You need to change the temp table.

Stephen

--- In vantage@yahoogroups.com, "Hellings, Lauren" <lauren.hellings@...> wrote:
>
> We are looking to stop receipt transactions for POs where the POHeader.ApprovalStatus <> "A". I am assuming a BPM is the solution, but have not been able to get anything working. I ran a trace log on the receipt process, but have not been able to isolate the correct business object to stop the receipts. It doesn't look like the POHeader table is referenced anywhere directly in these business objects.
>
> Does anyone have something similar to this in place that might be willing to share the solution?
>
> Thank you,
>
> Lauren Hellings
> Business Analyst
> Office: 281-207-4613
> Cell: 832-472-1736
> Email: Lauren.Hellings@...<mailto:Lauren.Hellings@...>
> www.c-p-i.com<http://www.c-p-i.com/>
>
>
> ----------Legal Disclaimer----------
>
> The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.
>
>
>
> [Non-text portions of this message have been removed]
>

system · October 26, 2012, 12:01pm

Lauren,
Â This came from another user but:
1.) Create a Pre-processing BPM on Receipt.GetPOInfo
2.) For the 'Condition' add the following custom source code
Â
/*Add source code that should be executed before the designed conditions here*/
{&CALL_DESIGNED_CONDITIONS}
/*Add source code that should be executed after the designed conditions here*/
FIND FIRST ttRcvHead WHERE ttRcvHead.RowMod = "A" NO-LOCK NO-ERROR.
FIND FIRST POHeader where POHeader.poNum = poNum NO-LOCK NO-ERROR.
/*IF POHeader.ApprovalStatus <> "A" THEN*/
Case POHeader.ApprovalStatus:
WHEN "U" THEN
{Lib/PublishEx.i &ExMsg = "'PO has not been submitted for approval. Please submit for approval before receiving PO.'"}
WHEN "P" THEN
{Lib/PublishEx.i &ExMsg = "'PO has not been approved. Please approve PO before receiving.'"}
WHEN "R" THEN
{Lib/PublishEx.i &ExMsg = "'PO has been rejected. PO cannot be received.'"}
END CASE.

________________________________
From: "Hellings, Lauren" <lauren.hellings@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, October 26, 2012 4:36 AM
Subject: [Vantage] BPM Help

Â
We are looking to stop receipt transactions for POs where the POHeader.ApprovalStatus <> "A". I am assuming a BPM is the solution, but have not been able to get anything working. I ran a trace log on the receipt process, but have not been able to isolate the correct business object to stop the receipts. It doesn't look like the POHeader table is referenced anywhere directly in these business objects.

Does anyone have something similar to this in place that might be willing to share the solution?

Thank you,

Lauren Hellings
Business Analyst
Office: 281-207-4613
Cell: 832-472-1736
Email: mailto:Lauren.Hellings%40c-p-i.com<mailto:mailto:Lauren.Hellings%40c-p-i.com>
www.c-p-i.com<http://www.c-p-i.com/>

----------Legal Disclaimer----------

The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]