Skip to Content

How can I make a field mandatory in AR Invoice rows, like unit price?

I want to make unit price for each row item in my AR invoice mandatory, how can i go about doing this

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 12, 2018 at 08:52 AM

    Hi Gwinyai,

    You can use sp_transaction_notification under the stored procedure. For example ;


    IF @transaction_type in( 'A' , 'U') AND @object_type ='13'

    BEGIN IF EXISTS (SELECT T0.U_XXXX FROM [dbo].[OINV] T0

    WHERE (T0.U_XXXX is null or T0.U_XXXX='') and T0.DocEntry = @list_of_cols_val_tab_del )

    BEGIN SELECT @Error = 69, @error_message = 'Error Message' END END

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 10, 2018 at 01:59 PM

    Hi,

    Do you mean you want to block '0' unit price AR Invoice?

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 11, 2018 at 05:06 AM

    Hi,

    You can achieve by stored procedure transaction notification.

    Regards,

    silambu

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 17, 2018 at 01:07 PM

    Thanky you Burcu

    Add comment
    10|10000 characters needed characters exceeded