Inventory Audit report showing Blank After Store Re-initialization

Problem Statement

Inventory Audit report showing Blank After Store Re-initialization

Investigation

Upon reviewing the issue, it was found that the inventory log data was missing in the respective SQL table. After further inspection, we identified that the flag ExcludeInStoreBackup in the RepObjectMapDB table, specifically for the InvInventoryItemLog table, was enabled.

As a result, during the re-initialization of the store database from the HO (Head Office) management console, the logs were not backed up in the store's backup. This caused the inventory audit report to appear blank.

SQL Query

SELECT ExcludeInStoreBackup, * FROM RepObjectMapDB WHERE tablename = 'InvInventoryItemLog';

• Related Articles

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

• Old transactions are not showing on Inventory Audit Report

  Product Version: 6.5 Update 6 Problem Statement: Customers have reinstalled POS and Management console for store, created backup of store database from enterprise management console, restored it in store database, POS and Management console are ...

• Store re-intialization Step

  Product version: 6.5 Update 6 or 6.6 Problem statement: User want to re-intialize the store. Proposed solution: Suggested customer to re-initalize Store by creating Store backup file from iVend Enterprise MC screen only when replication is cleared ...

• iVend Inventory Audit Report display Error "Incorrect Syntax near 'order'

  Environment: iVend 6.6 Problem Statement: Inventory Audit was not working on Enterprise Management Console Its shows error message “Incorrect Syntax near 'order' Incorrect Syntax near the Keyword 'As' Statement(s) could not be prepared". Proposed ...

• After store re-initialization, no old transaction on the POS and not in store table TrxTransaction

  Product version: Not a version-specific Problem statement: Customer re-initialized an existing Store as it was Crashed and now at that store after re-initialization process customer does not find any old transactions on the POS and not in SQL DB ...