I am try to create a BPM that needs to query data. For example, when someone creates an order I want a message to pop up if that customer is located outside of the USA.
What components do i need to use in the BPM designer?
Thanks!
This and many other topics like it are covered in-dept with examples in the Ice Customization and Experience guides available in Epic Web.
https://epicweb.epicor.com/doc/Docs/EpicorCustomization_UserGuide_102200.pdf
https://epicweb.epicor.com/doc/Docs/EpicorICETools_UserGuide_102200.pdf
https://epicweb.epicor.com/doc/Docs/Epicor10_ConvertedCode_ProgrammingGuide_102200.pdf
I suggest some thorough study of these and come back to us if you still have questions after 
2 Likes
The documents you sent me have good information. However, I cannot find anything to helps me accomplish my goal.
Displaying a MessageBox on a BPM is definitely covered in those documents.
Displaying a message box i knew how to do before I created this post. I need it to query data about a customer in an order. If the queried data matches a condition, then i have the message box pop up. Does this make sense.
there is a criteria in the conditions for making a query, and if the row exists, do something.
1 Like
The Help Files are also available and accessible online.
Hope that helps
Use a condition element, choose the number of rows in the designed query is not less than one. Use the baq editor to create a query to verify the country of origin is outside the US. The help documents mentioned by previous and subsequent posters covers creating BAQ’s.
Not for BPMs
Dang, thats going to make it tough
So here is my workflow:
This is my conditional query and criteria:
My message pops up for any Supplier I choose:
What could I be doing wrong? I figure its the query, but I cannot preview the query to see what exactly its showing.
Are you multi-company?
Yes.
ok what does your relationship between Vendor and ttPO look like? Click on the Line
What method is this running on?
Have you put the results for the TT table into your message box? I’d be curious to see what lines are being returned.
2 Likes
Erp.PO.Update
Pre-Processing
You want that message to pop up everytime record is saved? If not, your going to need criteria for added rows.