BAQ Job Demand Type

Hello everybody,

I am trying to make a BAQ that tracks our open Make To Stock jobs, but I cannot seem to find that field that dictates what type of demand the job has. Where would that be located?

Thanks!

I believe you are meant to glean that information from the JobProd table.

If it is make to stock you will have data in the WarehouseCode field.
If it is make to order you will have data in the order num/line/release fields
If it is make to job you will have data in the target job/assembly/material fields.

2 Likes

Also, remember jobs can have more than one demand linked to it. So you could for example, have one job that feeds 2 orders directly, as well as a make to stock demand. So a job doesn’t really have a singular type, and as @hackaphreaka mentioned, the types of demand are stored in the JobProd table.

2 Likes

If you are making the Job to Stock, check the part.nonstock field.

1 Like

read that again @Patrick , but slower…

if stock check non-stock

how does that work?

1 Like

Thanks everyone! I appreciate the help :smiley:

1 Like

Wow, I did phrase that horribly.