Is there a way to display both the Bill To CustID and the Sold To CustID for the Order Acknowledgement? The RDD doesn’t allow creating relationships with the same parent and child since the table joins between the two is BTCustNum and the other is CustNum. I can’t seem to get both the Bill To and Sold To CustID’s since the RDD doesn’t allow duplicate relationships.
1 Like
See if this helps…
Use the BTCustNum Linked Table to get the Bill To data and the Customer Linked Table should already be the Sold To.
I’m trying to apply this same concept to the AR Form but it already has a default InvcDtlToCustomer that I can’t remove or else it will break the report and need to use a different linked table using the BTCustNum. I still can’t seem to pull in both the different Bill To and Sold To in the AR Form.
I forgot about this, but the report dataset already has both addresses in it. There is a flag on the Invoice header that controls what prints. It is called Print Sold To Address. Look at the field Calc_BottomAddress in the report. I think that contains the other address.
Is there a way to do this in the report without having to check on the Print Sold To Address so it prints up both the Bill To and Sold To addresses every time?
I believe so. I think you would need to find that check box in the report dataset. Then build your report with the Bill To and Sold To areas. Then put an if statement for the address to check the flag and switch the fields. I think it would be something like this for the Bill To: if check box is false, Bill To, else Bottom Address. And then flip it for the Sold To.
Throw the BottomAddress field in the report and see what prints out.