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'
Check inventory audit in SAP select a.CreateDate, b.USER_CODE as [User], a.TransType SAP_DocType, case when a.TransType = 13 then 'Sale Invoice' when a.TransType = 14 then 'Sale Credit Note' when a
Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As LogDatetime, Case isNull(Status, 0) When 0 Then 'Not Processed' Else 'Fa