That's correct, the Customization Tools Dialog->Tools->Object explorer/adapters/Get Adapters is useful to see what adapters are available and their tables, properties and methods. Although you will need to create a reference to an adapter if it doesn't already exist in your customization. That's where you will use Customization Tools Dialog->Tools->Assembly Reference Manager.
--- In vantage@yahoogroups.com, Bill Wu <billw@...> wrote:
>
> You can also go through Customization Tools Dialog->Tools->Object explorer/adapters/Get Adapters. It will list all adapters from Epicor. The list may need some time to show up because there are a lot of adapters.
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of zanniebelle
> Sent: Wednesday, October 27, 2010 1:32 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Adapter to retreive BOM (PartMtl) List
>
>
>
> In the Customization Tools Dialog->Tools->Wizards->Customization Wizards..., I used the wizard "Add User Defined Table As Child" and then reviewed the code it created. I use the sample code as a guide to create other Adapters as needed.
>
> If the Adapter you want to use does not already exist in your BO then you have to first make a reference to it using Customization Tools Dialog->Tools->Assembly Reference Manager to add a custom one.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "cooner_55421" <cooner_55421@> wrote:
> >
> > Just wondering where you found information on setting up adapters?
> > I've never made one before.
> > This thread has given me some ideas I'd like to try.
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Bill Wu <billw@> wrote:
> > >
> > > You can try this,
> > >
> > > BOM.Tables("PartMtl").Select("","PartNum Desc")
> > >
> > > The first parameter is blank wwhich will return all rows in the table. The 2nd parameter is your sorting criteria. I'm using PartNum as an example, you can use BOMlevel number to make it fully-indented.
> > >
> > > ________________________________
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Brian W. Spolarich
> > > Sent: Wednesday, October 27, 2010 9:53 AM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] Re: Adapter to retreive BOM (PartMtl) List
> > >
> > >
> > >
> > > Out of curiousity, how would you sort the data in the returned DataSet
> > > so that you could get the fully-indented BOM in order? I wrote a SQL
> > > query to do this and had to construct a SortKey field based on BOMLevel
> > > and a zero-padded MtlSeq to make it work.
> > >
> > > -bws
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
> > > Of Bill Wu
> > > Sent: Wednesday, October 27, 2010 9:50 AM
> > > To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com><mailto:%27vantage%40yahoogroups.com>'
> > > Subject: RE: [Vantage] Re: Adapter to retreive BOM (PartMtl) List
> > >
> > > Here is working sample code. LE41A is our part number and
> > > B32-A is the rev. last True will give you full tree. There are four
> > > tables in the returned dataset, PartMtl is one of them.
> > >
> > > Dim adpBOM as BOMSearchAdapter = New BOMSearchAdapter(PartForm)
> > > adpBOM.Boconnect()
> > >
> > > Dim BOM as BOMSearchDataSet = adpBOM.BOMSearchData
> > > Dim SomethingFound as boolean =
> > > adpBOM.GetAllAlternateTrees("LE41A","B32-A",True,Date.Today,True)
> > > If SomethingFound then
> > >
> > > MessageBox.show(BOM.Tables("PartMtl").Rows.Count.Tostring)
> > > Else
> > > MessageBox.show("Bad part number
> > > encountered.","Warning",messageBoxbuttons.OK,messageboxicon.Error)
> > > end if
> > >
> > > ________________________________
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
> > > Of zanniebelle
> > > Sent: Wednesday, October 27, 2010 8:03 AM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Adapter to retreive BOM (PartMtl) List
> > >
> > > Hi Robert,
> > > Thanks for replying. I don't know what you mean "bring in". I'm looking
> > > to use an Adapter to get to the PartMtl table. The only one, I can find,
> > > that contains the table is the BOMSearchAdapter, but it's search
> > > functions (InvokeSearch, GetRows and GetList) fail with an error that
> > > states the method is not supported in this adapter.
> > >
> > > Thanks,
> > >
> > > Ray
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>,
> > > robertb_versa@ wrote:
> > > >
> > > >
> > > > It seems to me you'd need to bring in Partplant, PartRev PartMtl & the
> > > part OpDtl (et al) search by ID searches as you wash out more & more
> > > junk w/ improved searches (built upon the lessons learned from the past
> > > lessons) and you clean more and more junk from each successive resolt
> > > (you wash out more and more junk w/ each successive effort
> > > >
> > > > --- Original Message ---
> > > > From:"zanniebelle" <rwatson@>
> > > > Sent:Tue 10/26/10 2:58 pm
> > > > To:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > > > Subj:[Vantage] Adapter to retreive BOM (PartMtl) List
> > > >
> > > > Hi All,
> > > > I'm looking for an Adapter that I can use in a customization to
> > > retrieve the BOM list for a given part/revision. I tried the
> > > BOMSearchAdapter, but can't seem to get InvokeSearch, GetRows or GetList
> > > to work (they all say function is not supported in this Adapter).
> > > >
> > > > I also tried to to create a parent/child relationship, which also
> > > fails.
> > > >
> > > > Any help would be appreciated!
> > > >
> > > > Thanks,
> > > >
> > > > Ray
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > ------------------------------------
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > > have already linked your email address to a yahoo id to enable access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > > and Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/><http://groups.yahoo.com/group/vantage/files/>
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
> [Non-text portions of this message have been removed]
>