Ship To on Order Release

Hi All,

Has anyone linked the OrderRel table to the ShipTo table correctly?

I have a BAQ which when I join them it isn’t displaying the ShipToNum and address based on the information found in the OrderRel. Any reason why?

I have attached my BAQ… Anyone willing to help me?

Kind regards,
TEAGLE-UDLoadPlanning.baq (74.6 KB)

Aaron.

You need to link the ShipTo to the OrderRel instead of the OrderHed. That join should be on Company, ShipToCustNum, and ShipToNum.