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