Skip to Content

TRANSACTION NOTIFICATION FOR delivery price check

HI ALL,

my requirement is when we try to add invoice in system it should be match with delivery unit price .both unit price should be same else it has to give me error.


user will not be able to add invoice

pls guide the same.
thx in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 06 at 01:22 PM

    Hi,

    Try this transaction notification,

    if @object_type = '13' and (@TRANSACTION_TYPE = 'A' OR @TRANSACTION_TYPE = 'U')

    begin

    If exists

    (SELECT T2.[DocEntry] FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.[DocEntry] = T1.[DocEntry] LEFT JOIN INV1 T2 on T2.[BaseEntry] =T1.Docentry and T2.[BaseLine] = T1.[LineNum] INNER JOIN OINV T3 ON T2.[DocEntry] = T3.[DocEntry] where t2.docentry = @list_of_cols_val_tab_del and T1.[Price] <> T2.[Price] and T2.[BaseType] =15)

    begin

    select @error = 1,

    @error_message = 'AR Invoice unit price not same as DO price'

    end

    end

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded