Skip to Content
0
Jun 20 at 09:45 AM

Find customer who has no Sales Order from last two months?

104 Views

Greetings,

I have been trying to find customers who has no sales in the past two months. I'm basing it on the fact that they have had no product delivered in the past two months. But, how can I exactly get the name of those people?

I've tried:

NOT IN, EXCEPT and MAX aggregate function but nothing worked.

I'm new to SAP B1 and HANA and can't figure out any solution for a week. I'd really appreciate some help. Thanks :)