When the Essential Business Headlines calculates the Top Customer for the period, the total sales value appears to calculate based on the Amount Including VAT, also I think the Query is including all positive entries from the customer's account, so credits are not being included. If this Query simply calculated the total of Sales (LCY) from the Customer Ledger Entries in the period then it would accurately report the top customer based on revenue including credit notes and excluding VAT.