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 ...

• Inventory Audit report showing Blank After Store Re-initialization

  Problem Statement Inventory Audit report showing Blank After Store Re-initialization Investigation Upon reviewing the issue, it was found that the inventory log data was missing in the respective SQL table. After further inspection, we identified ...

• 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 ...