Skip to Content

SPT Not blocking the user if he didn't select Cost center or Project line wise in Goods Issue

Hi experts

I had made a SPT to block user in Goods issue, if he try to Add the Good issue without Cost center and Project Code

But is not working, pls any one can help me to solve it out

Regards

IF @transaction_type IN ('A','U') AND @Object_type = '60'
BEGIN
IF EXISTS (SELECT T0.[DocEntry] FROM IGE1 T0  INNER JOIN OIGE T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T0.OcrCode IS NULL and T1.Project IS NULL and 
T0.DocEntry = @list_of_cols_val_tab_del)
BEGIN
SELECT @Error = 18, @error_message = 'Please Select the Cost Center or Project Code'
END
End
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers