FS on Journal Entry

Hi Guys

I have created a Formatted Search on the Journal Entry, it selects the segment from my account using a substring to return the last three characters. The FS works it just doesn't update as the user enters more lines on the Journal, that is problem 1 but i will force the user to update this using another SP if i cannot get it to work.

The main issue i have is that i have a SP that will check the FS and if the FS Value on all the lines is not the same, ie diff segments then the SP will trigger and block the Journal, however my SP does not work?

JE Intercompany

if @object_type = '30' and @transaction_type IN ('A', 'U')

BEGIN

DECLARE @InterCompany as varchar(10)

Select @InterCompany = Transid from jdt1 where jdt1.U_Segment = 'BLM' and jdt1.U_Segment = 'VER' AND transid = @list_of_cols_val_tab_del

IF (@InterCompany <> '' )

begin

select @error = 1, @error_message = 'You Cannnot Create Inter Segment Journal Entries, Make Sure Debit and Credit are Both from SAa'

end

end