Here’s how you run a report in SAP Business One so you can see who your top customers are, based on the amount they’ve purchased:
1) From the Modules tab navigate to: Modules > Sales – A/R > Sales Reports > Sales Analysis
2) Choose the Customers Tab, Select the Invoice Radio Button, and Select the Dates that you want to review
3) After clicking OK the report will return the data you requested.
4) Now to see the customers organized by most sales, just double click the Total A/R Invoice Column (you will see a downward facing arrow). The customers are now sorted by highest to lowest total sales.