BAQ - SO Attn and Email fields

Kinetic ERP
1

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.

image

2

I believe the two fields you want to join to are OrderHed.BTConNum and OrderHed.ShpConNum

3

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.

4

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