BPM unchecking Purchase Direct on JobMtl

[hkeric.wci (Haso Keric)]

@Nancy_Hoyt

image639×579 23.8 KB

Do not join ttTable to a Real table. Epicor will pull in ALL Database records into memory before it filters it.

Joining "TT" records to regular DB records in BPMs

Right it should have returned no results. But I will try it with part and see if it makes a difference

BPM SPEED Helpful Hint - be careful how you "Join"

Help Hint for you all… I have been doing some refactoring of BPMs for efficiency. Finding mistakes made from prior sins of myself and others. You can probably find some ways to improve your end user’s experience by doing some of these same changes… note that this refactoring takes about 5 minutes, but saves users lots of frustrations. THIS example is applicable to all users (including Cloud). Also, as an encouragement to those NOT attending Insights… I learned about the need for this trick last…

As for will Epicor ever fix the behind the scenes generated code… unsure cc: @timshuwy