Skip to Content
0

TRANSACTION NOTIFICATION FOR delivery price check

Feb 06 at 12:05 PM

21

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Nagarajan K Feb 06 at 01:22 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded