Skip to Content
0
Former Member
Feb 25, 2011 at 09:05 AM

Resting Posting Inventory if the Detail field is empty

25 Views

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