I want to add that this work around is just not applicable to everyone (not the even with the sales by customer and customer profile reports). This workaround assumes that users are creating invoices one by one and have the time to add the the location every time an invoice is created. What about invoices that are posted automatically i.e. using Zapier? One will have to go and manually update these invoices one by one, which defeat the purpose of automation. We are paying for the Advanced Subscription, and we don't even get a basic report such as "Sales by Ship to".

With QuickBooks Online being around for such a long time, to not be able to do this report incomprehensible. With the 2018 Wayfair ruling, it's critical for business to have access to something this basic to be able to stay in compliance.