can you query back to the customer ship to table to get it? this is where the territory resides. You could join shipto table custNum and ShipToNum to OrderRel ShiptoCustNum and ShiptoNum
What is the easiest way to create a BAQ to derive the territory on each order? We have customers that have hundreds of ship to's with unique territories, so I need to grab the territory from the ship-to.
I can't find a territory field on the Order head or order detail.
I can't find a territory field on the Order head or order detail.