Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Discontinued Products
  • InventoryControl
  • Version 7
  • InventoryControl v7 - Customer History report is showing all transactions, instead of only those for customers
Subscribe Download PDF

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

Jason Whitmer
2020-04-03
in Version 7
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.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

20 of 32 people found this page helpful


Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro