Would like to write a query that shows us the following:
Customers we normally deliver to on a certain day (Sales Order Delivery Date should be a variable). Show us all customers that have ordered more than once in the last 2 months
But on top of this, show us whether these customers have a valid Sales Order with us for that Sales Order Delivery Date that was selected (so that we can see which customers we still need to call/chase for an order).
Attached is a query which I am stuck with as I can't get it working but if someone is able to help that would be great!
Hi
I can do it for you, I can write this query for you according to your requirements.
Can we discuss in details?
If you have any query please inbox me
Thanks