Hi the below transaction notification is not working, if the project is missing at the level of the purchase blanket agreement then it must not allow to add.
Sergei Travkin Former Member your help is appreciated
IF (:object_type = '001250000025' and (:transaction_type = 'A' OR :transaction_type = 'U')) THEN (Select COUNT(*) into cnt From "OOAT" a Where a."DocEntry" = :list_of_cols_val_tab_del AND a."Project" IS NULL); IF :cnt > 0 THEN error := 2301; error_message := 'Project is missing ...'; END IF; END IF;