Skip to Content
0
Former Member
Apr 21, 2010 at 08:59 AM

Transaction Notification does'n work with stock account

41 Views

Hi all,

I want to block users post JE manually with Stock account (156100). I use this code as below:

IF @transaction_type = N'A' AND (@Object_type = N'30') 
BEGIN 
if Exists ( select t1.account from JDT1 T1 INNER JOIN OACT T0 ON T1.Account = T0.AcctCode
where t0.Fathernum in ('1561','5111') and t1.transid = @list_of_cols_val_tab_del)
BEGIN 
SELECT @Error = 1, @error_message = N'Manual JE for these accounts is not permitted !!'
END
END

This code works properly on JE screen.

However, the system block all transactions which are generated by the system related to Landed cost and Inventory Revaluation functions.

How to solve this?

Thanks in advance,

Son

Edited by: Son Tran Van on Apr 21, 2010 4:01 PM