cancel
Showing results for 
Search instead for 
Did you mean: 

Duplication of JE

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

former_member583013
Active Contributor
0 Kudos

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)