Customer Search Button for Customization

Yahoo Archive
1
Perfect I totally missed that line. That is almost worse than finding the
missing semicolon in C++.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 11:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization





Charlie,

Sorry, I should have read more thoroughly.

Change the following line:

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Part"),EpiDataView)

To...

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("UD100"),EpiDataView)

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 10:13 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

It is filtering the way it should.

No I'm actually doing this on a completely custom form. UD100

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 11:11 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Charlie,

Is the search box filtering properly?

The only time I get the unhandled exception is when a part is not open. Then
it is the -1 error.

I assume you are doing this on the Part form. If so, this code requires an
active record.

Keep me posted.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:48 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Ross,

I keep getting unhandled exceptions after I make the Contact selection and
hit ok.

Dim recSelected As Boolean

Dim whereClause As String = "CustNum = " & nedEpiCustom1.Value & ""

Dim dsCustCnt As DataSet =
Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"CustCntAdapte
r", recSelected, True, whereClause)

If (recSelected) Then

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Part"),
EpiDataView)

edv.dataView(edv.Row)("Number03") =
dsCustCnt.Tables(0).Rows(0)("ConNum")

edv.dataView(edv.Row)("Character02") =
dsCustCnt.Tables(0).Rows(0)("Name")

edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,edv.Column) )

End If

Does something look off in my code. The contact number should be dumped into
ud100.number03 and the name of the contact into ud100.character02.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 10:33 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Try just txtCustID or maybe txtCustID.Value

You also need to remove the single quotes for numeric values.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:20 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

If I have a numeric editor box how would I adjust Dim whereClause As String
= "CustID = '" & txtCustID.Text & "'" to make is spit out the number I tried
changing .text to .number to no avail.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, October 28, 2009 12:49 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Drew,

It is only a matter of changing the WhereClause variable. But you need the
data to be available to use in the whereclause.

For example:

Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"

This is assuming the value resides in a custom field called txtCustID and
will only work this way.

Another option: If you are using a base control on the form you will need to
convert the base control (CustID) to an object before you can use it.

If so, try this:

'-------------------
Dim CustomerID As EpitextBox =
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
EpitextBox)
Dim whereClause As String = "CustID = '" & CustomerID & "'"
'-------------------

Make sure to change the GUID of the control (e.g.
GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
properties of the control you are using.

That should do it.

Let me know if you need more.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
drew.pete
Sent: Wednesday, October 28, 2009 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I had been trying to get a similar customization working for some time. I
manipulated the code you posted to utilize the ShipTo search and reassociate
the ShipToNum based on the row selected in the search. It functioned
perfectly. Thank you! The only thing I was looking at doing, however, was
filtering the search by the customer's id. I'm sure it is a filter in the
list lookup. Maybe you have a quick solution? I will continue to look for it
in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Ross
Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB
customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct
fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail. <http://mail. <http://mail.
<http://mail. <http://mail.yahoo.com> yahoo.com> yahoo.com>
yahoo.com> yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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. <http://groups.
<http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.
<http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.
<http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>

------------------------------------

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. <http://groups.
<http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
2
Is it possible to program a Button to be a customer search button so that
when you select a customer and click ok it will populate the correct fields
of your customization?



~Charlie





[Non-text portions of this message have been removed]
3
I am relatively sure you should be able to do this with a VB customization. You will have to use the customer search button, and based on the cust number it returns, write a SQL statement and then populate the form on the values returned by that.

Thanks,
Kunal




________________________________
From: Charlie Wilson <foamdesigncsw@...>
To: vantage@yahoogroups.com
Sent: Wed, October 28, 2009 7:36:56 AM
Subject: [Vantage] Customer Search Button for Customization


Is it possible to program a Button to be a customer search button so that
when you select a customer and click ok it will populate the correct fields
of your customization?

~Charlie

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




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
4
That is way out of my league maybe a drop down will work better.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Kunal Ganguly
Sent: Wednesday, October 28, 2009 8:51 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Customer Search Button for Customization





I am relatively sure you should be able to do this with a VB customization.
You will have to use the customer search button, and based on the cust
number it returns, write a SQL statement and then populate the form on the
values returned by that.

Thanks,
Kunal

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wed, October 28, 2009 7:36:56 AM
Subject: [Vantage] Customer Search Button for Customization

Is it possible to program a Button to be a customer search button so that
when you select a customer and click ok it will populate the correct fields
of your customization?

~Charlie

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. <http://mail.yahoo.com> yahoo.com

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





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

That's not out of your league.

If you have not solved this yet, here is an example of something that will
invoke the customer search box and return the values to ud fields on the
form.

Just change the ud field names to your own.

Modify as necessary.
--------------------------
Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
System.EventArgs) Handles btnCUSTID.Click
'// ** Place Event Handling Code Here **
Dim recSelected As Boolean
Dim whereClause As String = String.Empty
Dim dsCustomer As DataSet =
Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
"CustomerAdapter", recSelected, True, whereClause)
If (recSelected) Then
Dim edv As EpiDataView =
CType(oTrans.EpiDataViews("Part"), EpiDataView)
edv.dataView(edv.Row)("ShortChar05") =
dsCustomer.Tables(0).Rows(0)("CustID")
edv.dataView(edv.Row)("Character02") =
dsCustomer.Tables(0).Rows(0)("Name")
edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
edv.Column) )
End If
End Sub
-----------------------------

Tie this to an onclick event of a button.

Let me know if you have any questions.

Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Wednesday, October 28, 2009 8:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customer Search Button for Customization

That is way out of my league maybe a drop down will work better.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Kunal Ganguly
Sent: Wednesday, October 28, 2009 8:51 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Customer Search Button for Customization





I am relatively sure you should be able to do this with a VB customization.
You will have to use the customer search button, and based on the cust
number it returns, write a SQL statement and then populate the form on the
values returned by that.

Thanks,
Kunal

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wed, October 28, 2009 7:36:56 AM
Subject: [Vantage] Customer Search Button for Customization

Is it possible to program a Button to be a customer search button so that
when you select a customer and click ok it will populate the correct fields
of your customization?

~Charlie

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. <http://mail.yahoo.com> yahoo.com

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





[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/.
(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
6
That is correct, I forgot that the customer search function returns the whole customer record (as a row) rather than just the customer number. Thanks Ross!

Thanks,
Kunal




________________________________
From: Ross Hughes <ross.hughes@...>
To: vantage@yahoogroups.com
Sent: Wed, October 28, 2009 10:09:01 AM
Subject: RE: [Vantage] Customer Search Button for Customization


Charlie,

That's not out of your league.

If you have not solved this yet, here is an example of something that will
invoke the customer search box and return the values to ud fields on the
form.

Just change the ud field names to your own.

Modify as necessary.
------------ --------- -----
Private Sub btnCUSTID_Click( ByVal Sender As Object, ByVal Args As
System.EventArgs) Handles btnCUSTID.Click
'// ** Place Event Handling Code Here **
Dim recSelected As Boolean
Dim whereClause As String = String.Empty
Dim dsCustomer As DataSet =
Epicor.Mfg.UI. FormFunctions. SearchFunctions. listLookup( oTrans,
"CustomerAdapter" , recSelected, True, whereClause)
If (recSelected) Then
Dim edv As EpiDataView =
CType(oTrans. EpiDataViews( "Part"), EpiDataView)
edv.dataView( edv.Row)( "ShortChar05" ) =
dsCustomer.Tables( 0).Rows(0) ("CustID" )
edv.dataView( edv.Row)( "Character02" ) =
dsCustomer.Tables( 0).Rows(0) ("Name")
edv.Notify( New EpiNotifyArgs( oTrans, edv.Row,
edv.Column) )
End If
End Sub
------------ --------- --------

Tie this to an onclick event of a button.

Let me know if you have any questions.

Ross

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Charlie Wilson
Sent: Wednesday, October 28, 2009 8:06 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Customer Search Button for Customization

That is way out of my league maybe a drop down will work better.

~Charlie

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Kunal Ganguly
Sent: Wednesday, October 28, 2009 8:51 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Customer Search Button for Customization

I am relatively sure you should be able to do this with a VB customization.
You will have to use the customer search button, and based on the cust
number it returns, write a SQL statement and then populate the form on the
values returned by that.

Thanks,
Kunal

____________ _________ _________ __
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesignc sw%40yahoo. com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Sent: Wed, October 28, 2009 7:36:56 AM
Subject: [Vantage] Customer Search Button for Customization

Is it possible to program a Button to be a customer search button so that
when you select a customer and click ok it will populate the correct fields
of your customization?

~Charlie

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

____________ _________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. <http://mail. yahoo.com> yahoo.com

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

[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/.
(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]
7
Sweet I'll give that a try. I'm just not experienced with vb code in vantage
yet.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, October 28, 2009 11:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Customer Search Button for Customization





Charlie,

That's not out of your league.

If you have not solved this yet, here is an example of something that will
invoke the customer search box and return the values to ud fields on the
form.

Just change the ud field names to your own.

Modify as necessary.
--------------------------
Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
System.EventArgs) Handles btnCUSTID.Click
'// ** Place Event Handling Code Here **
Dim recSelected As Boolean
Dim whereClause As String = String.Empty
Dim dsCustomer As DataSet =
Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
"CustomerAdapter", recSelected, True, whereClause)
If (recSelected) Then
Dim edv As EpiDataView =
CType(oTrans.EpiDataViews("Part"), EpiDataView)
edv.dataView(edv.Row)("ShortChar05") =
dsCustomer.Tables(0).Rows(0)("CustID")
edv.dataView(edv.Row)("Character02") =
dsCustomer.Tables(0).Rows(0)("Name")
edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
edv.Column) )
End If
End Sub
-----------------------------

Tie this to an onclick event of a button.

Let me know if you have any questions.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, October 28, 2009 8:06 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Customer Search Button for Customization

That is way out of my league maybe a drop down will work better.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Kunal Ganguly
Sent: Wednesday, October 28, 2009 8:51 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: Re: [Vantage] Customer Search Button for Customization

I am relatively sure you should be able to do this with a VB customization.
You will have to use the customer search button, and based on the cust
number it returns, write a SQL statement and then populate the form on the
values returned by that.

Thanks,
Kunal

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wed, October 28, 2009 7:36:56 AM
Subject: [Vantage] Customer Search Button for Customization

Is it possible to program a Button to be a customer search button so that
when you select a customer and click ok it will populate the correct fields
of your customization?

~Charlie

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

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. <http://mail. <http://mail.yahoo.com> yahoo.com> yahoo.com

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

[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





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

I had been trying to get a similar customization working for some time. I manipulated the code you posted to utilize the ShipTo search and reassociate the ShipToNum based on the row selected in the search. It functioned perfectly. Thank you! The only thing I was looking at doing, however, was filtering the search by the customer's id. I'm sure it is a filter in the list lookup. Maybe you have a quick solution? I will continue to look for it in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail.yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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/.
> (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
>
9
Drew,

It is only a matter of changing the WhereClause variable. But you need the
data to be available to use in the whereclause.

For example:

Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"

This is assuming the value resides in a custom field called txtCustID and
will only work this way.

Another option: If you are using a base control on the form you will need to
convert the base control (CustID) to an object before you can use it.

If so, try this:

'-------------------
Dim CustomerID As EpitextBox =
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
EpitextBox)
Dim whereClause As String = "CustID = '" & CustomerID & "'"
'-------------------

Make sure to change the GUID of the control (e.g.
GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
properties of the control you are using.

That should do it.

Let me know if you need more.

Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
drew.pete
Sent: Wednesday, October 28, 2009 11:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I had been trying to get a similar customization working for some time. I
manipulated the code you posted to utilize the ShipTo search and reassociate
the ShipToNum based on the row selected in the search. It functioned
perfectly. Thank you! The only thing I was looking at doing, however, was
filtering the search by the customer's id. I'm sure it is a filter in the
list lookup. Maybe you have a quick solution? I will continue to look for it
in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB
customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct
fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail.yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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/.
> (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
>




------------------------------------

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/.
(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
10
Ross,

I interpolated the example you gave me and used

Dim whereClause As String = "CustNum='" & CustomerNum & "' AND ShipToNum <> ''"

to filter my search results and it worked beautifully.

Thank you for your help!

Drew

--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> Drew,
>
> It is only a matter of changing the WhereClause variable. But you need the
> data to be available to use in the whereclause.
>
> For example:
>
> Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"
>
> This is assuming the value resides in a custom field called txtCustID and
> will only work this way.
>
> Another option: If you are using a base control on the form you will need to
> convert the base control (CustID) to an object before you can use it.
>
> If so, try this:
>
> '-------------------
> Dim CustomerID As EpitextBox =
> ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
> EpitextBox)
> Dim whereClause As String = "CustID = '" & CustomerID & "'"
> '-------------------
>
> Make sure to change the GUID of the control (e.g.
> GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
> properties of the control you are using.
>
> That should do it.
>
> Let me know if you need more.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> drew.pete
> Sent: Wednesday, October 28, 2009 11:24 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Customer Search Button for Customization
>
> Ross,
>
> I had been trying to get a similar customization working for some time. I
> manipulated the code you posted to utilize the ShipTo search and reassociate
> the ShipToNum based on the row selected in the search. It functioned
> perfectly. Thank you! The only thing I was looking at doing, however, was
> filtering the search by the customer's id. I'm sure it is a filter in the
> list lookup. Maybe you have a quick solution? I will continue to look for it
> in the meantime.
>
> Thank you,
>
> Drew
>
> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
> >
> > Charlie,
> >
> > That's not out of your league.
> >
> > If you have not solved this yet, here is an example of something that will
> > invoke the customer search box and return the values to ud fields on the
> > form.
> >
> > Just change the ud field names to your own.
> >
> > Modify as necessary.
> > --------------------------
> > Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> > System.EventArgs) Handles btnCUSTID.Click
> > '// ** Place Event Handling Code Here **
> > Dim recSelected As Boolean
> > Dim whereClause As String = String.Empty
> > Dim dsCustomer As DataSet =
> > Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> > "CustomerAdapter", recSelected, True, whereClause)
> > If (recSelected) Then
> > Dim edv As EpiDataView =
> > CType(oTrans.EpiDataViews("Part"), EpiDataView)
> > edv.dataView(edv.Row)("ShortChar05") =
> > dsCustomer.Tables(0).Rows(0)("CustID")
> > edv.dataView(edv.Row)("Character02") =
> > dsCustomer.Tables(0).Rows(0)("Name")
> > edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> > edv.Column) )
> > End If
> > End Sub
> > -----------------------------
> >
> > Tie this to an onclick event of a button.
> >
> > Let me know if you have any questions.
> >
> > Ross
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> > Charlie Wilson
> > Sent: Wednesday, October 28, 2009 8:06 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Customer Search Button for Customization
> >
> > That is way out of my league maybe a drop down will work better.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> > Kunal Ganguly
> > Sent: Wednesday, October 28, 2009 8:51 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Customer Search Button for Customization
> >
> >
> >
> >
> >
> > I am relatively sure you should be able to do this with a VB
> customization.
> > You will have to use the customer search button, and based on the cust
> > number it returns, write a SQL statement and then populate the form on the
> > values returned by that.
> >
> > Thanks,
> > Kunal
> >
> > ________________________________
> > From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> > yahoo.com>
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Sent: Wed, October 28, 2009 7:36:56 AM
> > Subject: [Vantage] Customer Search Button for Customization
> >
> > Is it possible to program a Button to be a customer search button so that
> > when you select a customer and click ok it will populate the correct
> fields
> > of your customization?
> >
> > ~Charlie
> >
> > [Non-text portions of this message have been removed]
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail. <http://mail.yahoo.com> yahoo.com
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [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/.
> > (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
> >
>
>
>
>
> ------------------------------------
>
> 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/.
> (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
>
11
You are welcome.

Thanks for the update.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
drew.pete
Sent: Thursday, October 29, 2009 10:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I interpolated the example you gave me and used

Dim whereClause As String = "CustNum='" & CustomerNum & "' AND ShipToNum <>
''"

to filter my search results and it worked beautifully.

Thank you for your help!

Drew

--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> Drew,
>
> It is only a matter of changing the WhereClause variable. But you need
the
> data to be available to use in the whereclause.
>
> For example:
>
> Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"
>
> This is assuming the value resides in a custom field called txtCustID and
> will only work this way.
>
> Another option: If you are using a base control on the form you will need
to
> convert the base control (CustID) to an object before you can use it.
>
> If so, try this:
>
> '-------------------
> Dim CustomerID As EpitextBox =
>
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
> EpitextBox)
> Dim whereClause As String = "CustID = '" & CustomerID & "'"
> '-------------------
>
> Make sure to change the GUID of the control (e.g.
> GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
> properties of the control you are using.
>
> That should do it.
>
> Let me know if you need more.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> drew.pete
> Sent: Wednesday, October 28, 2009 11:24 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Customer Search Button for Customization
>
> Ross,
>
> I had been trying to get a similar customization working for some time. I
> manipulated the code you posted to utilize the ShipTo search and
reassociate
> the ShipToNum based on the row selected in the search. It functioned
> perfectly. Thank you! The only thing I was looking at doing, however, was
> filtering the search by the customer's id. I'm sure it is a filter in the
> list lookup. Maybe you have a quick solution? I will continue to look for
it
> in the meantime.
>
> Thank you,
>
> Drew
>
> --- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@> wrote:
> >
> > Charlie,
> >
> > That's not out of your league.
> >
> > If you have not solved this yet, here is an example of something that
will
> > invoke the customer search box and return the values to ud fields on the
> > form.
> >
> > Just change the ud field names to your own.
> >
> > Modify as necessary.
> > --------------------------
> > Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> > System.EventArgs) Handles btnCUSTID.Click
> > '// ** Place Event Handling Code Here **
> > Dim recSelected As Boolean
> > Dim whereClause As String = String.Empty
> > Dim dsCustomer As DataSet =
> > Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> > "CustomerAdapter", recSelected, True, whereClause)
> > If (recSelected) Then
> > Dim edv As EpiDataView =
> > CType(oTrans.EpiDataViews("Part"), EpiDataView)
> > edv.dataView(edv.Row)("ShortChar05") =
> > dsCustomer.Tables(0).Rows(0)("CustID")
> > edv.dataView(edv.Row)("Character02") =
> > dsCustomer.Tables(0).Rows(0)("Name")
> > edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> > edv.Column) )
> > End If
> > End Sub
> > -----------------------------
> >
> > Tie this to an onclick event of a button.
> >
> > Let me know if you have any questions.
> >
> > Ross
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> > Charlie Wilson
> > Sent: Wednesday, October 28, 2009 8:06 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Customer Search Button for Customization
> >
> > That is way out of my league maybe a drop down will work better.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> > Kunal Ganguly
> > Sent: Wednesday, October 28, 2009 8:51 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Customer Search Button for Customization
> >
> >
> >
> >
> >
> > I am relatively sure you should be able to do this with a VB
> customization.
> > You will have to use the customer search button, and based on the cust
> > number it returns, write a SQL statement and then populate the form on
the
> > values returned by that.
> >
> > Thanks,
> > Kunal
> >
> > ________________________________
> > From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> > yahoo.com>
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Sent: Wed, October 28, 2009 7:36:56 AM
> > Subject: [Vantage] Customer Search Button for Customization
> >
> > Is it possible to program a Button to be a customer search button so
that
> > when you select a customer and click ok it will populate the correct
> fields
> > of your customization?
> >
> > ~Charlie
> >
> > [Non-text portions of this message have been removed]
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail. <http://mail.yahoo.com> yahoo.com
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [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/.
> > (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
> >
>
>
>
>
> ------------------------------------
>
> 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/.
> (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
>




------------------------------------

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/.
(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
12
If I have a numeric editor box how would I adjust Dim whereClause As String
= "CustID = '" & txtCustID.Text & "'" to make is spit out the number I tried
changing .text to .number to no avail.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, October 28, 2009 12:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization





Drew,

It is only a matter of changing the WhereClause variable. But you need the
data to be available to use in the whereclause.

For example:

Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"

This is assuming the value resides in a custom field called txtCustID and
will only work this way.

Another option: If you are using a base control on the form you will need to
convert the base control (CustID) to an object before you can use it.

If so, try this:

'-------------------
Dim CustomerID As EpitextBox =
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
EpitextBox)
Dim whereClause As String = "CustID = '" & CustomerID & "'"
'-------------------

Make sure to change the GUID of the control (e.g.
GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
properties of the control you are using.

That should do it.

Let me know if you need more.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
drew.pete
Sent: Wednesday, October 28, 2009 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I had been trying to get a similar customization working for some time. I
manipulated the code you posted to utilize the ShipTo search and reassociate
the ShipToNum based on the row selected in the search. It functioned
perfectly. Thank you! The only thing I was looking at doing, however, was
filtering the search by the customer's id. I'm sure it is a filter in the
list lookup. Maybe you have a quick solution? I will continue to look for it
in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Ross
Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB
customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct
fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail. <http://mail.yahoo.com> yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>

------------------------------------

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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
13
Try just txtCustID or maybe txtCustID.Value

You also need to remove the single quotes for numeric values.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

If I have a numeric editor box how would I adjust Dim whereClause As String
= "CustID = '" & txtCustID.Text & "'" to make is spit out the number I tried
changing .text to .number to no avail.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, October 28, 2009 12:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization





Drew,

It is only a matter of changing the WhereClause variable. But you need the
data to be available to use in the whereclause.

For example:

Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"

This is assuming the value resides in a custom field called txtCustID and
will only work this way.

Another option: If you are using a base control on the form you will need to
convert the base control (CustID) to an object before you can use it.

If so, try this:

'-------------------
Dim CustomerID As EpitextBox =
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
EpitextBox)
Dim whereClause As String = "CustID = '" & CustomerID & "'"
'-------------------

Make sure to change the GUID of the control (e.g.
GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
properties of the control you are using.

That should do it.

Let me know if you need more.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
drew.pete
Sent: Wednesday, October 28, 2009 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I had been trying to get a similar customization working for some time. I
manipulated the code you posted to utilize the ShipTo search and reassociate
the ShipToNum based on the row selected in the search. It functioned
perfectly. Thank you! The only thing I was looking at doing, however, was
filtering the search by the customer's id. I'm sure it is a filter in the
list lookup. Maybe you have a quick solution? I will continue to look for it
in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Ross
Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB
customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct
fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail. <http://mail.yahoo.com> yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>

------------------------------------

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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[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/.
(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
14
Ross,



I keep getting unhandled exceptions after I make the Contact selection and
hit ok.



Dim recSelected As Boolean

Dim whereClause As String = "CustNum = " & nedEpiCustom1.Value & ""

Dim dsCustCnt As DataSet =
Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"CustCntAdapte
r", recSelected, True, whereClause)

If (recSelected) Then

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Part"),
EpiDataView)

edv.dataView(edv.Row)("Number03") =
dsCustCnt.Tables(0).Rows(0)("ConNum")

edv.dataView(edv.Row)("Character02") =
dsCustCnt.Tables(0).Rows(0)("Name")

edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,edv.Column) )

End If



Does something look off in my code. The contact number should be dumped into
ud100.number03 and the name of the contact into ud100.character02.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization





Try just txtCustID or maybe txtCustID.Value

You also need to remove the single quotes for numeric values.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:20 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

If I have a numeric editor box how would I adjust Dim whereClause As String
= "CustID = '" & txtCustID.Text & "'" to make is spit out the number I tried
changing .text to .number to no avail.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, October 28, 2009 12:49 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Drew,

It is only a matter of changing the WhereClause variable. But you need the
data to be available to use in the whereclause.

For example:

Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"

This is assuming the value resides in a custom field called txtCustID and
will only work this way.

Another option: If you are using a base control on the form you will need to
convert the base control (CustID) to an object before you can use it.

If so, try this:

'-------------------
Dim CustomerID As EpitextBox =
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
EpitextBox)
Dim whereClause As String = "CustID = '" & CustomerID & "'"
'-------------------

Make sure to change the GUID of the control (e.g.
GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
properties of the control you are using.

That should do it.

Let me know if you need more.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
drew.pete
Sent: Wednesday, October 28, 2009 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I had been trying to get a similar customization working for some time. I
manipulated the code you posted to utilize the ShipTo search and reassociate
the ShipToNum based on the row selected in the search. It functioned
perfectly. Thank you! The only thing I was looking at doing, however, was
filtering the search by the customer's id. I'm sure it is a filter in the
list lookup. Maybe you have a quick solution? I will continue to look for it
in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Ross
Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB
customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct
fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail. <http://mail. <http://mail.yahoo.com>
yahoo.com> yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>

------------------------------------

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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





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

Is the search box filtering properly?

The only time I get the unhandled exception is when a part is not open. Then
it is the -1 error.

I assume you are doing this on the Part form. If so, this code requires an
active record.

Keep me posted.

Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Ross,



I keep getting unhandled exceptions after I make the Contact selection and
hit ok.



Dim recSelected As Boolean

Dim whereClause As String = "CustNum = " & nedEpiCustom1.Value & ""

Dim dsCustCnt As DataSet =
Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"CustCntAdapte
r", recSelected, True, whereClause)

If (recSelected) Then

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Part"),
EpiDataView)

edv.dataView(edv.Row)("Number03") =
dsCustCnt.Tables(0).Rows(0)("ConNum")

edv.dataView(edv.Row)("Character02") =
dsCustCnt.Tables(0).Rows(0)("Name")

edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,edv.Column) )

End If



Does something look off in my code. The contact number should be dumped into
ud100.number03 and the name of the contact into ud100.character02.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization





Try just txtCustID or maybe txtCustID.Value

You also need to remove the single quotes for numeric values.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:20 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

If I have a numeric editor box how would I adjust Dim whereClause As String
= "CustID = '" & txtCustID.Text & "'" to make is spit out the number I tried
changing .text to .number to no avail.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, October 28, 2009 12:49 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Drew,

It is only a matter of changing the WhereClause variable. But you need the
data to be available to use in the whereclause.

For example:

Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"

This is assuming the value resides in a custom field called txtCustID and
will only work this way.

Another option: If you are using a base control on the form you will need to
convert the base control (CustID) to an object before you can use it.

If so, try this:

'-------------------
Dim CustomerID As EpitextBox =
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
EpitextBox)
Dim whereClause As String = "CustID = '" & CustomerID & "'"
'-------------------

Make sure to change the GUID of the control (e.g.
GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
properties of the control you are using.

That should do it.

Let me know if you need more.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
drew.pete
Sent: Wednesday, October 28, 2009 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I had been trying to get a similar customization working for some time. I
manipulated the code you posted to utilize the ShipTo search and reassociate
the ShipToNum based on the row selected in the search. It functioned
perfectly. Thank you! The only thing I was looking at doing, however, was
filtering the search by the customer's id. I'm sure it is a filter in the
list lookup. Maybe you have a quick solution? I will continue to look for it
in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Ross
Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB
customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct
fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail. <http://mail. <http://mail.yahoo.com>
yahoo.com> yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>

------------------------------------

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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[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/.
(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
16
It is filtering the way it should.



No I'm actually doing this on a completely custom form. UD100



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization





Charlie,

Is the search box filtering properly?

The only time I get the unhandled exception is when a part is not open. Then
it is the -1 error.

I assume you are doing this on the Part form. If so, this code requires an
active record.

Keep me posted.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:48 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Ross,

I keep getting unhandled exceptions after I make the Contact selection and
hit ok.

Dim recSelected As Boolean

Dim whereClause As String = "CustNum = " & nedEpiCustom1.Value & ""

Dim dsCustCnt As DataSet =
Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"CustCntAdapte
r", recSelected, True, whereClause)

If (recSelected) Then

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Part"),
EpiDataView)

edv.dataView(edv.Row)("Number03") =
dsCustCnt.Tables(0).Rows(0)("ConNum")

edv.dataView(edv.Row)("Character02") =
dsCustCnt.Tables(0).Rows(0)("Name")

edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,edv.Column) )

End If

Does something look off in my code. The contact number should be dumped into
ud100.number03 and the name of the contact into ud100.character02.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 10:33 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Try just txtCustID or maybe txtCustID.Value

You also need to remove the single quotes for numeric values.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:20 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

If I have a numeric editor box how would I adjust Dim whereClause As String
= "CustID = '" & txtCustID.Text & "'" to make is spit out the number I tried
changing .text to .number to no avail.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, October 28, 2009 12:49 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Drew,

It is only a matter of changing the WhereClause variable. But you need the
data to be available to use in the whereclause.

For example:

Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"

This is assuming the value resides in a custom field called txtCustID and
will only work this way.

Another option: If you are using a base control on the form you will need to
convert the base control (CustID) to an object before you can use it.

If so, try this:

'-------------------
Dim CustomerID As EpitextBox =
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
EpitextBox)
Dim whereClause As String = "CustID = '" & CustomerID & "'"
'-------------------

Make sure to change the GUID of the control (e.g.
GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
properties of the control you are using.

That should do it.

Let me know if you need more.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
drew.pete
Sent: Wednesday, October 28, 2009 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I had been trying to get a similar customization working for some time. I
manipulated the code you posted to utilize the ShipTo search and reassociate
the ShipToNum based on the row selected in the search. It functioned
perfectly. Thank you! The only thing I was looking at doing, however, was
filtering the search by the customer's id. I'm sure it is a filter in the
list lookup. Maybe you have a quick solution? I will continue to look for it
in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Ross
Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB
customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct
fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail. <http://mail. <http://mail.
<http://mail.yahoo.com> yahoo.com>
yahoo.com> yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>

------------------------------------

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. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





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

Sorry, I should have read more thoroughly.

Change the following line:

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Part"),EpiDataView)

To...

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("UD100"),EpiDataView)

Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 10:13 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

It is filtering the way it should.



No I'm actually doing this on a completely custom form. UD100



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Customer Search Button for Customization





Charlie,

Is the search box filtering properly?

The only time I get the unhandled exception is when a part is not open. Then
it is the -1 error.

I assume you are doing this on the Part form. If so, this code requires an
active record.

Keep me posted.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:48 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Ross,

I keep getting unhandled exceptions after I make the Contact selection and
hit ok.

Dim recSelected As Boolean

Dim whereClause As String = "CustNum = " & nedEpiCustom1.Value & ""

Dim dsCustCnt As DataSet =
Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"CustCntAdapte
r", recSelected, True, whereClause)

If (recSelected) Then

Dim edv As EpiDataView = CType(oTrans.EpiDataViews("Part"),
EpiDataView)

edv.dataView(edv.Row)("Number03") =
dsCustCnt.Tables(0).Rows(0)("ConNum")

edv.dataView(edv.Row)("Character02") =
dsCustCnt.Tables(0).Rows(0)("Name")

edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,edv.Column) )

End If

Does something look off in my code. The contact number should be dumped into
ud100.number03 and the name of the contact into ud100.character02.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, November 04, 2009 10:33 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Try just txtCustID or maybe txtCustID.Value

You also need to remove the single quotes for numeric values.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Wednesday, November 04, 2009 9:20 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

If I have a numeric editor box how would I adjust Dim whereClause As String
= "CustID = '" & txtCustID.Text & "'" to make is spit out the number I tried
changing .text to .number to no avail.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ross Hughes
Sent: Wednesday, October 28, 2009 12:49 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Customer Search Button for Customization

Drew,

It is only a matter of changing the WhereClause variable. But you need the
data to be available to use in the whereclause.

For example:

Dim whereClause As String = "CustID = '" & txtCustID.Text & "'"

This is assuming the value resides in a custom field called txtCustID and
will only work this way.

Another option: If you are using a base control on the form you will need to
convert the base control (CustID) to an object before you can use it.

If so, try this:

'-------------------
Dim CustomerID As EpitextBox =
ctype(csm.GetNativeControlReference("2b741e65-ebe9-426a-9423-d2bddd34323e"),
EpitextBox)
Dim whereClause As String = "CustID = '" & CustomerID & "'"
'-------------------

Make sure to change the GUID of the control (e.g.
GetNativeControlReference("XX-XX-XX, etc.") to the actual ID in the
properties of the control you are using.

That should do it.

Let me know if you need more.

Ross

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
drew.pete
Sent: Wednesday, October 28, 2009 11:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Re: Customer Search Button for Customization

Ross,

I had been trying to get a similar customization working for some time. I
manipulated the code you posted to utilize the ShipTo search and reassociate
the ShipToNum based on the row selected in the search. It functioned
perfectly. Thank you! The only thing I was looking at doing, however, was
filtering the search by the customer's id. I'm sure it is a filter in the
list lookup. Maybe you have a quick solution? I will continue to look for it
in the meantime.

Thank you,

Drew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Ross
Hughes" <ross.hughes@...> wrote:
>
> Charlie,
>
> That's not out of your league.
>
> If you have not solved this yet, here is an example of something that will
> invoke the customer search box and return the values to ud fields on the
> form.
>
> Just change the ud field names to your own.
>
> Modify as necessary.
> --------------------------
> Private Sub btnCUSTID_Click(ByVal Sender As Object, ByVal Args As
> System.EventArgs) Handles btnCUSTID.Click
> '// ** Place Event Handling Code Here **
> Dim recSelected As Boolean
> Dim whereClause As String = String.Empty
> Dim dsCustomer As DataSet =
> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
> "CustomerAdapter", recSelected, True, whereClause)
> If (recSelected) Then
> Dim edv As EpiDataView =
> CType(oTrans.EpiDataViews("Part"), EpiDataView)
> edv.dataView(edv.Row)("ShortChar05") =
> dsCustomer.Tables(0).Rows(0)("CustID")
> edv.dataView(edv.Row)("Character02") =
> dsCustomer.Tables(0).Rows(0)("Name")
> edv.Notify( New EpiNotifyArgs(oTrans, edv.Row,
> edv.Column) )
> End If
> End Sub
> -----------------------------
>
> Tie this to an onclick event of a button.
>
> Let me know if you have any questions.
>
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Charlie Wilson
> Sent: Wednesday, October 28, 2009 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Customer Search Button for Customization
>
> That is way out of my league maybe a drop down will work better.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of
> Kunal Ganguly
> Sent: Wednesday, October 28, 2009 8:51 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: Re: [Vantage] Customer Search Button for Customization
>
>
>
>
>
> I am relatively sure you should be able to do this with a VB
customization.
> You will have to use the customer search button, and based on the cust
> number it returns, write a SQL statement and then populate the form on the
> values returned by that.
>
> Thanks,
> Kunal
>
> ________________________________
> From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
> yahoo.com>
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Sent: Wed, October 28, 2009 7:36:56 AM
> Subject: [Vantage] Customer Search Button for Customization
>
> Is it possible to program a Button to be a customer search button so that
> when you select a customer and click ok it will populate the correct
fields
> of your customization?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail. <http://mail. <http://mail. <http://mail.
<http://mail.yahoo.com> yahoo.com>
yahoo.com> yahoo.com> yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links
>

------------------------------------

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. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.
<http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.
<http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

[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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[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/.
(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