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


IF @transaction_type IN ('A','U') AND @Object_type = '60'
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)
SELECT @Error = 18, @error_message = 'Please Select the Cost Center or Project Code'
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers