Transactional (Sales) data did not reach from Store to HO (Replication Skip issue)

************************** Internal to CitiXsys *****************************

Version

6.6

Issue

Transactional (Sales) data did not reach from Store to HO. It means the Store has the data but Enterprise does not have the same. This may happen due to the replication skip issue.

Solution

 Attached Script can be used to insert the missing data from the store to HO.

Steps to apply the script:

 

1) Stop IIS at Enterprise and stores

2) Create a linked server at HO with the stores (for which data is missing).

3) Execute the script by putting the liked server details of the stores in the queries.

4) Once the script is completed for all the stores then start the IIS at HO and the stores.

5) Do this exercise in Out of Business Hours.

 

Note: Before performing this exercise, first discuss with the available Manager.

This KB article concludes here.

• Related Articles

• Replication stuck and Not Moving

  Problem: Replication not moving from HO to Specific Store. Symptoms: Replication Log File Not generated and Event Viewer is showing "INVALID CLASS ERROR" What need to be Check : 1. Right Click on My PC 2. Click on Manage 3. Now Go to Services and ...

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

• SALES REPLICATION ERROR

  Environment: IVend 6.6 with SAP B1 Problem statement: After Applying patch 7723 for version 6.6 sales are not replicating. Did the test by modifying an article and after replicating but the sales did not. Below troubleshooting steps followed: 1.- ...

• Replication not working

  Environment: iVend 6.6 Problem Statement: Replication service not working due to controller application Error Screenshot: Solution: - This issue happened due to there’s an error showing from controller application when customer removed this ...

• Stock mismatch due to replication of data for HO, Store and Offline POS.

  Product Version: iVend 6.6 Problem Statement: Stock mismatch due to replication of data for HO, Store and Offline POS. Proposed Solution: We have analyzed that in the 6.6 version stock mismatch happened due to replication of data for HO, Store and ...