BAQ to verify methods on Jobs

ERP 9
#1

Does any one have a good SQL query or BAQ that will show if the wrong plant method (Ops/Resources) are on a Job? If not what are the best table to pull for this info.

thanks kim

#2

I’m not sure about E9, but in E10, there is the ability to show info about a field on a form.

put the cursor in the form’s field, then choose Technical Details in the Field Help pane.

#3

Here is a simple BAQ I use to list ResourceGrps, Resources and Capabilities.

  • from OpMasDtl or JobOpDtl

I’m not sure how you’ll determine which plant your resource resides.