Sales Invoice Totals by Customer report showing zero-balance customers

You did not mention you were using the cloud edition. The cloud edition will update automatically within a few hours. You can force the update at any time by restarting your cloud server following this Guide: Obtain cloud edition customer support | Manager.