iVend MC Enterprise Setting "Inter Store Transaction"

iVend MC Enterprise Setting "Inter Store Transaction"

--INTERNAL TO CXS SUPPORT TEAM---

Problem Statement

In the Enterprise Setting section, User  selected the 'Use Inter-store Transactions' field. want to uncheck it but the system does not allow it.

Environment

iVend 6.6 With SAPB1

Symptoms

NA

Resolution/Work Around

We have to make  the required changes using sql queries on HO DB and replication events were generated which will make changes on all the stores once replication is clear.

1. STOP Replication at HO.
2. Take Backup of RepObjectMapDBSelect * into RepObjectMapDB_Backup from RepObjectMapDB
3. Run Below two Queries at HOUpdate RepObjectMapDB set TableType = 0 where UseForInterStore = 1 and TableName like 'trx%'
4. Update CfgEnterprise set UseInterstoreTransaction = 0, ExchangeTransactionDataBetweenStore = 0
5. Now run Below Query at HO and execute result also to generate the replication events for change made on HO database

Declare @Batchkey nvarchar(100)
Set @BatchKey = newid()
Select 'exec DataNotification @pSourceType=217, @pSourceKey=''' + CONVERT(VARCHAR(100),objectID) + ''', @pBatchKey='''+ @BatchKey+''', @pOperationType=1, @pUserKey=''1'''
from
RepObjectMapDB WITH (NOLOCK) Where UseForInterStore = 1 and TableName like 'trx%'
UNION
Select 'exec DataNotification @pSourceType=8, @pSourceKey=''' + CONVERT(VARCHAR(100),EnterpriseKey) + ''', @pBatchKey='''+ @BatchKey+''', @pOperationType=1, @pUserKey=''1'''
from
CfgEnterprise WITH (NOLOCK)

6. start Replication at HO.

7. Close the MC and open again

8. Now to cross Check the changes made, run below queries on HO DB and any one Store DB

select * from RepObjectMapDB where UseForInterStore=1 and TableType=1

select UseInterstoreTransaction,* from CfgEnterprise

This KB article concludes here.

Note

1. On store DB run the queries after 5 minutes once turning on the replication service on HO
2. Changes in settings will have effect on the new transactions done onwards and old transactions will go without changes.

    • Related Articles

    • Inventory Data not replicated with setting Replicate Inter-Store Inventory.

      Environment: iVend 6.6 Product Query: Can we check Business transaction like Goods Issue, Goods Receipt etc of one store in another store using functionality "Replicate Inter Store Inventory" (Shown in the below image): Proposed Solution: When Goods ...

    • Inter-StoreCommunicationsUsingNotifications

      Overview Inter-store communication is key in a retail environment. In iVend Retail, the system allows users to setup inter-store notifications for the following back office transactions: · Stock Transfer Request · Stock Transfer Shipment · Purchase ...

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

    • iVend POS Transaction Server

      iVend POS – Transaction Server Transaction Server is an API service hosted on the iVend Enterprise. Transaction Server reduces the data replication across the store network when Inter-store Transactions has been enabled in the system or when SQL ...