TRANSACTION NOTIFICATION FOR delivery price check

[vinayak_chavan]

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

[kothandaraman_nagarajan · Accepted solution]

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