Customer contact for sales order?

Question

Is the customer contact stored in the sales order? You have to choose a contact in order to select a shipping address, but I don't see a way to get to the contact name in a report.

Dave-N-Darlene · Answer

Yes, you will need to add the contacts table and possibly the address table, Steve

Dave-N-Darlene · Answer

give this a try, Steve 
 LEFT JOIN "Contacts" ON "Customers"."CustomerRecordNumber" = "Contacts"."CustomerRecord" 
 Then if you are wanting Contact Address stuff, add this >> 
 LEFT JOIN "Address" ON "Contacts"."AddressRecordNumber" = "Address"."AddressRecordNumber" AND "Address"."AddressTypeNumber" = 0

Sage 50 US

Customer contact for sales order?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING