on 04-18-2008 7:50 AM
Hi All,
My Clients Requirment is that,Duplication of JE should not occur for if i am putting REF 1. field twice i.e if for the first time once the JE is done for suppose Ref.1= 2020.Now if i am posting the JE for the same REf. No. 2020 it should not allow me.it should give me pop-up that entry is done before for these.It wil be solved through FMS or Approval or Query based alert.Reply ASAP...
Thanks & Regards-
Mona
Hi,
Please check out this query
IF @transaction_type IN ('A', 'U') AND @Object_type = '30'
BEGIN
IF EXISTS (SELECT T0.REF1 FROM [dbo].[OJDT] T0 WHERE T0.REF1
IN (Select REF1 FROM OJDT)
AND T0.Number = @list_of_cols_val_tab_del)
BEGIN
SELECT @Error = 1, @error_message = 'Duplicate JE Invoice'
END
END
SAGAR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think if you using SBO Transaction Notification procedure just checking for Ref1 to be existing would be a in accurate check.
Check TransType in the Sub query is equally important. I would still validate the requirement as using SBO_TransactionNotification to filter JournalEntry can be very taxing on the system and is not recommendable.
SELECT T0.REF1 FROM dbo.OJDT T0 WHERE T0.REF1
IN (Select REF1 FROM OJDT WHERE <font color="red">TransType = '30' </font>)
AND T0.Number = @list_of_cols_val_tab_del)
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.