I think I finally have the links working now.
Here is what I need to see on the report:
**Shipment Date (Shipment Date field & Expected Ship Date fields - both are needed)
**Drop Code (we have used the TaxExempt1 field to put in a Drop Code - which is the order in which the load will be delivered)
**CustomerNumber/CustomerName/CustomerPhoneNumber (I created a formula to combine all of these into one drop)
**Terms (Terms Code field)
**For each Territory (we have 12 in total) I need to have them broke out by territory - the ones that are not working are those with subsidiary Ship-tos where it will not pick up if the ship-to is different than the mailing/billing address ship-to.
**I also need a formula to calculate the total number of orders & invoices for each customer so we know how many picks would be put onto the truck for each. I am having trouble getting this to work as well.
Like Bruse said it is only picking up from the header information. Is there some other field that I should be bringing in to get this to work? Any suggestions anyone?
Edited by Reen (01/17/11 06:42 AM)