top of page
Search
ABS

iVend Replication - Re-trigger the missing to Store DB


Select 'exec DataNotification @pSourceType=38, @pSourceKey=''' + CONVERT(VARCHAR(100),InventoryItemKey) + ''',@pBatchKey=''' + CONVERT(VARCHAR(100),NewID()) + ''', @pOperationType=0,@pUserKey=1'

from invinventoryitem WITH (NOLOCK)

join InvProduct on InvProduct.ProductKey=invinventoryitem.ProductKey

where InvProduct.Id='TEST002'



7 views0 comments

Recent Posts

See All

SAP B1/iVend- Query Inventory In SAP

Check inventory audit in SAP select  a.CreateDate, b.USER_CODE as [User], a.TransType SAP_DocType, case when a.TransType = 13 then  'Sale...

Comments


Post: Blog2_Post
bottom of page