Thanks! it worked for what i need it!
--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Yes, the tracer will lead you off in the wrong direction.
> I keep this old Epicor TechTip on hand to remind me.
>
>
> Page 5717MPS
>
> Problem:
> Trying to do a BAQ and trying to get a list of parts with various fields
> Needs to locate the the field for primary bin for parts
>
>
> What you need to do to access the primbin field (PrimBinNum) is link the plantwhse and partbin tables to get the primbin for the part. The plantwhse table stores the primary bin field and the partbin table holds the on hand qty for the part. If you have any questions about how to link the tables together you would need to talk to tech support.
>
>
> Second Problem:
> Need to locate the field for the primary warehouse for a part.
>
> Resolution:
> The primary warehouse for a part is stored in the PartPlant table in the PrimWhse field. The PartPlant table can be linked to the Part table.
>
> An exampled BAQ query statement would look like:
> for each Part no-lock , each PlantWhse where (Part.Company = PlantWhse.Company and Part.PartNum = PlantWhse.PartNum) no-lock , each PartBin where (PlantWhse.Company = PartBin.company and PlantWhse.PartNum = PartBin.PartNum and PlantWhse.WarehouseCode = PartBin.WarehouseCode and PlantWhse.PrimBin = PartBin.BinNum) no-lock
>
> --- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@> wrote:
> >
> > Nope
> >
> >
> >
> > Thanks,
> >
> > Blake Clemens
> >
> > IT Systems Engineer
> >
> > Delmarva Millwork Corporation
> >
> > (800) 360-2364 x132
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of liss_c
> > Sent: Thursday, July 28, 2011 1:10 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Part Dataset - PartWhse.PrimBinNum
> >
> >
> >
> >
> >
> > I was just working on this right now. Where you able to figured it out?
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Blake Clemens" <blake.clemens@> wrote:
> > >
> > > I am writing a query... can anyone tell me why I am unable to pull the
> > > PrimBinNum field in the PartWhse table?
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Blake Clemens
> > >
> > > IT Systems Engineer
> > >
> > > Delmarva Millwork Corporation
> > >
> > > (800) 360-2364 x132
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>