Hi Everyone, I’m trying to build a BPM which seems simple but couldn’t get it to work. I wanted to restrict user from receiving PO which is marked as Hold. I created a BPM on receipt.updatemaster and created a condition to detect orderheld = true, then prompt an error, but it doesn’t seem to work…

That’s still the same. More like this: [morelikethis1] [morelikethis2] dsRcvHeadRow will be tt something in yours.

You need to be linking ttRecvHed with Pohead on ponumber and check pohead held

oh silly me, didn’t notice that. you saved me once again :sweat_smile:

[image] klincecum: You need to be linking ttRecvHed [image] E10 BPM Slow due to Join? Epicor ERP 10 @knash that same issue does apply to custom code. You should NEVER EVER NEVER join to a ttTable. Weren’t you at our talk? Did ya fall asleep? LoL In this case though…

Full Analysis of Why [image] Joining "TT" records to regular DB records in BPMs Experts' Corner Ran it in 10.2.100.5 with the Same Results First Test: [image] Ran SQL Profiler Yielded the following SQL Statement SELECT 1 AS [C1], [Extent1].[Company] AS [Comp…

[image] josecgomez: Full Analysis of Why Nice research. I understand, but I don’t quite agree with “never, never, never” :slight_smile: This wasn’t performance dependent, (well at least I don’t think so?) and was easy to understand. But yes, pulling out the primitive and using it in a where…

[image] klincecum: but I don’t quite agree with “never, never, never” :slight_smile: [image]

if you are joining a TT table to the ABCCode table, then the join probably doesn’t matter, and you can do it… you will not see a performance hit that is measurable. If you are joining a TT table to the PartTran table, then you might see a huge performance hit due to the number of records in PartTra…

[image] timshuwy: joining a TT table to the PartTran table [mother of god danger GIF]

And that’s why I say “never ver never never never never never” because if you get used to drawing that little arrow between two boxes which is easy and painless one day you are going to draw it between PartTran and LaborDtl and ttLaborHed your server will catch on fire :joy: [it crowd maurice moss …

:grimacing: , can someone advice the proper way for my scenario if there is a risk of performance degradation by joining the TT table?

BPM enquiry

Epicor ERP 10

josecgomez (Jose C Gomez) March 3, 2023, 1:28pm 5

Full Analysis of Why

Topic		Replies	Views
BPM - Stop Receipt when PO is on Hold Epicor ERP 10	14	3257	June 20, 2017
BPM for Warning Message on Duplicate PO Epicor ERP 10	35	6888	February 21, 2019
BPM More Than One Record Error - Help Needed Epicor ERP 10 e10 , bpm	21	6700	December 21, 2020
BPM condition only working on first save Epicor ERP 10 bpm	10	2105	May 19, 2022
BPM with AND Conditions Epicor ERP 10 e10	3	568	May 9, 2023

BPM enquiry

Related topics