Symptom: After changing the filter on the Customer History report, it began showing all transactions, rather than showing only those that had a customer selected, and nothing can be done to get it to return to the original behavior.
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:
https://dl.waspbarcode.com/kb/ic/v7/IC7-FixCustomerHistoryReport.zip
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.
Helpful
Unhelpful
20 of 32 people found this page helpful