Foreign Key View

Yahoo Archive
1
Ok,I decided not to go with the FKV.I don't know whether it is even possible to use it.

I decided to use custom code to get the table into Ultragrid.
i have a button on my form.When I click the button the Invchead table should get loaded into ultragrid.

This is the code for button_click event

string connetionString;
SqlConnection connection;
SqlDataAdapter adapter ;
SqlCommandBuilder cmdBuilder;

DataSet changes ;
string sql ;
//Int32 i ;


connetionString = "Data Source=DBHQERPDB01;Initial Catalog=EpicorTest;User ID=manager;Password=March2011";
connection = new SqlConnection(connetionString);
sql = "select * from InvcHead";
try
{
DataSet ds = new DataSet();

connection.Open();
adapter = new SqlDataAdapter(sql, connection);
adapter.Fill(ds);
connection.Close();
epiUltraGridC1.DataSource= ds.Tables["InvcHead"];
}
catch(Exception ex)
{
}
But the table doesnt get loaded.Something is missing.If anyone could guide me that would just be great.

--- In vantage@yahoogroups.com, "Anitha" <anithayedavalli@...> wrote:
>
> Hi All,
> Can I add InvcHead in my Sales Order form?If so,how?
>
> Thanks.
>
2
Is it possible to create a FKV which will allow me to place the
CustXPrt.XPartNum on the Part maintenance screen?

I have tried FKV, Sub View, and Multi FKV. I cannot find the XPartNum
field in any of my views.

Since we have a one-to-one relationship between our Part Numbers and
the Customer Part Numbers, our users would like to see the Customer
Part Number on both the Part maintenance screen and the Part Tracker.

Is there a way to accomplish this customization?

Vantage 8.03.404

Thanks.

Lynn K.
3
I recently went through the exact same issue. There is not a way to setup a Foreign Key View for the cross reference and the part, so we had a special customization written that basically creates its own FKV and displays the customers part info in a separate tab. Most of our parts have a one-to-one relationship to our customer's, but there are a few commodity parts that cross customers and then some customers have multiple locations, so there are occasions that more than one customer and their part will display in the list.

Thanks,
Ed
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Lynn
Sent: Tuesday, December 09, 2008 9:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Foreign Key View


Is it possible to create a FKV which will allow me to place the
CustXPrt.XPartNum on the Part maintenance screen?

I have tried FKV, Sub View, and Multi FKV. I cannot find the XPartNum
field in any of my views.

Since we have a one-to-one relationship between our Part Numbers and
the Customer Part Numbers, our users would like to see the Customer
Part Number on both the Part maintenance screen and the Part Tracker.

Is there a way to accomplish this customization?

Vantage 8.03.404

Thanks.

Lynn K.


________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.


[Non-text portions of this message have been removed]
4
Xtable.fields are just short term fixes used by epicor to bridge a release change until they finally get around to actually chaning the db schema to fully support the change.

Theoretically, the native 'views' should already be taking care of this for you (and displaying Xtable view data in a 'native' tbale as if it already exists there).

I don't think you'll have any luck with the data tools wizard in trying to add the data via an FKV, multi FKV or SUb table.

I think you only might have a chance via a callable VB function that does a search by ID on the Xtable.

Rob

--- On Tue, 12/9/08, Lynn <lynn.khalife@...> wrote:

From: Lynn <lynn.khalife@...>
Subject: [Vantage] Foreign Key View
To: vantage@yahoogroups.com
Date: Tuesday, December 9, 2008, 10:47 AM






Is it possible to create a FKV which will allow me to place the
CustXPrt.XPartNum on the Part maintenance screen?

I have tried FKV, Sub View, and Multi FKV. I cannot find the XPartNum
field in any of my views.

Since we have a one-to-one relationship between our Part Numbers and
the Customer Part Numbers, our users would like to see the Customer
Part Number on both the Part maintenance screen and the Part Tracker.

Is there a way to accomplish this customization?

Vantage 8.03.404

Thanks.

Lynn K.
5
The CustXPrt table indexes require the CustNum to be a part of the
lookup. This info would not be available from part screens.

You may be able to use a listLookup where you can construct a
whereClause to pull in the CustXPrt records where PartNum = your part
number.

--- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@...> wrote:
>
> Is it possible to create a FKV which will allow me to place the
> CustXPrt.XPartNum on the Part maintenance screen?
>
> I have tried FKV, Sub View, and Multi FKV. I cannot find the
XPartNum
> field in any of my views.
>
> Since we have a one-to-one relationship between our Part Numbers
and
> the Customer Part Numbers, our users would like to see the Customer
> Part Number on both the Part maintenance screen and the Part
Tracker.
>
> Is there a way to accomplish this customization?
>
> Vantage 8.03.404
>
> Thanks.
>
> Lynn K.
>
6
I'm trying to add the e-mail address, for the Ship To Attention Contact, to
the Order Entry header screen as well as the Customer Shipment Entry header
screen. So Sales can verify there is an e-mail address attached to the
shipment and so shipping can have access to the address to alert the
customer that the order has shipped.



I've done a foreign key view before to do something similar, but I can seem
to get the linking correct for the one. I think I need to link the
OrderHed.ShipToNum to CustCnt ShipToNum, and OrderHed.ShpConNum to
CustCnt.ConNum. But I can't seem to create the view so I have those fields
to select from.



Does anyone have any pointers?



Thanks,



Norman Hutchins

Network Administrator

Howell Laboratories, Inc.









[Non-text portions of this message have been removed]
7
I needed something similar, but I did it with a SalesOrder.update Pre-Process BPM. I put a list of all email addresses from the contacts table into Character01 field of the order header. I used CheckBox02 in CustCnt to indicate the contact is suppose to receive an email. It looks like this:

ttorderhed.Character01 = "".
For Each CustCnt WHERE (CustCnt.Company = ttorderHed.Company) AND
  (CustCnt.CustNum = ttorderHed.CustNum) AND
   (CustCnt.CheckBox02) AND
  (NOT CustCnt.Inactive) AND
  (NOT CustCnt.NoContact):
  /* if email address has at least one character + @ + at least one character + . + at least one character */
  IF (available custcnt) and (CustCnt.EMailAddress <> "") and ((CustCnt.EMailAddress MATCHES "*.@.*~..*") and (NUM-ENTRIES(CustCnt.EMailAddress, "@") = 2))
  THEN DO:
   ttOrderHed.Character01 = ttOrderHed.Character01 + ";" + CustCnt.EMailAddress.
  End.
END.
If SubString(ttOrderHed.Character01, 1, 1) = ";" Then ttOrderHed.Character01 = SubString(ttOrderHed.Character01, 2).

Â
If you have the BPM module, then with a little modification this should work for you. This has the added advantage of being able to send an email to multiple people. Hope it helps.



________________________________
From: Norman Hutchins <nhutchins@...>
To: vantage@yahoogroups.com
Sent: Monday, September 21, 2009 5:25:53 PM
Subject: [Vantage] Foreign Key View

Â
I'm trying to add the e-mail address, for the Ship To Attention Contact, to
the Order Entry header screen as well as the Customer Shipment Entry header
screen. So Sales can verify there is an e-mail address attached to the
shipment and so shipping can have access to the address to alert the
customer that the order has shipped.

I've done a foreign key view before to do something similar, but I can seem
to get the linking correct for the one. I think I need to link the
OrderHed.ShipToNum to CustCnt ShipToNum, and OrderHed.ShpConNum to
CustCnt.ConNum. But I can't seem to create the view so I have those fields
to select from.

Does anyone have any pointers?

Thanks,

Norman Hutchins

Network Administrator

Howell Laboratories, Inc.

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







[Non-text portions of this message have been removed]
8
Hi All,
Can I add InvcHead in my Sales Order form?If so,how?

Thanks.