It uses the rev with the newest effective date.
________________________________
From: Jeff Rogers <jeff.rogers@...>
To: vantage@yahoogroups.com
Sent: Tuesday, January 10, 2012 5:38 PM
Subject: [Vantage] Re: BOM's
Â
Does anyone know how/where Vantage determines which mtlpart revision a BOM for a particular part and revision uses? The partmtl table gives you the parent partnum and revisionnum, but only the child partnum (not the child revisionnum).
________________________________
From: Jeff Rogers <jeff.rogers@...>
To: vantage@yahoogroups.com
Sent: Tuesday, January 10, 2012 5:38 PM
Subject: [Vantage] Re: BOM's
Â
Does anyone know how/where Vantage determines which mtlpart revision a BOM for a particular part and revision uses? The partmtl table gives you the parent partnum and revisionnum, but only the child partnum (not the child revisionnum).
--- In vantage@yahoogroups.com, "Lynn Thomas 83" <thomasl@...> wrote:
>
> OK, thanks. I finally found where/how to connect to those published
> columns, with less-than-usual-for-me head banging. This dashboard is
> a wonderful thing! I've added a query to show me the stock status for
> the parts associated with the BOM, and the combination will make one
> my users just sit there and cry [he's been pinging on me, and seems to
> have a bad case of ADD when it's time to hear answers, or give
> detailed explanations of what he wants so that I can find or make a
> solution....]
>
> Now to beat the demand into submission...
>
> Thank you!
>
> Lynn
>
> --- In vantage@yahoogroups.com, "andrew.tapper" <atapper@> wrote:
> >
> > The first BAQ is the BOM Parent BAQ and it is publishing the
> > PartMTL.PartNum and PartMTL.RevisionNum. The 2nd through 8th BAQs
> are the BOM MTL BAQs.
> >
> > The 2nd BAQ is filtered on the published info from the BOM Parent
> BAQ. This becomes the "1st" level of the BOM display. The 2nd BAQ
> publishes PartMtl.MtlPartNum (which is the highlighted line of the 1st
> level) to the 3rd BAQ to make the 2nd level of the BOM display.
> >
> > This pattern then repeats itself for as many levels you want to set
> up your dashboard to display.
> >
> > Sorry it has taken me so many posts to explain this. I guess I am
> not good enough at this yet to explain it.
> >
> > Andrew
> >
> > --- In vantage@yahoogroups.com, "Thomas, Lynn A." <thomasl@> wrote:
> > >
> > > Andrew,
> > >
> > > How, or maybe where, do you have the first BAQ feeding into the
> > second? I've looked at your queries and the dashboard, but that bit
> > eludes me. The XML files didn't help, either. I'm learning how to
> > read them but it's a slow process.
> > >
> > > I like your dashboard, and it could be very useful to my users, but
> > we need a bit of warehouse and part-on-hand information too. I
> > _think_ I know how to add it, but I don't want to mess with that
> > existing relationship, nor get caught in the works.
> > >
> > > Thank you!
> > >
> > > Lynn Thomas
> > > Senior Engineer
> > > SAIC
> > > 317-357-4041 X255
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
[Non-text portions of this message have been removed]