Skip to Content
author's profile photo Stephen Zhang
0
Stephen Zhang
Mar 26, 2019 at 05:07 AM

SAP B1 Query to show a list of customers who have not bought anything in 12 months.

1769 Views Last edit Mar 26, 2019 at 05:57 AM 4 rev

Hello

can you please show me a query to show customers who have not bought anything in the last 12 months.

Customer Code, Customer Name, Total Sales - Total Credits

Thank you.