BAQ Needed to identify parts without Method of Manufacture

Kinetic ERP
1

Need to identify any Manufactured parts that do not have operations and material (Method) built in system.

2

This should do it:

image
image1147Ă—854 164 KB

3

Throw a PartType=“M” in to get only the Manufactured parts.

4

Oops, thanks @gpayne . Updated screencap:

image
image1241Ă—813 128 KB

5

Thank you for the quick response… and a great one too! Always a matter of what Table to join!
ESS_0000-02.baq (8.0 KB)

6

Got it! Did it! Thanks!