Skip to Content
avatar image
Former Member

Transaction notification

i want to check a user defined filed in row that it should not be blank while adding in sales order

can i get the row no and item code also in message

please help

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 29, 2016 at 08:47 AM

    Hi Nikhil,

    SELECT @error = 999, @error_message = 'Row ' + CONVERT(NVARCHAR(10), VisOrder + 1 ) + '. Item Code = ' + ItemCode + '. UDF must not empty.'

    FROM RDR1

    WHERE DocEntry = @list_of_cols_val_tab_del AND ISNULL(U_FIELD,'') = ''

    SELECT @error, @error_message

    Regards

    Edy

    Add comment
    10|10000 characters needed characters exceeded