cancel
Showing results for 
Search instead for 
Did you mean: 

Purchase Quotation manual closing ?

former_member275969
Participant
0 Kudos

Hi Friends

I need a SPTN for  when Purchase Quotation is MANUAL closing NEED to write a reason for manual closing , that in a UDF field for (15 characters mandatory for that field )

Need a SPTN for this

Regards

Reddy K

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please try this;

IF @transaction_type IN (N'L') AND

(@Object_type = N'540000006')

BEGIN

If EXISTS (SELECT T0.[Docentry]

FROM OPQT T0

WHERE T0.[Docentry] = @list_of_cols_val_tab_del and T0.U_Receiver_Name is null)

Begin

SET @error = 14

SET @error_message = N'Please add reason closing at UDF'

End

END

Thank you

former_member275969
Participant
0 Kudos

Hi Sir,

This Query is executing but it is not working for that closing time

Please help me out

Regards

Reddy

kothandaraman_nagarajan
Active Contributor
0 Kudos

Please change UDF T0.U_Receiver_Name  to actual UDF from your DB and then try.

former_member275969
Participant
0 Kudos

hi Sir

yes i replaced that field with my new udf but it is not working sir,

Please help me out

Regards

REDDY