Skip to main content

InventoryControl v7 - Customer History report is showing all transactions, instead of only those for customers - Knowledgebase / Discontinued Products / InventoryControl / Version 7 - Wasp Helpdesk

InventoryControl v7 - Customer History report is showing all transactions, instead of only those for customers

Authors list
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