ahh ok try adding in most or all of the std cost fields with the AND connection…so in the end you should have:
- StdMaterialUnitCost = 0
and - StdLbrUnitCost = 0
and - StdBurdenUnitCost = 0
and - StdSubUnitCost = 0
A much easier method, but im sure there was a reason i didnt use it in the past, or maybe not lol, is to use the total cost field from cost management. so in your query replace StdMaterial with StdTotUnitCost = 0. this does the same thing as my 4 item list above but just with one field.
Whichever way you choose, now a row will only be added to your query if all of those cost fields are blank. because obviously some parts can have 0 material cost or 0 subcontract cost etc etc. This way only something with truly zero cost should throw the exception. let me know how that works for you.
