When pulling the OTS City and State in a BAQ I can’t get complete data. The orders look identical. The OTS box is checked, and the OTS address is completed properly. The customers are all checked that they allow the One Time Ship To. I have filter by the Use OTS both with and without. As soon as I put in OTS City there are orders missing from the BAQ when it is tested. I would use the ShipHead.ShipToAddressFormatted but it is not a choice in the BAQ under ShipHead. I pay commissions by sales area and I need all of the sales by city and state. Any suggestions would be greatly appreciated.
Are you getting OTS from OrderHed and superseding that one with OTS from OrderRel if it exists? All of the address fields will need to be calculated with case when the release OTS field is not blank.
The one that is supposed to be in OrderRel is not there. Because of this I am using the OTS in the OrderHead. I think it is strange that using this does get some lines but not all. Thanks for the response.
Awesome!! Thank you, great idea.