Customization V8.03-From Supplier to Sales Order

system · December 12, 2006, 9:28pm

Check out sub process menu maintenance

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: 12 December 2006 21:37
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customization V8.03-From Supplier to Sales Order

I tried it out and see what you mean. Other Customizations I have
done for 'called' forms always have called a menu item, whether it
was visible on the menu or not. This one does not. I'm afraid I do
not have an answer.

Sorry...

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"laidig.systems" <laidig.systems@...>
wrote:

>
> I'm not sure what you mean by that. Let me explain what I have
> already done. In developer mode, i open the Sales Order Form, i

make

> a sales order and go to File>New>New Line From Quote. The window

that

> pops up is Epicor.Mfg.UI.App.SalesOrderEntry.LineFromQuoteForm and i
> have customized this for. In the Menu Maintenance, i wanted to link
> my new customization to this menu for all of the users who are not

in

> Developer Mode. I don't know what "program" in the menu

maintenance

> to link my new customization to since it was not originally in the
> menu. I can find my new customization under the SalesOrderEntry.dll
> Program but it doesn't do anything when i link my customization to
> that. I have looked in our SQL server for the table where the menus
> and customizations are stored but i can't find the correct table.

The

> only table i found was the Menu table and that just showed the

parents

> and sequence of the menus. If you need any other information, just
> let me know. Thanks so much for all your help.
>
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,

"bw2868bond" <bwalker@> wrote:

> >
> > While in developer mode, do whatever it is that calls the second

form

> > and make note of the menu id called - at least in V8.00
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,

"laidig.systems"
<laidig.systems@>

> > wrote:
> > >
> > > I looked in the menu table in my db and there isn't any

reference to

> > > the App.SalesOrderEntry.LineFromQuoteForm. How do i find this

form

> > in
> > > my menu? I didn't see any items in the menu that were marked

with

> > > "DoNotDisplayInMenu" either. Am I looking in the wrong place?
> > >
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

, "bw2868bond" <bwalker@> wrote:

> > > >
> > > > They *are* in the menu structure, but hidden from view. One

would

> > think
> > > > that there would be an option to view the hidden items maybe

on

> > the
> > > > Menu Maintenance actions menu. To assist in deploying
> > customizations to
> > > > the 'hidden from menu' forms.
> > > >
> > > > It is possible to mess up the menu system to the point where
> > Vantage
> > > > will not launch so extreme care must be used when altering

the

> > menu
> > > > table to allow the hidden item to be un-hidden so that a
> > customization
> > > > can be specified and then re-hidden.
>

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=53624/stime=1165959726/nc1=3848544/nc2=3848640/nc3=3>

[Non-text portions of this message have been removed]

system · December 5, 2006, 10:13am

I am trying to write a customization that will take a supplier number
entered into the OrderDtl table in Character05 and display the Vendor
Name that was entered into the Supplier Master table. I have written
the following code. I think everything is ok with connecting to the
VendorDetail table but my problem is after the "Try" statement. Any
help would be appreciated.

Dim VendDtlAdapt As VendorAdapter = New VendorAdapter(SalesOrderForm)
VendDtlAdapt.BOConnect()
Dim soVendID As String =
edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
'msgbox("Get by ID Num: " & soVendID)
VendDtlAdapt.GetByID(soVendID)
'msgbox("Get by ID Found " & VendDtlFound)
Try
Dim dsVendDtl As EpiDataView =
CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
Dim VendName As String = dsVendDtl.dataView(dsVendDtl.Row)("Name")
msgbox(VendName)
Catch e As Exception
msgBox(e)
Finally
VendDtlAdapt.Dispose()
End Try

system · December 5, 2006, 11:37am

It may be easier to use the 'listlookup'

do a search in help for listlookup and read through the custom
example - standard comments

You should be able to easily change the code example given to the
vendoradapter

hth

--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:

>
> I am trying to write a customization that will take a supplier

number

> entered into the OrderDtl table in Character05 and display the

Vendor

> Name that was entered into the Supplier Master table. I have written
> the following code. I think everything is ok with connecting to the
> VendorDetail table but my problem is after the "Try" statement. Any
> help would be appreciated.
>
> Dim VendDtlAdapt As VendorAdapter = New VendorAdapter

(SalesOrderForm)

> VendDtlAdapt.BOConnect()
> Dim soVendID As String =
> edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
> 'msgbox("Get by ID Num: " & soVendID)
> VendDtlAdapt.GetByID(soVendID)
> 'msgbox("Get by ID Found " & VendDtlFound)
> Try
> Dim dsVendDtl As EpiDataView =
> CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
> Dim VendName As String = dsVendDtl.dataView(dsVendDtl.Row)

("Name")

> msgbox(VendName)
> Catch e As Exception
> msgBox(e)
> Finally
> VendDtlAdapt.Dispose()
> End Try
>

system · December 5, 2006, 3:34pm

That worked great. I didn't know about the ListLookUp function. Thanks!

system · December 5, 2006, 3:58pm

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
So how could that work for a child key? For instance
Customer Is Key1 and Child Key is some other Number that tied to
specific Child Table Data
Would that be done in the whereclause?

>
> It may be easier to use the 'listlookup'
>
> do a search in help for listlookup and read through the custom
> example - standard comments
>
> You should be able to easily change the code example given to the
> vendoradapter
>
> hth
>
>
> --- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@>
> wrote:
> >
> > I am trying to write a customization that will take a supplier
> number
> > entered into the OrderDtl table in Character05 and display the
> Vendor
> > Name that was entered into the Supplier Master table. I have
written
> > the following code. I think everything is ok with connecting to
the
> > VendorDetail table but my problem is after the "Try" statement.
Any
> > help would be appreciated.
> >
> > Dim VendDtlAdapt As VendorAdapter = New VendorAdapter
> (SalesOrderForm)
> > VendDtlAdapt.BOConnect()
> > Dim soVendID As String =
> > edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
> > 'msgbox("Get by ID Num: " & soVendID)
> > VendDtlAdapt.GetByID(soVendID)
> > 'msgbox("Get by ID Found " & VendDtlFound)
> > Try
> > Dim dsVendDtl As EpiDataView =
> > CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
> > Dim VendName As String = dsVendDtl.dataView(dsVendDtl.Row)
> ("Name")
> > msgbox(VendName)
> > Catch e As Exception
> > msgBox(e)
> > Finally
> > VendDtlAdapt.Dispose()
> > End Try
> >
>

system · December 5, 2006, 5:36pm

He was doing a lookup on a totally unrelated table using a value
entered into a user defined field.

You can do a listlookup on almost any BO that only takes one
whereclause parameter. The whereclause itself can have multiple
conditions...

If you have a particular lookup in mind, I will try to help...

--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:

>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> So how could that work for a child key? For instance
> Customer Is Key1 and Child Key is some other Number that tied to
> specific Child Table Data
> Would that be done in the whereclause?
>
> >
> > It may be easier to use the 'listlookup'
> >
> > do a search in help for listlookup and read through the custom
> > example - standard comments
> >
> > You should be able to easily change the code example given to the
> > vendoradapter
> >
> > hth
> >
> >
> > --- In vantage@yahoogroups.com, "laidig.systems"

<laidig.systems@>

> > wrote:
> > >
> > > I am trying to write a customization that will take a supplier
> > number
> > > entered into the OrderDtl table in Character05 and display the
> > Vendor
> > > Name that was entered into the Supplier Master table. I have
> written
> > > the following code. I think everything is ok with connecting

to

> the
> > > VendorDetail table but my problem is after the "Try"

statement.

> Any
> > > help would be appreciated.
> > >
> > > Dim VendDtlAdapt As VendorAdapter = New VendorAdapter
> > (SalesOrderForm)
> > > VendDtlAdapt.BOConnect()
> > > Dim soVendID As String =
> > > edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
> > > 'msgbox("Get by ID Num: " & soVendID)
> > > VendDtlAdapt.GetByID(soVendID)
> > > 'msgbox("Get by ID Found " & VendDtlFound)
> > > Try
> > > Dim dsVendDtl As EpiDataView =
> > > CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
> > > Dim VendName As String = dsVendDtl.dataView(dsVendDtl.Row)
> > ("Name")
> > > msgbox(VendName)
> > > Catch e As Exception
> > > msgBox(e)
> > > Finally
> > > VendDtlAdapt.Dispose()
> > > End Try
> > >
> >
>

system · December 5, 2006, 6:03pm

Take a look at setting up a foreign key.

I setup UD01 to have part number in key1 and I wanted to display the
part description in my UD01 Maintenance screen.

In customization --> Tools --> Data Tools you create a "Custom Column
Like" (in my case UD01.key1 is like Part.PartNum)

Create a new custom View tying UD01.key1 to Part.PartNum. The fields
are case sensitive so be careful.

When I added the Text field, The new view was a option on the Datasource
property dropdown.

Once the new view was selected and of the part fields were in the
Datafield dropdown. Chose Part description.

Save the customization.

Reload the customization from the menu and description was displayed
when a part number was entered. This required no VB code except to
make the textbox read only.

Hope I understood your requirement and hope this helps.

Dale

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Tuesday, December 05, 2006 2:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customization V8.03-From Supplier to Sales Order

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"bw2868bond" <bwalker@...> wrote:
So how could that work for a child key? For instance
Customer Is Key1 and Child Key is some other Number that tied to
specific Child Table Data
Would that be done in the whereclause?

>
> It may be easier to use the 'listlookup'
>
> do a search in help for listlookup and read through the custom
> example - standard comments
>
> You should be able to easily change the code example given to the
> vendoradapter
>
> hth
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,

"laidig.systems" <laidig.systems@>

> wrote:
> >
> > I am trying to write a customization that will take a supplier
> number
> > entered into the OrderDtl table in Character05 and display the
> Vendor
> > Name that was entered into the Supplier Master table. I have

written

> > the following code. I think everything is ok with connecting to

the

> > VendorDetail table but my problem is after the "Try" statement.

Any

> > help would be appreciated.
> >
> > Dim VendDtlAdapt As VendorAdapter = New VendorAdapter
> (SalesOrderForm)
> > VendDtlAdapt.BOConnect()
> > Dim soVendID As String =
> > edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
> > 'msgbox("Get by ID Num: " & soVendID)
> > VendDtlAdapt.GetByID(soVendID)
> > 'msgbox("Get by ID Found " & VendDtlFound)
> > Try
> > Dim dsVendDtl As EpiDataView =
> > CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
> > Dim VendName As String = dsVendDtl.dataView(dsVendDtl.Row)
> ("Name")
> > msgbox(VendName)
> > Catch e As Exception
> > msgBox(e)
> > Finally
> > VendDtlAdapt.Dispose()
> > End Try
> >
>

########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################

[Non-text portions of this message have been removed]

system · December 5, 2006, 7:08pm

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:

>
> He was doing a lookup on a totally unrelated table using a value
> entered into a user defined field.
>

Here is what I am trying to do. I want to pull in UD Data into
OrderDtl
I have UD110 set up. Key 1 is equal to OrderDtl.CustNumCustID
UD110A the Child Table has Child Key that is equal to
OrderDtl.Character05
I am trying to view the fields in UD110A based on the CustNumCustID &
OrderDtl.Character05
I would appreciate any help.

> You can do a listlookup on almost any BO that only takes one
> whereclause parameter. The whereclause itself can have multiple
> conditions...
>
> If you have a particular lookup in mind, I will try to help...
>
> --- In vantage@yahoogroups.com, "Michael McWilliams"
> <mmcwilliams22@> wrote:
> >
> > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > So how could that work for a child key? For instance
> > Customer Is Key1 and Child Key is some other Number that tied to
> > specific Child Table Data
> > Would that be done in the whereclause?
> >
> > >
> > > It may be easier to use the 'listlookup'
> > >
> > > do a search in help for listlookup and read through the custom
> > > example - standard comments
> > >
> > > You should be able to easily change the code example given to

the

> > > vendoradapter
> > >
> > > hth
> > >
> > >
> > > --- In vantage@yahoogroups.com, "laidig.systems"
> <laidig.systems@>
> > > wrote:
> > > >
> > > > I am trying to write a customization that will take a

supplier

> > > number
> > > > entered into the OrderDtl table in Character05 and display

the

> > > Vendor
> > > > Name that was entered into the Supplier Master table. I have
> > written
> > > > the following code. I think everything is ok with connecting
> to
> > the
> > > > VendorDetail table but my problem is after the "Try"
> statement.
> > Any
> > > > help would be appreciated.
> > > >
> > > > Dim VendDtlAdapt As VendorAdapter = New VendorAdapter
> > > (SalesOrderForm)
> > > > VendDtlAdapt.BOConnect()
> > > > Dim soVendID As String =
> > > > edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
> > > > 'msgbox("Get by ID Num: " & soVendID)
> > > > VendDtlAdapt.GetByID(soVendID)
> > > > 'msgbox("Get by ID Found " & VendDtlFound)
> > > > Try
> > > > Dim dsVendDtl As EpiDataView =
> > > > CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
> > > > Dim VendName As String = dsVendDtl.dataView

(dsVendDtl.Row)

> > > ("Name")
> > > > msgbox(VendName)
> > > > Catch e As Exception
> > > > msgBox(e)
> > > > Finally
> > > > VendDtlAdapt.Dispose()
> > > > End Try
> > > >
> > >
> >
>

system · December 5, 2006, 7:41pm

I have never grasped the concept of the UD parent/child tables.
If someone could give a good example of the use of these tables I
would appreciate it :)

That being said, the UD tables pose a unique problem with using in a
base form. You can not make a foreign Key View to them using the data
tools menu. You can however cause them to appear as a dataview by
using code. There is an example in help that can be found by doing a
search for 'user preferences faqs' and then view the topic about user-
defined tables and foreign-key views

If you can't find it or have problems, reply back - I will check back
here later...

--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:

>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> >
> > He was doing a lookup on a totally unrelated table using a value
> > entered into a user defined field.
> >
>
> Here is what I am trying to do. I want to pull in UD Data into
> OrderDtl
> I have UD110 set up. Key 1 is equal to OrderDtl.CustNumCustID
> UD110A the Child Table has Child Key that is equal to
> OrderDtl.Character05
> I am trying to view the fields in UD110A based on the CustNumCustID

&

> OrderDtl.Character05
> I would appreciate any help.
>
> > You can do a listlookup on almost any BO that only takes one
> > whereclause parameter. The whereclause itself can have multiple
> > conditions...
> >
> > If you have a particular lookup in mind, I will try to help...
> >
> > --- In vantage@yahoogroups.com, "Michael McWilliams"
> > <mmcwilliams22@> wrote:
> > >
> > > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > > So how could that work for a child key? For instance
> > > Customer Is Key1 and Child Key is some other Number that tied

to

> > > specific Child Table Data
> > > Would that be done in the whereclause?
> > >
> > > >
> > > > It may be easier to use the 'listlookup'
> > > >
> > > > do a search in help for listlookup and read through the

custom

> > > > example - standard comments
> > > >
> > > > You should be able to easily change the code example given to
> the
> > > > vendoradapter
> > > >
> > > > hth
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "laidig.systems"
> > <laidig.systems@>
> > > > wrote:
> > > > >
> > > > > I am trying to write a customization that will take a
> supplier
> > > > number
> > > > > entered into the OrderDtl table in Character05 and display
> the
> > > > Vendor
> > > > > Name that was entered into the Supplier Master table. I

have

> > > written
> > > > > the following code. I think everything is ok with

connecting

> > to
> > > the
> > > > > VendorDetail table but my problem is after the "Try"
> > statement.
> > > Any
> > > > > help would be appreciated.
> > > > >
> > > > > Dim VendDtlAdapt As VendorAdapter = New VendorAdapter
> > > > (SalesOrderForm)
> > > > > VendDtlAdapt.BOConnect()
> > > > > Dim soVendID As String =
> > > > > edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
> > > > > 'msgbox("Get by ID Num: " & soVendID)
> > > > > VendDtlAdapt.GetByID(soVendID)
> > > > > 'msgbox("Get by ID Found " & VendDtlFound)
> > > > > Try
> > > > > Dim dsVendDtl As EpiDataView =
> > > > > CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
> > > > > Dim VendName As String = dsVendDtl.dataView
> (dsVendDtl.Row)
> > > > ("Name")
> > > > > msgbox(VendName)
> > > > > Catch e As Exception
> > > > > msgBox(e)
> > > > > Finally
> > > > > VendDtlAdapt.Dispose()
> > > > > End Try
> > > > >
> > > >
> > >
> >
>

system · December 5, 2006, 8:44pm

It looks like UD110A which is the child table also holds the Key from
UD110. I can get the info easily using crystal just using UD110A
(child table) without ever looking to the Parent. If I could connect
to the Table UD110A via UD110Adapter and get the fields based off
Key1 in UD110 and ChildKey1 in UD110A it would work. I am guessing
if I could pull in the Table UD110A Via the adapter I could do
something that looks at both UD110A.Key1 and UD110A.ChildKey1.

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> I have never grasped the concept of the UD parent/child tables.
> If someone could give a good example of the use of these tables I
> would appreciate it :)
>
> That being said, the UD tables pose a unique problem with using in
a
> base form. You can not make a foreign Key View to them using the
data
> tools menu. You can however cause them to appear as a dataview by
> using code. There is an example in help that can be found by doing
a
> search for 'user preferences faqs' and then view the topic about
user-
> defined tables and foreign-key views
>
> If you can't find it or have problems, reply back - I will check
back
> here later...
>
> --- In vantage@yahoogroups.com, "Michael McWilliams"
> <mmcwilliams22@> wrote:
> >
> > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > >
> > > He was doing a lookup on a totally unrelated table using a
value
> > > entered into a user defined field.
> > >
> >
> > Here is what I am trying to do. I want to pull in UD Data into
> > OrderDtl
> > I have UD110 set up. Key 1 is equal to OrderDtl.CustNumCustID
> > UD110A the Child Table has Child Key that is equal to
> > OrderDtl.Character05
> > I am trying to view the fields in UD110A based on the
CustNumCustID
> &
> > OrderDtl.Character05
> > I would appreciate any help.
> >
> > > You can do a listlookup on almost any BO that only takes one
> > > whereclause parameter. The whereclause itself can have multiple
> > > conditions...
> > >
> > > If you have a particular lookup in mind, I will try to help...
> > >
> > > --- In vantage@yahoogroups.com, "Michael McWilliams"
> > > <mmcwilliams22@> wrote:
> > > >
> > > > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > > > So how could that work for a child key? For instance
> > > > Customer Is Key1 and Child Key is some other Number that tied
> to
> > > > specific Child Table Data
> > > > Would that be done in the whereclause?
> > > >
> > > > >
> > > > > It may be easier to use the 'listlookup'
> > > > >
> > > > > do a search in help for listlookup and read through the
> custom
> > > > > example - standard comments
> > > > >
> > > > > You should be able to easily change the code example given
to
> > the
> > > > > vendoradapter
> > > > >
> > > > > hth
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "laidig.systems"
> > > <laidig.systems@>
> > > > > wrote:
> > > > > >
> > > > > > I am trying to write a customization that will take a
> > supplier
> > > > > number
> > > > > > entered into the OrderDtl table in Character05 and
display
> > the
> > > > > Vendor
> > > > > > Name that was entered into the Supplier Master table. I
> have
> > > > written
> > > > > > the following code. I think everything is ok with
> connecting
> > > to
> > > > the
> > > > > > VendorDetail table but my problem is after the "Try"
> > > statement.
> > > > Any
> > > > > > help would be appreciated.
> > > > > >
> > > > > > Dim VendDtlAdapt As VendorAdapter = New VendorAdapter
> > > > > (SalesOrderForm)
> > > > > > VendDtlAdapt.BOConnect()
> > > > > > Dim soVendID As String =
> > > > > > edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
> > > > > > 'msgbox("Get by ID Num: " & soVendID)
> > > > > > VendDtlAdapt.GetByID(soVendID)
> > > > > > 'msgbox("Get by ID Found " & VendDtlFound)
> > > > > > Try
> > > > > > Dim dsVendDtl As EpiDataView =
> > > > > > CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
> > > > > > Dim VendName As String = dsVendDtl.dataView
> > (dsVendDtl.Row)
> > > > > ("Name")
> > > > > > msgbox(VendName)
> > > > > > Catch e As Exception
> > > > > > msgBox(e)
> > > > > > Finally
> > > > > > VendDtlAdapt.Dispose()
> > > > > > End Try
> > > > > >
> > > > >
> > > >
> > >
> >
>

system · December 5, 2006, 9:02pm

You are on the correct lines,

Create data views for the two views then link them via the
setParentView method from the child.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: 06 December 2006 01:36
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customization V8.03-From Supplier to Sales Order

It looks like UD110A which is the child table also holds the Key from
UD110. I can get the info easily using crystal just using UD110A
(child table) without ever looking to the Parent. If I could connect
to the Table UD110A via UD110Adapter and get the fields based off
Key1 in UD110 and ChildKey1 in UD110A it would work. I am guessing
if I could pull in the Table UD110A Via the adapter I could do
something that looks at both UD110A.Key1 and UD110A.ChildKey1.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"bw2868bond" <bwalker@...> wrote:

>
> I have never grasped the concept of the UD parent/child tables.
> If someone could give a good example of the use of these tables I
> would appreciate it :)
>
> That being said, the UD tables pose a unique problem with using in

a

> base form. You can not make a foreign Key View to them using the

data

> tools menu. You can however cause them to appear as a dataview by
> using code. There is an example in help that can be found by doing

a

> search for 'user preferences faqs' and then view the topic about

user-

> defined tables and foreign-key views
>
> If you can't find it or have problems, reply back - I will check

back

> here later...
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,

"Michael McWilliams"

> <mmcwilliams22@> wrote:
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,

"bw2868bond" <bwalker@> wrote:

> > >
> > > He was doing a lookup on a totally unrelated table using a

value

> > > entered into a user defined field.
> > >
> >
> > Here is what I am trying to do. I want to pull in UD Data into
> > OrderDtl
> > I have UD110 set up. Key 1 is equal to OrderDtl.CustNumCustID
> > UD110A the Child Table has Child Key that is equal to
> > OrderDtl.Character05
> > I am trying to view the fields in UD110A based on the

CustNumCustID

> &
> > OrderDtl.Character05
> > I would appreciate any help.
> >
> > > You can do a listlookup on almost any BO that only takes one
> > > whereclause parameter. The whereclause itself can have multiple
> > > conditions...
> > >
> > > If you have a particular lookup in mind, I will try to help...
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

, "Michael McWilliams"

> > > <mmcwilliams22@> wrote:
> > > >
> > > > --- In vantage@yahoogroups.com

<mailto:vantage%40yahoogroups.com> , "bw2868bond" <bwalker@> wrote:

> > > > So how could that work for a child key? For instance
> > > > Customer Is Key1 and Child Key is some other Number that tied
> to
> > > > specific Child Table Data
> > > > Would that be done in the whereclause?
> > > >
> > > > >
> > > > > It may be easier to use the 'listlookup'
> > > > >
> > > > > do a search in help for listlookup and read through the
> custom
> > > > > example - standard comments
> > > > >
> > > > > You should be able to easily change the code example given

to

> > the
> > > > > vendoradapter
> > > > >
> > > > > hth
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com

<mailto:vantage%40yahoogroups.com> , "laidig.systems"

> > > <laidig.systems@>
> > > > > wrote:
> > > > > >
> > > > > > I am trying to write a customization that will take a
> > supplier
> > > > > number
> > > > > > entered into the OrderDtl table in Character05 and

display

> > the
> > > > > Vendor
> > > > > > Name that was entered into the Supplier Master table. I
> have
> > > > written
> > > > > > the following code. I think everything is ok with
> connecting
> > > to
> > > > the
> > > > > > VendorDetail table but my problem is after the "Try"
> > > statement.
> > > > Any
> > > > > > help would be appreciated.
> > > > > >
> > > > > > Dim VendDtlAdapt As VendorAdapter = New VendorAdapter
> > > > > (SalesOrderForm)
> > > > > > VendDtlAdapt.BOConnect()
> > > > > > Dim soVendID As String =
> > > > > > edvOrderDtl.dataView(edvOrderDtl.Row)("Character05")
> > > > > > 'msgbox("Get by ID Num: " & soVendID)
> > > > > > VendDtlAdapt.GetByID(soVendID)
> > > > > > 'msgbox("Get by ID Found " & VendDtlFound)
> > > > > > Try
> > > > > > Dim dsVendDtl As EpiDataView =
> > > > > > CType(oTrans.EpiDataViews("VendorDetail"), EpiDataView)
> > > > > > Dim VendName As String = dsVendDtl.dataView
> > (dsVendDtl.Row)
> > > > > ("Name")
> > > > > > msgbox(VendName)
> > > > > > Catch e As Exception
> > > > > > msgBox(e)
> > > > > > Finally
> > > > > > VendDtlAdapt.Dispose()
> > > > > > End Try
> > > > > >
> > > > >
> > > >
> > >
> >
>

[Non-text portions of this message have been removed]

system · December 8, 2006, 2:03pm

Another question i have that is somewhat related to this post is
getting information from UD01 via a combo dopdown box. I am able to
click on "Get Retriever Info" and find my "UD01ADAPTER" but the
problem is that it aways displays the Character01 feild in my
dropdown, i want it to display Key 1.

system · December 8, 2006, 4:03pm

As long as you do not already have data in Character01, the easiest
solution would be to populate Character01 with the same data in Key1...

I have read in help that you can define the data returned in a
retriever, but Support did not understand my question when I asked how
and copied them on what help said....

--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:

>
> Another question i have that is somewhat related to this post is
> getting information from UD01 via a combo dopdown box. I am able to
> click on "Get Retriever Info" and find my "UD01ADAPTER" but the
> problem is that it aways displays the Character01 feild in my
> dropdown, i want it to display Key 1.
>

system · December 11, 2006, 7:41am

I know, i read in help where it said you could customize the retriever
but that was it. No explanations. Anybody else know?

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> As long as you do not already have data in Character01, the easiest
> solution would be to populate Character01 with the same data in Key1...
>
> I have read in help that you can define the data returned in a
> retriever, but Support did not understand my question when I asked how
> and copied them on what help said....
>
> --- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@>
> wrote:
> >
> > Another question i have that is somewhat related to this post is
> > getting information from UD01 via a combo dopdown box. I am able to
> > click on "Get Retriever Info" and find my "UD01ADAPTER" but the
> > problem is that it aways displays the Character01 feild in my
> > dropdown, i want it to display Key 1.
> >
>

system · December 12, 2006, 7:47am

Another question. Is there a way to customize forms that are not
located in the menu structure? For instance, in the Sales Order
Entry, i wanted to customize the dialog box that pops up when you add
a "New Line From Quote." I was able to customize the sheet but I
can't link that customization to the sheet as default for all the
other users who aren't in Developer mode. The form i am trying to
customize is App.SalesOrderEntry.LineFromQuoteForm

system · December 12, 2006, 11:20am

They *are* in the menu structure, but hidden from view. One would think
that there would be an option to view the hidden items maybe on the
Menu Maintenance actions menu. To assist in deploying customizations to
the 'hidden from menu' forms.

It is possible to mess up the menu system to the point where Vantage
will not launch so extreme care must be used when altering the menu
table to allow the hidden item to be un-hidden so that a customization
can be specified and then re-hidden.

--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:

>
> Another question. Is there a way to customize forms that are not
> located in the menu structure? For instance, in the Sales Order
> Entry, i wanted to customize the dialog box that pops up when you add
> a "New Line From Quote." I was able to customize the sheet but I
> can't link that customization to the sheet as default for all the
> other users who aren't in Developer mode. The form i am trying to
> customize is App.SalesOrderEntry.LineFromQuoteForm
>

system · December 12, 2006, 2:47pm

I looked in the menu table in my db and there isn't any reference to
the App.SalesOrderEntry.LineFromQuoteForm. How do i find this form in
my menu? I didn't see any items in the menu that were marked with
"DoNotDisplayInMenu" either. Am I looking in the wrong place?

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> They *are* in the menu structure, but hidden from view. One would think
> that there would be an option to view the hidden items maybe on the
> Menu Maintenance actions menu. To assist in deploying customizations to
> the 'hidden from menu' forms.
>
> It is possible to mess up the menu system to the point where Vantage
> will not launch so extreme care must be used when altering the menu
> table to allow the hidden item to be un-hidden so that a customization
> can be specified and then re-hidden.
>
> --- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@>
> wrote:
> >
> > Another question. Is there a way to customize forms that are not
> > located in the menu structure? For instance, in the Sales Order
> > Entry, i wanted to customize the dialog box that pops up when you add
> > a "New Line From Quote." I was able to customize the sheet but I
> > can't link that customization to the sheet as default for all the
> > other users who aren't in Developer mode. The form i am trying to
> > customize is App.SalesOrderEntry.LineFromQuoteForm
> >
>

system · December 12, 2006, 3:12pm

While in developer mode, do whatever it is that calls the second form
and make note of the menu id called - at least in V8.00

--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:

>
> I looked in the menu table in my db and there isn't any reference to
> the App.SalesOrderEntry.LineFromQuoteForm. How do i find this form

in

> my menu? I didn't see any items in the menu that were marked with
> "DoNotDisplayInMenu" either. Am I looking in the wrong place?
>
>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> >
> > They *are* in the menu structure, but hidden from view. One would

think

> > that there would be an option to view the hidden items maybe on

the

> > Menu Maintenance actions menu. To assist in deploying

customizations to

> > the 'hidden from menu' forms.
> >
> > It is possible to mess up the menu system to the point where

Vantage

> > will not launch so extreme care must be used when altering the

menu

> > table to allow the hidden item to be un-hidden so that a

customization

> > can be specified and then re-hidden.
> >
> > --- In vantage@yahoogroups.com, "laidig.systems"

<laidig.systems@>

> > wrote:
> > >
> > > Another question. Is there a way to customize forms that are

not

> > > located in the menu structure? For instance, in the Sales Order
> > > Entry, i wanted to customize the dialog box that pops up when

you add

> > > a "New Line From Quote." I was able to customize the sheet but

I

> > > can't link that customization to the sheet as default for all

the

> > > other users who aren't in Developer mode. The form i am trying

to

> > > customize is App.SalesOrderEntry.LineFromQuoteForm
> > >
> >
>

system · December 12, 2006, 3:32pm

I'm not sure what you mean by that. Let me explain what I have
already done. In developer mode, i open the Sales Order Form, i make
a sales order and go to File>New>New Line From Quote. The window that
pops up is Epicor.Mfg.UI.App.SalesOrderEntry.LineFromQuoteForm and i
have customized this for. In the Menu Maintenance, i wanted to link
my new customization to this menu for all of the users who are not in
Developer Mode. I don't know what "program" in the menu maintenance
to link my new customization to since it was not originally in the
menu. I can find my new customization under the SalesOrderEntry.dll
Program but it doesn't do anything when i link my customization to
that. I have looked in our SQL server for the table where the menus
and customizations are stored but i can't find the correct table. The
only table i found was the Menu table and that just showed the parents
and sequence of the menus. If you need any other information, just
let me know. Thanks so much for all your help.

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> While in developer mode, do whatever it is that calls the second form
> and make note of the menu id called - at least in V8.00
>
> --- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@>
> wrote:
> >
> > I looked in the menu table in my db and there isn't any reference to
> > the App.SalesOrderEntry.LineFromQuoteForm. How do i find this form
> in
> > my menu? I didn't see any items in the menu that were marked with
> > "DoNotDisplayInMenu" either. Am I looking in the wrong place?
> >
> >
> > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > >
> > > They *are* in the menu structure, but hidden from view. One would
> think
> > > that there would be an option to view the hidden items maybe on
> the
> > > Menu Maintenance actions menu. To assist in deploying
> customizations to
> > > the 'hidden from menu' forms.
> > >
> > > It is possible to mess up the menu system to the point where
> Vantage
> > > will not launch so extreme care must be used when altering the
> menu
> > > table to allow the hidden item to be un-hidden so that a
> customization
> > > can be specified and then re-hidden.

system · December 12, 2006, 4:42pm

I tried it out and see what you mean. Other Customizations I have
done for 'called' forms always have called a menu item, whether it
was visible on the menu or not. This one does not. I'm afraid I do
not have an answer.

Sorry...

--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:

>
> I'm not sure what you mean by that. Let me explain what I have
> already done. In developer mode, i open the Sales Order Form, i

make

> a sales order and go to File>New>New Line From Quote. The window

that

> pops up is Epicor.Mfg.UI.App.SalesOrderEntry.LineFromQuoteForm and i
> have customized this for. In the Menu Maintenance, i wanted to link
> my new customization to this menu for all of the users who are not

in

> Developer Mode. I don't know what "program" in the menu

maintenance

> to link my new customization to since it was not originally in the
> menu. I can find my new customization under the SalesOrderEntry.dll
> Program but it doesn't do anything when i link my customization to
> that. I have looked in our SQL server for the table where the menus
> and customizations are stored but i can't find the correct table.

The

> only table i found was the Menu table and that just showed the

parents

> and sequence of the menus. If you need any other information, just
> let me know. Thanks so much for all your help.
>
>
>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> >
> > While in developer mode, do whatever it is that calls the second

form

> > and make note of the menu id called - at least in V8.00
> >
> > --- In vantage@yahoogroups.com, "laidig.systems"

<laidig.systems@>

> > wrote:
> > >
> > > I looked in the menu table in my db and there isn't any

reference to

> > > the App.SalesOrderEntry.LineFromQuoteForm. How do i find this

form

> > in
> > > my menu? I didn't see any items in the menu that were marked

with

> > > "DoNotDisplayInMenu" either. Am I looking in the wrong place?
> > >
> > >
> > > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > > >
> > > > They *are* in the menu structure, but hidden from view. One

would

> > think
> > > > that there would be an option to view the hidden items maybe

on

> > the
> > > > Menu Maintenance actions menu. To assist in deploying
> > customizations to
> > > > the 'hidden from menu' forms.
> > > >
> > > > It is possible to mess up the menu system to the point where
> > Vantage
> > > > will not launch so extreme care must be used when altering

the

> > menu
> > > > table to allow the hidden item to be un-hidden so that a
> > customization
> > > > can be specified and then re-hidden.
>

Topic		Replies	Views
Order Entry Customization Yahoo Archive	9	504	January 4, 2007
Customization - supplier search Yahoo Archive	3	755	March 20, 2008
Customization Problem Yahoo Archive	13	834	September 11, 2007
Customer Ship To Mainenance Yahoo Archive	4	980	May 5, 2009
Customization Request Yahoo Archive	4	365	February 27, 2009

Customization V8.03-From Supplier to Sales Order

Related Topics