Add ShipToAddress Phone Number to Pack List Summary

Question

I'm trying to add the customer's Ship To Address PHONE NUMBER to the sozrg002 Crystal. 
 It seems obvious that it needs to come from the tciContact table. I haven't found the magic combination of tables and links to make it work. It seems like it would be a pretty standard request wanted by most companies that use the Pack List Summary. Has anyone here tackled this one before? 
 Thanks. 
 Using Sage 500 7.40.5

Tim Rodman · Accepted Answer

Ralph, 
 Try this and replace the ? with an order number to see if it grabs the data you expect. This is grabbing the default ship to from the header though. Technically, there could be a different ship to on each line. 
 SELECT Phone FROM dbo.tsoSalesOrder JOIN dbo.tarCustAddr ON dbo.tsoSalesOrder.DfltShipToCAddrKey = dbo.tarCustAddr.AddrKey JOIN dbo.tciContact ON dbo.tarCustAddr.DfltCntctKey = dbo.tciContact.CntctKey WHERE TranNo='?'

Sage 500

Add ShipToAddress Phone Number to Pack List Summary

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING