In building a report for deliveries in and out of town we have used “Territory” as or main record selection and sort option. We are running into a problem with customers who have more than one “Ship-to” address which in turn each of those need to have a different Territory from the main customer (billing address) territory. Both of these Territory fields are available in the forms in Receivables and Order Entry and can be filled in individually. However, we are running into a snag in finding the “Ship-to” territory in any of the tables that are currently available to us in Crystal Reports. Can someone please tell us where this field is (in which table - does it possibly have an Alias name assigned to it?) or what we need to do to have this field pull into our report?

We appreciate any help or advice that can be given to help us through this.



Cheers and Happy Holidays,