I am writing a baq for a sales order dashboard and want to add the Customer Sold To Contact. I am linking the OrderHed.PrcConNum to CustCnt table. But in several instances I get multiple rows returned for the same order as there may be two customer contacts whose ConNum are the same relating to previous orders. I know one ConNum relates to a ShipTo Contact and ShipToNum is used as a 2nd key. Is there a 2nd CustCnt field to determine the SoldTo Contact?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Attn Contact on OrderHed - How can I get this? | 6 | 2282 | February 11, 2022 | |
| Sales Order Contact # confusion | 8 | 1492 | July 1, 2024 | |
| BAQ for the Ship To field | 5 | 1827 | May 9, 2019 | |
| Multiple CustContact Records with same ConNum for Same Customer | 7 | 1439 | July 18, 2024 | |
| Customer Primary Bill To Contact | 3 | 910 | March 7, 2018 |