I think you will need to head over to the connector module, Steve.  The joins in the canned container (Sales Analysis) will not give you what you need.

I've looked in the help at the field listing for JrnlHdr.dat and can't find anything linking back to the contacts. I also noticed that if you choose a contact/ship-to other than the default when entering a sales order or invoice, it doesn't display that contact when you re-open the transaction. So I suspect that the transaction doesn't hold a link to the contact table.

I've looked in the help at the field listing for JrnlHdr.dat and can't find anything linking back to the contacts. I also noticed that if you choose a contact/ship-to other than the default when entering a sales order or invoice, it doesn't display that contact when you re-open the transaction. So I suspect that the transaction doesn't hold a link to the contact table.

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

That's what I was trying to do. The problem is, I don't see a field in JrnlHdr.dat to join to contacts.dat.

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