I have a Foreign Key View to Customer.CustNum from OrderHedCustNum
And then a sub table view to Ship to, linking company, custnum, shiptonum
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Roberts
Sent: Thursday, June 02, 2011 4:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Customizing Order Entry - adding ShipTo information
I'm customizing the Order Entry screen in Epicor 9.05. I'd like to
display some additional fields stored in the ShipTo table, but don't
know how to get to the data I want.
There doesn't seem to be a ShipTo data view, nor a Customer data view
available in the order entry screen. The OrderHed data view has a
couple fields that start with "ShipTo..." but it doesn't include the UD
fields that I want to display. I tried to add a foreign key view with
OrderHed as the parent, but ShipToNum isn't in the list of available
column names (and I think I'd have to choose both CustNum + ShipToNum as
the key, which doesn't seem possible in that screen).
Any suggestions for getting this data?
Thanks,
Brian Roberts
Business Systems Analyst
Ground Effects Ltd
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
And then a sub table view to Ship to, linking company, custnum, shiptonum
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Roberts
Sent: Thursday, June 02, 2011 4:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Customizing Order Entry - adding ShipTo information
I'm customizing the Order Entry screen in Epicor 9.05. I'd like to
display some additional fields stored in the ShipTo table, but don't
know how to get to the data I want.
There doesn't seem to be a ShipTo data view, nor a Customer data view
available in the order entry screen. The OrderHed data view has a
couple fields that start with "ShipTo..." but it doesn't include the UD
fields that I want to display. I tried to add a foreign key view with
OrderHed as the parent, but ShipToNum isn't in the list of available
column names (and I think I'd have to choose both CustNum + ShipToNum as
the key, which doesn't seem possible in that screen).
Any suggestions for getting this data?
Thanks,
Brian Roberts
Business Systems Analyst
Ground Effects Ltd
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]