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 inventory counts/stock takes in the store however unable to merge the individual counts within a given location.  After selecting the counts and clicking "Merge" the customer gets an error that "Id already exists". Below is the Screenshot (in this case just trying to merge the first 2 but they get the same error regardless of how many and which counts they select).

​

Below are the steps and configuration:

1. Create the document Series in Administrtion >> System Initialization >> Document Number Series

define the series as below configuration

Store: Select Store

Document Type : InventoryCount

Prefix :COUNT

Start Number : 000000000448

End Number : 000000000999

2. Create the inventory count on Operations >> Business Transaction >> Inventory Counting

Create 4 documents.

3. Select Any two documents and Click on the merge button.

4. Now again Select the remaining two documents and click on merge it will show the error as above.

Workaround

You can only have 1 open merged count record at a time (they always get that same ID and the system seemingly allows duplicate count IDs but ONLY if they are in a closed status). There was one remaining item in the existing merged count that we reconciled and then that count was closed and we were able to continue with merging and reconciling the next locations' counts (one at a time).

So this is a bug in design.

Solution

This issue is fix in latest version of iVend.

This KB article concludes here.

• Related Articles

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

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

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

• The record already exists in the Integration Subrecord table. Identification fields and values:

  Problem Statement Getting an error while adding the initial inventory in Business Central ERP "The record already exists in the Integration Subrecord table. Identification fields and values: Nó mov. = '469049'" Solution When an item comes from NAV ...