Unable to search for transactions at POS

Unable to search for transactions at POS

Version

 6.6

Issue

 At all the store locations and in every POS users are not able to search for transactions. We've gone through the configuration and there seem to be no errors. 

Below is the screenshot of the error:

The Customer is using Transaction Search functionality to search the transactions. Below is the configuration screen for the same:
​

Resolution

It was found that there were a few backup tables created of Trx table where name starting with Trx which was causing the issue as the system was considering those tables also while fetching the data.

As a standard, there should not be any extra table that may conflict with the iVend functionality.

This means, there should not be any extra table in the iVend DB with a name starting with Trx (Other than default iVend tables).

The customer should ensure this. During the Transaction server search, iVend gets the records from all tables whose name starts with Trx so if there is any extra table with the prefix Trx will cause the issue.
To fix the issue rename this extra table with any other name.

This KB article concludes here.

    • Related Articles

    • Scan Sequence Resolution

      iVend POS – Barcode Scan Sequence Resolution Order The user at the POS scans either the barcode of the product when it is being transacted or swipes the loyalty card for the customer or the security user card. The system follows a sequence of methods ...

    • Unable to perform Product Search at POS, error:multi-part identifier "InvUOM.UOMKey" could notbound

      Environment: iVend 6.5 updates 6 with Patch 2 Problem Statement: Unable to perform Product Search with POS terminal after reinstalling POS and error logged in POS log file <Message>The multi-part identifier "InvUOM.UOMKey" could not be bound. The ...

    • How to use Transaction Server Search at the POS?

      Product version: iVend 6.6 Problem statement : How to use Transaction Server Search at the POS? Proposed solution/workaround: Transaction Server Search is a method used to perform a Return, Exchange or Delivery of Sale done at other stores without ...

    • POS - Business Transactions

      Introduction iVend Add-on Framework is used for writing Custom Business Logic independently by a programmer. iVend Addon allows to extend business logic either in Management Console or at the Terminal POS. The addon framework allows deployment of ...

    • POS - Business Transactions

      Introduction iVend Add-on Framework is used for writing Custom Business Logic independently by a programmer. iVend Addon allows to extend business logic either in Management Console or at the Terminal POS.The addon framework allows deployment of ...