Skip to Content

sp_tn for blocking receipt from production when challan entry is blank

IF @OBJECT_TYPE IN ('59','202') AND @TRANSACTION_TYPE IN ('A','U') BEGIN IF EXISTS ( SELECT T1.Whscode,T1.U_ChallanEntry,T1.DocEntry FROM IGN1 T1 --LEFT JOIN OWOR T4 ON (T1.DocEntry = T4.DocEntry) AND (T1.BaseRef = T4.DocNum) --LEFT JOIN WOR1 T2 ON T1.BaseEntry = T2.DocEntry LEFT JOIN OIGN T3 ON T1.DocEntry = T3.DocEntry WHERE T1.BaseType = 202 AND T1.WhsCode='1SC' AND T1.U_ChallanEntry IS NULL and T1.DocEntry= @list_of_cols_val_tab_del ) BEGIN Set @error = '1011' Set @error_message = 'ChallanEntry is mandatory' END END

Please correct it its not working

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers