Skip to Content
0
Aug 11, 2023 at 12:45 PM

I WANT TO CHANGE MY BP CURRENCY MUST BE INR ONLY ... WHAT I SHOULD WROTE THE VALIDATION QUERY

86 Views Last edit Aug 11, 2023 at 12:48 PM 3 rev

I WANT TO CHANGE MY BP CURRENCY MUST BE INR ONLY ... WHAT I SHOULD WROTE THE VALIDATION QUERY..

THIS IS VALIDATION QUERY WHAT I NEED TO CHANGE ANYONE HELP ME

if @object_type ='22' and @transaction_type in ('A','U')

BEGIN

IF EXISTS

( Select * from OPOR a

where a.DocEntry= @list_of_cols_val_tab_del and a.CurSource ='C'

)

Begin

set @error='22'

set @error_message='BP CURRENCY IS MANDATORY '

end

end