Skip to Content
0

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

Jan 07 at 09:28 AM

19

avatar image

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers