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

Navigating to Sales Analysis in SAP Business One

2) Choose the Customers Tab, Select the Invoice Radio Button, and Select the Dates that you want to review

Sales Analysis Report Selection Criteria Window

3) After clicking OK the report will return the data you requested.

Sales Analysis by Customer (Annual)

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.

SAP Sales Analysis - Sorting by Total A/R Invoice