top of page
Search

iVend Replication - Re-trigger the missing to Store DB

ABS

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'



 
 
 

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

Comentarii


Post: Blog2_Post

©2021 by Addon Business Solution Co., Ltd.

bottom of page