Change from Mixed Mode to Separate Store

------------------This article is for only internal use ------------------------

Product version:          

iVend 6.6 with SAPB1.

Problem statement:

A Store was created in mixed mode however it was required to be created as Separate Mode Store

Proposed Solution/Workaround:

Steps : 

1.When a store is created with mixed mode store, it has siteid 1.

2.If customer creates store in mixed mode and may require to change it as Separate Store

3.iVend table RtlStore contains site id information of Store

select SiteId,* from RtlStore

4.iVend table SysNextNumber contain the next number of site id of store

select * from SysNextNumber where NextNumberid like  'Table.Store'

5.So to change it as separate store, you need to check what is last site id number in SysNextNumber for NextNumberid like  'Table.Store'  and then assign this number on RtlStore table for particular store key and Site id using SQL Query window :-

update RtlStore set SiteId='Put Next Site id' where StoreKey='Put Store key' and SiteId=1

update SysNextNumber set NextNumber='Put next number' where NextNumberid like  'Table.Store' 

6.You will be required to do this activties on other Store database so other database will get same site id of changed store

7.Generate events by updating Store description so that it could be replicated on each store by normal replication process.

it should be done with  Support Team

• Related Articles

• POS - Transaction mode change event

  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 - Transaction mode change event

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

• Addon information was not updated for newly created store

  Environment: iVend 6.6 integrated with SAPB1 Problem Statement: Addon information was not updated for newly created store Symptoms: Not Applicable Resolution/Work Around: Issue is already fixed in the latest iVend patch (8567). As a workaround we ...

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

• Store license with General warehouse in iVend unplugged

  Environment: iVend Version 6.6 and 6.5 Update 6 unplugged Problem Statement: New Button on the iVend MC Warehouse screen is not enabled however store license is available to create a new store in iVend Enterprise MC. Symptoms: Not Applicable ...