Is it possible to pull in the Sales Order Attn field and Email in the Header Sold To fields in a BAQ? I tried joining the OrderHed to Customer and CustCnt but it’s bringing in all the contacts. I just need to bring in what’s displayed in the SO Header Sold To.
I believe the two fields you want to join to are OrderHed.BTConNum and OrderHed.ShpConNum
I tried the OrderHed.BTConNum to the Customer table and then from Customer to CustCnt but it brings in all contact and not specifically the one selected on the Sales Order.
You need to connect right to the CustCnt table.
For BT, the join is to CustNum, ConNum, and ShipToNum = null
For ST, the join is CustNum, ConNum, and ShipToNum