BPM question Blank Title 70067

Yahoo Archive
1
In a pre-processing BPM you can do a query on OrderHed (physical table) to examine the value of the checkbox and then raise an exception. What version of Epicor are you running?

Jim Kinneman
Encompass Solutions, Inc.
2
I want to update jobhead.date01 with current date and set checkbox01 to 1 when someone tries to print a traveler from job entry.

Users want the date01 to update to Today() if checkbox01 = 0, then set checkbox01 to 1.

JobEntry has a lot of BPMs, but none sound like "PrintTraveler"
Am i looking in wrong BO?


Thanks for any help.





[Non-text portions of this message have been removed]
3
I don't believe you can capture an actions process using BPM. Those processes are not a part of the Job Business Object.

----- Original Message -----
From: Tony Hughes
To: vantage@yahoogroups.com
Sent: Friday, October 24, 2008 3:39 PM
Subject: [Vantage] BPM question


I want to update jobhead.date01 with current date and set checkbox01 to 1 when someone tries to print a traveler from job entry.

Users want the date01 to update to Today() if checkbox01 = 0, then set checkbox01 to 1.

JobEntry has a lot of BPMs, but none sound like "PrintTraveler"
Am i looking in wrong BO?

Thanks for any help.

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





[Non-text portions of this message have been removed]
4
Charles,
That's a good point.
I was thinking because jobhead stores the field travelerlastprinted and travelerreadytoprint that the event was trappable somehow.
Any idea what object I'd look at to capture that?
I could also use a trigger on the database (We have SQL Server)
If I did that, is writing to data## or checkbox## fields safe in this manner?
Thanks for any advice,
Tony




________________________________
From: Charles Carden <shadowcar1449@...>
To: vantage@yahoogroups.com
Sent: Friday, October 24, 2008 3:54:53 PM
Subject: Re: [Vantage] BPM question


I don't believe you can capture an actions process using BPM. Those processes are not a part of the Job Business Object.

----- Original Message -----
From: Tony Hughes
To: vantage@yahoogroups .com
Sent: Friday, October 24, 2008 3:39 PM
Subject: [Vantage] BPM question

I want to update jobhead.date01 with current date and set checkbox01 to 1 when someone tries to print a traveler from job entry.

Users want the date01 to update to Today() if checkbox01 = 0, then set checkbox01 to 1.

JobEntry has a lot of BPMs, but none sound like "PrintTraveler"
Am i looking in wrong BO?

Thanks for any help.

[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]
5
This sounds more like a UI customization than a BO customization. I
don't see anything in the UI customization events about printing or
menus...all of the event hooks mentioned seem like they're ones inside
the window, not the window itself. I'd ask the tools guys at support if
there's a way to capture this event...you should be able to write your
own handler if you know what the event is called. I just didn't see
anything that stuck out at me in ObjectExplorer.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Friday, October 24, 2008 5:25 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM question



Charles,
That's a good point.
I was thinking because jobhead stores the field travelerlastprinted and
travelerreadytoprint that the event was trappable somehow.
Any idea what object I'd look at to capture that?
I could also use a trigger on the database (We have SQL Server)
If I did that, is writing to data## or checkbox## fields safe in this
manner?
Thanks for any advice,





[Non-text portions of this message have been removed]
6
Version 8.03.408b.

I have a BPM pre-processing directive on the Part table that checks the Unit of Measure against a user defined table for validity. This works very well except that when I make changes to one of the related Part tables, e.g. Part Plant table, it triggers the BPM and the exception message is given as if the UOM is invalid. The directive uses a simply query to check validity. I assume there is something I am missing here since it appears updating one of the related Part tables signals an update to the Part Table without the "ttPart" data being available.

This is my query:

for each ttPart where (ttPart.RowMod = 'U' or ttPart.RowMod = 'A') , each UD04 where UD04.Company = ttPart.Company and UD04.Key1 = ttPart.IUM no-lock

Has anyone else run across this and if so how did you resolve the problem?

I have cleaned up the UOM fields in anticipation of converting to Epicor 9 and I would like to keep them clean.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas

[Non-text portions of this message have been removed]
7
BPMs are on methods not the table. so when you change something on the plant
tab you are bumping the partservice.update method which is in turn firing
your BPM.



Turn on tracing and check out the data set. Your BPM is probably working and
telling you that what ever UOM is in the part is not valid.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charles Carden
Sent: Monday, September 28, 2009 9:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM question





Version 8.03.408b.

I have a BPM pre-processing directive on the Part table that checks the Unit
of Measure against a user defined table for validity. This works very well
except that when I make changes to one of the related Part tables, e.g. Part
Plant table, it triggers the BPM and the exception message is given as if
the UOM is invalid. The directive uses a simply query to check validity. I
assume there is something I am missing here since it appears updating one of
the related Part tables signals an update to the Part Table without the
"ttPart" data being available.

This is my query:

for each ttPart where (ttPart.RowMod = 'U' or ttPart.RowMod = 'A') , each
UD04 where UD04.Company = ttPart.Company and UD04.Key1 = ttPart.IUM no-lock

Has anyone else run across this and if so how did you resolve the problem?

I have cleaned up the UOM fields in anticipation of converting to Epicor 9
and I would like to keep them clean.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas

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





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



You are correct that multiple tables trigger the Part.Update method(13
tables in Epicor 9).

You will need a "For each tt?????" for every table you want the UOM
Validation to run.



Hope this helps,



Thank you,



Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner



RAM Software Systems, Inc.

Richardson,TX

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charles Carden
Sent: Monday, September 28, 2009 8:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM question





Version 8.03.408b.

I have a BPM pre-processing directive on the Part table that checks the
Unit of Measure against a user defined table for validity. This works
very well except that when I make changes to one of the related Part
tables, e.g. Part Plant table, it triggers the BPM and the exception
message is given as if the UOM is invalid. The directive uses a simply
query to check validity. I assume there is something I am missing here
since it appears updating one of the related Part tables signals an
update to the Part Table without the "ttPart" data being available.

This is my query:

for each ttPart where (ttPart.RowMod = 'U' or ttPart.RowMod = 'A') ,
each UD04 where UD04.Company = ttPart.Company and UD04.Key1 = ttPart.IUM
no-lock

Has anyone else run across this and if so how did you resolve the
problem?

I have cleaned up the UOM fields in anticipation of converting to Epicor
9 and I would like to keep them clean.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas

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




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
9
I figured out how to resolve the problem. By anding the condition "there is at least one updated row in the ttPart table" with the query condition everything works as needed.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas
----- Original Message -----
From: Dale Schuerman
To: vantage@yahoogroups.com
Sent: Monday, September 28, 2009 9:20 AM
Subject: RE: [Vantage] BPM question


Charles,

You are correct that multiple tables trigger the Part.Update method(13
tables in Epicor 9).

You will need a "For each tt?????" for every table you want the UOM
Validation to run.

Hope this helps,

Thank you,

Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner

RAM Software Systems, Inc.

Richardson,TX

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charles Carden
Sent: Monday, September 28, 2009 8:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM question

Version 8.03.408b.

I have a BPM pre-processing directive on the Part table that checks the
Unit of Measure against a user defined table for validity. This works
very well except that when I make changes to one of the related Part
tables, e.g. Part Plant table, it triggers the BPM and the exception
message is given as if the UOM is invalid. The directive uses a simply
query to check validity. I assume there is something I am missing here
since it appears updating one of the related Part tables signals an
update to the Part Table without the "ttPart" data being available.

This is my query:

for each ttPart where (ttPart.RowMod = 'U' or ttPart.RowMod = 'A') ,
each UD04 where UD04.Company = ttPart.Company and UD04.Key1 = ttPart.IUM
no-lock

Has anyone else run across this and if so how did you resolve the
problem?

I have cleaned up the UOM fields in anticipation of converting to Epicor
9 and I would like to keep them clean.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas

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

########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################

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





[Non-text portions of this message have been removed]
10
I am trying to set a field to 0. I attempted the following line of BPM code and its inserting the data as NULL, the SQL data shows that it should be either a 0 or 1 since the DATATYPE is TINYINT.

here's what i tried and none worked. any suggestions?
run lib\updatetablebuffer.p(input BUFFER QuoteHed:HANDLE, 'CheckOff1','False').
run lib\updatetablebuffer.p(input BUFFER QuoteHed:HANDLE, 'CheckOff1',False).
run lib\updatetablebuffer.p(input BUFFER QuoteHed:HANDLE, 'CheckOff1','0').
run lib\updatetablebuffer.p(input BUFFER QuoteHed:HANDLE, 'CheckOff1',0).
11
What bo/method are you running from.... Is the quote head outside the
transaction set? (i.e. this bpm is not called from the quoteform)
assuming you are working from the quote form.. your line would be



Assign ttquotehed.CheckOff1 = False.



Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of rec0rder
Sent: Tuesday, January 25, 2011 1:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM question





I am trying to set a field to 0. I attempted the following line of BPM
code and its inserting the data as NULL, the SQL data shows that it
should be either a 0 or 1 since the DATATYPE is TINYINT.

here's what i tried and none worked. any suggestions?
run lib\updatetablebuffer.p(input BUFFER QuoteHed:HANDLE,
'CheckOff1','False').
run lib\updatetablebuffer.p(input BUFFER QuoteHed:HANDLE,
'CheckOff1',False).
run lib\updatetablebuffer.p(input BUFFER QuoteHed:HANDLE,
'CheckOff1','0').
run lib\updatetablebuffer.p(input BUFFER QuoteHed:HANDLE,
'CheckOff1',0).





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

I am trying to create a BPM that will force users to select a Customer ID from a drop down list, rather than typing in their own text.

The drop down list is a UD field (Part.ShortChar06) which is populated with the Customer ID from a BAQ.

In my BPM I wanted my condition to read "the ttPart.ShortChar06 field of the changed row is not equal to (a value from the drop down list) then the action would display an error message. I am not sure how to accomplish the "not equal to a value from the drop down list"

Any suggestions?  Please and thanks in advance.

Carol

13
You can just restrict the drop-down to not allow typing... Its a property in the EpiComboBox


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Jan 14, 2015 at 10:24 AM, cmpelows@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p><span></span></p><p>I am trying to create a BPM that will force users to select a Customer ID from a drop down list, rather than typing in their own text.</p><p>The drop down list is a UD field (Part.ShortChar06) which is populated with the Customer ID from a BAQ.</p><p>In my BPM I wanted my condition to read &quot;the ttPart.ShortChar06 field of the changed row is not equal to (a value from the drop down list) then the action would display an error message. I am not sure how to accomplish the &quot;not equal to a value from the drop down list&quot;</p><p>Any suggestions?  Please and thanks in advance.</p><p>Carol</p><p></p>

</div>
 


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

14
Thanks Jose for your response.  I am using the BAQ combo, but am not seeing anything that would restrict typing text in the properties.
15

You have to hard code it. I think the property is DropDownStyle google it it’s part of the base MS Control I believe.

 

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: Wednesday, January 14, 2015 11:10 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BPM question

 

 

Thanks Jose for your response.  I am using the BAQ combo, but am not seeing anything that would restrict typing text in the properties.

16
I am creating BPM to Stop Shipment if a checkbox is not checked.  The problem is the check box is on the OrderHed.  When I got to create the BPM ttOrderHed is not an option.  Is there a way to add this tt?

I already have the checkbox displayed on ShipEntry using a Foreign key view.

I am thinking I may have to populate a checkbox on ShipHed from Order....

Any thoughts??

Thanks Kim
17

I use a post processing bpm on CustShip.GetMainfest Info to transfer Order information. You could transfer the check box there or possibly throw an error.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, August 24, 2016 3:31 PM
To: yahoogroups
Subject: [Vantage] BPM question

 

 

I am creating BPM to Stop Shipment if a checkbox is not checked.  The problem is the check box is on the OrderHed.  When I got to create the BPM ttOrderHed is not an option.  Is there a way to add this tt?

 

I already have the checkbox displayed on ShipEntry using a Foreign key view.

 

I am thinking I may have to populate a checkbox on ShipHed from Order....

 

Any thoughts??

 

Thanks Kim



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."
18

On the Order Entry Summary there is a HOLD checkbox.

 

Note: If the Allow Shipments for Orders on Hold check box has been cleared for this company in the Company Configuration - Modules - Materials - Shipping/Receiving sheet, this prevents processing of shipments for sales orders that have been placed on hold. This affects shipment programs such as Customer Shipment Entry throughout the Epicor application. Sales order holds must first be removed in order to process shipments.

 

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, August 24, 2016 12:31 PM
To: yahoogroups <vantage@yahoogroups.com>
Subject: [Vantage] BPM question

 

 

I am creating BPM to Stop Shipment if a checkbox is not checked.  The problem is the check box is on the OrderHed.  When I got to create the BPM ttOrderHed is not an option.  Is there a way to add this tt?

 

I already have the checkbox displayed on ShipEntry using a Foreign key view.

 

I am thinking I may have to populate a checkbox on ShipHed from Order....

 

Any thoughts??

 

Thanks Kim



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.