Send "Error" if a User Changes Payment Term While Adding SO

[larryenet]

Hello SAP Gurus,

Is there a way to edit SP Transaction Notification to make it give an "Error" if a user selects either "AMEX" or "VISA-6556" from the drop-down menu for Payment Terms when adding a Sales Order?

Thank you for your help.

Kind regards,

Larry T.

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please try this:

IF @object_type IN ('17') AND @transaction_type  IN( 'A','U')

Begin

if exist (SELECT t0.docentry FROM ORDR T0 INNER JOIN OCTG T1 ON T0.GroupNum = T1.GroupNum

WHERE T1.PymntGroup IN ('AMEX', 'VISA - 6556') AND T0.DocEntry = @list_of_cols_val_tab_del)

Begin

   SET @error = -5000

  SET @error_message = N'Amex and VIsa can not be chosen'

end

END

[larryenet · Accepted solution]

Thank you very much!!

[frank_wang6]

Yes, u can do that with SP_TN

and i give u another suggestion, you can change the Term name to Z_AMEX, so it will be at the end of the list.

[larryenet]

Hi Frank,

Thank you for your input, but I'm not quite sure how to setup the SP for this one.

We don't want to change the Term names.

Can you or maybe someone help me with SP?

[frank_wang6]

IF @object_type IN ('17') AND @transaction_type = 'A'

Begin

if exist (SELECT t0.docentry FROM ORDR T0 INNER JOIN OCTG T1 ON T0.GroupNum = T1.GroupNum

WHERE T1.PymntGroup IN ('AMEX', 'VISA - 6656') AND T0.DocEntry = @list_of_cols_val_tab_del)

Begin

   SET @error = -5000

  SET @error_message = N'Amex and VIsa can not be chosen'

end

END

[larryenet]

Thank you very much!!