iVend Inventory Audit Report display Error "Incorrect Syntax near 'order'

iVend Inventory Audit Report display Error "Incorrect Syntax near 'order'

Environment:

iVend 6.6


Problem Statement: 

Inventory Audit was not working on Enterprise Management Console

Its shows error message 



“Incorrect Syntax near 'order' Incorrect Syntax near the Keyword  'As' Statement(s) could not be prepared".


  


Proposed Solution:

Suggested customer to check sql server version. There is some syntax which is not supported on older versions of sql. This may be one of the reasons for the error.


Steps if any: 

We can check the sql server version by executing the below command on the database.


 Select @@version.


 We have suggested the customer to using the SQL server version as per the software specification guide.


Constraints / Scenarios:  

NA



    • Related Articles

    • Require to make the inventory as Zero for particular store

      Environment: iVend 6.6 with SAP B1 10 Problem statement: Require to make the inventory as Zero for particular store. Symptoms: products Inventory show in negative and some are in positive numbers. Resolution/Work Around: There is need to check if SAP ...
    • Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"

      *****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...
    • While searching product on iVend POS Screen, it doesn't display the incorrect price

      Product Version : iVend 6.5 Update 6 with SAPB1 9.2 Problem Statement: While searching product on iVend POS Screen, it doesn’t display the incorrect price. Proposed Solution :- If price is getting different from view inventory price so need to update ...
    • Old transactions are not showing on Inventory Audit Report

      Product Version: 6.5 Update 6 Problem Statement: Customers have reinstalled POS and Management console for store, created backup of store database from enterprise management console, restored it in store database, POS and Management console are ...
    • iVend Retail Audit Log

      iVend Retail Audit Log The Audit log is one of the most important features that comes with iVend versions 6.5 and above. It allows for the tracking of all users’ data changes in the application. All operations such as Add, Update, and Soft Deletes ...