BAQ Job Demand Type

Kinetic ERP
1

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!

2

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
3

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
4

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

1 Like
5

read that again @Patrick , but slower…

if stock check non-stock

how does that work?

1 Like
6

Thanks everyone! I appreciate the help :smiley:

1 Like
7

Wow, I did phrase that horribly.