SP Code to make plant field mandatory in GRPO ?
How to make plant field mandatory in GRPO using Stored procedure notification ?
Expecting your valuable reply.
Suda Sampath replied
That is exactly correct, thanks for pointing..... it was a oversight
IF (@object_type = '20' AND @transaction_type= 'A')
IF EXISTS (SELECT DocEntry FROM [dbo\].[PDN1\] WHERE (OcrCode IS NULL OR OcrCode = '') AND DocEntry = @list_of_cols_val_tab_del)
SELECT @error =1, @error_message = 'Profit Center cannot be blank'