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 | 1907 | February 11, 2022 | |
| AR Invoice | 3 | 667 | December 5, 2017 | |
| VendCnt.ConNum not unique | 2 | 318 | April 7, 2023 | |
| Odd Customer Number behavior on sales order | 2 | 524 | November 8, 2018 | |
| PerCon ID Not Saved to QuoteCnt Table Consistently | 0 | 471 | November 18, 2019 |