While receiving the stock transfer request getting the error "Serial number already exists"

Problem Statement: 

While receiving the stock transfer request getting the error “Serial number already exists” as shown below:

​

 

Incident: 

INC0028761

Version: 

iVend 6.6.7531

Symptoms: 

In “InvSerial” table there is more than one row available for the same serial number having status-=1 (In-Store) 

e.g.  serial number let’s say “1234” is available in more than one warehouse with status=1 for the concerned store.

Resolution/Work Around: 

This can be resolved by updating the status=0  in “InvSerial” table for the non-relevant warehouse using the below query after taking the backup of “InvSerial” table:

update InvSerial set status=0 where SerialKey=’Serial key of the concern serial number’

Note: To check the non-relevant warehouse check the serial number status of both the warehouses in Enterprise.. 

• Related Articles

• Serial Number Already Exists while receiving the stock at store

  Environment: iVend Version 6.6 With SAP B1 HANA Problem Statement: Customer has informed that stock transfer was made from SAP to iVend for the store, when it comes to receive the transfer, this error appears 'serial number already exists.' Symptoms: ...

• Getting an Error while receiving the Stock transfer

  Environment: Not Version Specific Problem Statement: While receiving the stock transfer, getting an error "code cannot be left blank " Proposed solution: We need to enter the code to avoid the error As an alternative We can enter the code manually ...

• Getting integration error "System.Exception: DI:To generate this document, first define the number

  Problem Statement Integration error "generate this document, first define the numbering series in the Administration module" Issue in detail Getting integration error "System.Exception: DI:To generate this document, first define the numbering series ...

• While Cancelling the Stock Transfers error message showing 'Id already exists'

  Product Version: iVend 6.6 Problem Statement: While Cancelling the Stock Transfers error message showing '"Id already exists"' Proposed Solution: User trying to receive an inter-store transfer from iVend, but gets an error indicating that the "Id ...

• Getting an error "ID already exists" while merging the two inventory count open transactions

  *************************** Internal to CitiXsys************************* Environment iVend 6.6, Patch: 7723 and until patch 7915 Issue Getting an error "ID already exists" while merging the two inventory count open transactions. When doing physical ...