Adding Order Header Ship to Contact Pnone onto Sales Order Ackno

Yahoo Archive
1
The first thing I check when adding data in the RDD - is linked tables
before adding tables . For OrderHed one of the linked tables is Customer.




For ship to contact phone - you will have might have to add the contact
table (PerCon) to the RDD and link on custnum and shpconnum.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Wineinger
Sent: Friday, December 21, 2012 7:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Adding Order Header Ship to Contact Pnone onto Sales
Order Ackno





Jose,

The field doesn't exist in the table in RDD or I would.

Regards,

Chris Wineinger

ERP Specialist

Interior Systems, Inc. <http://www.isiamerica.com/>

241 N Broadway Ste 600

Milwaukee, WI 53202

Office # 414.224.0957 X2051

Direct# 414.847.0701

Cell # 414.840.6594

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





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

The field doesn't exist in the table in RDD or I would.



Regards,



Chris Wineinger

ERP Specialist

Interior Systems, Inc. <http://www.isiamerica.com/>

241 N Broadway Ste 600

Milwaukee, WI 53202

Office # 414.224.0957 X2051

Direct# 414.847.0701

Cell # 414.840.6594





[Non-text portions of this message have been removed]
3
You will have to use the OrderHed.ShipToCustId to create a relationship with the customer table, and then pull in the phone number. You will have to add the customer table to the RDD.




________________________________
From: Chris Wineinger <cwineinger@...>
To: vantage@yahoogroups.com
Sent: Friday, December 21, 2012 9:01 AM
Subject: [Vantage] Re: Adding Order Header Ship to Contact Pnone onto Sales Order Ackno

Jose,

The field doesn't exist in the table in RDD or I would.



Regards,



Chris Wineinger

ERP Specialist

Interior Systems, Inc. <http://www.isiamerica.com/>Â

241 N Broadway Ste 600

Milwaukee, WI 53202

Office # 414.224.0957 X2051

Direct# 414.847.0701

Cell # 414.840.6594





[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/.%c2%a0
(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]