Cause: The default filtering to not show transactions with no customer attached should be done at the database level, but was previously built into the report. Changing the filter overrides that default setting, allowing all transactions to show up on the report.
Solution: This script will update the database query used by that report to return only transactions that have a customer selected.
Download this file on the database server machine:
Extract the files, then run UpdateDB.bat. If this for some reason fails to correct the issue, please contact support and send us the file wql.log, which will be created in the folder where you ran the UpdateDB file.