BPM auto set pull as assembly unless part is Purchased

Kinetic ERP
1

Hello,
I have a super simple BPM that will set any part added to a BOM to pull-as-assembly if the part number begins with the letter G which works great. The only piece I’m missing is that if the part is purchased, don’t do that and I’m not sure how to do it. I’m not strong in the BPM area so if someone could explain it to me as if I was a 5-year-old, that would be greatly appreciated. Here is what I have at present which is working as intended:

image
image298×577 24.7 KB

2

You want to filter on the field Part.TypeID. I think you want TypeID = “P”. You could add this to your criteria widget. You may have to add the Part table to your criteria. I am not sure if your criteria is based on a query, but you could add the Part table and criteria to that query.

3

I understand that much, I’m just not sure how to actually do it.
Right now the condition is if the ttECOMtl.MtlPartNum of the changed row begins with G, do what I say. I’m not sure how to add the part table to it as well to be able to pull the type code.

4

Can you screenshot your condition details?

5

Sure thing:

image
image736×137 13.8 KB

6

I see now. I think you have to add a query to your condition, but I am not fluent enough to walk you through each step. If you export your directive using Directive Export, then I can look at it on my end and I will let you know what to change.

7

Attached a zip file with the export from Solution Workbench. I appreciate you taking the time to look at it!

G-Pull-BPM_Customer Solution_4.1.200.0.zip (28.3 KB)

Edit: I should have actually read what you asked for. Here is the directive export:
export.bpm (37.1 KB)

8

I am not sure if this is 100%, but it should get you closer.

export.bpm (49.1 KB)
I replaced your original criteria with a query to check for mtlpartnums that start with G and where the part typeID is P.
I don’t have your data so I can’t test it on my end.
I hope this helps get you in the right direction.

1 Like
9

Thanks a lot for this! I only had to make a slight adjustment to line up with what I needed it to do and it works perfectly. Never would’ve figured that out on my own. I appreciate it!

1 Like