Check Goods Receipt & Goods Issue against Inventory counting iVend MC

Check Goods Receipt & Goods Issue against Inventory counting iVend MC

Environment:

iVend 6.6 integrated with SAPB1


Problem Statement:

How to check Goods Receipt & Goods Issue against Inventory counting iVend MC

 

Symptoms:

NA

 

Resolution/Work Around: 

Below SQL Queries can be used to check:


Select A1.InventoryCountKey,A1.Created,TotalRecords, CountedWale,GRCount , GICount,  COUNT(1) as [GRCreated], GRCount - COUNT(1) as [GRDifference],

(select COUNT(1) from InvInventoryTransactionDetail Where SourceKey = A1.InventoryCountKey) as [GICreated]

From 

(SELECT A.InventoryCountKey,A.Created, COUNT(1) TotalRecords,  Sum(case when B.Counted > 0 and counted=1 and b.Status=1 then 1 else 0 end) CountedWale,

Sum(case when B.DifferenceQuantity > 0 then 1 else 0 end) GRCount, sum(case when B.DifferenceQuantity < 0 and counted=1 and b.Status=1 then 1 else 0 end) GICount

FROM InvInventoryCount A, InvInventoryCountDetail B

Where A.InventoryCountKey = B.InventoryCountKey

and A.Created > '2022-01-01 00:00:00.000'

group by A.InventoryCountKey,A.Created

having Sum(case when B.Counted > 0 then 1 else 0 end) > 0) As A1, InvGoodReceiptDetail B

Where A1.InventoryCountKey = B.SourceKey

--and GICount >0

Group by A1.InventoryCountKey,TotalRecords, CountedWale,GRCount, GICount,A1.Created

order by Created desc

-- GR Count should be equal to GR created.

-- GI count should be equal to GI created.


Recommendations /Suggestion: 

NA


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

    • Multiple Receipt Printing issue

      Environment: iVend 6.6 7989 SAP B1 10 Problem Statement: iVend is sending lots of receipts for single transaction until printing has to be stopped. Symptoms: It was observed that for Receipt ID ‘Transaction receipt’, Transaction receipt was selected ...

    • Inventory Counting Manual CountingAndFile Upload

      Inventory Counting - Manual and File Upload In versions of iVend Retail 6.5 and above, the system allows users to perform physical stock counts of inventory products. It also enables the user to reconcile the system inventory against the actual ...

    • Enable the Print button on Inventory Counting

      Environment: iVend 6.6 Problem statement: Enable the Print button on Inventory Counting Resolution/Work Around: 1: Login in MC. 2: Click on Administration Tab >> Retail Configuration >> Document Print Profile. 3: Select Document Print Profile and ...

    • Data template for importing inventory counting

      Product version: 6.5 Update 6/6.6 Problem statement: Data Template is required to use in iVend MC--> Inventory Transaction Screens such as inventory counting . Proposed solution: Suggested to use the below format for Inventory Counting and also ...