What is the JobProdSearch adapter?
--- In vantage@yahoogroups.com, "Kirstin Brandt" <kirstin.brandt@...> wrote:
>
> Depending on how you're doing this, you can use the JobProdSearch adapter which will get you a MakeToType column or, if you're just trying to create a simple BAQ, you can use a calculated field with the expression:
>
> if JobProd.OrderNum = 0 and JobProd.TargetJobNum = "" then "Stock" else if JobProd.OrderNum = 0 then "Job" else "Order"
>
> --- In vantage@yahoogroups.com, "Virginia Joseph" <vjoseph@> wrote:
> >
> > I haven't been able to find a single "Make to..." field but you could use various fields in the JobProd Table.
> >
> > JobProd.OrderNum field would tell you the sales order number for a make to order job. The JobProd.TargetJobNum field would tell you the job for which this job is making parts to define make to job. The JobProd.WarehouseCode and JobProd.PartNum can be used for make to stock jobs. The jobProd.WarehouseCode is only relevant for build to stock demands (ordernum = 0)and a valid Part must be referenced in JobProd.PartNum.
> >
> > I know it would be much simpler to find the magic "Make to..." field so if anyone knows where it is, please post!
> >
> >
> > Virginia Joseph
> > Deep Hole Specialists, LLC
> > 440-543-8157
> > vjoseph@
> >
> >
> > --- In vantage@yahoogroups.com, "brucewbrannan" <bruce.brannan@> wrote:
> > >
> > > The Inspection Pending Report in 8.03 is a progress report. I've been asked to recreate showing where each part's destination is, as in, at the Job, was it flagged to Make to Stock, Make to Order, Make to Job, etc. I've successfully extracted all part quantities that are pending inspection but can't find where the Make to ??? is located. Any help is much appreciated.
> > >
> >
>