Hi Expert,
I would like to restrict the users to Post/Reconcile the Inventory Posting, how could i do this on StoredProcedure-TransactionNotification, I have tried the script below but still i cant fixed the problem.
Please help me on this.
-- RESTRICT POSTING INVENTORY POSTING LIST (Inventory Posting) --
If @transaction_type in ('A','U') AND @Object_type = '58'
BEGIN
IF EXISTS (SELECT T0.Transnum FROM OINM T0 WHERE T0.Comments IS NULL AND T0.Transnum = @list_of_cols_val_tab_del)
BEGIN
SELECT @Error = 1, @error_message = 'Please enter the detail field first! '
END
END
Thanks,
John